Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

RE: cursor #0

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: "Egor Starostin" <egorst@xxxxxxxxx>
Date: Thu, 1 Sep 2005 08:34:39 +0200

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@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

RE: cursor #0

Other related posts: