WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORCL1166960197orcl126-May-08 15:0511.1.0.6.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
11gR1NFLinux IA (32-bit) 1   1.32

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:58426-May-08 16:44:4847 3.8
End Snap:58526-May-08 16:45:5446 3.9
Elapsed:  1.09 (mins)  
DB Time:  3.23 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 172M 172MStd Block Size: 8K
Shared Pool Size: 204M 204MLog Buffer: 5,988K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 3.0 5.7 0.00 0.23
DB CPU(s): 0.5 1.0 0.00 0.04
Redo size: 292,721.0 563,350.1  
Logical reads: 7,776.7 14,966.5  
Block changes: 2,662.2 5,123.5  
Physical reads: 13.3 25.5  
Physical writes: 0.3 0.6  
User calls: 13.1 25.1  
Parses: 27.2 52.4  
Hard parses: 1.4 2.7  
W/A MB processed: 707,460.5 1,361,528.5  
Logons: 0.4 0.7  
Executes: 802.5 1,544.4  
Rollbacks: 0.1 0.2  
Transactions: 0.5   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 100.00
Buffer Hit %: 99.83In-memory Sort %: 100.00
Library Hit %: 99.34Soft Parse %: 94.78
Execute to Parse %: 96.61Latch Hit %: 99.98
Parse CPU to Parse Elapsd %: 0.00% Non-Parse CPU: 97.73

Shared Pool Statistics

BeginEnd
Memory Usage %: 91.83 91.30
% SQL with executions>1: 86.06 86.33
% Memory for SQL w/exec>1: 83.86 82.66

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 33 16.82 
buffer deadlock1623146612.09Other
db file sequential read865212410.66User I/O
cursor: pin S wait on X1,29316128.32Concurrency
log file sync4591944.50Commit

