WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid. WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Startup Time Release RAC ------------ ----------- ------------ -------- --------------- ----------- --- TRAC 192046410 trac 1 15-Jan-12 12:14 11.2.0.1.0 NO Host Name Platform CPUs Cores Sockets Memory(GB) ---------------- -------------------------------- ---- ----- ------- ---------- IE70TRA001 Microsoft Windows IA (32-bit) .00 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 2681 15-Jan-12 13:30:07 End Snap: 2728 17-Jan-12 12:30:06 Elapsed: 2,819.97 (mins) DB Time: 0.00 (mins) Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache:MM Std Block Size:K Shared Pool Size: 0M 0M Log Buffer:K Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~ --------------- --------------- ---------- ---------- DB Time(s): 0.0 0.0 0.00 0.00 DB CPU(s): 0.0 0.0 0.00 0.00 Redo size: Logical reads: 0.0 1.0 Block changes: 0.0 1.0 Physical reads: 0.0 1.0 Physical writes: 0.0 1.0 User calls: 0.0 1.0 Parses: 0.0 1.0 Hard parses: W/A MB processed: 0.0 0.0 Logons: Executes: 0.0 1.0 Rollbacks: Transactions: 0.0 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: Redo NoWait %: Buffer Hit %: In-memory Sort %: Library Hit %: Soft Parse %: Execute to Parse %: 0.00 Latch Hit %: Parse CPU to Parse Elapsd %: % Non-Parse CPU: Shared Pool Statisitics Not Available Top 5 Timed Foreground Events ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg wait % DB Event Waits Time(s) (ms) time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- DB CPU 0 100.0 Host CPU (CPUs: Cores: Sockets: ) ~~~~~~~~ Load Average Begin End %User %System %WIO %Idle --------- --------- --------- --------- --------- --------- Instance CPU ~~~~~~~~~~~~ % of total CPU for Instance: % of busy CPU for Instance: %DB time waiting for CPU - Resource Mgr: Memory Statistics ~~~~~~~~~~~~~~~~~ Begin End Host Mem (MB): SGA use (MB): PGA use (MB): % Host Mem used for SGA+PGA: Time Model Statistics DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Operating System Statistics DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Operating System Statistics - Detail DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Foreground Wait Class DB/Inst: TRAC/trac Snaps: 2681-2728 -> s - second, ms - millisecond - 1000th of a second -> ordered by wait time desc, waits desc -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Captured Time accounts for % of Total DB time .00 (s) -> Total FG Wait Time: (s) DB CPU time: .00 (s) Avg %Time Total Wait wait Wait Class Waits -outs Time (s) (ms) %DB time -------------------- ---------------- ----- ---------------- -------- --------- DB CPU 0 100.0 ------------------------------------------------------------- Foreground Wait Events DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Background Wait Events DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Wait Event Histogram DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: TRAC/trac Snaps: 2681 No data exists for this section of the report. ------------------------------------------------------------- Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: TRAC/trac Snaps: 2681-2 No data exists for this section of the report. ------------------------------------------------------------- Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: TRAC/trac Snaps: 2681-27 No data exists for this section of the report. ------------------------------------------------------------- Service Statistics DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Service Wait Class Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by User I/O Wait Time DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Gets DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Reads DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Physical Reads (UnOptimized)DB/Inst: TRAC/trac Snaps: 2681-27 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Executions DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats - Absolute ValuesDB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats - Thread Activity DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- IOStat by Function summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- IOStat by Filetype summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- IOStat by Function/Filetype summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Tablespace IO Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- File IO Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Checkpoint Activity DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Instance Recovery Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- MTTR Advisory DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- PGA Aggr Summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- PGA Memory Advisory DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- Shared Pool Advisory DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- SGA Target Advisory DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- Streams Pool Advisory DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- Java Pool Advisory DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Enqueue Activity DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Undo Segment Summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Undo Segment Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Latch Activity DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Latch Miss Sources DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Mutex Sleep Summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Parent Latch Statistics DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Logical Reads: 1 -> Captured Segments account for 1.9E+11% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA FINAL TABLE 1.830291E+09 1.8E+11 TRAC TRAC_DATA VSRBENCH TABLE 32,244,704 3.2E+09 TRAC TRAC_DATA CURVES TABLE 8,474,784 8.5E+08 SYS SYSTEM I_SYSAUTH1 INDEX 2,323,344 2.3E+08 SYS TEMP SYS_TEMP_0FD9D6606_1 TABLE 1,479,104 1.5E+08 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Physical Reads: 1 -> Captured Segments account for 1.8E+11% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA FINAL TABLE 1.824030E+09 1.8E+11 TRAC TRAC_DATA VSRBENCH TABLE 12,025,778 1.2E+09 TRAC TRAC_DATA CURVES TABLE 5,759,109 5.8E+08 TRAC TRAC_DATA CHRA TABLE 135,517 1.4E+07 TRAC TRAC_DATA VSRBENCH_040907 TABLE 36,478 3.6E+06 ------------------------------------------------------------- Segments by Physical Read Requests DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Physical Read Requests: 1 -> Captured Segments account for 5.8E+09% of Total Tablespace Subobject Obj. Phys Read Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA FINAL TABLE 57,045,281 5.7E+09 TRAC TRAC_DATA VSRBENCH TABLE 380,301 3.8E+07 TRAC TRAC_DATA CURVES TABLE 187,586 1.9E+07 TRAC TRAC_IND SYS_C007076 INDEX 11,186 1.1E+06 TRAC TRAC_DATA CHRA TABLE 5,113 5.1E+05 ------------------------------------------------------------- Segments by UnOptimized Reads DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total UnOptimized Read Requests: 1 -> Captured Segments account for 5.8E+09% of Total Tablespace Subobject Obj. UnOptimized Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA FINAL TABLE 57,045,281 5.7E+09 TRAC TRAC_DATA VSRBENCH TABLE 380,301 3.8E+07 TRAC TRAC_DATA CURVES TABLE 187,586 1.9E+07 TRAC TRAC_IND SYS_C007076 INDEX 11,186 1.1E+06 TRAC TRAC_DATA CHRA TABLE 5,113 5.1E+05 ------------------------------------------------------------- Segments by Optimized Reads DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Segments by Direct Physical Reads DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Direct Physical Reads: 1 -> Captured Segments account for 1.8E+11% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA FINAL TABLE 1.822034E+09 1.8E+11 TRAC TRAC_DATA VSRBENCH TABLE 12,020,022 1.2E+09 TRAC TRAC_DATA CURVES TABLE 5,751,544 5.8E+08 TRAC TRAC_DATA CHRA TABLE 134,616 1.3E+07 TRAC TRAC_DATA VSRBENCH_040907 TABLE 36,000 3.6E+06 ------------------------------------------------------------- Segments by Physical Writes DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Physical Writes: 1 -> Captured Segments account for 7.0E+06% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA VSRBENCH TABLE 10,039 1.0E+06 TRAC TRAC_DATA CURVES TABLE 7,457 7.5E+05 TRAC TRAC_IND SYS_C007076 INDEX 7,457 7.5E+05 SYSTEM SYSTEM AUD$ TABLE 4,740 4.7E+05 TRAC TRAC_IND PK_CHRA INDEX 2,917 2.9E+05 ------------------------------------------------------------- Segments by Physical Write Requests DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Physical Write Requestss: 1 -> Captured Segments account for 4.9E+06% of Total Tablespace Subobject Obj. Phys Write Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA VSRBENCH TABLE 9,097 9.1E+05 TRAC TRAC_IND SYS_C007076 INDEX 6,930 6.9E+05 TRAC TRAC_DATA CURVES TABLE 3,741 3.7E+05 TRAC TRAC_IND PK_CHRA INDEX 2,905 2.9E+05 TRAC TRAC_DATA FINAL TABLE 2,742 2.7E+05 ------------------------------------------------------------- Segments by Direct Physical Writes DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Direct Physical Writes: 1 -> Captured Segments account for 6.7E+05% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 2,668 2.7E+05 ** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 2,512 2.5E+05 ** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 1,207 1.2E+05 ** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 341 3.4E+04 SYS TEMP SYS_TEMP_0FD9D6600_1 TABLE 3 300.00 ------------------------------------------------------------- Segments by Table Scans DB/Inst: TRAC/trac Snaps: 2681-2728 -> Total Table Scans: 1 -> Captured Segments account for 4.0E+06% of Total Tablespace Subobject Obj. Table Owner Name Object Name Name Type Scans %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_DATA FINAL TABLE 39,381 3.9E+06 SYS SYSTEM I_OBJ2 INDEX 413 4.1E+04 TRAC TRAC_DATA VSRBENCH TABLE 62 6.2E+03 SYSMAN SYSAUX MGMT_CURRENT_METRICS INDEX 55 5.5E+03 SYS SYSTEM I_OBJ1 INDEX 41 4.1E+03 ------------------------------------------------------------- Segments by DB Blocks Changes DB/Inst: TRAC/trac Snaps: 2681-2728 -> % of Capture shows % of DB Block Changes for each top segment compared -> with total DB Block Changes for all segments captured by the Snapshot Tablespace Subobject Obj. DB Block % of Owner Name Object Name Name Type Changes Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- SYSTEM SYSTEM AUD$ TABLE 843,504 34.20 SYS TEMP SYS_TEMP_0FD9D6606_1 TABLE 462,160 18.74 ** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 402,064 16.30 TRAC2010 TRAC_DATA VSRBENCH TABLE 184,048 7.46 SYS SYSAUX WRH$_SYSMETRIC_HISTO INDEX 53,632 2.17 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: TRAC/trac Snaps: 2681-2728 -> % of Capture shows % of row lock waits for each top segment compared -> with total row lock waits for all segments captured by the Snapshot Row Tablespace Subobject Obj. Lock % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- TRAC TRAC_IND SYS_C007076 INDEX 34 61.82 TRAC TRAC_IND PK_CHRA INDEX 5 9.09 TRAC TRAC_IND SYS_C007047 INDEX 4 7.27 SYS SYSAUX WRH$_SEG_STAT_PK 46410_2696 INDEX 4 7.27 TRAC TRAC_IND SYS_C007036 INDEX 3 5.45 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: TRAC/trac Snaps: 2681-2728 -> % of Capture shows % of Buffer Busy Waits for each top segment compared -> with total Buffer Busy Waits for all segments captured by the Snapshot Buffer Tablespace Subobject Obj. Busy % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- SYSTEM SYSTEM AUD$ TABLE 123 96.09 TRAC TRAC_IND SYS_C007076 INDEX 3 2.34 SYSMAN SYSAUX MGMT_POLICY_ASSOC_EV TABLE 1 .78 SYS SYSTEM SCHEDULER$_JOB TABLE 1 .78 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Library Cache Activity DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Memory Dynamic Components DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Memory Resize Operations Summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Memory Resize Ops DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Process Memory Summary DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- ------------------- sum ------------------------------------------------------------- SGA breakdown difference DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture Rate DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply Rate DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queue Subscribers DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queues DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queues Rate DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queue Subscribers DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Resource Limit Stats DB/Inst: TRAC/trac Snap: 2728 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Activity DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Rates DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Utilization DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Common Queue DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Dispatchers DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- init.ora Parameters DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- Dynamic Remastering Stats DB/Inst: TRAC/trac Snaps: 2681-2728 No data exists for this section of the report. ------------------------------------------------------------- End of Report