RE: cursor #0
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <paul.baumgartel@xxxxxxxxx>
- Date: Thu, 1 Sep 2005 06:40:35 +0200
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