Host CPU (CPUs: 1 Cores: Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
1.53 4.68 29.0 47.6 5.1 22.8
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
50.9 66.0 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 1,355.4 1,355.4
SGA use (MB): 404.0 404.0
PGA use (MB): 224.1 231.0
% Host Mem used for SGA+PGA: 46.34 46.34

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time178.4792.02
parse time elapsed50.6526.11
PL/SQL execution elapsed time39.1920.21
hard parse elapsed time36.7618.95
DB CPU32.6216.82
connection management call elapsed time10.725.52
PL/SQL compilation elapsed time4.032.08
sequence load elapsed time0.040.02
repeated bind elapsed time0.000.00
hard parse (sharing criteria) elapsed time0.000.00
DB time193.95 
background elapsed time14.58 
background cpu time0.81 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME5,068 
IDLE_TIME1,501 
IOWAIT_TIME338 
SYS_TIME3,124 
USER_TIME1,902 
LOAD25
PHYSICAL_MEMORY_BYTES1,421,262,848 
NUM_CPUS1 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX262,144 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
26-May 16:44:481.53     
26-May 16:45:544.6877.1528.9547.565.1522.85

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Concurrency1,56383332117.24
DB CPU  33 16.82
Other43402661013.52
User I/O9040232511.81
Commit45491944.50
Configuration500170.04
System I/O7410000.01
Application50010.00
Network5460000.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
buffer deadlock161002314660.4712.09
db file sequential read8650212425.4410.66
cursor: pin S wait on X1,293100161238.038.32
log file sync45491941.324.50
latch: shared pool69071042.033.70
buffer busy waits11403293.351.69
library cache load lock14021760.411.27
read by other session3602611.061.13
enq: TX - index contention3702581.091.10
library cache: mutex X1210011180.350.73
cursor: pin S1100111010.030.57
latch: cache buffers chains1801400.530.37
WCR: Sync context busy1015780.030.30
enq: FB - contention1001550.290.28
latch free500450.150.11
enq: TX - contention2001020.060.10
latch: row cache objects500200.150.05
latch: redo allocation600150.180.05
latch: redo copy200230.060.02
db file scattered read200190.060.02
enq: TX - allocate ITL entry100230.030.01
latch: object queue header operation100210.030.01
row cache lock100210.030.01
enq: SQ - contention100140.030.01
control file sequential read74100021.790.01
flashback buf free by RVWR10080.030.00
enq: TX - row lock contention10050.030.00
SQL*Net message to client54200015.940.00
SQL*Net break/reset to client40010.120.00
SQL*Net message from client5420840155015.94 
PL/SQL lock timer169415898930.47 
WCR: replay clock387910327131.12 
wait for unread message on broadcast channel651006510041.91 
Streams AQ: waiting for messages in the queue131006550070.38 
WCR: replay client notify66765107690.18 
jobq slave wait111004036010.32 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write8407782.4744.84
control file parallel write42051081.2430.99
os thread startup1001350.030.92
latch: shared pool200460.060.64
control file sequential read970002.850.08
rdbms ipc message37778827219411.09 
DIAG idle wait9410012913692.76 
ASM background timer1207158900.35 
pmon timer38586817901.12 
Space Manager: slave idle wait131006550080.38 
Streams AQ: qmn slave idle wait2058289660.06 
Streams AQ: qmn coordinator idle wait210058289660.06 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
SQL*Net break/reset to client475.025.0      
SQL*Net message to client60999.8.2      
SQL*Net more data from client1100.0       
SQL*Net more data to client3100.0       
WCR: Sync context busy1      100.0 
buffer busy waits11428.94.44.46.114.918.422.8 
buffer deadlock166.3    6.331.356.3
control file parallel write43   20.94.711.662.8 
control file sequential read83999.9  .1    
cursor: pin S1       100.0
cursor: pin S wait on X1293.3   92.75.81.2 
db file scattered read2     100.0  
db file sequential read87265.51.81.02.56.87.914.2.2
direct path write1100.0       
enq: FB - contention10    10.020.070.0 
enq: HW - contention1100.0       
enq: SQ - contention1    100.0   
enq: TX - allocate ITL entry1     100.0  
enq: TX - contention2      100.0 
enq: TX - index contention372.7 5.42.724.324.340.5 
enq: TX - row lock contention1   100.0    
flashback buf free by RVWR1    100.0   
latch free728.6    14.357.1 
latch: cache buffers chains1811.15.6  11.133.338.9 
latch: object queue header operation1     100.0  
latch: redo allocation6  16.7 50.033.3  
latch: redo copy2    50.050.0  
latch: row cache objects5 20.0  40.020.020.0 
latch: shared pool78 1.3 1.312.811.573.1 
library cache load lock14   7.17.121.464.3 
library cache: mutex X1225.0 16.78.316.78.325.0 
log file parallel write843.610.711.94.82.49.557.1 
log file sync452.22.24.42.22.28.973.34.4
os thread startup1      100.0 
read by other session36   5.611.133.350.0 
row cache lock1     100.0  
ASM background timer11       100.0
DIAG idle wait96      54.245.8
PL/SQL lock timer166.3   6.3 18.868.8
SQL*Net message from client60958.019.46.12.82.02.34.94.6
Space Manager: slave idle wait13       100.0
Streams AQ: qmn coordinator idle wait2       100.0
Streams AQ: qmn slave idle wait2       100.0
Streams AQ: waiting for messages in the queue13       100.0
WCR: replay client notify5      40.060.0
WCR: replay clock38      10.589.5
dispatcher timer1       100.0
jobq slave wait12       100.0
pmon timer362.85.68.3 5.6 16.761.1
rdbms ipc message3814.5 .5.81.31.630.460.9
virtual circuit status2       100.0
wait for unread message on broadcast channel66      100.0 

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
BATCH_STD92200406
SYS$USERS41508
BATCH_LOW354086
DSS21202
OLTP3100
orcl.oracle.com2106
ADHOC0000
SYS$BACKGROUND0000
orcl0000
orclXDB0000

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
BATCH_STD 000000600
SYS$USERS 184129100540
BATCH_LOW 16820000300
DSS 0000001800
OLTP 000000300
orcl.oracle.com 29051001920
SYS$BACKGROUND 00300000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
519225.3926.180wvttswphs2ky SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
43313,7060.0022.121dmv3vasxtjtu LoadGenerator INSERT INTO AP.INVOICE_ITEMS (...
372136.7518.951vu8j8vxpak4v Admin Connection BEGIN :1 := dbms_workload_repl...
3610218.0618.624ymp71aaj3bud SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
344217.1917.731bshjy696nrzg SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
13313,7080.006.519cgwmxs9wdnx4 LoadGenerator SELECT PRODUCT_ID FROM (SELECT...
1103140.045.81abchp6whju3fy SQL*Plus SELECT CUSTOMER_ID FROM (SELEC...
111111.115.730ytkqyqa89xq7 Admin Connection SELECT XMLCONCAT( :B1 , DBMS_...
111111.055.70g6f8nqdzgv9xg Admin Connection SELECT xmlelement( "top_ser...
7017.413.828nqkx2x3yj2ng Admin Connection SELECT APPENDCHILDXML(PRVT_REP...
5022.562.644wjn4yqfuykz8 SQL*Plus DECLARE rcout AP.PKG_LOAD...
4014.292.21f6d6y4g13d49s Admin Connection SELECT XMLCONCAT( :B1 , DBMS_...
4014.292.210qnq5z54k66cg Admin Connection SELECT xmlelement( "a...
4014.132.13fguvzz4t33qbn Admin Connection SELECT XMLCONCAT( :B1 , DBMS_...
4014.122.13c32jw7cwf856w Admin Connection SELECT xmlelement( "top_ses...
4021.952.01aquqna9vhr57b SQL*Plus DECLARE rcout AP.PKG_LOAD...
30210.161.7739m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
31100.311.614cpkqmdsq46br SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
30200.131.341uzhrfn574t12 wrc@11gR1NF (TNS V1-V3) SELECT ATTRIBUTE, SCOPE, NUMER...
201140.021.22db78fxqxwxt7r   select /*+ rule */ bucket, en...
2012.301.1951ns8aw6c5wq5 Admin Connection SELECT DBMS_ASH_INTERNAL.BUILD...
20210.111.18cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
2080.251.03bgjhtnqhr5u9h   select procedure#, entrypoint#...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
103624.9230.1918.624ymp71aaj3bud SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
95124.6928.7526.180wvttswphs2ky SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
43422.1313.0717.731bshjy696nrzg SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
34313,7060.008.8422.121dmv3vasxtjtu LoadGenerator INSERT INTO AP.INVOICE_ITEMS (...
31313,7080.008.636.519cgwmxs9wdnx4 LoadGenerator SELECT PRODUCT_ID FROM (SELECT...
23712.367.2218.951vu8j8vxpak4v Admin Connection BEGIN :1 := dbms_workload_repl...
1111.023.120.763z5b10rcvwbc0 OEM BEGIN dbms_workload_replay.sta...
13100.082.501.614cpkqmdsq46br SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
120 2.230.817snbfvf2qc0v4 WRC$ begin :1 := dbms_workload_repl...
11110.672.075.730ytkqyqa89xq7 Admin Connection SELECT XMLCONCAT( :B1 , DBMS_...
11110.662.045.70g6f8nqdzgv9xg Admin Connection SELECT xmlelement( "top_ser...
0410.441.352.13fguvzz4t33qbn Admin Connection SELECT XMLCONCAT( :B1 , DBMS_...
0410.441.342.13c32jw7cwf856w Admin Connection SELECT xmlelement( "top_ses...
0113,7080.001.310.592cfatxwm4dtjp LoadGenerator SELECT P.LIST_PRICE FROM OE.PR...
0110.381.160.61auu0bcau5ff55 Admin Connection SELECT XMLCONCAT( :B1 , DBMS_...
0110.381.150.61102hp0n5bz675 Admin Connection SELECT xmlelement( "top_sql...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
219,39013,70816.0043.112.8212.629cgwmxs9wdnx4 LoadGenerator SELECT PRODUCT_ID FROM (SELECT...
212,7062106,353.0041.809.8536.124ymp71aaj3bud SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
193,448296,724.0038.029.3850.780wvttswphs2ky SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
101,28713,7067.3919.902.8842.901dmv3vasxtjtu LoadGenerator INSERT INTO AP.INVOICE_ITEMS (...
85,948242,974.0016.894.2634.381bshjy696nrzg SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
27,41413,7082.005.390.431.142cfatxwm4dtjp LoadGenerator SELECT P.LIST_PRICE FROM OE.PR...
21,56830470.954.240.170.76bzbqb10q243ct LoadGenerator UPDATE AP.INVOICES SET BALANCE...
5,00415,004.000.982.3636.751vu8j8vxpak4v Admin Connection BEGIN :1 := dbms_workload_repl...
2,80812,808.000.551.021.483z5b10rcvwbc0 OEM BEGIN dbms_workload_replay.sta...
1,6503105.320.320.101.6941n4g99ucshck LoadGenerator INSERT INTO AP.INVOICES ( INVO...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
59413,7060.0468.512.8842.901dmv3vasxtjtu LoadGenerator INSERT INTO AP.INVOICE_ITEMS (...
2782139.0032.069.3850.780wvttswphs2ky SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
186293.0021.459.8536.124ymp71aaj3bud SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
158279.0018.224.2634.381bshjy696nrzg SQL*Plus BEGIN AP.PKG_LOAD_GENERATO...
88188.0010.152.3636.751vu8j8vxpak4v Admin Connection BEGIN :1 := dbms_workload_repl...
800 9.230.731.577snbfvf2qc0v4 WRC$ begin :1 := dbms_workload_repl...
79179.009.111.021.483z5b10rcvwbc0 OEM BEGIN dbms_workload_replay.sta...
371140.324.270.052.36db78fxqxwxt7r   select /*+ rule */ bucket, en...
35135.004.040.324.290qnq5z54k66cg Admin Connection SELECT xmlelement( "a...
35135.004.040.324.29f6d6y4g13d49s Admin Connection SELECT XMLCONCAT( :B1 , DBMS_...
19210.902.190.032.29cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
1628.001.850.125.124wjn4yqfuykz8 SQL*Plus DECLARE rcout AP.PKG_LOAD...
16116.001.850.092.3051ns8aw6c5wq5 Admin Connection SELECT DBMS_ASH_INTERNAL.BUILD...
163140.051.850.2411.26abchp6whju3fy SQL*Plus SELECT CUSTOMER_ID FROM (SELEC...
1413,7080.001.612.8212.629cgwmxs9wdnx4 LoadGenerator SELECT PRODUCT_ID FROM (SELECT...
9210.431.040.013.4439m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
13,70813,7061.000.000.002cfatxwm4dtjp LoadGenerator SELECT P.LIST_PRICE FROM OE.PR...
13,70813,7061.000.000.009cgwmxs9wdnx4 LoadGenerator SELECT PRODUCT_ID FROM (SELECT...
13,70613,7061.000.000.001dmv3vasxtjtu LoadGenerator INSERT INTO AP.INVOICE_ITEMS (...
7,2907,2901.000.000.00g8tm45j2jdgq8 LoadGenerator SELECT (SQRT(:B2 /:B1 )) FROM ...
3143141.000.000.04abchp6whju3fy SQL*Plus SELECT CUSTOMER_ID FROM (SELEC...
3103060.990.000.0141n4g99ucshck LoadGenerator INSERT INTO AP.INVOICES ( INVO...
3103060.990.000.01gcdp623mad41b LoadGenerator SELECT VENDOR_ID FROM (SELECT ...
3043041.000.000.00bzbqb10q243ct LoadGenerator UPDATE AP.INVOICES SET BALANCE...
1449696.730.000.000h6b2sajwb74n   select privilege#, level from ...
1141,81915.960.000.02db78fxqxwxt7r   select /*+ rule */ bucket, en...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1441448.090h6b2sajwb74n   select privilege#, level from ...
96965.392syvqzbxp4k9z   select u.name, o.name, a.int...
79794.44grwydz59pu6mc   select text from view$ where r...
48482.702xyb5d6xg9srh   select a.default_cpu_cost, a....
48482.706c9wx6z8w9qpu   select a.default_selectivity ...
43432.420k8522rmdzg4k   select privilege# from sysauth...
24241.35bsa0wjtftg3uw   select file# from file$ where ...
23231.293ktacv9r56b51   select owner#, name, namespace...
23231.298swypbbr0m372   select order#, columns, types ...
22221.240kkhhb2w93cx0   update seg$ set type#=:4, bloc...
22221.240ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
22221.24209fr01svbb5s   update sys.aud$ set action#=:2...
22221.24459f3z9u4fb3u   select value$ from props$ wher...
22221.244vs91dcv7u1p6 emagent@11gR1NF (TNS V1-V3) insert into sys.aud$( sessioni...
22221.245ur69atw3vfhj   select decode(failover_method,...
21211.1839m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
21211.18c6awqs517jpj0   select /*+ index(idl_char$ i_i...
21211.18cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
21211.18ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
20201.121uzhrfn574t12 wrc@11gR1NF (TNS V1-V3) SELECT ATTRIBUTE, SCOPE, NUMER...
20201.123mqbg0gn1ky0v LoadGenerator insert into wrr$_replay_diverg...
20201.125qgz1p0cut7mx wrc@11gR1NF (TNS V1-V3) BEGIN DBMS_OUTPUT.DISABLE; END...
20201.12c4pc3jhzjcmc7 wrc@11gR1NF (TNS V1-V3) SELECT CHAR_VALUE FROM SYSTEM....
20201.12cfrvd7bn0fd05 wrc@11gR1NF (TNS V1-V3) select seq_name, seq_bnm, se...
20201.12d6vwqbw6r2ffk wrc@11gR1NF (TNS V1-V3) SELECT USER FROM DUAL
20201.12dyk4dprp70d74 SQL*Plus SELECT DECODE('A', 'A', '1', '...
20201.12g4y6nw3tts7cc wrc@11gR1NF (TNS V1-V3) BEGIN DBMS_APPLICATION_INFO.SE...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kkhhb2w93cx0update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
0qnq5z54k66cg SELECT xmlelement( "ash", (SELECT xmlagg( xmlelement( "total_ash_count", dim_count ) ORDER BY dim_count desc ) FROM ( SELECT 1 , count(*) as dim_count, rank() over (order by count(*) desc, 1 ) as dim_rank FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) a WHERE 1 = 1 GROUP BY 1 ) WHERE 1 = 1 ) ) FROM dual
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0wvttswphs2kyBEGIN AP.PKG_LOAD_GENERATOR.RandomDML(250); COMMIT; END;
0ytkqyqa89xq7SELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_2D( 'top_service_module_actions' ) ) FROM DUAL
102hp0n5bz675 SELECT xmlelement( "top_sql_events", (SELECT xmlagg( dbms_ash_internal.build_sql_tag( sql_id => sql_id, planhash => max(sql_plan_hash_value), ash_num_executions => count(distinct sql_exec_id), ash_count => count(*), xtra => (SELECT xmlagg( dbms_ash_internal.build_event_tag ( event_name => nvl(event, 'CPU + wait for CPU'), ash_count => count(*) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_i d, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d2 WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.sql_id is not null and d2.sql_id = d1.sql_id GROUP BY event ) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.cu rrent_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id l ike :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d1 WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.sql_id is not null GROUP BY sql_id ) ) FROM dual
1bshjy696nrzgBEGIN AP.PKG_LOAD_GENERATOR.RandomDML(375); COMMIT; END;
1dmv3vasxtjtuINSERT INTO AP.INVOICE_ITEMS ( INVOICE_ID , LINE_ITEM_NBR , ACTIVE_IND , PRODUCT_ID , QTY , EXTENDED_AMT , TAXABLE_IND ) VALUES( :B6 , :B5 , 'Y' , :B4 , :B3 , :B2 , :B1 )
1uzhrfn574t12SELECT ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE, DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)
1vu8j8vxpak4vBEGIN :1 := dbms_workload_replay.report(:2, :3); END;
209fr01svbb5supdate sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
2cfatxwm4dtjpSELECT P.LIST_PRICE FROM OE.PRODUCT_INFORMATION P WHERE PRODUCT_ID = :B1
2syvqzbxp4k9zselect u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#
2xyb5d6xg9srhselect a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3mqbg0gn1ky0vinsert into wrr$_replay_divergence (id, time, type, exp_num_rows, obs_num_rows, exp_error, obs_error, file_id, call_counter, sql_id, session_id, session_serial#, service, module, action) select :rep_id, time, type, exp_num_rows, obs_num_rows, exp_error, obs_error, file_id, call_counter, sql_id, session_id, session_serial#, service, module, action from x$kecpdentry
3z5b10rcvwbc0BEGIN dbms_workload_replay.start_replay(); END;
41n4g99ucshckINSERT INTO AP.INVOICES ( INVOICE_ID , ACTIVE_IND , INVOICE_TYPE , VENDOR_ID , CUSTOMER_ID , BALANCE_DUE , TAXABLE_AMT ) VALUES( :B3 , 'Y' , 'C' , :B2 , :B1 , 0 , 0 )
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4cpkqmdsq46brBEGIN AP.PKG_LOAD_GENERATOR.SpinCPUs(250); END;
4vs91dcv7u1p6insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
4wjn4yqfuykz8DECLARE rcout AP.PKG_LOAD_GENERATOR.rcReport; BEGIN AP.PKG_LOAD_GENERATOR.RandomQuery(250, rcout); END;
4ymp71aaj3budBEGIN AP.PKG_LOAD_GENERATOR.RandomDML(500); COMMIT; END;
51ns8aw6c5wq5SELECT DBMS_ASH_INTERNAL.BUILD_DATABASE_HEADER_TAG( R.DBID, R.DBNAME, R.DBVERSION, R.PARALLEL, NULL, NULL, NULL, XMLCONCAT(XMLELEMENT( "replay_name", R.NAME), XMLELEMENT( "replay_status", R.STATUS))), CAPTURE_ID FROM DBA_WORKLOAD_REPLAYS R WHERE ID = :B1
5qgz1p0cut7mxBEGIN DBMS_OUTPUT.DISABLE; END;
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6c9wx6z8w9qpuselect a.default_selectivity from association$ a where a.obj# = :1 and a.property = :2
7snbfvf2qc0v4begin :1 := dbms_workload_replay.client_connect( dbms_workload_replay.KECP_CLIENT_CONNECT_GOODBYE ); end;
8nqkx2x3yj2ngSELECT APPENDCHILDXML(PRVT_REPORT_TAGS.BUILD_REPORT_TAG(:B2 ), '/*', :B1 ) FROM DUAL
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
9cgwmxs9wdnx4SELECT PRODUCT_ID FROM (SELECT PRODUCT_ID FROM OE.PRODUCT_INFORMATION SAMPLE(3) WHERE LIST_PRICE IS NOT NULL ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM < 2
abchp6whju3fySELECT CUSTOMER_ID FROM (SELECT CUSTOMER_ID FROM OE.CUSTOMERS SAMPLE(3) ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM < 2
aquqna9vhr57bDECLARE rcout AP.PKG_LOAD_GENERATOR.rcReport; BEGIN AP.PKG_LOAD_GENERATOR.RandomQuery(500, rcout); END;
auu0bcau5ff55SELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_2D( 'top_sql_events' ) ) FROM DUAL
bgjhtnqhr5u9hselect procedure#, entrypoint# from procedureplsql$ where obj#=:1 order by procedure#
bsa0wjtftg3uwselect file# from file$ where ts#=:1
bzbqb10q243ctUPDATE AP.INVOICES SET BALANCE_DUE = :B3 , TAXABLE_AMT = :B2 WHERE INVOICE_ID = :B1
c32jw7cwf856w SELECT xmlelement( "top_session_events", (SELECT xmlagg( dbms_ash_internal.build_session_tag( session_id => session_id, session_serial => session_serial#, user_name => dbms_ash_internal.get_user_name(max(user_id)), program_name => to_char(max(program)), ash_num_transactions => count(distinct xid), ash_count => count(*), xtra => (SELECT xmlagg( dbms_ash_internal.build_event_tag ( event_name => nvl(event, 'CPU + wait for CPU'), ash_count => count(*) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk _etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1. object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d2 WHERE 1 = 1 and bitand(flags, 4) > 0 and d2.session_id = d1.session_id and d2.session_serial# = d1.session_serial# GROUP BY event ) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a. p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_o bject_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS N ULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d1 WHERE 1 = 1 and bitand(flags, 4) > 0 GROUP BY 1, session_id, session_serial# ) ) F ROM dual
c4pc3jhzjcmc7SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND (UPPER(ATTRIBUTE) = 'ROLES')
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cfrvd7bn0fd05select seq_name, seq_bnm, seq_bow, first_value, last_value, change, num_values, call_ctr, rank from WRR$_REPLAY_SEQ_DATA where file_id = :file_id and call_ctr >= :call_ctr and rank > :rank order by call_ctr, rank
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d6vwqbw6r2ffkSELECT USER FROM DUAL
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dyk4dprp70d74SELECT DECODE('A', 'A', '1', '2') FROM DUAL
f6d6y4g13d49sSELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_1D( 'ash' ) ) FROM DUAL
fguvzz4t33qbnSELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_2D( 'top_session_events' ) ) FROM DUAL
g4y6nw3tts7ccBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1, NULL); END;
g6f8nqdzgv9xg SELECT xmlelement( "top_service_module_actions", (SELECT xmlagg( dbms_ash_internal.build_service_module_tag( service_hash => service_hash, service_name => max(a.name), module_name => nvl(module, 'UNNAMED'), ash_count => count(*), xtra => (SELECT xmlagg( dbms_ash_internal.build_action_tag ( action_name => nvl(action, 'UNNAMED'), ash_count => count(*) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as e vent_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line _id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d2 WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.service_hash is not null and d2.service_hash = d1.service_hash and (d2.module = d1.module OR (d2.module IS NULL AND d1.module IS NULL)) GROUP BY action ) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.bl ocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_s ession_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_ sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d1 , v$active_services a WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.service_hash is not null and a.name_hash = d1.service_hash GROUP BY service_hash, module ) ) FROM dual
g8tm45j2jdgq8SELECT (SQRT(:B2 /:B1 )) FROM DUAL
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gcdp623mad41bSELECT VENDOR_ID FROM (SELECT VENDOR_ID FROM AP.VENDORS SAMPLE(3) ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM < 2
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count30.050.09
Batched IO (full) vector count00.000.00
Batched IO block miss count90.140.26
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count60.090.18
Batched IO single block count30.050.09
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
CCursor + sql area evicted390.601.15
CPU used by this session3,01846.1288.76
CPU used when call started3,02346.2088.91
CR blocks created3024.628.88
DB time76,8591,174.602,260.56
DBWR checkpoint buffers written180.280.53
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR transaction table writes00.000.00
DBWR undo block writes40.060.12
Effective IO time00.000.00
HSC Heap Segment Block Changes14,774225.78434.53
Heap Segment Array Inserts781.192.29
Heap Segment Array Updates210.320.62
LOB table id lookup cache misses00.000.00
Number of read IOs issued00.000.00
RowCR - row contention10.020.03
RowCR attempts590.901.74
RowCR hits580.891.71
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client5428.2815.94
Workload Replay: dbtime152,645,7802,332,820.554,489,581.76
Workload Replay: network time19,265294.42566.62
Workload Replay: think time996,23215,224.9929,300.94
Workload Replay: time gain14,196,504216,959.13417,544.24
Workload Replay: time loss167,784,1722,564,174.164,934,828.59
Workload Replay: user calls4406.7212.94
active txn count during cleanout2,07731.7461.09
application wait time00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts2944.498.65
buffer is not pinned count230,0173,515.256,765.21
buffer is pinned count4,03561.67118.68
bytes received via SQL*Net from client134,4622,054.933,954.76
bytes sent via SQL*Net to client128,0191,956.463,765.26
calls to get snapshot scn: kcmgss95,1401,453.982,798.24
calls to kcmgas6229.5118.29
calls to kcmgcs1742.665.12
calls to kcmgrs104,5711,598.113,075.62
change write time1382.114.06
cleanout - number of ktugct calls69010.5420.29
cleanouts and rollbacks - consistent read gets2994.578.79
cleanouts only - consistent read gets70.110.21
cluster key scan block gets2223.396.53
cluster key scans2143.276.29
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed60.090.18
commit batch/immediate requested60.090.18
commit cleanout failures: block lost00.000.00
commit cleanout failures: callback failure70.110.21
commit cleanouts6139.3718.03
commit cleanouts successfully completed6069.2617.82
commit immediate performed60.090.18
commit immediate requested60.090.18
commit nowait performed20.030.06
commit nowait requested20.030.06
commit txn count during cleanout1281.963.76
commit wait/nowait performed20.030.06
commit wait/nowait requested20.030.06
concurrency wait time3,36651.4499.00
consistent changes19,947304.84586.68
consistent gets284,8794,353.688,378.79
consistent gets - examination55,122842.411,621.24
consistent gets direct10.020.03
consistent gets from cache284,8784,353.678,378.76
consistent gets from cache (fastpath)227,8993,482.886,702.91
current blocks converted for CR00.000.00
cursor authentications350.531.03
data blocks consistent reads - undo records applied19,936304.67586.35
db block changes174,1992,662.215,123.50
db block gets223,9813,423.016,587.68
db block gets direct10.020.03
db block gets from cache223,9803,422.996,587.65
db block gets from cache (fastpath)97,5121,490.232,868.00
deferred (CURRENT) block cleanout applications2483.797.29
dirty buffers inspected00.000.00
enqueue conversions160.240.47
enqueue releases2,04131.1960.03
enqueue requests2,04231.2160.06
enqueue timeouts00.000.00
enqueue waits530.811.56
exchange deadlocks160.240.47
execute count52,511802.501,544.44
failed probes on index block reclamation00.000.00
flashback log writes310.470.91
free buffer inspected91313.9526.85
free buffer requested1,22618.7436.06
heap block compress320.490.94
hot buffers moved to head of LRU5418.2715.91
immediate (CR) block cleanout applications3064.689.00
immediate (CURRENT) block cleanout applications3325.079.76
index crx upgrade (positioned)971.482.85
index crx upgrade (prefetch)00.000.00
index fast full scans (full)30.050.09
index fetch by key15,946243.70469.00
index scans kdiixs13,57854.68105.24
leaf node 90-10 splits300.460.88
leaf node splits961.472.82
lob reads00.000.00
lob writes50.080.15
lob writes unaligned50.080.15
logons cumulative240.370.71
messages received1021.563.00
messages sent1021.563.00
no work - consistent read gets186,3182,847.425,479.94
opened cursors cumulative52,351800.061,539.74
parse count (failures)00.000.00
parse count (hard)931.422.74
parse count (total)1,78027.2052.35
parse time cpu741.132.18
parse time elapsed2,38436.4370.12
physical read IO requests85613.0825.18
physical read bytes7,102,464108,543.94208,896.00
physical read total IO requests1,71426.1950.41
physical read total bytes21,004,288320,999.60617,773.18
physical read total multi block requests00.000.00
physical reads86713.2525.50
physical reads cache86513.2225.44
physical reads cache prefetch110.170.32
physical reads direct20.030.06
physical reads direct (lob)10.020.03
physical reads direct temporary tablespace00.000.00
physical reads for flashback new68810.5120.24
physical reads prefetch warmup00.000.00
physical write IO requests170.260.50
physical write bytes155,6482,378.704,577.88
physical write total IO requests4026.1411.82
physical write total bytes31,361,024479,277.20922,383.06
physical write total multi block requests450.691.32
physical writes190.290.56
physical writes direct10.020.03
physical writes direct (lob)10.020.03
physical writes direct temporary tablespace00.000.00
physical writes from cache180.280.53
physical writes non checkpoint30.050.09
pinned buffers inspected00.000.00
prefetch warmup blocks aged out before use400.611.18
prefetched blocks aged out before use10.020.03
process last non-idle time1552.374.56
recursive calls68,6911,049.782,020.32
recursive cpu usage1,28219.5937.71
redo blocks checksummed by FG (exclusive)3,46853.00102.00
redo blocks written38,500588.381,132.35
redo blocks written for direct writes8,228125.75242.00
redo buffer allocation retries00.000.00
redo entries87,5211,337.552,574.15
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks250.380.74
redo size19,153,904292,720.97563,350.12
redo synch time86913.2825.56
redo synch writes600.921.76
redo wastage20,640315.43607.06
redo write time6539.9819.21
redo writer latching time00.000.00
redo writes841.282.47
rollback changes - undo records applied42,050642.631,236.76
rollbacks only - consistent read gets50.080.15
rows fetched via callback15,533237.38456.85
session connect time00.000.00
session cursor cache hits51,329784.441,509.68
session logical reads508,8607,776.6914,966.47
shared hash latch upgrades - no wait1,41321.5941.56
sorts (memory)15,076230.40443.41
sorts (rows)131,5172,009.923,868.15
sql area evicted1772.715.21
sql area purged00.000.00
summed dirty queue length00.000.00
switch current to new buffer550.841.62
table fetch by rowid18,477282.38543.44
table fetch continued row70.110.21
table scan blocks gotten181,0902,767.525,326.18
table scan rows gotten259,7833,970.157,640.68
table scans (long tables)00.000.00
table scans (short tables)13,840211.51407.06
total number of times SMON posted00.000.00
transaction rollbacks60.090.18
undo change vector size4,381,45666,959.93128,866.35
user I/O wait time2,29735.1067.56
user calls85413.0525.12
user commits280.430.82
user rollbacks60.090.18
workarea executions - optimal14,652223.92430.94
write clones created in background00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current4746
session uga memory max526,667,060543,065,936
session pga memory334,563,044341,772,004
session pga memory max489,592,316500,012,540
session cursor cache count10,12310,821
session uga memory429,547,570,376433,844,037,372
opened cursors current179180

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
UNDOTBS1 51685.411.0030618.33
EXAMPLE 143211.961.080014336.64
SYSTEM 1182128.311.005010.00
SYSAUX 54112.221.009000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EXAMPLE/u01/app/oracle/oradata/orcl/example01.dbf 143211.961.080014336.64
SYSAUX/u01/app/oracle/oradata/orcl/sysaux01.dbf 54112.221.009000.00
SYSTEM/u01/app/oracle/oradata/orcl/system01.dbf 1182128.311.005010.00
UNDOTBS1/u01/app/oracle/oradata/orcl/undotbs01.dbf 51685.411.0030618.33

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D21,414100508,8068621800150


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B029285117595031843209503 
E0381311394424791518432047915 

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D160.091,9923.66118,949
D320.183,9841.7958,372
D480.275,9761.5149,249
D640.367,9681.3744,636
D800.459,9601.2139,463
D960.5511,9521.1136,214
D1120.6413,9441.0835,143
D1280.7315,9361.0433,894
D1440.8217,9281.0333,512
D1600.9119,9201.0233,130
D1761.0021,9121.0032,531
D1921.0923,9041.0032,404
D2081.1825,8961.0032,391
D2241.2727,8881.0032,378
D2401.3629,8801.0032,378
D2561.4531,8721.0032,378
D2721.5533,8641.0032,378
D2881.6435,8561.0032,378
D3041.7337,8481.0032,378
D3201.8239,8400.8327,065

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00440

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B15031224.060.000.000.000.0030,720
E15028231.020.000.000.000.0030,720

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K14,63214,63200
64K128K2200
512K1024K171700
1M2M1100

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
190.13998.59146.6987.0017263,628
380.25998.59146.6987.0017263,628
750.50998.59146.6987.0017263,628
1130.75998.5986.2092.0012249,706
1501.00998.590.00100.000229,863
1801.20998.590.00100.000229,863
2101.40998.590.00100.000229,863
2401.60998.590.00100.000229,863
2701.80998.590.00100.000229,863
3002.00998.590.00100.000229,863
4503.00998.590.00100.000229,863
6004.00998.590.00100.000229,863
9006.00998.590.00100.000229,863
1,2008.00998.590.00100.000229,863

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
1320.65226845,2490.995492.4039
1560.76262,99145,2750.995232.28405
1800.88505,15645,5251.002731.19407
2041.00737,30845,5691.002291.00407
2281.12899,78445,5691.002291.00407
2521.24899,78445,5691.002291.00407
2761.35899,78445,5691.002291.00407
3001.47899,78445,5691.002291.00407
3241.59899,78445,5691.002291.00407
3481.71899,78445,5691.002291.00407
3721.82899,78445,5691.002291.00407
3961.94899,78445,5691.002291.00407
4202.06899,78445,5691.002291.00407

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2020.501,78549,174
3030.751,24036,155
4041.001,12032,473
5051.251,11732,320
6061.501,00827,008
7071.751,00827,008
8082.001,00827,008

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
41.000000
82.000000
123.000000
164.000000
205.000000
246.000000
287.000000
328.000000
369.000000
4010.000000
4411.000000
4812.000000
5213.000000
5614.000000
6015.000000
6416.000000
6817.000000
7218.000000
7619.000000
8020.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
121.000202421.002291.00157
161.330211421.002291.00164
201.670211421.002291.00164
242.000211421.002291.00164

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block124429
2nd level bmb71120
1st level bmb9178
undo block6018
segment header4020

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 3737037258.65
FB-Format Block 3131010153.00
TX-Transaction 236236020100.00
SQ-Sequence Cache 171701020.00
TX-Transaction (allocate ITL entry) 1101020.00
HW-Segment High Water Mark 666601010.00
TX-Transaction (row lock contention) 1101010.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch400.00 00 
ASM map operation freelist40.00 00 
ASM map operation hash table30.00 00 
ASM network background latch220.00 00 
AWR Alerted Metric Element list4080.00 00 
Change Notification Hash table latch220.00 00 
Consistent RBA840.00 00 
DML lock allocation43,1310.00 00 
Event Group Locks240.00 00 
FAL request queue10.00 00 
FAL subheap alocation10.00 00 
FIB s.o chain latch80.00 00 
FOB s.o list latch780.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch10.00 00 
JS Sh mem access10.00 00 
JS queue access latch10.00 00 
JS queue state obj latch9360.00 00 
JS slv state obj latch40.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch160.00 00 
KFMD SGA30.00 00 
KFR redo allocation latch10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch220.00 00 
KTF sga latch0  0170.00
KWQP Prop Status20.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch60.00 00 
Locator state objects pool parent latch10.00 00 
MQL Tracking Latch0  020.00
Memory Management Latch10.00 0220.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch1,5960.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process990.00 00 
OS process allocation730.00 00 
OS process: request allocation470.00 00 
PL/SQL warning settings1380.00 00 
QMT10.00 00 
Real-time plan statistics latch20.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch80.00 0200.00
SQL memory manager workarea list latch2,0230.00 00 
Shared B-Tree200.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: kecu cas mem160.00 00 
Write State Object Pool Parent Latch10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch370.00 00 
active service list3590.00 0380.00
archive control80.00 00 
archive process latch220.00 00 
begin backup scn array10.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles2180.00 00 
cache buffers chains1,025,4920.020.1219290.00
cache buffers lru chain1,3200.00 03440.00
cache table scan latch20.00 020.00
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch480.00 00 
channel operations parent latch4830.00 00 
checkpoint queue latch5340.00 01,0410.00
client/application info15,7230.00 00 
commit callback allocation10.00 00 
compile environment latch240.00 00 
corrupted undo seg lock126,1560.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch160.00 00 
cv apply list lock10.00 00 
cv free list lock10.00 00 
deferred cleanup latch160.00 00 
dml lock allocation160.00 00 
done queue latch10.00 00 
dummy allocation500.00 00 
enqueue hash chains4,1580.00 030.00
enqueues2,7180.00 00 
fifth spare latch10.00 00 
file cache latch360.00 00 
flashback allocation9500.00 00 
flashback copy10.00 08990.22
flashback mapping290.00 00 
flashback sync request30.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA220.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch0  0104,7570.00
hash table modification latch20.00 00 
internal temp table object number allocation latch460.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 020.00
job_queue_processes parameter latch20.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats8480.00 00 
kokc descriptor allocation latch160.00 00 
ksfv messages10.00 00 
kss move lock10.00 00 
ksuosstats global area80.00 00 
ksv allocation latch160.00 00 
ksv class latch10.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch470.00 00 
kwqbsn:qsga40.00 00 
lgwr LWN SCN880.00 00 
library cache load lock1890.00 040.00
list of block allocation950.00 00 
loader state object freelist60.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch10.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch10.00 00 
messages9100.00 00 
mostly latch-free SCN880.00 00 
msg queue latch10.00 00 
multiblock read objects40.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch160.00 00 
object queue header heap430.00 0310.00
object queue header operation3,0370.032.0000 
object stats modification480.00 00 
parallel query alloc buffer90.00 00 
parallel query stats10.00 00 
parameter list2250.00 00 
parameter table management910.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
pesom_heap_alloc10.00 00 
post/wait queue820.00 0450.00
process allocation480.00 0230.00
process group creation470.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch825.001.0000 
recovery domain hash list10.00 00 
redo allocation1793.351.33087,4810.01
redo copy1910.531.00087,4690.02
redo writing3320.00 00 
resmgr group change latch7310.00 00 
resmgr:active threads720.00 00 
resmgr:actses change group680.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list490.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config10.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects298,8890.001.2001,3100.00
rules engine evaluation context statistics0  020.00
rules engine rule set statistics1000.00 00 
second spare latch10.00 00 
sequence cache1,0590.00 00 
session allocation18,2920.00 00 
session idle bit2,0150.00 00 
session queue latch10.00 00 
session state list latch690.00 00 
session switching170.00 00 
session timer370.00 00 
shared pool40,7290.191.18100 
shared pool sim alloc70.00 00 
shared pool simulator46,2460.00 00 
sim partition latch10.00 00 
simulator hash latch26,7390.00 00 
simulator lru latch26,5900.021.000510.00
sort extent pool220.00 00 
space background task latch480.00 0440.00
state object free list20.00 00 
statistics aggregation3,0800.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch10.00 00 
trace latch40.00 00 
transaction allocation9,6280.00 00 
transaction branch allocation370.00 00 
undo global data3,9830.00 00 
user lock1300.771.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains1,025,49216420147
shared pool40,72977910
redo allocation179680
row cache objects298,889560
simulator lru latch26,590440
qmn task queue latch8220
redo copy19220
object queue header operation3,037120
user lock130110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chainskcbgtcr: fast path082
cache buffers chainskcbchg1: kslbegin: bufs not pinned052
cache buffers chainskcbgtcr: fast path (cr pin)043
cache buffers chainskcbgcur_2023
cache buffers chainskcbrls_2020
cost functionkzulgt: find user res011
object queue header operationkcbo_unlink_q020
qmn task queue latchkwqmnmvtsks: delay to ready list020
redo allocationkcrfw_redo_gen: redo allocation 1080
redo copykcrfw_redo_gen: nowait020
row cache objectskqreqd: reget030
row cache objectskqreqd023
row cache objectskqrpre: find obj013
shared poolkghalo04925
shared poolkghupr103256
shared poolkghalp078
shared poolkghfre032
simulator lru latchkcbs_simulate: simulate set044

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
OEEXAMPLEPRODUCT_INFORMATION TABLE232,78445.75
APEXAMPLEINVOICE_ITEMS_PK_IDX INDEX28,6405.63
APEXAMPLEINVOICE_ITEMS_PROD_IDX INDEX28,2885.56
OEEXAMPLEPRODUCT_INFORMATION_PK INDEX27,2325.35
APEXAMPLEINVOICE_ITEMS TABLE14,5762.86

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
APEXAMPLEINVOICE_ITEMS_PK_IDX INDEX586.69
APEXAMPLEINVOICE_ITEMS TABLE424.84
APEXAMPLEINVOICE_ITEMS_PROD_IDX INDEX364.15
OEEXAMPLEPRODUCT_INFORMATION TABLE141.61
SYSSYSAUXWRH$_LATCH960197_569TABLE PARTITION80.92

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APEXAMPLEINVOICE_ITEMS_PROD_IDX INDEX2052.63
APEXAMPLEINVOICE_ITEMS_PK_IDX INDEX1744.74
SYSSYSTEMWRR$_REPLAYS TABLE12.63

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
APEXAMPLEINVOICE_ITEMS_PROD_IDX INDEX1100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
APEXAMPLEINVOICE_ITEMS_PK_IDX INDEX5853.70
APEXAMPLEINVOICE_ITEMS_PROD_IDX INDEX3532.41
APEXAMPLEINVOICE_ITEMS TABLE1211.11
APEXAMPLEINVOICES_PK_IDX INDEX21.85
SYSSYSTEMAUD$ TABLE10.93

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control50.000 21
dc_database_links440.000 01
dc_global_oids4710.210 0262
dc_histogram_data8,1791.390 02,257
dc_histogram_defs10,3780.810 05,687
dc_object_grants14213.380 0148
dc_objects4,4941.090 04,555
dc_profiles230.000 02
dc_segments2854.210 211,643
dc_sequences166.250 1611
dc_tablespace_quotas160.000 01
dc_tablespaces60,7790.000 013
dc_users20,6920.020 0126
global database name670.000 01


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1633.074502.6700
CLUSTER1150.00120.0000
INDEX110.0080.0000
SQL AREA83414.1553,7570.5100
TABLE/PROCEDURE4,2151.072,2473.8710
TRIGGER370.00540.0000


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache172.00172.00164.00176.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target152.00152.00152.00152.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target404.00404.00404.00404.000STA/
Shared IO Pool4.004.004.004.000STA/
java pool12.0012.008.0012.000GRO/IMM
large pool4.004.004.004.000STA/
shared pool204.00204.00204.00212.000SHR/DEF
streams pool4.004.004.004.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther196.69 4.016.4524294949
 Freeable24.560.000.940.634 2626
 SQL2.240.980.070.05093027
 PL/SQL0.600.390.010.01004747
EOther205.33 4.286.6424294848
 Freeable22.810.000.950.664 2424
 SQL2.401.110.080.07092926
 PL/SQL0.620.350.010.02004646

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers180,355,072 
Fixed Size1,300,352 
Redo Buffers6,131,712 
Variable Size239,077,504 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory3.673.670.00
javajoxlod exec hp8.068.060.00
javajoxs heap0.270.270.00
largeASM map operations hashta0.230.230.00
largePX msg pool0.200.200.00
largefree memory3.543.581.10
sharedCCursor12.2412.391.24
sharedHeap0: KGL6.505.91-9.07
sharedKCB Table Scan Buffer3.803.800.00
sharedKGL buckets3.003.000.00
sharedKGL handle7.657.751.24
sharedKGLS heap8.697.95-8.54
sharedKQR M PO5.925.22-11.75
sharedKSFD SGA I/O b3.793.790.00
sharedPCursor4.845.023.73
sharedPL/SQL DIANA13.2313.20-0.21
sharedPL/SQL MPCODE15.4815.560.54
sharedXDB Schema Cac6.886.880.00
sharedflashback generation buff3.803.800.00
sharedfree memory16.6717.756.52
sharedrow cache3.613.610.00
sharedsql area38.7539.221.21
sharedsql area:PLSQL2.182.07-5.06
sharedtype object de3.283.300.34
streamsfree memory4.004.000.00
 buffer_cache172.00172.000.00
 fixed_sga1.241.240.00
 log_buffer5.855.850.00
 shared_io_pool4.004.000.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator3,00000
QMON Slaves1,00000

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R00000

Back to Streams Statistics
Back to Top

Persistent Queues

Queue Schema and NameIncoming Msg per secondOutgoing Msg per secondExpired Msg per secondReady Msg per second
SYS.ALERT_QUE0000
SYSMAN.MGMT_NOTIFY_Q0000
SYSMAN.MGMT_TASK_Q0000

Back to Streams Statistics
Back to Top

Persistent Subscribers

Subscriber NameIncoming Msg per secondOutgoing Msg per secondExpired Msg per second
B1GR1NF_3938_ORCL000
HAE_SUB000

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/orcl/adump  
audit_trailDB  
compatible11.1.0.0.0  
control_files/u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/oradata/orcl/control02.ctl, /u01/app/oracle/oradata/orcl/control03.ctl  
db_block_size8192  
db_domain    
db_nameorcl  
db_recovery_file_dest/u03/fra  
db_recovery_file_dest_size3221225472  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=orclXDB)  
open_cursors300  
optimizer_capture_sql_plan_baselinesFALSE  
optimizer_features_enable11.1.0.6  
optimizer_index_caching0  
optimizer_index_cost_adj100  
optimizer_modeALL_ROWS  
pga_aggregate_target157286400  
processes150  
remote_login_passwordfileEXCLUSIVE  
service_namesorcl.oracle.com, OLTP, DSS, ADHOC, BATCH_STD, BATCH_LOW  
sga_target423624704  
star_transformation_enabledTRUE  
undo_tablespaceUNDOTBS1  


Back to Top

End of Report