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)
--
//www.freelists.org/webpage/oracle-l
Other related posts: