Monday, October 22, 2012

4 Set Autotrace

command Result sets Execution Plan Statistics Execution time
set autotrace on YES YES YES NO
set autotrace traceonly NO YES YES NO
set timing on NO NO NO YES

sysdba has permission to run the autotrace even without the PLUSTRACE role.

How to turnoff the trace

set autotrace off

How to grant normal user permission to use autotrace

Normal user needs to have PLUSTRACE role to turn on the trace.

without the PLUSTRACE, normal user would get the error “SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled and SP2-0611: Error enabling STATISTICS report

image

List role from oracle

Below query list available roles . PLUSTRACE role can be created by install plustrce.sql

SELECT name FROM user$ WHERE type# = 0;

image

Run plustrace sql

The script normally exists at $ORACLE_HOME/sqlplus/admin/plustrce.sql

image

Grant permission

grant connect,resource,PLUSTRACE to PO;

image

Login as user PO

image

Reference
http://docs.oracle.com/cd/B10501_01/server.920/a96533/autotrac.htm

4 comments:

  1. Dans le monde de l'horlogerie,fausses montres de luxe aucun nom ne peut égaler le statut d'une Rolex. fausses rolex lady datejust montres Littéralement, Rolex est synonyme de qualité, et le nom de la marque transcende l'industrie horlogère, c'est à la fois une niche impeccable un fabricant de produits de premier plan et un article international sur la culture pop.

    ReplyDelete
  2. The England Euro 2020 home shirt is cheap soccer jerseys predominantly white with royal blue, navy and red.cheap league jerseys Royal blue is used on the England and Nike logos, while navy will be used for trim alongside red.Based on the Nike 2020 template, which we've already seen on the leaked China and Netherlands shirts. Therefore, it has 'normal' sleeves instead of the raglan cut Nike had been using since 2016.

    ReplyDelete
  3. Created in 1993,cnbrands.ru Christian Louboutin’s sreplica bags christian louboutin ignature red-bottom heels remain the fashion world’s most stylish stilettos. Level up your shoe collection for less with unbeatable Christian Louboutin sales, where you’ll find alluring Louboutin heels and unique Louboutin shoes in your perfect size.

    ReplyDelete
  4. Alexander McQueen is an iconic replica ALEXANDER MCQUEEN Shoes fashion house creatively cheap ALEXANDER MCQUEEN sneaker womens taken over by Sarah Burton who continues to work and evolve with the brand, offering a luxurious range of prêt-à-porter clothing and accessories.

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates