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 ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A href="mailto:Jacques.Kilchoer_at_quest.com" title=Jacques.Kilchoer_at_quest.com>Jacques Kilchoer To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Wednesday, February 14, 2001 7:10 PM Subject: RE: Set Autotrace on

> -----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