We are using Oracle 10.2.0.3 on AIX 5.3
We are using DBMS_Monitor via an after logon trigger to do an extended trace of an application's startup process.
In the trace file, there is a reference to a cursor #0 throughout the file. The first line in the file, after the header information is a wait statement for cursor #0, see below for an example. There are never any bind, exec or fetch events associated with the cursor, only wait events.
The vast majority of the waits associated with this cursor are:
SQL*Net Message from client,
SQL*Net Message to client, and
SQL*Net mroe data to client
with a few Direct Path read wait events thrown in for good measure.
Does anyone know what the cursor #0 refers to?
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2
System name: AIX
Node name: qaapega01
Instance name: PRPCQA
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 1433636, image: oraclePRPCQA@qaapega01