RE: cursor #0

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 1 Sep 2005 08:34:39 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF1340C4@MSXVS04.trivadis.com>

Egor

>> 2) At the beginning of the trace file where no statement has been parsed yet.
>I think that even if 'WAIT' line is printed before 'PARSING IN CURSOR'
>line, it should still have nonzero #<CURSOR>.

Here an example...

/dbms/oracle/AVALOQ40/udump/avaloq40_ora_5247216.trc Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /app/oracle/product/9.2.0.5

System name:	AIX
Node name:	zsi-aix597p4
Release:	2
Version:	5
Machine:	00C9B9FE4C00

Instance name: AVALOQ40
Redo thread mounted by this instance: 1
Oracle process number: 80
Unix process pid: 5247216, image: oracle_at_zsi-aix597p4 (TNS V1-V3)

• SESSION ID:(78.831) 2005-07-27 13:09:05.905 WAIT #0: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0 WAIT #0: nam='SQL*Net message from client' ela= 455 p1=1413697536 p2=1 p3=0

  ---

  PARSING IN CURSOR #3 len=147 dep=1 uid=0 oct=3 lid=0 tim=1096154829987609 hv=1356713530 ad='e2b1e470' select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0 END OF STMT ...

Regards,
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

Received on Thu Sep 01 2005 - 01:36:40 CDT