RE: cursor #0

Hi Paul

>There are no PARSING IN CURSOR #0 lines in the file...so what's cursor #0?

Cursor #0 is used when no cursor number is available. There are two common 
situations for that:

1) When a commit or rollback is executed. In fact for these operations you will 
find a XCTEND line where no cursor number is available...

2) At the beginning of the trace file where no statement has been parsed yet.


HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com
Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Zürich (11-Oct), Hamburg (13-Oct), München (20-Oct), Basel (25-Oct), 
         Frankfurt (27-Oct), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart 
(13-Dec)
--
http://www.freelists.org/webpage/oracle-l

Other related posts: