Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Set Autotrace on - Jacques R. KilchoŽr

Re: Set Autotrace on - Jacques R. KilchoŽr

From: Eriovaldo do Carmo Andrietta <eca_at_widesoft.com.br>
Date: Thu, 15 Feb 2001 06:52:47 -0800
Message-ID: <F001.002B5169.20010215060636@fatcity.com>

I understood it too.
But i need to do it with a simple user
...

How can I do it ?

Eriovaldo do Carmo AndriettaLimeira/SP - Brasil <BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

> -----Original Message----- >

  From: Shakeel Qureshi [<A
  href="mailto:msklq_at_yahoo.com">mailto:msklq_at_yahoo.com] <FONT   size=2>> > In oracle 8.1.6 I only run as a   schema owner > the utlxplan.sql and everything   works fine. I just set > sql trace explain and it   gives me all the details of > execution   plan.
  My understanding is that running
  "$ORACLE_HOME/sqlplus/admin/plustrce.sql" will allow a user without DBA or   "select any table" privilege to do a 'set autotrace .... statistics" in   SQL*Plus.
  Jacques R. KilchoŽr x8816 Received on Thu Feb 15 2001 - 08:52:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US