makiju
30th January 2004, 12:36
Hi !
I'm tracing sql by using dbslog. What does different message_types mean?

SQL> ora_multi_fetch( 0x40150cc8 ) no_rows 1
ora_multi_fetch( 0x40150cc8 ) done - rows fetched 0 - End of Fetch
DBMS set exhausted.
Fetched 0 rows from DBMS.
Fetch : end of set.
oracle_break_cursor 0x40213008
oracle_break_cursor: cancel
SQL> ora_cancel_cursor( 0x40150cc8 )
Cursor 0x40092318 put in break list [21].
Msg_type 6 received.
Msg_type 5 received.
Msg_type 5 received.
Msg_type 10 received.
oracle_exec_cursor 0x40149008
Taking cursor from break list.
Cursor 0x40091fc8 removed from break list [20].


Seems like when session is working, it will be only Msg_type 10!