Eriovaldo: If you don't have the PLUSTRACE role, you may get the excution plan but you can not get the statisic report. To make the autotrace fully function, you need to be granted the "plustrace role". If this role is not created yet, connect internal and run the $ORACLE_HOME/sqlplus/plustrce.sql file. Then grant the role to whoever pemitted to use autotrace. Hope this can help William Dong |--------+-----------------------> | | "Eriovaldo do| | | Carmo | | | Andrietta" | | | <eca@widesoft| | | .com.br> | | | | | | 02/14/01 | | | 10:30 AM | | | Please | | | respond to | | | ORACLE-L | | | | |--------+-----------------------> >----------------------------------------------| | | | To: Multiple recipients of list | | ORACLE-L <[EMAIL PROTECTED]> | | cc: (bcc: William Dong/New York | | Life Asset Management) | | Subject: Set Autotrace on | >----------------------------------------------| Friends : I have created the table Plantable on the schema and tryed the command bellow . I received the error message but it works the plan of execution. What can I do for don
´t receive this error message ? sql > set autotrace on Unable to verify PLAN_TABLE format or existence Error enabling EXPLAIN report Cannot find the Session Identifier. Check PLUSTRACE role is enabled Error enabling STATISTICS report Thanks Eriovaldo do Carmo Andrietta Widesoft Sistemas Ltda. Limeira/SP - Brasil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).