Database Capture Report For ORCL

DB NameDB IdReleaseRACCapture NameStatus
ORCL116696019711.1.0.6.0NODBR_CAPTURE_100COMPLETED

InformationCapture
Start time:23-May-08 16:49:35 (SCN = 4164210)
End time:23-May-08 16:52:05 (SCN = 4166463)
Duration:2 minutes 30 seconds
Capture size:105.63 KB
Directory object:DBRCONTROL
Directory path:/home/oracle/DBRControl
Directory shared in RAC:TRUE
Filters used:2 EXCLUSION filters

DB Capture Report


Back to Top

Captured Workload Statistics

Statistic NameValue% Total
DB time (secs)143.1868.28
Average Active Sessions0.95 
User calls captured49613.30
User calls captured with Errors0 
Session logins3470.83
Transactions46773.31


Back to Top

Workload Captured

Back to Top

Top Events Captured

EventEvent Class% EventAvg Active Sessions
CPU + Wait for CPUCPU30.430.47
buffer deadlockOther13.040.20
enq: TX - index contentionConcurrency8.700.13
db file sequential readUser I/O4.350.07

Back to Workload Captured
Back to Top

Top Service/Module Captured

ServiceModule% ActivityAction% Action
BATCH_STDLoadGenerator39.13BuildInvoiceDetail39.13
BATCH_LOWLoadGenerator17.39BuildInvoiceDetail13.04
   BuildInvoices4.35

Back to Workload Captured
Back to Top

Top SQL Captured

SQL ID% ActivityEvent% EventSQL Text
4ymp71aaj3bud26.09CPU + Wait for CPU26.09 BEGIN AP.PKG_LOAD_GENERATO...
1bshjy696nrzg17.39enq: TX - index contention8.70 BEGIN AP.PKG_LOAD_GENERATO...
  buffer deadlock4.35
  db file sequential read4.35
0wvttswphs2ky13.04buffer deadlock8.70 BEGIN AP.PKG_LOAD_GENERATO...
  CPU + Wait for CPU4.35

Back to Workload Captured
Back to Top

Top Sessions Captured

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
112, 517.39enq: TX - index contention8.70 SHsqlplus@11gR1NF (TNS V1-V3)2/15 [ 13%]2
  buffer deadlock4.35   1/15 [ 7%]1
  db file sequential read4.35   1/15 [ 7%]0
114, 1717.39CPU + Wait for CPU17.39 OEsqlplus@11gR1NF (TNS V1-V3)4/15 [ 27%]4
99, 78.70CPU + Wait for CPU4.35 OEsqlplus@11gR1NF (TNS V1-V3)1/15 [ 7%]1
  buffer deadlock4.35   1/15 [ 7%]1
109, 28.70CPU + Wait for CPU8.70 OEsqlplus@11gR1NF (TNS V1-V3)2/15 [ 13%]2
116, 284.35buffer deadlock4.35 OEsqlplus@11gR1NF (TNS V1-V3)1/15 [ 7%]1

Back to Workload Captured
Back to Top

Workload Not Captured - Contains Unreplayable Calls

Back to Top

Top Events containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Top Service/Module containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Top SQL containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Top Sessions containing Unreplayable Calls

No data exists for this section of the report.

Back to Workload Not Captured - Contains Unreplayable Calls
Back to Top

Workload Not Captured - User Filtered

Back to Top

Top Events Filtered Out

EventEvent Class% EventAvg Active Sessions
log file syncCommit13.040.20
CPU + Wait for CPUCPU4.350.07
db file sequential readUser I/O4.350.07

Back to Workload Not Captured - User Filtered
Back to Top

Top Service/Module Filtered Out

ServiceModule% ActivityAction% Action
orcl.oracle.comOEM.BoundedPool8.70UNNAMED8.70
 OMS8.70UNNAMED8.70
 OEM.DefaultPool4.35/database/instance/sitemap4.35

Back to Workload Not Captured - User Filtered
Back to Top

Top SQL Filtered Out

SQL ID% ActivityEvent% EventSQL Text
4ckzywf6w81bk4.35db file sequential read4.35 SELECT ELEM_TYPE_NAME, ELEM_T...
c69cz0cs2a76y4.35CPU + Wait for CPU4.35 BEGIN EMDW_LOG.set_context(MGM...

Back to Workload Not Captured - User Filtered
Back to Top

Top Sessions Filtered Out

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
131, 228.70CPU + Wait for CPU4.35 SYSMANOMS1/15 [ 7%]1
  log file sync4.35   1/15 [ 7%]0
121, 14.35log file sync4.35 SYSMANOMS1/15 [ 7%]0
128, 64.35log file sync4.35 SYSMANOMS1/15 [ 7%]0
170, 174.35db file sequential read4.35 SYSMANOMS1/15 [ 7%]0

Back to Workload Not Captured - User Filtered
Back to Top

Workload Not Captured - DB Scheduler Jobs and Background Activity

Back to Top

Top Events (Jobs and Background Activity)

EventEvent Class% EventAvg Active Sessions
log file parallel writeSystem I/O13.040.20
control file parallel writeSystem I/O4.350.07
db file sequential readUser I/O4.350.07

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Top Service/Module (Jobs and Background Activity)

ServiceModule% ActivityAction% Action
SYS$BACKGROUNDUNNAMED17.39UNNAMED17.39
SYS$USERSUNNAMED4.35UNNAMED4.35

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Top SQL (Jobs and Background Activity)

No data exists for this section of the report.

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Top Sessions (Jobs and Background Activity)

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
162, 113.04log file parallel write13.04 SYSoracle@11gR1NF (LGWR)3/15 [ 20%]0
129, 44.35db file sequential read4.35 SYSMANoracle@11gR1NF (J001)1/15 [ 7%]1
154, 54.35control file parallel write4.35 SYSoracle@11gR1NF (RVWR)1/15 [ 7%]0

Back to Workload Not Captured - DB Scheduler Jobs and Background Activity
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0wvttswphs2kyBEGIN AP.PKG_LOAD_GENERATOR.RandomDML(250); COMMIT; END;
1bshjy696nrzgBEGIN AP.PKG_LOAD_GENERATOR.RandomDML(375); COMMIT; END;
4ckzywf6w81bkSELECT ELEM_TYPE_NAME, ELEM_TYPE_OWNER FROM ALL_COLL_TYPES WHERE TYPE_NAME='MGMT_INV_TARGET_LIST_OBJ_ARRAY' AND OWNER='SYSMAN'
4ymp71aaj3budBEGIN AP.PKG_LOAD_GENERATOR.RandomDML(500); COMMIT; END;
c69cz0cs2a76yBEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.update_async_op_status(:2, :3, :4); END; EMDW_LOG.set_context; END;


Back to Top

Workload Filters

#Filter NameType Attribute Value
1ORACLE MANAGEMENT AGENT (DEFAULT)EXCLUDEPROGRAMemagent%
2ORACLE MANAGEMENT SERVICE (DEFAULT)EXCLUDEPROGRAMOMS


Back to Top

End of Report