Hi, 3rd May 2001 19:57 hrs chennai

i understand your 1 doubt try to execute the same query for
example

>alter session set sql_trace=true
>select * from emp;
>alter session set sql_trace=false

now execute as follows the above steps thrice

>tkprof inputfile.trc outputfile.trc explain=scott/tiger

see the generated file at UDUMP directory

>tkprof inputfile.trc outputfile.trc explain=scott/tiger sys=no

see the generated file at UDUMP directory

>tkprof inputfile.trc outputfile.trc explain=scott/tiger sys=no

see the generated file at UDUMP directory

Now look each time at the output file and tell me what happened for the number of parses ?for each time to execute the tkprof execute a standard SQL statement as mentioned above but first time let it be from a new table and other 2 times the same query.

Note:SYS=NO==>Ignore recursive SQL ststements run as user SYS.

Let me know what you understood on the above results.?

now you can find at last the parse,fetch,execute would have become 0,0,0 for recursive statements.

II)

http://www.dbspecialists.com/4dbas/p...e_explain.html

Read this article and let me have your idea on the same

Cheers

padmam



[Edited by padmam on 05-03-2001 at 10:45 AM]