The Recrsive calls are made on behalf of you on the data dictionary. You can
use Tkprof to see what caals where made...

Yes you may need to worry about recursive calls as they form a part of yor
cost of excution.

Read more about tkprof in the manuals.


Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================



-----Original Message-----
From: oraora oraora [mailto:[Email Address Removed]
Sent: Wednesday, July 31, 2002 3:11 PM
To: LazyDBA.com Discussion
Subject: recursive calls for SELECT statement ???


Guys,

why 144 recursive calls are made for this SELECT statement ? does
it indicate anything strange ?
or nothing to worry about it ?

let me know guys .

select Pt3 from SBSTPT where EntPC = :EntPC;

Elapsed: 00:00:01.15

Execution Plan
------------------------------------------------------- 0
SELECT STATEMENT Optimizer=CHOOSE (Cost=1 Card=1 Bytes=6)
1 0 TABLE ACCESS (FULL) OF 'SBSTPT' (Cost=1 Card=1
Bytes=6)

Statistics
---------------------------------------------------------
144 recursive calls
4 db block gets
12 consistent gets
8 physical reads
0 redo size
211 bytes sent via SQL*Net to client
319 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
3 sorts (memory)
0 sorts (disk)
0 rows processed

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page