Database Reference
In-Depth Information
service and module are collected and available by querying
V$SERV_MOD_ACT_STATS
. Now press
Return in the window where the Java program is running one more time.
application instrumentation settings removed
Please query V$SESSION and hit return to continue when done.
At this point, the program has set module, action, and client identifier to empty strings. It
pauses again to allow us to observe the effects. The previous consumer group of the session has
been restored.
SQL> SELECT program, module, action, client_identifier,
resource_consumer_group AS consumer_group
FROM v$session
WHERE service_name='TEN.oradbpro.com';
PROGRAM MODULE ACTION CLIENT_IDENTIFIER CONSUMER_GROUP
-------------------------- ------ ------ ----------------- --------------
ApplicationInstrumentation OTHER_GROUPS
The program disconnects and exits as soon as you press Return one last time. There is now
an extended SQL trace file, which includes wait events but not binds, in the directory set with
parameter
USER_DUMP_DEST
. To include binds, set the boolean parameter
BINDS
in the call to
DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE
to
TRUE
. The relevant sections of the trace file are
reproduced here:
*** SERVICE NAME:(TEN.oradbpro.com) 2007-10-30 22:52:52.703
*** SESSION ID:(47.2195) 2007-10-30 22:52:52.703
WAIT #0: nam='SQL*Net message to client' ela= 3 driver id=1413697536 #bytes=1 p3=0
obj#=-1 tim=392092318798
…
*** 2007-10-30 22:53:03.984
WAIT #0: nam='SQL*Net message from client' ela= 11260272 driver id=1413697536
#bytes=1 p3=0 obj#=-1 tim=392103603777
*** ACTION NAME:(act) 2007-10-30 22:53:03.984
*** MODULE NAME:(mod) 2007-10-30 22:53:03.984
*** CLIENT ID:(Ray.Deevers) 2007-10-30 22:53:03.984
=====================
PARSING IN CURSOR #2 len=75 dep=0 uid=61 oct=3 lid=61 tim=392103604193 hv=536335290
ad='66afd944'
SELECT userenv('sid'), to_char(sysdate, 'Month dd. yyyy hh24:mi') FROM dual
END OF STMT
PARSE #2:c=0,e=90,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=392103604185
EXEC #2:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=392103608774
WAIT #2: nam='SQL*Net message to client' ela= 4 driver id=1413697536 #bytes=1 p3=0
obj#=-1 tim=392103608842
WAIT #2: nam='SQL*Net message from client' ela= 52777 driver id=1413697536 #bytes=1
p3=0 obj#=-1 tim=392103661760
WAIT #2: nam='SQL*Net message to client' ela= 4 driver id=1413697536 #bytes=1 p3=0
obj#=-1 tim=392103661904
FETCH #2:c=0,e=93,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=392103661941
