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