-------- Parallel Run AWR Report for DB: ORNAGE, Inst: ornage, Snaps: 5096-5097

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORNAGE4260570729ornage109-Apr-15 05:0411.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
ACCQADB2150Microsoft Windows x86 64-bit 1 1 1 8.00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:509602-Jun-15 21:00:5255 2.3
End Snap:509702-Jun-15 22:00:3263 2.9
Elapsed:  59.68 (mins)  
DB Time:  206.83 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,456M 1,488MStd Block Size: 8K
Shared Pool Size: 608M 576MLog Buffer: 15,632K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 3.5 23.7 0.30 0.81
DB CPU(s): 0.3 1.7 0.02 0.06
Redo size: 1,308,294.3 8,940,568.8  
Logical reads: 29,761.4 203,382.1  
Block changes: 10,868.8 74,275.0  
Physical reads: 190.9 1,304.6  
Physical writes: 383.0 2,617.3  
User calls: 4.3 29.4  
Parses: 6.5 44.5  
Hard parses: 0.7 4.8  
W/A MB processed: 2.7 18.6  
Logons: 0.2 1.5  
Executes: 11.5 78.7  
Rollbacks: 0.0 0.1  
Transactions: 0.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.87
Buffer Hit %: 99.65In-memory Sort %: 99.94
Library Hit %: 91.65Soft Parse %: 89.15
Execute to Parse %: 43.40Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 5.01% Non-Parse CPU: 98.93

Shared Pool Statistics

BeginEnd
Memory Usage %: 43.00 38.90
% SQL with executions>1: 87.42 70.60
% Memory for SQL w/exec>1: 78.54 68.99

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read188,3053,3291826.83User I/O
direct path read temp128,6251,3201010.64User I/O
DB CPU 906 7.30 
log file switch completion15081654376.57Configuration
log file switch (checkpoint incomplete)32474623016.01Configuration

Host CPU (CPUs: 1 Cores: 1 Sockets: 1)

Load Average BeginLoad Average End%User%System%WIO%Idle
   34.8 11.8  53.4
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
26.7 57.3 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 8,191.6 8,191.6
SGA use (MB): 2,144.0 2,144.0
PGA use (MB): 151.6 229.4
% Host Mem used for SGA+PGA: 28.02 28.97

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time11,454.2992.30
DB CPU905.557.30
connection management call elapsed time801.246.46
parse time elapsed661.375.33
hard parse elapsed time659.155.31
hard parse (sharing criteria) elapsed time590.344.76
PL/SQL execution elapsed time22.930.18
PL/SQL compilation elapsed time8.330.07
repeated bind elapsed time0.080.00
hard parse (bind mismatch) elapsed time0.040.00
failed parse elapsed time0.000.00
sequence load elapsed time0.000.00
DB time12,409.50 
background elapsed time4,411.06 
background cpu time53.63 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME167,283 
AVG_IDLE_TIME191,878 
AVG_SYS_TIME42,303 
AVG_USER_TIME124,980 
BUSY_TIME167,283 
IDLE_TIME191,878 
SYS_TIME42,303 
USER_TIME124,980 
RSRC_MGR_CPU_WAIT_TIME60 
VM_IN_BYTES-12,898,538,025,857,265,664 
VM_OUT_BYTES-208,995,170,296,766,464 
PHYSICAL_MEMORY_BYTES8,589,467,648 
NUM_CPUS1 
NUM_CPU_CORES1 
NUM_CPU_SOCKETS1 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
02-Jun 21:00:520.00     
02-Jun 22:00:320.0046.5834.8011.7853.420.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
User I/O341,48705,7451746.29
Configuration70102,208315017.79
DB CPU  906 7.30
Commit83504705633.79
Concurrency60019332101.55
Other2,07692320.03
System I/O6403400.02
Scheduler6011010.00
Network9,2060000.00
Application60020.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
db file sequential read188,30503,32918359.3626.83
direct path read temp128,62501,32010245.4710.64
log file switch completion150081654370.296.57
log file switch (checkpoint incomplete)324074623010.626.01
db file scattered read21,02507143440.125.76
log buffer space218064629640.425.21
log file sync83504705631.593.79
direct path write temp3,2940262806.292.11
buffer busy waits46019141480.091.54
Disk file operations I/O18201166390.350.94
read by other session25031030.050.02
control file sequential read6403400.120.02
latch: cache buffers lru chain11501120.220.01
library cache load lock2016690.000.01
asynch descriptor resize1,910100103.650.01
resmgr:cpu quantum6011010.010.00
ADR block file read5011010.010.00
latch: redo copy701720.010.00
latch: cache buffers chains800460.020.00
enq: HW - contention2001580.000.00
latch: undo global data2001320.000.00
Parameter File I/O1600150.030.00
latch: redo allocation270090.050.00
cursor: pin S wait on X200380.000.00
buffer exterminate21000350.000.00
latch: object queue header operation90060.020.00
latch: messages100320.000.00
db file parallel read100230.000.00
SQL*Net message to client9,07400017.320.00
SQL*Net break/reset to client60020.010.00
SQL*Net more data to client1320000.250.00
SQL*Net message from client9,071040,118442317.31 
jobq slave wait6,6941003,49452212.77 
PL/SQL lock timer1100111510.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file parallel write18,82601,1115935.9325.18
log file parallel write4,39809532178.3921.60
control file sequential read15,19106854528.9915.53
control file parallel write2,85702881015.456.54
db file sequential read3,3840134406.463.04
enq: CF - contention5409918410.102.25
buffer busy waits4052129550.011.17
Disk file operations I/O1910512650.361.15
enq: TH - metric threshold evaluation1040402490.000.91
log file switch (checkpoint incomplete)403177630.010.70
os thread startup1220242010.230.55
Parameter File I/O352023660.670.53
latch free251023920.480.53
log file switch completion301963220.010.43
direct path write241013530.460.29
log file single write20208390.390.18
db file scattered read13406450.260.14
direct path read20406270.390.13
Streams AQ: qmn coordinator waiting for slave to start250526010.000.12
log buffer space5059050.010.10
enq: HW - contention10437210.000.08
log file sync6034740.010.06
enq: JD - contention10327320.000.06
log file sequential read20203130.390.06
LGWR wait for redo copy6402290.120.04
rdbms ipc reply3701360.070.03
SQL*Net break/reset to client1,1960112.280.02
latch: redo allocation2500130.050.01
latch: redo writing200950.000.00
direct path write temp1001310.000.00
SQL*Net more data to client5870001.120.00
latch: In memory undo latch100320.000.00
reliable message350010.070.00
latch: cache buffers lru chain20070.000.00
SQL*Net more data from client5870001.120.00
enq: JS - queue lock20020.000.00
latch: object queue header operation10040.000.00
asynch descriptor resize774100001.480.00
SQL*Net message to client2,4190004.620.00
latch: cache buffers chains20010.000.00
rdbms ipc message20,1016839,077194438.36 
DIAG idle wait6,9231007,181103713.21 
Streams AQ: qmn slave idle wait24506,720274300.47 
shared server idle wait1201003,605300380.23 
Streams AQ: qmn coordinator idle wait130993,593276410.25 
Space Manager: slave idle wait716993,58850111.37 
pmon timer1,700683,58521093.24 
dispatcher timer591003,542600330.11 
smon timer13853,3382567330.02 
class slave wait150299199440.03 
SGA: MMAN sleep for component shrink6,29995761212.02 
SQL*Net message from client3,0310825.78 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read5    20.020.060.0 
Disk file operations I/O37656.119.72.4.81.1.516.23.2
LGWR wait for redo copy6475.01.63.13.11.61.614.1 
Parameter File I/O3689.04.12.711.417.122.632.11.1
SQL*Net break/reset to client120698.3.7.7.2  .1 
SQL*Net message to client11.5K100.0       
SQL*Net more data from client589100.0       
SQL*Net more data to client72199.6.3.1     
Streams AQ: qmn coordinator waiting for slave to start2      50.050.0
asynch descriptor resize269799.7.0   .0.3 
buffer busy waits502.0     24.074.0
buffer exterminate2    50.0 50.0 
control file parallel write2859   .13.827.068.11.0
control file sequential read15.3K47.714.15.38.39.46.68.2.5
cursor: pin S wait on X2    50.0 50.0 
db file parallel read1     100.0  
db file parallel write18.8K5.83.45.410.517.620.936.1.4
db file scattered read21.2K28.46.53.010.317.416.917.3.2
db file sequential read192.1K33.311.67.212.215.310.89.4.1
direct path read21313.62.84.712.215.521.629.6 
direct path read temp128.6K62.83.03.76.99.47.27.0.0
direct path write2419.12.52.58.311.621.644.0.4
direct path write temp33077.21.31.94.37.816.460.6.5
enq: CF - contention541.91.93.77.41.93.761.118.5
enq: HW - contention3      66.733.3
enq: JD - contention1       100.0
enq: JS - queue lock250.0  50.0    
enq: TH - metric threshold evaluation1       100.0
latch free25298.0.4.8    .8
latch: In memory undo latch1     100.0  
latch: cache buffers chains1030.010.010.010.0 20.020.0 
latch: cache buffers lru chain11777.83.44.35.1.92.66.0 
latch: enqueue hash chains2100.0       
latch: messages250.0    50.0  
latch: object queue header operation1040.010.020.010.0 20.0  
latch: redo allocation5284.6 5.8 3.8 5.8 
latch: redo copy7  42.914.3 14.328.6 
latch: redo writing250.0     50.0 
latch: shared pool2100.0       
latch: undo global data2      100.0 
library cache load lock2      100.0 
log buffer space223.4  .9 1.350.746.6
log file parallel write4415  .11.84.35.186.91.8
log file sequential read20231.77.45.016.319.812.47.4 
log file single write202    15.340.644.1 
log file switch (checkpoint incomplete)328 .3    62.537.2
log file switch completion153      57.542.5
log file sync844  .13.313.412.462.28.5
os thread startup122   3.31.636.953.34.9
rdbms ipc reply3794.6     2.72.7
read by other session25  4.08.020.028.036.04.0
reliable message3791.98.1      
resmgr:cpu quantum812.5 12.5 12.537.525.0 
utl_file I/O5100.0       
DIAG idle wait6929      78.421.6
PL/SQL lock timer1       100.0
SGA: MMAN sleep for component shrink62991.0.41.12.292.31.11.8 
SQL*Net message from client12.1K81.16.13.33.31.3.51.72.7
Space Manager: slave idle wait717      .499.6
Streams AQ: qmn coordinator idle wait130.8      99.2
Streams AQ: qmn slave idle wait2451.6   .4  98.0
class slave wait1573.3 6.7  6.76.76.7
dispatcher timer59       100.0
jobq slave wait6704.1     99.8.2
pmon timer170420.5.1.3.5.4.87.070.5
rdbms ipc message20.1K8.3.1.1.3.91.536.052.8
shared server idle wait120       100.0
smon timer137.7      92.3

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ADR block file read340.0 20.040.0    
Disk file operations I/O6680.61.13.73.55.12.91.31.9
LGWR wait for redo copy985.93.11.64.74.7   
Parameter File I/O12066.816.010.33.51.6.5.5.5
SQL*Net break/reset to client199.9   .1   
Streams AQ: qmn coordinator waiting for slave to start1  50.0    50.0
asynch descriptor resize799.7.1.1.1    
buffer busy waits212.0  8.010.06.018.056.0
buffer exterminate150.050.0      
control file parallel write195630.941.419.85.31.2.4.3.7
control file sequential read127391.33.62.11.6.5.3.2.4
cursor: pin S wait on X150.050.0      
db file parallel write687563.516.910.65.02.21.5.4.0
db file scattered read367382.59.54.52.3.8.2.0.1
db file sequential read18.2K90.55.52.21.2.3.1.0.1
direct path read6370.421.66.61.4    
direct path read temp898393.03.81.91.0.3.1.0.0
direct path write10755.625.712.04.61.7 .4 
direct path write temp201638.924.721.811.12.5.5.3.2
enq: CF - contention3720.43.71.911.120.424.17.411.1
enq: HW - contention2  33.333.3   33.3
latch: cache buffers chains280.0 10.010.0    
latch: cache buffers lru chain794.01.7.92.6.9   
latch: redo allocation394.21.9 1.91.9   
latch: redo copy271.4  14.314.3   
latch: redo writing150.0  50.0    
latch: undo global data2 50.0 50.0    
library cache load lock2     100.0  
log buffer space1642.71.34.95.415.723.322.923.8
log file parallel write386911.38.534.133.09.22.0.81.0
log file sequential read1592.64.02.51.0    
log file single write8955.931.79.92.5    
log file switch (checkpoint incomplete)232.3 1.53.725.931.48.229.0
log file switch completion100  3.93.324.226.17.834.6
log file sync55629.313.719.412.910.95.23.74.9
os thread startup6941.816.415.69.010.71.63.31.6
rdbms ipc reply294.6 2.7   2.7 
read by other session1060.012.04.016.04.0 4.0 
resmgr:cpu quantum275.0  12.512.5   

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
Disk file operations I/O798.1  .8.8.3  
Parameter File I/O299.5.5      
Streams AQ: qmn coordinator waiting for slave to start150.0 50.0     
buffer busy waits2844.024.014.08.010.0   
control file parallel write2099.3.4.2.1.0   
control file sequential read6099.6.1.1.1.0   
db file parallel write2100.0.0      
db file scattered read2799.9.0.0.0.0   
db file sequential read11199.9.0.0.0.0   
direct path read temp6100.0.0      
direct path write temp699.8.2      
enq: CF - contention688.91.9 5.63.7   
enq: HW - contention166.733.3      
enq: JD - contention1 100.0      
enq: TH - metric threshold evaluation1     100.0  
latch free299.2  .8    
log buffer space5376.29.010.33.1  1.3 
log file parallel write4599.0.4.4.2    
log file switch (checkpoint incomplete)9571.013.78.53.73.0   
log file switch completion5365.45.27.83.317.6.7  
log file sync4195.11.41.81.3.4   
os thread startup298.41.6      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
ORNAGE10,697866672106,006
SYS$USERS1,683395518
ORNAGEXDB0000
SYS$BACKGROUND00643

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
ORNAGE 338478525841990086130
SYS$USERS 29964861993005930
SYS$BACKGROUND 4491232129760000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
9,448.6842,362.1776.148.8654.65am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
2,683.488335.4321.6210.3764.03492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
2,267.194566.8018.278.9061.104rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
1,396.104349.0211.253.720.64c6h3ypm205u91 JDBC Thin Client INSERT INTO NXGT_ACTR_ALL_GROU...
1,351.724337.9310.8912.0754.04gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
551.245110.814.441.3459.096gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
375.33846.923.028.8465.886n5cgxm2fr14h JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
306.60838.322.476.3785.853dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
302.41475.602.444.6686.91g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
277.446180.452.240.100.514vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
225.47828.181.8219.5222.69a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
158.91439.731.283.3394.44bb0dybyq6bjsm JDBC Thin Client UPDATE NXGT_ACTR_RESULT_SET T ...
133.58433.391.082.3997.94d1dsc597kqr7s JDBC Thin Client DELETE FROM NXGT_ACTR_RESULT_S...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
837.194209.3092.459,448.688.8654.65am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
278.31834.7930.732,683.4810.3764.03492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
201.86450.4622.292,267.198.9061.104rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
163.13440.7818.011,351.7212.0754.04gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
51.92412.985.731,396.103.720.64c6h3ypm205u91 JDBC Thin Client INSERT INTO NXGT_ACTR_ALL_GROU...
44.0285.504.86225.4719.5222.69a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
33.1784.153.66375.338.8465.886n5cgxm2fr14h JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
19.5282.442.16306.606.3785.853dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
14.0843.521.55302.414.6686.91g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
7.38510.140.81551.241.3459.096gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
5,163.6941,290.9286.409,448.688.8654.65am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
1,718.258214.7828.752,683.4810.3764.03492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
1,385.364346.3423.182,267.198.9061.104rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
730.444182.6112.221,351.7212.0754.04gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
325.74516.395.45551.241.3459.096gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
263.20832.904.40306.606.3785.853dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
262.84465.714.40302.414.6686.91g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
247.26830.914.14375.338.8465.886n5cgxm2fr14h JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
150.07437.522.51158.913.3394.44bb0dybyq6bjsm JDBC Thin Client UPDATE NXGT_ACTR_RESULT_SET T ...
130.83432.712.19133.582.3997.94d1dsc597kqr7s JDBC Thin Client DELETE FROM NXGT_ACTR_RESULT_S...
118.83429.711.99121.943.0497.446nr22s0vjrtc1 JDBC Thin Client UPDATE NXGT_ACTR_RESULT_SET SE...
85.70185.701.4386.280.2499.33ajymgnp1qnruw   select o.name, o.owner# from o...
70.234540.151.1870.330.1899.86db78fxqxwxt7r   select /*+ rule */ bucket, end...
62.80144.491.0562.810.0099.98459f3z9u4fb3u   select value$ from props$ wher...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
105,175,161426,293,790.2598.699,448.688.8654.65am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
44,310,619411,077,654.7541.582,267.198.9061.104rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
43,047,55785,380,944.6340.392,683.4810.3764.03492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
5,963,6908745,461.255.60225.4719.5222.69a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
5,272,77741,318,194.254.951,351.7212.0754.04gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
2,195,1874548,796.752.061,396.103.720.64c6h3ypm205u91 JDBC Thin Client INSERT INTO NXGT_ACTR_ALL_GROU...
1,383,5994345,899.751.30302.414.6686.91g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
1,336,7228167,090.251.25375.338.8465.886n5cgxm2fr14h JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
792,9041792,904.000.7438.1116.9374.66572fbaj0fdw2b SQL*Plus select output from table(dbms_...
388,5040 0.3652.913.1392.516mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
671,4414167,860.2598.229,448.688.8654.65am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
165,346820,668.2524.192,683.4810.3764.03492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
138,585434,646.2520.272,267.198.9061.104rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
129,584432,396.0018.961,351.7212.0754.04gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
51,04486,380.507.47306.606.3785.853dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
43,24185,405.136.33375.338.8465.886n5cgxm2fr14h JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
31,24847,812.004.5758.337.0491.94dcy1bgdgavcr4 JDBC Thin Client SELECT TREE_NODE_ID FROM NXGT_...
30,27247,568.004.43121.943.0497.446nr22s0vjrtc1 JDBC Thin Client UPDATE NXGT_ACTR_RESULT_SET SE...
25,00946,252.253.66133.582.3997.94d1dsc597kqr7s JDBC Thin Client DELETE FROM NXGT_ACTR_RESULT_S...
23,69445,923.503.47302.414.6686.91g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
16,06382,007.882.35225.4719.5222.69a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
13,39243,348.001.96158.913.3394.44bb0dybyq6bjsm JDBC Thin Client UPDATE NXGT_ACTR_RESULT_SET T ...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
138,369138,369817,296.130.0039.80492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
20,46920,46982,558.630.005.896n5cgxm2fr14h JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
17,33717,33782,167.130.004.993dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
2,8442,84412,844.000.000.82ajymgnp1qnruw   select o.name, o.owner# from o...
1,0961,0965121.490.000.326gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
9919918123.880.000.29a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
9789780 0.000.2859v4zh1ac3v2a DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
8268260 0.000.24b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
7587580 0.000.226mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
6896891689.000.000.20572fbaj0fdw2b SQL*Plus select output from table(dbms_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
4,6725,0191.070.68100.910.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
2,0601,9480.951.5621.0878.183c1kubcdjnppq   update sys.col_usage$ set equa...
9399391.0022.680.6299.46grwydz59pu6mc   select text from view$ where r...
8761,7421.996.831.6098.385n1fs4m2n2y0r   select pos#, intcol#, col#, sp...
7567561.000.2374.840.56bsa0wjtftg3uw   select file# from file$ where ...
68100.000.0533.010.00b2gnxm5z6r51n   lock table sys.col_usage$ in e...
6689,37214.0325.220.6898.9883taa7kaw59c1   select name, intcol#, segcol#,...
6654,8867.350.3486.450.000k8522rmdzg4k   select privilege# from sysauth...
6186181.00277.440.100.514vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
4978761.763.3312.6788.107ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
4546,86615.1270.330.1899.86db78fxqxwxt7r   select /*+ rule */ bucket, end...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
4,6724,67220.02cm5vu20fhtnq1   select /*+ connect_by_filterin...
9399394.02grwydz59pu6mc   select text from view$ where r...
7567563.24bsa0wjtftg3uw   select file# from file$ where ...
6811122.920v3dvmc22qnam   insert into sys.col_usage$ (ob...
6812,0602.923c1kubcdjnppq   update sys.col_usage$ set equa...
6816812.92b2gnxm5z6r51n   lock table sys.col_usage$ in e...
6656652.850k8522rmdzg4k   select privilege# from sysauth...
6166182.644vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
2102100.903ktacv9r56b51   select owner#, name, namespace...
2102100.908swypbbr0m372   select order#, columns, types ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,127,09210.352tr12b1b8uj71 DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
1301120v3dvmc22qnam   insert into sys.col_usage$ (ob...
1022188vwv6hx92ymmm OEM.SystemPool UPDATE MGMT_CURRENT_METRICS SE...
985fcb5u7n0r523m   SELECT NVL(AVG((VALUE*1000.0)/...
985fcb5u7n0r523m   SELECT NVL(AVG((VALUE*1000.0)/...
77202g00cj285jmgsw   update sys.mon_mods$ set inser...
752,0603c1kubcdjnppq   update sys.col_usage$ set equa...
73571nx1518vff191   UPDATE MGMT_COLLECTION_TASKS S...
71573x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
68545r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
67119davq1msn9b8kd   UPDATE MGMT_POLICY_ASSOC_EVAL_...
6416wm3n4d7bnddg   SELECT source, (case when tim...
645cabqn4dp09qck   SELECT TASK_CLASS, ROUND(NVL(S...
6352wuxsvgst612h   SELECT NVL(AVG(VALUE), 0) FROM...
62692g0wsxgktu720   SELECT RESULT_KEY_VALUE FROM M...
6210bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
563ab3swhv5g138y   select OBJOID, CLSOID, RUNTIME...
54171fsbqktj5vw6n9   select next_run_date, obj#, ru...
5158aq8yqxyyb40nn   update sys.job$ set this_date=...
306184vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
28454db78fxqxwxt7r   select /*+ rule */ bucket, end...
244977ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
244977ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
23520xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
23871gu8t96d0bdmu   select t.ts#, t.file#, t.block...
23574jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
224,672cm5vu20fhtnq1   select /*+ connect_by_filterin...
21579ds1amk0gttnh   insert into "SYSMAN"."MGMT_TAS...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0xqn4sx1ytghrselect /*+ first_rows(1) no_expand */ tab.msgid from "SYSMAN"."AQ$_MGMT_TASK_QTABLE_F" tab where q_name = :1 and (state = :2 ) and queue_id = :3 and ( tab.user_data.scheduled_time <= CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) AND (tab.user_data.message_code = 0 OR tab.user_data.message_code = 1))
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1nx1518vff191UPDATE MGMT_COLLECTION_TASKS SET TASK_TYPE=NVL(:B14 , TASK_TYPE), PRIORITY=NVL(:B13 , PRIORITY), NEXT_COLLECTION_TIMESTAMP=NVL(:B12 , NEXT_COLLECTION_TIMESTAMP), LAST_COLLECTION_TIMESTAMP=NVL(:B11 , LAST_COLLECTION_TIMESTAMP), ERROR_MESSAGE=:B10 , FAILURES=NVL(:B9 , FAILURES), TOTAL_RUNS=NVL(:B8 , TOTAL_RUNS), MIN_WAIT_TIME=NVL(:B7 , MIN_WAIT_TIME), MAX_WAIT_TIME=NVL(:B6 , MAX_WAIT_TIME), AVG_WAIT_TIME=NVL(:B5 , AVG_WAIT_TIME), MIN_RUN_TIME=NVL(:B4 , MIN_RUN_TIME), MAX_RUN_TIME=NVL(:B3 , MAX_RUN_TIME), AVG_RUN_TIME=NVL(:B2 , AVG_RUN_TIME) WHERE TASK_ID = :B1 RETURNING FREQUENCY_CODE, PRIORITY, TASK_TYPE, NEXT_COLLECTION_TIMESTAMP, TASK_CLASS INTO :O0 , :O1 , :O2 , :O3 , :O4
2g0wsxgktu720SELECT RESULT_KEY_VALUE FROM MGMT_POLICY_ASSOC_EVAL_DETAILS WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1 AND RESULT_KEY_VALUE NOT IN (SELECT COLUMN_VALUE FROM TABLE(CAST(:B4 AS MGMT_MEDIUM_STRING_TABLE)))
2tr12b1b8uj71 MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > LOG(0.01, NVL(LOC_STALE_PCT, :B1 )/100) THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 5 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#( +) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME IN ('SUMDELTA$', 'SNAP_XCMT$')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100 .0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M .DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL, 'TRUE') * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_ est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ# (+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 6 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLO CK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S , SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#)
2wuxsvgst612hSELECT NVL(AVG(VALUE), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND NAME=:B1 AND TIME>(SYSDATE-(1/24))
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3dmrp1716t2wkMERGE INTO NXGT_ACCOUNT_TREE_AP T USING ( WITH SUB_ACCOUNTS AS (SELECT ID, PARENT_ID, APPLIED_POLICY_ID, CALENDAR_ID FROM NXGT_ACCOUNT_TREE_AP WHERE NTYPE = 'S') SELECT S1.ID , S2.APPLIED_POLICY_ID , S2.CALENDAR_ID FROM SUB_ACCOUNTS S1 JOIN (SELECT PARENT_ID, MAX(APPLIED_POLICY_ID) APPLIED_POLICY_ID, CALENDAR_ID FROM SUB_ACCOUNTS WHERE CALENDAR_ID <> :B1 GROUP BY PARENT_ID, CALENDAR_ID) S2 ON S1.PARENT_ID = S2.PARENT_ID WHERE S1.APPLIED_POLICY_ID IS NULL) SA ON (T.ID = SA.ID) WHEN MATCHED THEN UPDATE SET T.APPLIED_POLICY_ID=SA.APPLIED_POLICY_ID , T.CALENDAR_ID=SA.CALENDAR_ID
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#
3x0kdm7z3yaswSELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
492dn6mqhqfzuINSERT INTO NXGT_ACCOUNT_TREE_AP (ID, PARENT_ID, ACCT_NUM, NTYPE, HAS_CURRENT_APPLIED_POLICY, APPLIED_POLICY_ID, CALENDAR_ID) WITH LEVEL_1_KIDS AS (SELECT TR.TREE_NODE_ID, TR.PARENT_TREE_NODE_ID , TR.NODE_TYPE , TR.NODE_ID , CASE WHEN TR.APPLIED_POLICY_ID IS NULL OR TR.APPLIED_POLICY_ID <> :B2 THEN 0.0 ELSE 1.0 END HAS_CURRENT_APPLIED_POLICY , TR.APPLIED_POLICY_ID , TR.CALENDAR_ID , TR.LEVEL_NUM FROM NXGT_ACTR_RESULT_SET TR START WITH TR.TREE_NODE_ID = :B1 CONNECT BY PRIOR TR.TREE_NODE_ID = TR.PARENT_TREE_NODE_ID) SELECT L1K.TREE_NODE_ID , L1K.PARENT_TREE_NODE_ID , L1K.NODE_ID , L1K.NODE_TYPE , L1K.HAS_CURRENT_APPLIED_POLICY , L1K.APPLIED_POLICY_ID , L1K.CALENDAR_ID FROM LEVEL_1_KIDS L1K WHERE L1K.LEVEL_NUM > 1 AND L1K.NODE_TYPE IN ('A', 'S')
4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
4rmr95aagzqv3INSERT INTO NXGT_ACTR_RESULT_SET (TREE_NODE_ID, PARENT_TREE_NODE_ID, NODE_TYPE, NODE_ID, NODE_PARENT_ID , NODE_DESCRIPTION, HAS_CHILDREN, APPLIED_POLICY_ID, CALENDAR_ID, LEVEL_NUM) WITH TREE_NODES AS (SELECT A.ACCT_GROUP PARENT_TREE_NODE_ID , A.ACCT_ID TREE_NODE_ID , A.ACCT_TYPE_CODE NODE_TYPE , A.ACCT_NUM NODE_ID , A.ACCT_NAME NODE_DESCRIPTION , 'N' HAS_CHILDREN , LEVEL AS LEVEL_NUM FROM NXGT_ACTR_ALL_GROUPS_ASAS A START WITH A.ACCT_GROUP = :B1 CONNECT BY PRIOR A.ACCT_ID = A.ACCT_GROUP) SELECT TN.TREE_NODE_ID, TN.PARENT_TREE_NODE_ID, TN.NODE_TYPE, TN.NODE_ID , A.ACCT_NUM NODE_PARENT_ID, TN.NODE_DESCRIPTION, TN.HAS_CHILDREN , AP.APPLIED_POLICY_ID, AP.CALENDAR_ID, TN.LEVEL_NUM FROM TREE_NODES TN LEFT JOIN BS_ACCTS A ON TN.PARENT_TREE_NODE_ID = A.ACCT_ID LEFT JOIN NXGT_ACTR_AP_SNAPSHOT AP ON TN.TREE_NODE_ID = AP.ACCT_ID
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)
572fbaj0fdw2bselect output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
59v4zh1ac3v2aDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5n1fs4m2n2y0rselect pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5r8jah3jm5au2SELECT TARGETS.TARGET_NAME, TARGETS.TARGET_TYPE, TARGETS.TIMEZONE_REGION, TARGETS.EMD_URL, NVL(CAST(SYSTIMESTAMP AT TIME ZONE TARGETS.TIMEZONE_REGION AS DATE), :B2 ) FROM MGMT_TARGETS TARGETS WHERE TARGETS.TARGET_GUID = :B1
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6n5cgxm2fr14hDELETE FROM NXGT_ACCOUNT_TREE_AP
6nr22s0vjrtc1UPDATE NXGT_ACTR_RESULT_SET SET SELECTED = 1 WHERE NODE_TYPE IN ('A', 'S') AND APPLIED_POLICY_ID = :B1
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
9ds1amk0gttnhinsert into "SYSMAN"."MGMT_TASK_QTABLE" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
a4cfk3vjhd9qjDELETE FROM NXGT_ACCOUNT_TREE_AP WHERE ID IN ( SELECT SA.ID FROM NXGT_ACCOUNT_TREE_AP SA JOIN NXGT_ACCOUNT_TREE_AP A ON SA.PARENT_ID = A.ID AND A.APPLIED_POLICY_ID IS NOT NULL UNION SELECT A.ID FROM NXGT_ACCOUNT_TREE_AP A JOIN NXGT_ACCOUNT_TREE_AP SA ON A.ID = SA.PARENT_ID AND SA.APPLIED_POLICY_ID IS NOT NULL)
ab3swhv5g138y select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
ajymgnp1qnruwselect o.name, o.owner# from obj$ o, type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
am1fn6xx94q5uBEGIN crt_get_account_tree(:1 , :2 , :3 ) ; END;
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
bb0dybyq6bjsmUPDATE NXGT_ACTR_RESULT_SET T SET T.HAS_CHILDREN = 'Y' WHERE EXISTS (SELECT 1 FROM BS_SUBACCOUNT WHERE ACCT_ID = T.TREE_NODE_ID)
bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bsa0wjtftg3uwselect file# from file$ where ts#=:1
c6h3ypm205u91INSERT INTO NXGT_ACTR_ALL_GROUPS_ASAS (ACCT_ID, ACCT_GROUP, ACCT_NUM, ACCT_NAME, ACCT_TYPE, ACCT_TYPE_CODE, ACCT_TYPE_SORT, SUBACCOUNT_ID) WITH ACCOUNTS_AND_GROUPS AS (SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , -1 SUBACCOUNT_ID , CASE WHEN A.ACCT_TYPE IN (0, 1) THEN 'A' ELSE 'G' END ACCT_TYPE_CODE , CASE WHEN A.ACCT_TYPE IN (0, 1) THEN 2 ELSE 1 END ACCT_TYPE_SORT FROM BS_ACCTS A START WITH A.ACCT_GROUP = :B1 CONNECT BY PRIOR A.ACCT_ID = A.ACCT_GROUP UNION ALL SELECT 0, NULL, 'root', 'root' , 4, -1, 'G' ACCT_TYPE_CODE, 1 ACCT_TYPE_SORT FROM DUAL WHERE :B1 = 0) , SUBACCOUNTS AS ( SELECT :B2 + ROW_NUMBER() OVER (ORDER BY A.ACCT_ID) AS ACCT_ID , A.ACCT_ID ACCT_GROUP , S.SUBACCOUNT_NUMBER ACCT_NUM , S.SUBACCOUNT_NAME ACCT_NAME , 999 ACCT_TYPE , S.SUBACCOUNT_ID , 'S' ACCT_TYPE_CODE , 3 ACCT_TYPE_SORT FROM ACCOUNTS_AND_GROUPS A JOIN BS_SUBACCOUNT S ON A.ACCT_ID = S.ACCT_ID WHERE A.ACCT_TYPE <> 4 ) SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , A.ACCT_TYPE_CODE , A.ACCT_TYPE_SORT , A.SUBACCOUNT_ID FROM ACCOUNTS_AND_GROUPS A UNION ALL SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , A.ACCT_TYPE_CODE , A.ACCT_TYPE_SORT , A.SUBACCOUNT_ID FROM SUBACCOUNTS A
cabqn4dp09qckSELECT TASK_CLASS, ROUND(NVL(SUM(THROUGHPUT), 0), 2), NVL(SUM(TOTAL_VALUE), 0), NVL(SUM(TOTAL_DURATION), 0) FROM (SELECT CLIENT_DATA WORKER_ID, ACTION TASK_CLASS, NVL(AVG(VALUE*1000/ DECODE(DURATION, 0, 1000, DURATION)), 0) THROUGHPUT, SUM(VALUE) TOTAL_VALUE, SUM(DURATION)/1000 TOTAL_DURATION, COUNT(*) RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA, ACTION ) GROUP BY TASK_CLASS
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d1dsc597kqr7sDELETE FROM NXGT_ACTR_RESULT_SET WHERE NODE_TYPE = 'G' AND HAS_CHILDREN = 'N'
davq1msn9b8kdUPDATE MGMT_POLICY_ASSOC_EVAL_DETAILS SET CRIT_COUNTER = NVL(:B9 , CRIT_COUNTER), WARN_COUNTER = NVL(:B8 , WARN_COUNTER), INFO_COUNTER = NVL(:B7 , INFO_COUNTER), LAST_ERROR_MESSAGE = :B6 , LAST_EVALUATION_DATE = :B5 WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND COLL_NAME = :B2 AND RESULT_KEY_VALUE = :B1
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dcy1bgdgavcr4SELECT TREE_NODE_ID FROM NXGT_ACTR_RESULT_SET WHERE NODE_TYPE = 'G' AND LEVEL_NUM = 1
fcb5u7n0r523mSELECT NVL(AVG((VALUE*1000.0)/DURATION), 0), NVL((((SUM(DURATION)/(60*1000))/60)*100), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 = B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.IS_TOTAL='Y' AND A.DURATION > 0
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g52zugxj4a7kbINSERT INTO NXGT_ACTR_AP_SNAPSHOT (ACCT_ID, APPLIED_POLICY_ID, CALENDAR_ID) SELECT AC.ACCT_ID, AP.APPLIED_POLICY_ID, AP.CALENDAR_ID FROM CRTV_CURR_ASA_APPLIED_POLICY AP JOIN NXGT_ACTR_ALL_GROUPS_ASAS AC ON AP.ASA_EXT_ID = AC.ACCT_NUM
gc8rqv835jxv0MERGE INTO NXGT_ACTR_RESULT_SET T USING (SELECT SA.TREE_NODE_ID , CASE WHEN SA.APPLIED_POLICY_ID <> :B1 THEN 2 WHEN A.APPLIED_POLICY_ID = :B1 THEN 3 WHEN A.APPLIED_POLICY_ID <> :B1 THEN 4 WHEN EXISTS ( SELECT 1 FROM NXGT_ACTR_RESULT_SET WHERE PARENT_TREE_NODE_ID = SA.PARENT_TREE_NODE_ID AND CALENDAR_ID <> :B2 ) THEN 5 ELSE 1 END AS AVAILABILITY FROM NXGT_ACTR_RESULT_SET SA JOIN NXGT_ACTR_RESULT_SET A ON SA.PARENT_TREE_NODE_ID = A.TREE_NODE_ID) TSA ON (T.TREE_NODE_ID = TSA.TREE_NODE_ID) WHEN MATCHED THEN UPDATE SET AVAILABILITY=TSA.AVAILABILITY
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 count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced20.000.00
CCursor + sql area evicted40.000.01
CPU used by this session89,28524.93170.39
CPU used when call started88,63424.75169.15
CR blocks created9860.281.88
Cached Commit SCN referenced00.000.00
Commit SCN cached00.000.00
DB time1,508,346421.222,878.52
DBWR checkpoint buffers written613,954171.451,171.67
DBWR checkpoints1010.030.19
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer20.000.00
DBWR thread checkpoint buffers written602,909168.371,150.59
DBWR transaction table writes5260.151.00
DBWR undo block writes643,259179.641,227.59
HSC Compressed Segment Block Changes00.000.00
HSC Heap Segment Block Changes6,850,7711,913.1513,073.99
HSC IDL Compressed Blocks00.000.00
HSC OLTP Compressed Blocks00.000.00
HSC OLTP Space Saving00.000.00
HSC OLTP positive compression00.000.00
HSC OLTP recursive compression00.000.00
Heap Segment Array Inserts197,50455.16376.92
Heap Segment Array Updates870.020.17
IMU CR rollbacks290.010.06
IMU Flushes990.030.19
IMU Redo allocation size180,71650.47344.88
IMU commits3480.100.66
IMU contention80.000.02
IMU ktichg flush70.000.01
IMU pool not allocated2260.060.43
IMU recursive-transaction flush00.000.00
IMU undo allocation size964,080269.231,839.85
IMU- failed to get a private strand2260.060.43
LOB table id lookup cache misses00.000.00
Number of read IOs issued90.000.02
PX local messages recv'd00.000.00
PX local messages sent00.000.00
RowCR - row contention10.000.00
RowCR attempts5,3111.4810.14
RowCR hits4,4861.258.56
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink10.000.00
SQL*Net roundtrips to/from client9,0742.5317.32
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout697,779194.861,331.64
application wait time10.000.00
auto extends on undo tablespace00.000.00
background checkpoints completed1030.030.20
background checkpoints started1010.030.19
background timeouts14,1113.9426.93
branch node splits5980.171.14
buffer is not pinned count2,219,122619.714,234.97
buffer is pinned count68,417,95719,106.41130,568.62
bytes received via SQL*Net from client1,933,280539.893,689.47
bytes sent via SQL*Net to client3,793,9501,059.507,240.36
calls to get snapshot scn: kcmgss643,123179.601,227.33
calls to kcmgas402,506112.40768.14
calls to kcmgcs949,131265.051,811.32
cell physical IO interconnect bytes21,984,511,4886,139,398.7241,955,174.60
change write time71,85820.07137.13
cleanout - number of ktugct calls906,336253.101,729.65
cleanouts and rollbacks - consistent read gets130.000.02
cleanouts only - consistent read gets126,43935.31241.30
cluster key scan block gets377,686105.47720.77
cluster key scans374,879104.69715.42
commit batch/immediate performed2450.070.47
commit batch/immediate requested2450.070.47
commit cleanout failures: block lost618,613172.751,180.56
commit cleanout failures: buffer being written60.000.01
commit cleanout failures: callback failure40.000.01
commit cleanout failures: cannot pin10.000.00
commit cleanouts622,730173.901,188.42
commit cleanouts successfully completed4,1061.157.84
commit immediate performed2450.070.47
commit immediate requested2450.070.47
commit txn count during cleanout779,413217.661,487.43
concurrency wait time26,8937.5151.32
consistent changes24,984,5766,977.2047,680.49
consistent gets5,733,4251,601.1210,941.65
consistent gets - examination1,094,678305.702,089.08
consistent gets direct120.000.02
consistent gets from cache5,733,4131,601.1110,941.63
consistent gets from cache (fastpath)4,462,4621,246.198,516.15
cursor authentications9470.261.81
data blocks consistent reads - undo records applied1,0720.302.05
db block changes38,920,09610,868.8374,274.99
db block gets100,838,79328,160.26192,440.44
db block gets direct10,0812.8219.24
db block gets from cache100,828,71228,157.44192,421.21
db block gets from cache (fastpath)10,4412.9219.93
deferred (CURRENT) block cleanout applications6,6631.8612.72
dirty buffers inspected366,271102.28698.99
drop segment calls in space pressure00.000.00
enqueue conversions1,2810.362.44
enqueue releases446,959124.82852.98
enqueue requests447,045124.84853.14
enqueue timeouts490.010.09
enqueue waits610.020.12
execute count41,23911.5278.70
failed probes on index block reclamation7690.211.47
file io service time00.000.00
file io wait time625,945,738,648174,801,722.101,194,552,936.35
frame signature mismatch00.000.00
free buffer inspected1,302,743363.802,486.15
free buffer requested1,485,866414.942,835.62
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress334,00793.27637.42
hot buffers moved to head of LRU165,98446.35316.76
immediate (CR) block cleanout applications126,45235.31241.32
immediate (CURRENT) block cleanout applications637,196177.941,216.02
index crx upgrade (positioned)60.000.01
index crx upgrade (prefetch)00.000.00
index fast full scans (full)1420.040.27
index fetch by key616,205172.081,175.96
index scans kdiixs19,975,3562,785.7219,036.94
leaf node 90-10 splits45,83512.8087.47
leaf node splits184,51551.53352.13
lob reads81,45522.75155.45
lob writes63,49017.73121.16
lob writes unaligned63,49017.73121.16
local undo segment hints helped00.000.00
local undo segment hints were stale00.000.00
logons cumulative8000.221.53
max cf enq hold time00.000.00
messages received31,9508.9260.97
messages sent31,9508.9260.97
min active SCN optimization applied on CR110.000.02
no buffer to keep pinned count1470.040.28
no work - consistent read gets4,096,6791,144.047,818.09
non-idle wait count422,886118.10807.03
non-idle wait time1,222,484341.392,332.98
opened cursors cumulative38,42110.7373.32
parse count (describe)190.010.04
parse count (failures)70.000.01
parse count (hard)2,5320.714.83
parse count (total)23,3416.5244.54
parse time cpu9710.271.85
parse time elapsed19,3835.4136.99
physical read IO requests347,63697.08663.43
physical read bytes5,600,182,2721,563,907.9310,687,370.75
physical read total IO requests363,257101.44693.24
physical read total bytes5,850,775,5521,633,888.6611,165,602.20
physical read total multi block requests4,5931.288.77
physical reads683,616190.911,304.61
physical reads cache376,302105.09718.13
physical reads cache prefetch163,25045.59311.55
physical reads direct307,31485.82586.48
physical reads direct (lob)90.000.02
physical reads direct temporary tablespace306,16985.50584.29
physical reads prefetch warmup00.000.00
physical write IO requests437,862122.28835.61
physical write bytes11,235,008,5123,137,490.5421,440,855.94
physical write total IO requests451,578126.11861.79
physical write total bytes16,133,735,9364,505,510.0630,789,572.40
physical write total multi block requests53,82515.03102.72
physical writes1,371,461382.992,617.29
physical writes direct296,38482.77565.62
physical writes direct (lob)30.000.01
physical writes direct temporary tablespace295,19282.44563.34
physical writes from cache1,075,077300.232,051.67
physical writes non checkpoint1,366,763381.682,608.33
pinned buffers inspected7490.211.43
pinned cursors current90.000.02
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use110.000.02
process last non-idle time4,1271.157.88
recursive aborts on index block reclamation00.000.00
recursive calls327,62991.49625.25
recursive cpu usage85,92524.00163.98
redo blocks checksummed by FG (exclusive)4,331,0251,209.488,265.31
redo blocks written9,384,8572,620.8217,910.03
redo buffer allocation retries4,2791.198.17
redo entries13,087,0103,654.6824,975.21
redo log space requests17,6414.9333.67
redo log space wait time160,89144.93307.04
redo ordering marks140.000.03
redo size4,684,858,0481,308,294.328,940,568.79
redo size for direct writes6240.171.19
redo synch time47,33713.2290.34
redo synch writes8480.241.62
redo wastage1,145,344319.852,185.77
redo write time95,41626.65182.09
redo writes4,4051.238.41
rollback changes - undo records applied4,1641.167.95
rollbacks only - consistent read gets9510.271.81
root node splits350.010.07
rows fetched via callback77,31121.59147.54
scheduler wait time630.020.12
session connect time00.000.00
session cursor cache hits29,1638.1455.65
session logical reads106,572,21829,761.38203,382.10
shared hash latch upgrades - no wait9,3922.6217.92
sorts (disk)110.000.02
sorts (memory)17,4374.8733.28
sorts (rows)41,202,20911,506.1478,630.17
space was found by tune down00.000.00
space was not found by tune down00.000.00
sql area evicted3,9351.107.51
sql area purged390.010.07
steps of tune down ret. in space pressure00.000.00
summed dirty queue length2,962,261827.245,653.17
switch current to new buffer63,66317.78121.49
table fetch by rowid34,680,0139,684.7566,183.23
table fetch continued row7190.201.37
table scan blocks gotten402,466112.39768.06
table scan rows gotten62,388,41017,422.60119,061.85
table scans (direct read)00.000.00
table scans (long tables)1690.050.32
table scans (short tables)6,7431.8812.87
temp space allocated (bytes)1,284,505,600358,711.272,451,346.56
total cf enq hold time276,85477.31528.35
total number of cf enq holders1,5970.453.05
total number of times SMON posted20.000.00
transaction rollbacks2450.070.47
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
tune down retentions in space pressure00.000.00
undo change vector size3,624,938,0081,012,300.856,917,820.63
user I/O wait time598,707167.201,142.57
user calls15,4054.3029.40
user commits4860.140.93
user rollbacks380.010.07
workarea executions - onepass620.020.12
workarea executions - optimal9,6362.6918.39
write clones created in background190.010.04
write clones created in foreground2960.080.56

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max223,324,214,352224,098,941,648
session cursor cache count7,299,9147,306,192
session uga memory385,443,102,813,256385,718,040,834,880
opened cursors current127180
workarea memory allocated09,894
logons current5563
session uga memory max525,219,102,496526,059,465,632
session pga memory198,434,375,552198,688,352,128

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)101101.54

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR0M0.000M8.2G117.752.345780 
LGWR167M3.05.0466364.5G2.741.2885012.1K22.49
Direct Reads2.3G37.52.663242578M0.85.1614120 
Buffer Cache Reads2.9G59.60.8227000M0.000M213.4K5956.31
Direct Writes26M0.06.0072601.7G3.60.4727870 
Others71M1.31.019827107M1.18.0298806785108.61
Streams AQ0M0.000M0M0.000M415.75
TOTAL:5.5G101.551.5596615G126.124.29837232.3K5475.63

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Temp File5.1G94.651.460255.5G40.671.582283806.1277.38
Data File118M2.54.0329524.9G81.611.4111077.74162.90
Log File0M0.060M4.5G2.171.2798412.77 
Control File239M4.27.06674389M1.60.02485445.13 
Other0M0.040M0M0.060M65.19 
TOTAL:5.5G101.551.5599415G126.124.298093548.7478.82

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR 0M0.000M8.2G117.752.345780 
DBWR (Data File) 0M0.000M8.2G117.752.345780 
LGWR 167M3.05.0466364.5G2.741.2885011.1K20.31
LGWR (Log File) 0M0.060M4.5G2.171.2798440425.66
LGWR (Control File) 167M2.99.04663631M0.56.00865710.7K20.11
Direct Reads 2.3G37.52.663242578M0.85.1614120 
Direct Reads (Data File) 2.3G37.52.663242578M0.85.1614120 
Buffer Cache Reads 2.9G59.62.8227000M0.000M213.5K5954.23
Buffer Cache Reads (Data File) 2.9G59.62.8227000M0.000M213.5K5954.23
Direct Writes 26M0.06.0072601.7G3.60.4727870 
Direct Writes (Data File) 26M0.06.0072601.7G3.60.4727870 
Others 71M1.28.019827107M1.11.0298804582103.61
Others (Control File) 71M1.28.01982758M1.03.0161974568103.81
Others (Data File) 0M0.000M49M0.08.0136831436.71
Streams AQ 0M0.000M0M0.000M415.75
Streams AQ (Data File) 0M0.000M0M0.000M415.75
TOTAL: 5.5G101.541.5596615G126.054.29837229.2K5549.26

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TEMP 338,9259510.461.97145,6264100.00
UNDOTBS1 132032.651.00289,97881170892.24
SYSTEM 6,217280.181.413010130708.46
SYSAUX 1,0820117.281.991,058000.00
AS_DATA 208012.121.00175011050.00
AS_INDEX 162015.3715.091030230.00
AS_DYN_DATA 10300.001.00103000.00
AS_DYN_INDEX 10300.001.00103000.00
AS_LOB 10300.001.00103000.00
AS_REPORTS_DATA 10300.001.00103000.00
AS_REPORTS_INDEX 10300.001.00103000.00
USERS 10300.001.00103000.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)
AS_DATAC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_DATA.DAT 208012.121.00175011050.00
AS_DYN_DATAC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_DYN_DATA.DAT 10300.001.00103000.00
AS_DYN_INDEXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_DYN_INDEX.DAT 10300.001.00103000.00
AS_INDEXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_INDEX.DAT 162015.3715.091030230.00
AS_LOBC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_LOB.DAT 10300.001.00103000.00
AS_REPORTS_DATAC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_REPORTS_DATA.DAT 10300.001.00103000.00
AS_REPORTS_INDEXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_REPORTS_INDEX.DAT 10300.001.00103000.00
SYSAUXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\SYSAUX01.DBF 1,0820117.281.991,058000.00
SYSTEMC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\SYSTEM01.DBF 6,217280.181.413010130708.46
TEMPC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\TEMP01.DBF 338,9259510.461.97145,626410 
UNDOTBS1C:\APP\ADMINISTRATOR\ORADATA\ORNAGE\UNDOTBS01.DBF 132032.651.00289,97881170892.24
USERSC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\USERS01.DBF 10300.001.00103000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D181,895100106,560,531376,2541,075,07700303

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0557,7040011,04545,205

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B06175734157557165888165888511918   
E01273942832165888165888429457   

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D1440.10181.5411,1571155240.00
D2880.19351.379,9361130530.00
D4320.29531.279,1601114829.00
D5760.39711.198,5811103096.00
D7200.48891.138,158194543.00
D8640.581061.097,854188379.00
D1,0080.681241.067,651184272.00
D1,1520.771421.047,507181362.00
D1,2960.871601.027,380178791.00
D1,4400.971771.007,266176485.00
D1,4881.001831.007,232175798.00
D1,5841.061950.997,164174422.00
D1,7281.162130.987,065172415.00
D1,8721.262300.966,970170494.00
D2,0161.352480.956,871168486.00
D2,1601.452660.946,770166454.00
D2,3041.552840.926,679164615.00
D2,4481.653010.916,593162872.00
D2,5921.743190.906,504161067.00
D2,7361.843370.896,417159314.00
D2,8801.943550.876,325157435.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
72.289,7313,732

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K7,8727,87200
64K128K343400
128K256K373700
256K512K6600
512K1024K34634600
1M2M1,1751,17500
2M4M272700
4M8M464600
8M16M161600
32M64M7032380
64M128M5228240

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
1420.13442,511.97141,565.7476.0035,278,784,181
2840.25442,511.9759,836.8988.0004,540,134,221
5680.50442,511.9735,412.5393.0004,319,391,513
8520.75442,511.9732,777.3493.0004,295,575,115
1,1361.00442,511.9731,086.9893.0004,280,298,019
1,3631.20442,511.973,297.5499.0004,029,142,299
1,5901.40442,511.973,297.5499.0004,029,142,299
1,8181.60442,511.973,297.5499.0004,029,142,299
2,0451.80442,511.973,297.5499.0004,029,142,299
2,2722.00442,511.973,297.5499.0004,029,142,299
3,4083.00442,511.973,297.5499.0004,029,142,299
4,5444.00442,511.973,297.5499.0004,029,142,299
6,8166.00442,511.973,297.5499.0004,029,142,299
9,0888.00442,511.973,297.5499.0004,029,142,299

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)
5120.89169803,562,7651.008,3401.079,232
5761.00824,7133,563,3151.007,7901.0035,729
6401.111458,3133,565,4381.005,6670.7335,809
7041.2220911,9593,567,5331.003,5720.4635,888
7681.3327415,2463,569,5661.001,5390.2035,965
8321.4433817,9493,571,5141.0010.0036,039
8961.5640221,8403,573,3621.0010.0036,110
9601.6746626,4613,575,0911.0010.0036,176
1,0241.7853030,1353,576,6691.0010.0036,238
1,0881.8959431,9223,578,1121.0010.0036,296
1,1522.0065834,0873,579,4211.0010.0036,348

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,0720.50372,7798,975,721
1,6080.75341,6897,695,128
2,1441.00328,2957,230,904
2,6801.25319,8586,828,866
3,2161.50313,7526,460,090
3,7521.75306,6286,196,885
4,2882.00306,6286,196,885

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)
161.000000
322.000000
483.000000
644.000000
805.000000
966.000000
1127.000000
1288.000000
1449.000000
16010.000000
17611.000000
19212.000000
20813.000000
22414.000000
24015.000000
25616.000000
27217.000000
28818.000000
30419.000000
32020.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header158141889
data block13293705
file header block1211932
segment header10200

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 4,4084,3644454991,838.52
TH-Threshold Chain (metric threshold evaluation) 142142014040,203.00
HW-Segment High Water Mark 65,29965,2990341,344.00
JD-Job Queue Date 7187180132,734.00
JS-Job Scheduler (queue lock) 12,07212,0720208.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
2755.49403,2201,0981215/33.30/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
02-Jun 21:5185,23217,6891,0986330/00/0/0/0/0/0
02-Jun 21:4198,33654,7955999250/00/0/0/0/0/0
02-Jun 21:31160,33270,4071907150/00/0/0/0/0/0
02-Jun 21:21160,904107,42077311240/00/0/0/0/0/0
02-Jun 21:11132,57986,63416912150/00/0/0/0/0/0
02-Jun 21:01118,10566,2757873240/00/0/0/0/0/0

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
AQ deq hash table latch10.00 00 
ASM db client latch2,2780.00 00 
ASM map operation hash table10.00 00 
ASM network state latch2790.00 00 
AWR Alerted Metric Element list27,4950.00 00 
Change Notification Hash table latch1,1250.00 00 
Consistent RBA4,5000.00 00 
DML lock allocation13,718,2460.00 00 
Event Group Locks7440.00 00 
FIB s.o chain latch920.00 00 
FOB s.o list latch6240.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch5,5250.021.0001,2980.00
JS Sh mem access1145.451.0000 
JS broadcast autostart latch570.00 00 
JS mem alloc latch320.00 00 
JS queue access latch330.00 00 
JS queue state obj latch24,1440.00 00 
JS slv state obj latch1,470,0990.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.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 latch7,4610.00 00 
KMG resize request state object freelist440.00 00 
KTF sga latch200.00 09210.00
KWQMN job cache list latch20.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch70.00 00 
KWQS pqueue ctx latch740.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0710.00
Memory Management Latch7,0040.00 07,4610.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 Latch60.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process2,9290.00 00 
OS process allocation3,1460.00 00 
OS process: request allocation1,4760.00 00 
PL/SQL warning settings1,0060.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch1,0280.00 00 
SGA IO buffer pool latch6,3860.00 016,1810.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1160.00 09680.00
SQL memory manager workarea list latch70,1910.00 00 
Shared B-Tree3240.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch22,2230.00 00 
active service list9,6140.00 094,3050.00
begin backup scn array120.00 00 
buffer pool6450.00 00 
business card10.00 00 
cache buffer handles2,1980.00 00 
cache buffers chains294,563,2810.001.10013,476,9470.02
cache buffers lru chain2,801,0390.001.0517,191,6590.00
cache table scan latch21,1700.00 021,1700.00
call allocation5,0570.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch1,5370.00 00 
channel operations parent latch19,4030.00 00 
checkpoint queue latch843,6220.00 0650,2320.11
client/application info5,7430.00 00 
compile environment latch8000.00 00 
corrupted undo seg latch12,7370.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch2790.00 00 
cvmap freelist lock10.00 00 
database property service latch80.00 00 
deferred cleanup latch2790.00 00 
dml lock allocation2790.00 00 
done queue latch10.00 00 
dummy allocation1,5910.00 00 
enqueue hash chains895,3520.001.500410.00
enqueues211,7220.00 00 
fifth spare latch10.00 00 
file cache latch1,1040.00 00 
flashback copy10.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 SGA6140.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch9260.00 0473,6280.00
hash table modification latch1050.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch530.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch690.00 0680.00
job_queue_processes free list latch1530.00 00 
job_queue_processes parameter latch7810.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch1010.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats9,9860.00 00 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
kokc descriptor allocation latch5660.00 00 
ksfv messages10.00 00 
kss move lock290.00 00 
ksuosstats global area2420.00 00 
ksv allocation latch3340.00 00 
ksv class latch570.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch1,4760.00 00 
ktm global data210.00 00 
kwqbsn:qsga1300.00 00 
lgwr LWN SCN4,6660.00 00 
list of block allocation5,3860.00 00 
loader state object freelist1,4760.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.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 parent2880.00 0640.00
mapped buffers lru chain10.00 00 
message pool operations parent latch5120.00 00 
messages100,2790.001.0000 
mostly latch-free SCN4,6660.00 00 
msg queue latch10.00 00 
multiblock read objects98,0600.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch2790.00 00 
object queue header heap20,7800.00 02870.00
object queue header operation5,684,8880.001.00010,9420.00
object stats modification19,4560.00 00 
parallel query alloc buffer4410.00 00 
parallel query stats10.00 00 
parameter list2,8380.00 00 
parameter table management1,6440.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue20,3620.00 020,3700.00
process allocation1,5970.00 07430.00
process group creation1,4750.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn state object latch30.00 00 
qmn task queue latch64037.341.00230 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation29,9660.171.04113,089,4570.00
redo copy838.431.14113,089,4020.00
redo writing54,0140.001.0000 
resmgr group change latch9850.00 00 
resmgr:active threads1,6120.00 0110.00
resmgr:actses change group7070.00 00 
resmgr:actses change state50.00 00 
resmgr:free threads list1,5920.00 00 
resmgr:method mem alloc latch160.00 00 
resmgr:plan CPU method8,7990.00 00 
resmgr:resource group CPU method3,8510.00 00 
resmgr:schema config940.00 010.00
resmgr:session queuing10,5450.00 00 
rm cas latch10.00 00 
row cache objects952,6440.00 05830.00
rules engine aggregate statistics20.00 00 
rules engine rule set statistics1040.00 00 
second spare latch10.00 00 
sequence cache2,4270.00 00 
session allocation21,9010.00 00 
session idle bit35,4540.00 00 
session queue latch10.00 00 
session state list latch1,6420.00 00 
session switching3,9450.00 00 
session timer1,6680.00 00 
shared pool187,0080.001.0000 
shared pool sim alloc10.00 00 
shared pool simulator23,1290.00 00 
sim partition latch10.00 00 
simulator hash latch7,346,1590.001.0000 
simulator lru latch648,5490.00 06,549,5070.01
sort extent pool6,2460.00 00 
space background task latch2,6360.271.0002,3640.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation50.00 00 
temporary table state object allocation60.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch2040.00 00 
transaction allocation3,170,4900.00 00 
undo global data2,578,7630.001.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
qmn task queue latch6402392390
cache buffers lru chain2,801,0391171230
redo allocation29,96652540
cache buffers chains294,563,28110110
object queue header operation5,684,88810100
redo copy83780
space background task latch2,636770
JS Sh mem access11550
enqueue hash chains895,352230
messages100,279220
redo writing54,014220
shared pool187,008220
undo global data2,578,763220
In memory undo latch5,525110
simulator hash latch7,346,159110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchkticmt: child010
JS Sh mem accessjsksGetShMemLatch055
PC and Classifier lists for WLMNo latch060
cache buffers chainskcbnew: new latch again065
cache buffers chainskcbgtcr: fast path020
cache buffers chainskcbchg1: kslbegin: call CR func010
cache buffers chainskcbgtcr: fast path (cr pin)011
cache buffers chainskcbzgb: scan from tail. nowait010
cache buffers lru chainkcbzgws_10115120
cache buffers lru chainkcbbxsv: move to being written030
cache buffers lru chainkcbbic2022
cache buffers lru chainkcbzgm020
cache buffers lru chainkcbbwlru010
enqueue hash chainsksqrcl020
enqueue hash chainsksqgtl3013
messagesksarcv011
messagesksarcv: after wait010
object queue header operationkcbo_switch_mq_bg041
object queue header operationkcbo_unlink_q044
object queue header operationkcbo_link_q011
object queue header operationkcbo_switch_q_bg010
qmn task queue latchkwqmnmvtsks: delay to ready list01270
qmn task queue latchkwqmngettsk: get task0109172,337
qmn task queue latchkwqmnaddtsk: add task030
redo allocationkcrfw_redo_gen: redo allocation 10540
redo copykcrfw_redo_gen: nowait080
redo writingkcrfw_post: rba scn pair010
redo writingkcrfws: in loop010
shared poolkghalo010
shared poolkghupr1011
simulator hash latchkcbsacc: lookup dba010
space background task latchktsjCreateTask010
undo global dataktudba: KSLBEGIN021

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkkslce [KKSCHLPIN2]7-863

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
BANKRECTEMPNXGT_ACCOUNT_TREE_AP_PK INDEX3,726,5123.50
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,556,2401.46
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,549,3921.45
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,446,2241.36
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,360,3841.28

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE37,2925.46
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE35,2325.15
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE32,3834.74
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE32,2264.71
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE2 INDEX19,5972.87

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE26,8787.73
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE26,2507.55
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE22,4506.46
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE22,3556.43
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE2 INDEX6,8171.96

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE26,8787.73
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE26,2507.55
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE22,4506.46
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE22,3556.43
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE2 INDEX6,8171.96

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX13,4340.98
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE13,3340.97
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE2 INDEX12,4640.91
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX8,7710.64
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE5 INDEX5,8020.42

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE7,4551.70
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE6,8951.57
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX6,8041.55
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX6,2861.44
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE2 INDEX5,8961.35

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_4260570729_5095TABLE PARTITION560.02

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE7122.83
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE6320.26
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE144.50
BANKRECAS_INDEXBS_SUBACCOUNT_PK INDEX41.29
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE2 INDEX41.29

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
BANKRECTEMPNXGT_ACCOUNT_TREE_AP_PK INDEX1,366,60814.18
BANKRECTEMPNXGT_ACCOUNT_TREE_AP TABLE1,273,45613.22
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,263,58413.11
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,195,76012.41
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,146,20811.90

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX1933.33
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_PK INDEX1322.81
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_PK INDEX915.79
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX814.04
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX58.77

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX2100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSSYSTEMAUD$ TABLE9397.89
BANKRECAS_DATAAS_SECURITY TABLE11.05
SYSSYSTEMJOB$ TABLE11.05

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control700.000 21
dc_files110.000 011
dc_global_oids1,0001.100 068
dc_histogram_data30,9281.420 02,612
dc_histogram_defs34,8883.870 394,085
dc_object_grants47310.360 0180
dc_objects45,7440.950 652,529
dc_profiles7000.000 02
dc_rollback_segments8650.000 022
dc_segments12,6361.020 121,203
dc_sequences1127.270 117
dc_tablespaces94,9310.000 013
dc_users115,2820.020 0180
global database name2,4120.000 01
outstanding_alerts631.590 210
sch_lj_objs1233.330 04
sch_lj_oids2236.360 010


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1,7571.202,2841.58110
CLUSTER6340.472862.4540
DBLINK1,2300.000 00
DIRECTORY1100.002100.0000
EDITION940.001700.0000
INDEX3982.513053.2800
OBJECT ID14100.000 00
QUEUE560.001980.0000
RULESET20.0020.0000
SCHEMA1,6740.240 00
SQL AREA12,61317.0368,2908.962,39339
SUBSCRIPTION250.00250.0000
TABLE/PROCEDURE17,3401.3123,4237.541,2860
TRIGGER1503.331737.5180


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 cache1,456.001,488.00784.001,552.0022SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target1,136.001,136.001,136.001,136.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target2,144.002,144.002,144.002,144.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool16.0016.0016.0016.000STA/
large pool16.0016.0016.0016.000STA/
shared pool608.00576.00512.001,280.0022GRO/DEF
streams pool16.0016.0016.0016.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

ComponentMin Size (Mb)Max Size (Mb)Avg Size (Mb)Re- SizesGrowsShrinks
DEFAULT buffer cache1,440.001,520.001,468.9521129
shared pool544.00624.00595.0521912

Back to Memory Statistics
Back to Top

Memory Resize Ops

StartEla (s)ComponentOper Typ/ModInit Size (M)DeltaTarget DeltaFinal (M)Sta
06/02 21:54:311bufcacheSHR/DEF1,520-16 1,504COM
06/02 21:54:311sharedGRO/DEF54416 560COM
06/02 21:51:290bufcacheGRO/DEF1,50416 1,520COM
06/02 21:51:290sharedSHR/DEF560-16 544COM
06/02 21:50:590bufcacheGRO/DEF1,48816 1,504COM
06/02 21:50:590sharedSHR/DEF576-16 560COM
06/02 21:47:261bufcacheSHR/DEF1,504-16 1,488COM
06/02 21:47:261sharedGRO/DEF56016 576COM
06/02 21:42:221bufcacheGRO/DEF1,48816 1,504COM
06/02 21:42:221sharedSHR/DEF576-16 560COM
06/02 21:39:080bufcacheGRO/DEF1,47216 1,488COM
06/02 21:39:080sharedSHR/DEF592-16 576COM
06/02 21:38:350bufcacheGRO/DEF1,45616 1,472COM
06/02 21:38:350sharedSHR/DEF608-16 592COM
06/02 21:38:040bufcacheGRO/DEF1,44016 1,456COM
06/02 21:38:040sharedSHR/DEF624-16 608COM
06/02 21:34:323bufcacheSHR/DEF1,456-16 1,440COM
06/02 21:34:323sharedGRO/DEF60816 624COM
06/02 21:31:281bufcacheSHR/DEF1,472-16 1,456COM
06/02 21:31:281sharedGRO/DEF59216 608COM
06/02 21:30:580bufcacheGRO/DEF1,45616 1,472COM
06/02 21:30:580sharedSHR/DEF608-16 592COM
06/02 21:30:280bufcacheGRO/DEF1,44016 1,456COM
06/02 21:30:280sharedSHR/DEF624-16 608COM
06/02 21:27:232bufcacheSHR/DEF1,456-16 1,440COM
06/02 21:27:232sharedGRO/DEF60816 624COM
06/02 21:24:193bufcacheSHR/DEF1,472-16 1,456COM
06/02 21:24:193sharedGRO/DEF59216 608COM
06/02 21:23:490bufcacheGRO/DEF1,45616 1,472COM
06/02 21:23:490sharedSHR/DEF608-16 592COM
06/02 21:20:190bufcacheSHR/DEF1,472-16 1,456COM
06/02 21:20:190sharedGRO/DEF59216 608COM
06/02 21:19:160bufcacheGRO/DEF1,45616 1,472COM
06/02 21:19:160sharedSHR/DEF608-16 592COM
06/02 21:18:460bufcacheGRO/DEF1,44016 1,456COM
06/02 21:18:460sharedSHR/DEF624-16 608COM
06/02 21:14:4141bufcacheSHR/DEF1,456-16 1,440COM
06/02 21:14:4141sharedGRO/DEF60816 624COM
06/02 21:14:100bufcacheGRO/DEF1,44016 1,456COM
06/02 21:14:100sharedSHR/DEF624-16 608COM
06/02 21:06:2218bufcacheSHR/DEF1,456-16 1,440COM
06/02 21:06:2218sharedGRO/DEF60816 624COM

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
BOther81.81 1.341.147176161
 Freeable66.690.002.086.1035 3232
 SQL1.650.430.040.0601464337
 PL/SQL1.461.200.030.04025555
EOther138.05 2.004.1133546969
 Freeable76.000.001.905.2333 4040
 SQL9.826.800.200.7951465046
 PL/SQL5.545.160.090.27226363

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers1,526,726,6561,560,281,088
Fixed Size2,180,544 
Redo Buffers16,007,168 
Variable Size1,879,050,8161,845,496,384

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largePX msg pool0.470.470.00
largefree memory15.5315.530.00
sharedCCUR23.2322.05-5.08
sharedFileOpenBlock10.5010.500.00
sharedKGH: NO ACCESS85.85165.6492.94
sharedKGLHD10.759.34-13.06
sharedKGLS9.40 -100.00
sharedPCUR26.7317.99-32.70
sharedSQLA57.8232.85-43.20
sharedXDBSC9.559.550.00
sharedfree memory346.56351.951.56
sharedkglsim object batch8.568.560.00
sharedrow cache7.23 -100.00
streamsfree memory16.0016.000.00
 buffer_cache1,456.001,488.002.20
 fixed_sga2.082.080.00
 log_buffer15.2715.270.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Coordinator0409 05:05:000.030.000.00
QMON Slaves0409 05:05:10-17.55-13.180.00

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 Capture Rate

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

Streams Apply Rate

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 Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
SYS.ALERT_QUE_R 20.0000.000.000.000.000.000.000

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 20100.000.0012.600.000.000.00
SYS.AQ$_ALERT_QT_E(12342) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(66897) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(66567) 57570.000.0070.907.060.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(12343) 0.000.006.30 
SYS.AQ$_ALERT_QT_E(12342) 0.000.00  
SYSMAN.MGMT_NOTIFY_Q(66897) 0.000.00  
SYSMAN.MGMT_TASK_Q(66567) 0.020.021.240.12

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
ACCQADB2150_F_1831_ORNAGE(41)/SYS.ALERT_QUE 2000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
001010

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
3,5970.00100.000.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.003,5970.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_destC:\APP\ADMINISTRATOR\ADMIN\ORNAGE\ADUMP  
audit_trailDB  
compatible11.2.0.0.0  
control_filesC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\CONTROL01.CTL, C:\APP\ADMINISTRATOR\ORADATA\ORNAGE\CONTROL02.CTL  
db_block_size8192  
db_domain    
db_nameORNAGE  
diagnostic_destC:\APP\ADMINISTRATOR  
dispatchers(PROTOCOL=TCP) (SERVICE=ORNAGEXDB)  
memory_target3439329280  
open_cursors300  
processes150  
remote_login_passwordfileEXCLUSIVE  
resource_manager_plan  SCHEDULER[0x3004]:DEFAULT_MAINTENANCE_PLAN
sql_traceFALSE  
undo_tablespaceUNDOTBS1  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report ---------- Non-Parallel Run AWR Report for DB: ORNAGE, Inst: ornage, Snaps: 5095-5096

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORNAGE4260570729ornage109-Apr-15 05:0411.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
ACCQADB2150Microsoft Windows x86 64-bit 1 1 1 8.00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:509502-Jun-15 20:00:4450 2.2
End Snap:509602-Jun-15 21:00:5255 2.3
Elapsed:  60.13 (mins)  
DB Time:  9.55 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,472M 1,456MStd Block Size: 8K
Shared Pool Size: 592M 608MLog Buffer: 15,632K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.2 0.9 0.02 0.03
DB CPU(s): 0.1 0.3 0.01 0.01
Redo size: 301,610.8 1,702,968.0  
Logical reads: 6,946.1 39,219.3  
Block changes: 2,376.2 13,416.5  
Physical reads: 20.7 116.7  
Physical writes: 62.7 354.1  
User calls: 5.5 31.0  
Parses: 4.9 27.7  
Hard parses: 0.1 0.5  
W/A MB processed: 0.6 3.4  
Logons: 0.3 1.5  
Executes: 6.5 36.9  
Rollbacks: 0.0 0.0  
Transactions: 0.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.95
Buffer Hit %: 99.97In-memory Sort %: 99.99
Library Hit %: 97.15Soft Parse %: 98.09
Execute to Parse %: 25.07Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 87.24% Non-Parse CPU: 97.90

Shared Pool Statistics

BeginEnd
Memory Usage %: 43.80 43.00
% SQL with executions>1: 90.81 87.42
% Memory for SQL w/exec>1: 87.43 78.54

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 202 35.27 
direct path read temp32,265118420.66User I/O
log file switch (checkpoint incomplete)3369208812.03Configuration
log file sync1,03146447.96Commit
log file switch completion152013363.50Configuration

Host CPU (CPUs: 1 Cores: 1 Sockets: 1)

Load Average BeginLoad Average End%User%System%WIO%Idle
   12.7 10.0  77.4
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
6.0 26.4 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 8,191.6 8,191.6
SGA use (MB): 2,144.0 2,144.0
PGA use (MB): 144.9 151.6
% Host Mem used for SGA+PGA: 27.94 28.02

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time489.5385.46
DB CPU202.0235.27
connection management call elapsed time47.108.22
parse time elapsed6.281.10
hard parse elapsed time5.320.93
PL/SQL execution elapsed time2.610.46
PL/SQL compilation elapsed time0.420.07
repeated bind elapsed time0.020.00
failed parse elapsed time0.020.00
hard parse (sharing criteria) elapsed time0.010.00
DB time572.82 
background elapsed time547.74 
background cpu time13.39 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME81,487 
AVG_IDLE_TIME278,800 
AVG_SYS_TIME35,892 
AVG_USER_TIME45,595 
BUSY_TIME81,487 
IDLE_TIME278,800 
SYS_TIME35,892 
USER_TIME45,595 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES664,720,754,138,042,368 
VM_OUT_BYTES-19,703,248,195,198,976 
PHYSICAL_MEMORY_BYTES8,589,467,648 
NUM_CPUS1 
NUM_CPU_CORES1 
NUM_CPU_SOCKETS1 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
02-Jun 20:00:440.00     
02-Jun 21:00:520.0022.6212.669.9677.380.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  202 35.27
User I/O34,1260153426.70
Configuration660103156718.06
Commit1,031046447.96
Concurrency501632572.84
Application3601250.15
System I/O400020.02
Network12,1950000.01
Other51597000.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
direct path read temp32,2650118450.4920.66
log file switch (checkpoint incomplete)3306920880.0512.03
log file sync1,031046441.617.96
log file switch completion1502013360.023.50
buffer busy waits501632570.012.84
direct path write temp553015280.872.70
db file sequential read997015151.562.64
log buffer space180148050.032.53
db file scattered read13103200.210.45
local write wait4601290.070.23
enq: RO - fast object reuse1801320.030.10
SQL*Net break/reset to client1800170.030.05
Disk file operations I/O1340010.210.02
control file sequential read400020.060.02
asynch descriptor resize499100000.780.01
SQL*Net message to client12,11200018.950.01
SQL*Net more data from client260010.040.00
latch: object queue header operation10080.000.00
SQL*Net more data to client570000.090.00
reliable message140000.020.00
SQL*Net message from client12,10901,531,91112651018.95 
jobq slave wait7,2071003,71651611.28 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
control file sequential read5,4210164308.4829.89
log file parallel write2,2090127583.4623.26
db file parallel write2,1700123563.4022.37
control file parallel write1,643065402.5711.94
os thread startup12908660.201.55
Parameter File I/O16074080.031.19
enq: CF - contention13043040.020.72
db file sequential read7402330.120.44
direct path write5202330.080.32
log file single write4801240.080.21
direct path read6301170.100.20
log file sync3012850.000.16
Disk file operations I/O960190.150.16
SQL*Net break/reset to client1,4200002.220.06
log file sequential read480050.080.05
SQL*Net more data to client6970001.090.02
LGWR wait for redo copy130050.020.01
SQL*Net more data from client6970001.090.00
latch: redo allocation30030.000.00
latch: cache buffers lru chain30020.000.00
asynch descriptor resize861100001.350.00
latch: object queue header operation20020.000.00
SQL*Net message to client2,8750004.500.00
latch free1380000.220.00
rdbms ipc message17,3968542,745245727.22 
DIAG idle wait7,0221007,216102810.99 
dispatcher timer611003,662600310.10 
Space Manager: slave idle wait722993,60949991.13 
pmon timer1,398853,60525792.19 
shared server idle wait1201003,604300320.19 
smon timer121003,6003000120.02 
Streams AQ: qmn slave idle wait13103,587273850.21 
Streams AQ: qmn coordinator idle wait1281003,587280260.20 
SGA: MMAN sleep for component shrink1,3259916122.07 
SQL*Net message from client3,6020625.64 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
Disk file operations I/O23090.47.4.9.4  .9 
LGWR wait for redo copy1376.9   7.77.77.7 
Parameter File I/O166.3 6.312.518.825.025.06.3
SQL*Net break/reset to client143899.0.3.6   .1 
SQL*Net message to client15K100.0       
SQL*Net more data from client72399.7.1.1     
SQL*Net more data to client75499.6.3.1     
asynch descriptor resize136099.9    .1  
buffer busy waits520.020.0    40.020.0
control file parallel write1643   .316.253.330.0.2
control file sequential read546146.712.05.512.811.34.17.4.3
db file parallel write21705.83.06.111.820.122.230.6.4
db file scattered read1316.12.33.124.435.916.012.2 
db file sequential read111028.86.46.727.020.65.84.3.4
direct path read636.3 15.915.930.223.87.9 
direct path read temp32.3K72.96.92.86.36.43.21.6 
direct path write52 3.85.817.311.528.832.7 
direct path write temp5533.82.56.110.719.729.327.8 
enq: CF - contention13      100.0 
enq: RO - fast object reuse1827.8    16.755.6 
latch free138100.0       
latch: cache buffers chains2100.0       
latch: cache buffers lru chain475.0  25.0    
latch: object queue header operation333.3 33.3 33.3   
latch: redo allocation366.7   33.3   
local write wait46    17.460.921.7 
log buffer space18     5.677.816.7
log file parallel write2207 .21.414.227.416.939.6.3
log file sequential read4837.58.310.420.816.76.3  
log file single write48    54.220.825.0 
log file switch (checkpoint incomplete)33      72.727.3
log file switch completion15      66.733.3
log file sync1034 .21.513.242.626.215.7.7
os thread startup129   .8.845.052.7.8
reliable message14100.0       
DIAG idle wait7022      76.923.1
SGA: MMAN sleep for component shrink1325.3 .2.495.32.61.3 
SQL*Net message from client15.7K84.57.72.22.0.5.21.11.8
Space Manager: slave idle wait722.1      99.9
Streams AQ: qmn coordinator idle wait128       100.0
Streams AQ: qmn slave idle wait1312.3      97.7
class slave wait11100.0       
dispatcher timer61       100.0
jobq slave wait7211.1     99.9.0
pmon timer139813.2   .1.31.485.0
rdbms ipc message17.4K2.1.2.2.51.0.924.770.3
shared server idle wait120       100.0
smon timer12       100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
Disk file operations I/O299.1   .9   
LGWR wait for redo copy192.37.7      
Parameter File I/O468.86.36.312.5   6.3
SQL*Net break/reset to client199.9   .1   
buffer busy waits240.0    40.0 20.0
control file parallel write49669.823.44.91.0.4.2.2.1
control file sequential read40492.35.1.71.4.2.1.0.3
db file parallel write67468.913.28.65.02.71.2.4 
db file scattered read1687.88.43.1  .8  
db file sequential read5195.32.81.1.3.1.1.3.1
direct path read592.14.81.61.6    
direct path read temp52998.41.1.3.1.1.0  
direct path write1767.323.15.83.8    
direct path write temp15472.218.18.31.4    
enq: CF - contention13 7.77.730.846.27.7  
enq: RO - fast object reuse1044.444.411.1     
local write wait1078.319.6 2.2    
log buffer space145.6 11.111.122.233.3 16.7
log file parallel write87860.116.815.15.41.31.0.2.1
log file single write1275.025.0      
log file switch (checkpoint incomplete)26  3.027.339.43.06.121.2
log file switch completion14  13.326.720.06.726.76.7
log file sync16783.78.93.71.51.2.5.5.2
os thread startup6946.534.110.17.01.6 .8 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
Parameter File I/O193.8 6.3     
buffer busy waits180.0  20.0    
control file parallel write199.9 .1     
control file sequential read1499.7.1.1.1.0   
db file sequential read199.9.1      
log buffer space383.316.7      
log file parallel write299.9.0.0     
log file switch (checkpoint incomplete)778.818.2   3.0  
log file switch completion193.3  6.7    
log file sync299.8.1.1     

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
ORNAGE5311897424,940
SYS$USERS42130103
ORNAGEXDB0000
SYS$BACKGROUND00019

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
ORNAGE 339411521100119040
SYS$USERS 1851416002910
SYS$BACKGROUND 2981313180000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
426.811426.8174.5136.9133.84am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
138.95269.4724.2638.6644.78492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
121.551121.5521.2244.7242.154rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
53.90226.959.4114.350.00a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
51.66151.669.0242.1327.16gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
33.70133.705.8831.250.18c6h3ypm205u91 JDBC Thin Client INSERT INTO NXGT_ACTR_ALL_GROU...
15.86170.932.770.990.007km26mb71wh49 TOAD 10.6.1.3 Select lk.SID, se.username, se...
13.00150.872.270.360.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
12.87112.872.2523.9175.51g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
10.517270.011.843.420.404vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
10.3625.181.8126.7068.773dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
9.9719.971.7429.7854.31bcn055937n92v RecAdmin.exe BEGIN cpr_refresh_user_ac_mat_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
157.531157.5377.98426.8136.9133.84am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
54.36154.3626.91121.5544.7242.154rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
53.72226.8626.59138.9538.6644.78492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
21.77121.7710.7751.6642.1327.16gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
10.53110.535.2133.7031.250.18c6h3ypm205u91 JDBC Thin Client INSERT INTO NXGT_ACTR_ALL_GROU...
7.7323.873.8353.9014.350.00a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
4.42170.262.194.9289.933.25guh01k8v05txt TOAD 10.6.1.3 Select lk.SID, se.username, se...
3.0813.081.5212.8723.9175.51g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
2.9712.971.479.9729.7854.31bcn055937n92v RecAdmin.exe BEGIN cpr_refresh_user_ac_mat_...
2.7721.381.3710.3626.7068.773dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
2.48600.041.233.3374.5714.326gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
144.421144.4287.25426.8136.9133.84am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
62.22231.1137.59138.9538.6644.78492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
51.23151.2330.95121.5544.7242.154rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
14.03114.038.4851.6642.1327.16gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
9.7219.725.8712.8723.9175.51g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
7.1223.564.3010.3626.7068.773dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
5.4115.413.279.9729.7854.31bcn055937n92v RecAdmin.exe BEGIN cpr_refresh_user_ac_mat_...
2.46300.081.494.3830.6856.17735svmrpvntsk RecAdmin.exe WITH ACCTS_UNDER_GP_PLUS_ROOTS...
1.3211.320.802.5945.8051.05a2pqqfz420xwg RecAdmin.exe DELETE brt_accounts_under_grou...
0.48600.010.293.3374.5714.326gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
24,677,930124,677,930.0098.47426.8136.9133.84am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
11,074,979111,074,979.0044.19121.5544.7242.154rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
9,935,71624,967,858.0039.65138.9538.6644.78492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
1,374,7032687,351.505.4953.9014.350.00a4cfk3vjhd9qj JDBC Thin Client DELETE FROM NXGT_ACCOUNT_TREE_...
1,320,24111,320,241.005.2751.6642.1327.16gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
547,4661547,466.002.1833.7031.250.18c6h3ypm205u91 JDBC Thin Client INSERT INTO NXGT_ACTR_ALL_GROU...
128,6691128,669.000.512.5945.8051.05a2pqqfz420xwg RecAdmin.exe DELETE brt_accounts_under_grou...
96,639196,639.000.390.7599.740.00363tzjzrrt6b6 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
80,795180,795.000.320.4195.980.00adnuk42np2m5y JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
80,777180,777.000.320.4394.510.005fkg0rqrqhw3t JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
71,940171,940.0096.48426.8136.9133.84am1fn6xx94q5u JDBC Thin Client BEGIN crt_get_account_tree(:1 ...
26,235126,235.0035.18121.5544.7242.154rmr95aagzqv3 JDBC Thin Client INSERT INTO NXGT_ACTR_RESULT_S...
21,923210,961.5029.40138.9538.6644.78492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
15,803115,803.0021.1951.6642.1327.16gc8rqv835jxv0 JDBC Thin Client MERGE INTO NXGT_ACTR_RESULT_SE...
7,72423,862.0010.3610.3626.7068.773dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
1,63811,638.002.209.9729.7854.31bcn055937n92v RecAdmin.exe BEGIN cpr_refresh_user_ac_mat_...
1,3903046.331.864.3830.6856.17735svmrpvntsk RecAdmin.exe WITH ACCTS_UNDER_GP_PLUS_ROOTS...
3671367.000.492.5945.8051.05a2pqqfz420xwg RecAdmin.exe DELETE brt_accounts_under_grou...
1551155.000.2112.8723.9175.51g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
94194.000.1333.7031.250.18c6h3ypm205u91 JDBC Thin Client INSERT INTO NXGT_ACTR_ALL_GROU...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
15,17915,17927,589.500.0044.09492dn6mqhqfzu JDBC Thin Client INSERT INTO NXGT_ACCOUNT_TREE_...
3763762188.000.001.093dmrp1716t2wk JDBC Thin Client MERGE INTO NXGT_ACCOUNT_TREE_A...
3173171317.000.000.92a2pqqfz420xwg RecAdmin.exe DELETE brt_accounts_under_grou...
2872871287.000.000.83bcn055937n92v RecAdmin.exe BEGIN cpr_refresh_user_ac_mat_...
1491491149.000.000.43g52zugxj4a7kb JDBC Thin Client INSERT INTO NXGT_ACTR_AP_SNAPS...
6767601.120.000.196gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
3939301.300.000.11735svmrpvntsk RecAdmin.exe WITH ACCTS_UNDER_GP_PLUS_ROOTS...
2424171.410.000.07guh01k8v05txt TOAD 10.6.1.3 Select lk.SID, se.username, se...
1919420.450.000.060tpr8rm09yzqd RecAdmin.exe SELECT O_USER_HIERARCHY(USERID...
1515115.000.000.041q3yu7119ppts TOAD 10.6.1.3 Select 1 FROM ALL_OBJECTS WHER...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
5,3875,7071.060.7181.050.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
7865,6377.170.32117.240.000k8522rmdzg4k   select privilege# from sysauth...
7277271.0010.513.420.404vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
3323571.080.0280.580.0053saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
2412411.000.0588.150.00bsa0wjtftg3uw   select file# from file$ where ...
1971971.000.09108.351.02fsbqktj5vw6n9   select next_run_date, obj#, ru...
1931280.660.060.0067.3008bqjmf8490s2 OMS SELECT PARAMETER_VALUE FROM MG...
1931931.000.05234.140.000kkhhb2w93cx0   update seg$ set type#=:4, bloc...
1652641.600.01229.090.005n1fs4m2n2y0r   select pos#, intcol#, col#, sp...
1371371.000.01137.120.009r9t4qu6ubs00 certificationrecappserver.exe SELECT t9.prop_value FROM as_p...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
5,3875,38730.49cm5vu20fhtnq1   select /*+ connect_by_filterin...
7867864.450k8522rmdzg4k   select privilege# from sysauth...
7277274.124vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
2412411.36bsa0wjtftg3uw   select file# from file$ where ...
1971971.12fsbqktj5vw6n9   select next_run_date, obj#, ru...
1931931.090kkhhb2w93cx0   update seg$ set type#=:4, bloc...
1891931.0708bqjmf8490s2 OMS SELECT PARAMETER_VALUE FROM MG...
1371370.789r9t4qu6ubs00 certificationrecappserver.exe SELECT t9.prop_value FROM as_p...
1371370.78d68rhmuqnqh5y certificationrecappserver.exe SELECT t9.prop_value FROM as_p...
1371370.78d89kywzsf6w3d certificationrecappserver.exe SELECT t9.prop_value FROM as_p...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,479,15520.23c0gvws85ubcgq TOAD 10.6.1.3 Select owner FROM all_objects ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
6416wm3n4d7bnddg   SELECT source, (case when tim...
6215bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
563ab3swhv5g138y   select OBJOID, CLSOID, RUNTIME...
54197fsbqktj5vw6n9   select next_run_date, obj#, ru...
5166aq8yqxyyb40nn   update sys.job$ set this_date=...
307274vs91dcv7u1p6 OMS insert into sys.aud$( sessioni...
24557ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
24557ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
23151gu8t96d0bdmu   select t.ts#, t.file#, t.block...
225,387cm5vu20fhtnq1   select /*+ connect_by_filterin...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
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
0tpr8rm09yzqdSELECT O_USER_HIERARCHY(USERID, USERNAME, USER_GROUP, USER_TYPE, LEVEL_NUM ) FROM TABLE(FN_GET_USER_HIERARCHY(:B1 ))
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1q3yu7119pptsSelect 1 FROM ALL_OBJECTS WHERE object_type = 'PACKAGE' AND object_name = 'TOAD_PROFILER'
363tzjzrrt6b6MERGE INTO NXGT_ACTR_RESULT_SET A USING (SELECT PARENT_TREE_NODE_ID, COUNT(*) MY_COUNT FROM NXGT_ACTR_RESULT_SET WHERE AVAILABILITY = 1 GROUP BY PARENT_TREE_NODE_ID) SA ON ( A.TREE_NODE_ID = SA.PARENT_TREE_NODE_ID AND A.NODE_TYPE = 'A') WHEN MATCHED THEN UPDATE SET A.SA_AVAIL_COUNT = SA.MY_COUNT
3dmrp1716t2wkMERGE INTO NXGT_ACCOUNT_TREE_AP T USING ( WITH SUB_ACCOUNTS AS (SELECT ID, PARENT_ID, APPLIED_POLICY_ID, CALENDAR_ID FROM NXGT_ACCOUNT_TREE_AP WHERE NTYPE = 'S') SELECT S1.ID , S2.APPLIED_POLICY_ID , S2.CALENDAR_ID FROM SUB_ACCOUNTS S1 JOIN (SELECT PARENT_ID, MAX(APPLIED_POLICY_ID) APPLIED_POLICY_ID, CALENDAR_ID FROM SUB_ACCOUNTS WHERE CALENDAR_ID <> :B1 GROUP BY PARENT_ID, CALENDAR_ID) S2 ON S1.PARENT_ID = S2.PARENT_ID WHERE S1.APPLIED_POLICY_ID IS NULL) SA ON (T.ID = SA.ID) WHEN MATCHED THEN UPDATE SET T.APPLIED_POLICY_ID=SA.APPLIED_POLICY_ID , T.CALENDAR_ID=SA.CALENDAR_ID
492dn6mqhqfzuINSERT INTO NXGT_ACCOUNT_TREE_AP (ID, PARENT_ID, ACCT_NUM, NTYPE, HAS_CURRENT_APPLIED_POLICY, APPLIED_POLICY_ID, CALENDAR_ID) WITH LEVEL_1_KIDS AS (SELECT TR.TREE_NODE_ID, TR.PARENT_TREE_NODE_ID , TR.NODE_TYPE , TR.NODE_ID , CASE WHEN TR.APPLIED_POLICY_ID IS NULL OR TR.APPLIED_POLICY_ID <> :B2 THEN 0.0 ELSE 1.0 END HAS_CURRENT_APPLIED_POLICY , TR.APPLIED_POLICY_ID , TR.CALENDAR_ID , TR.LEVEL_NUM FROM NXGT_ACTR_RESULT_SET TR START WITH TR.TREE_NODE_ID = :B1 CONNECT BY PRIOR TR.TREE_NODE_ID = TR.PARENT_TREE_NODE_ID) SELECT L1K.TREE_NODE_ID , L1K.PARENT_TREE_NODE_ID , L1K.NODE_ID , L1K.NODE_TYPE , L1K.HAS_CURRENT_APPLIED_POLICY , L1K.APPLIED_POLICY_ID , L1K.CALENDAR_ID FROM LEVEL_1_KIDS L1K WHERE L1K.LEVEL_NUM > 1 AND L1K.NODE_TYPE IN ('A', 'S')
4rmr95aagzqv3INSERT INTO NXGT_ACTR_RESULT_SET (TREE_NODE_ID, PARENT_TREE_NODE_ID, NODE_TYPE, NODE_ID, NODE_PARENT_ID , NODE_DESCRIPTION, HAS_CHILDREN, APPLIED_POLICY_ID, CALENDAR_ID, LEVEL_NUM) WITH TREE_NODES AS (SELECT A.ACCT_GROUP PARENT_TREE_NODE_ID , A.ACCT_ID TREE_NODE_ID , A.ACCT_TYPE_CODE NODE_TYPE , A.ACCT_NUM NODE_ID , A.ACCT_NAME NODE_DESCRIPTION , 'N' HAS_CHILDREN , LEVEL AS LEVEL_NUM FROM NXGT_ACTR_ALL_GROUPS_ASAS A START WITH A.ACCT_GROUP = :B1 CONNECT BY PRIOR A.ACCT_ID = A.ACCT_GROUP) SELECT TN.TREE_NODE_ID, TN.PARENT_TREE_NODE_ID, TN.NODE_TYPE, TN.NODE_ID , A.ACCT_NUM NODE_PARENT_ID, TN.NODE_DESCRIPTION, TN.HAS_CHILDREN , AP.APPLIED_POLICY_ID, AP.CALENDAR_ID, TN.LEVEL_NUM FROM TREE_NODES TN LEFT JOIN BS_ACCTS A ON TN.PARENT_TREE_NODE_ID = A.ACCT_ID LEFT JOIN NXGT_ACTR_AP_SNAPSHOT AP ON TN.TREE_NODE_ID = AP.ACCT_ID
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)
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5fkg0rqrqhw3tMERGE INTO NXGT_ACTR_RESULT_SET A USING (SELECT PARENT_TREE_NODE_ID , COUNT(*) MY_COUNT FROM NXGT_ACTR_RESULT_SET WHERE SELECTED IN (1, 3) GROUP BY PARENT_TREE_NODE_ID) SA ON ( A.TREE_NODE_ID = SA.PARENT_TREE_NODE_ID AND A.NODE_TYPE = 'A') WHEN MATCHED THEN UPDATE SET A.SA_SELECTED_COUNT = SA.MY_COUNT
5n1fs4m2n2y0rselect pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
735svmrpvntsk WITH ACCTS_UNDER_GP_PLUS_ROOTSYS AS ( SELECT ACCT_ID, ACCT_GROUP, ACCT_LEVEL FROM BRT_ACCOUNTS_UNDER_GROUP UNION ALL SELECT ACCT_ID, ACCT_GROUP, 1 FROM BS_ACCTS WHERE ACCT_GROUP = 0 AND ACCT_TYPE != 4 UNION ALL SELECT 0 , -1 , 999999 FROM DUAL ), USER_AC_PROPS AS (SELECT P.USER_ID , :B3 DRIVING_USER , P.ACCT_ID , AP.PROPERTY_ID , P.PRVALUE , P.PRORDER , P.PRTYPE , UH.USERID , UH.USERNAME , UH.USER_GROUP , UH.USER_TYPE , UH.LEVEL_NUM USER_LEVEL , AP.PROPERTY_TYPE_ID FROM BR_PROPS P JOIN AS_PROPERTY AP ON P.PROPERTY = AP.NAME JOIN TABLE(:B1 ) UH ON P.USER_ID = UH.USERID WHERE P.PROPERTY = :B2 AND (P.USER_ID <> 0 AND P.ACCT_ID <> 0 AND AP.PROPERTY_TYPE_ID = 2) UNION ALL SELECT P.USER_ID , :B3 DRIVING_USER , A.ACCT_ID , AP.PROPERTY_ID , P.PRVALUE , P.PRORDER , P.PRTYPE , UH.USERID , UH.USERNAME , UH.USER_GROUP , UH.USER_TYPE , UH.LEVEL_NUM USER_LEVEL , AP.PROPERTY_TYPE_ID FROM BR_PROPS P JOIN AS_PROPERTY AP ON P.PROPERTY = AP.NAME JOIN BS_ACCTS A ON P.ACCT_ID = A.ACCT_GROUP JOIN TABLE(:B1 ) UH ON P.USER_ID = UH.USERID WHERE P.PROPERTY = :B2 AND (P.ACCT_ID = 0 AND UH.USERID = 0 AND AP.PROPERTY_TYPE_ID = 3)) , USER_ACS_AS_GROUPS_AND_NODES AS (SELECT 1 AC_LEVEL_SET , BAUG.ACCT_ID , BAUG.ACCT_GROUP , BAUG.ACCT_LEVEL , T.USER_ID , T.ACCT_ID X_ACCT_ID , T.PROPERTY_ID , T.PRVALUE , T.PRORDER , T.PRTYPE , T.USERID , T.USERNAME , T.USER_GROUP , T.USER_TYPE , T.USER_LEVEL , T.PROPERTY_TYPE_ID FROM ACCTS_UNDER_GP_PLUS_ROOTSYS BAUG JOIN USER_AC_PROPS T ON BAUG.ACCT_GROUP = T.ACCT_ID UNION ALL SELECT 2 AC_LEVEL_SET , BAUG.ACCT_ID , BAUG.ACCT_GROUP , 1 ACCT_LEVEL , T.USER_ID , T.ACCT_ID , T.PROPERTY_ID , T.PRVALUE , T.PRORDER , T.PRTYPE , T.USERID , T.USERNAME , T.USER_GROUP , T.USER_TYPE , T.USER_LEVEL , T.PROPERTY_TYPE_ID FROM ACCTS_UNDER_GP_PLUS_ROOTSYS BAUG JOIN USER_AC_PROPS T ON BAUG.ACCT_ID = T.ACCT_ID) , RANKED_USER_ACS AS (SELECT USER_ID , ACCT_ID , USER_LEVEL , USER_TYPE , USER_GROUP , USERNAME , USERID , PRTYPE , PRORDER , PRVALUE , PROPERTY_ID , X_ACCT_ID , ACCT_LEVEL , ACCT_GROUP , AC_LEVEL_SET , ROW_NUMBER() OVER ( PARTITION BY ACCT_ID ORDER BY CASE PROPERTY_TYPE_ID WHEN 3 THEN 1 ELSE 0 END , CASE WHEN ACCT_LEVEL <= USER_LEVEL THEN ACCT_LEVEL ELSE USER_LEVEL END , CASE WHEN ACCT_LEVEL <= USER_LEVEL THEN 0 ELSE 1 END , CASE WHEN ACCT_LEVEL <= USER_LEVEL THEN USER_LEVEL ELSE ACCT_LEVEL END ) RANK FROM USER_ACS_AS_GROUPS_AND_NODES) SELECT O_USER_ACCOUNTS(ACCT_ID, PROPERTY_ID) FROM RANKED_USER_ACS WHERE PRVALUE = 'Yes' AND RANK = 1
7km26mb71wh49Select lk.SID, se.username, se.OSUser, se.Machine, DECODE(lk.TYPE, 'TX', 'Transaction', 'TM', 'DML', 'UL', 'PL/SQL User Lock', lk.TYPE ) lock_type, DECODE(lk.lmode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR(lk.lmode) ) mode_held, DECODE(lk.request, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR(lk.request) ) mode_requested, TO_CHAR(lk.id1) lock_id1, TO_CHAR(lk.id2) lock_id2, decode(block, 0, 'No', 1, 'Yes', 2, 'Global') block, se.lockwait FROM v$lock lk, v$session se WHERE (lk.type = 'TX') AND (lk.SID = se.SID) AND ( lk.sid = '80')
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
9r9t4qu6ubs00SELECT t9.prop_value FROM as_props t9 WHERE t9.user_id = 0 AND t9.prop_name = 'Number of ASAs' AND t9.prop_order = 0
a2pqqfz420xwgDELETE brt_accounts_under_group
a4cfk3vjhd9qjDELETE FROM NXGT_ACCOUNT_TREE_AP WHERE ID IN ( SELECT SA.ID FROM NXGT_ACCOUNT_TREE_AP SA JOIN NXGT_ACCOUNT_TREE_AP A ON SA.PARENT_ID = A.ID AND A.APPLIED_POLICY_ID IS NOT NULL UNION SELECT A.ID FROM NXGT_ACCOUNT_TREE_AP A JOIN NXGT_ACCOUNT_TREE_AP SA ON A.ID = SA.PARENT_ID AND SA.APPLIED_POLICY_ID IS NOT NULL)
ab3swhv5g138y select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
adnuk42np2m5yMERGE INTO NXGT_ACTR_RESULT_SET A USING (SELECT PARENT_TREE_NODE_ID , COUNT(*) MY_COUNT FROM NXGT_ACTR_RESULT_SET WHERE AVAILABILITY <> 1 GROUP BY PARENT_TREE_NODE_ID) SA ON ( A.TREE_NODE_ID = SA.PARENT_TREE_NODE_ID AND A.NODE_TYPE = 'A') WHEN MATCHED THEN UPDATE SET A.SA_UNAVAIL_COUNT = SA.MY_COUNT
am1fn6xx94q5uBEGIN crt_get_account_tree(:1 , :2 , :3 ) ; END;
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
bcn055937n92vBEGIN cpr_refresh_user_ac_mat_views ( P_USERID => :ph10, P_ACTION_BRT_USER_AUTH_ACS => :ph11, P_ACTION_BRT_AC_SUBM_USERS => :ph12, P_BRT_USER_AUTH_DEL_RPT => :ph13, P_BRT_USER_AUTH_ARCH_RPT => :ph14, P_BRT_USER_AUTH_SIGNOFF_RPT => :ph15, P_SUCCESS => :ph16, P_ERRMSG => :ph17 ); END;
bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bsa0wjtftg3uwselect file# from file$ where ts#=:1
c0gvws85ubcgqSelect owner FROM all_objects WHERE object_name = 'QU_VERSION' AND object_type = 'PACKAGE' AND owner = USER UNION Select owner FROM all_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = 'PUBLIC' UNION Select owner FROM all_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = USER
c6h3ypm205u91INSERT INTO NXGT_ACTR_ALL_GROUPS_ASAS (ACCT_ID, ACCT_GROUP, ACCT_NUM, ACCT_NAME, ACCT_TYPE, ACCT_TYPE_CODE, ACCT_TYPE_SORT, SUBACCOUNT_ID) WITH ACCOUNTS_AND_GROUPS AS (SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , -1 SUBACCOUNT_ID , CASE WHEN A.ACCT_TYPE IN (0, 1) THEN 'A' ELSE 'G' END ACCT_TYPE_CODE , CASE WHEN A.ACCT_TYPE IN (0, 1) THEN 2 ELSE 1 END ACCT_TYPE_SORT FROM BS_ACCTS A START WITH A.ACCT_GROUP = :B1 CONNECT BY PRIOR A.ACCT_ID = A.ACCT_GROUP UNION ALL SELECT 0, NULL, 'root', 'root' , 4, -1, 'G' ACCT_TYPE_CODE, 1 ACCT_TYPE_SORT FROM DUAL WHERE :B1 = 0) , SUBACCOUNTS AS ( SELECT :B2 + ROW_NUMBER() OVER (ORDER BY A.ACCT_ID) AS ACCT_ID , A.ACCT_ID ACCT_GROUP , S.SUBACCOUNT_NUMBER ACCT_NUM , S.SUBACCOUNT_NAME ACCT_NAME , 999 ACCT_TYPE , S.SUBACCOUNT_ID , 'S' ACCT_TYPE_CODE , 3 ACCT_TYPE_SORT FROM ACCOUNTS_AND_GROUPS A JOIN BS_SUBACCOUNT S ON A.ACCT_ID = S.ACCT_ID WHERE A.ACCT_TYPE <> 4 ) SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , A.ACCT_TYPE_CODE , A.ACCT_TYPE_SORT , A.SUBACCOUNT_ID FROM ACCOUNTS_AND_GROUPS A UNION ALL SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , A.ACCT_TYPE_CODE , A.ACCT_TYPE_SORT , A.SUBACCOUNT_ID FROM SUBACCOUNTS A
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d68rhmuqnqh5ySELECT t9.prop_value FROM as_props t9 WHERE t9.user_id = 0 AND t9.prop_name = 'Number of Policies' AND t9.prop_order = 0
d89kywzsf6w3dSELECT t9.prop_value FROM as_props t9 WHERE t9.user_id = 0 AND t9.prop_name = 'Registered Processes' AND t9.prop_order = 0
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
g52zugxj4a7kbINSERT INTO NXGT_ACTR_AP_SNAPSHOT (ACCT_ID, APPLIED_POLICY_ID, CALENDAR_ID) SELECT AC.ACCT_ID, AP.APPLIED_POLICY_ID, AP.CALENDAR_ID FROM CRTV_CURR_ASA_APPLIED_POLICY AP JOIN NXGT_ACTR_ALL_GROUPS_ASAS AC ON AP.ASA_EXT_ID = AC.ACCT_NUM
gc8rqv835jxv0MERGE INTO NXGT_ACTR_RESULT_SET T USING (SELECT SA.TREE_NODE_ID , CASE WHEN SA.APPLIED_POLICY_ID <> :B1 THEN 2 WHEN A.APPLIED_POLICY_ID = :B1 THEN 3 WHEN A.APPLIED_POLICY_ID <> :B1 THEN 4 WHEN EXISTS ( SELECT 1 FROM NXGT_ACTR_RESULT_SET WHERE PARENT_TREE_NODE_ID = SA.PARENT_TREE_NODE_ID AND CALENDAR_ID <> :B2 ) THEN 5 ELSE 1 END AS AVAILABILITY FROM NXGT_ACTR_RESULT_SET SA JOIN NXGT_ACTR_RESULT_SET A ON SA.PARENT_TREE_NODE_ID = A.TREE_NODE_ID) TSA ON (T.TREE_NODE_ID = TSA.TREE_NODE_ID) WHEN MATCHED THEN UPDATE SET AVAILABILITY=TSA.AVAILABILITY
guh01k8v05txtSelect lk.SID, se.username, se.OSUser, se.Machine, DECODE (lk.TYPE, 'TX', 'Transaction', 'TM', 'DML', 'UL', 'PL/SQL User Lock', lk.TYPE ) lock_type, DECODE (lk.lmode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR (lk.lmode) ) mode_held, DECODE (lk.request, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR (lk.request) ) mode_requested, TO_CHAR (lk.id1) lock_id1, TO_CHAR (lk.id2) lock_id2, ob.owner, ob.object_type, ob.object_name, decode(lk.Block, 0, 'No', 1, 'Yes', 2, 'Global') block, se.lockwait FROM v$lock lk, dba_objects ob, v$session se WHERE lk.TYPE IN ('TM', 'UL') AND lk.SID = se.SID AND lk.id1 = ob.object_id (+) AND ( lk.sid = '80')

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced00.000.00
CCursor + sql area evicted50.000.01
CPU used by this session18,4425.1128.86
CPU used when call started17,7844.9327.83
CR blocks created3100.090.49
Cached Commit SCN referenced00.000.00
Commit SCN cached00.000.00
DB time422,301117.05660.88
DBWR checkpoint buffers written150,97641.85236.27
DBWR checkpoints430.010.07
DBWR object drop buffers written1710.050.27
DBWR revisited being-written buffer00.000.00
DBWR thread checkpoint buffers written149,70941.49234.29
DBWR transaction table writes2200.060.34
DBWR undo block writes149,03641.31233.23
HSC Compressed Segment Block Changes00.000.00
HSC Heap Segment Block Changes1,450,559402.052,270.05
HSC IDL Compressed Blocks00.000.00
HSC OLTP Compressed Blocks00.000.00
HSC OLTP Space Saving00.000.00
HSC OLTP positive compression00.000.00
HSC OLTP recursive compression00.000.00
Heap Segment Array Inserts50,01913.8678.28
Heap Segment Array Updates2700.070.42
IMU CR rollbacks1480.040.23
IMU Flushes880.020.14
IMU Redo allocation size261,57672.50409.35
IMU commits5900.160.92
IMU contention10.000.00
IMU ktichg flush20.000.00
IMU pool not allocated320.010.05
IMU recursive-transaction flush00.000.00
IMU undo allocation size2,425,792672.353,796.23
IMU- failed to get a private strand320.010.05
LOB table id lookup cache misses00.000.00
Number of read IOs issued00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
RowCR - row contention00.000.00
RowCR attempts1,3540.382.12
RowCR hits1,1480.321.80
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client12,1123.3618.95
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout175,19148.56274.16
application wait time880.020.14
auto extends on undo tablespace00.000.00
background checkpoints completed220.010.03
background checkpoints started240.010.04
background timeouts14,8094.1023.18
branch node splits1510.040.24
buffer is not pinned count471,779130.76738.31
buffer is pinned count16,263,4324,507.6725,451.38
bytes received via SQL*Net from client2,435,111674.933,810.82
bytes sent via SQL*Net to client5,089,8341,410.737,965.31
calls to get snapshot scn: kcmgss114,35331.69178.96
calls to kcmgas107,19129.71167.75
calls to kcmgcs242,57467.23379.62
cell physical IO interconnect bytes3,727,670,7841,033,182.505,833,600.60
change write time2,4400.683.82
cleanout - number of ktugct calls223,63861.98349.98
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets27,9557.7543.75
cluster key scan block gets5,6661.578.87
cluster key scans5,0201.397.86
commit batch/immediate performed380.010.06
commit batch/immediate requested380.010.06
commit cleanout failures: block lost161,36444.72252.53
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure130.000.02
commit cleanout failures: cannot pin00.000.00
commit cleanouts167,08546.31261.48
commit cleanouts successfully completed5,7081.588.93
commit immediate performed380.010.06
commit immediate requested380.010.06
commit txn count during cleanout191,30953.02299.39
concurrency wait time2,4780.693.88
consistent changes5,522,7231,530.718,642.76
consistent gets1,081,380299.721,692.30
consistent gets - examination276,15676.54432.17
consistent gets direct00.000.00
consistent gets from cache1,081,380299.721,692.30
consistent gets from cache (fastpath)798,595221.341,249.76
cursor authentications770.020.12
data blocks consistent reads - undo records applied4150.120.65
db block changes8,573,1212,376.1813,416.46
db block gets23,979,7336,646.3637,526.97
db block gets direct3,8701.076.06
db block gets from cache23,975,8636,645.2937,520.91
db block gets from cache (fastpath)84,88823.53132.85
deferred (CURRENT) block cleanout applications2,0130.563.15
dirty buffers inspected8,2032.2712.84
drop segment calls in space pressure00.000.00
enqueue conversions8640.241.35
enqueue releases143,22639.70224.14
enqueue requests143,24139.70224.16
enqueue timeouts70.000.01
enqueue waits310.010.05
execute count23,5776.5336.90
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time88,450,642,30024,515,484.50138,420,410.49
frame signature mismatch00.000.00
free buffer inspected165,28645.81258.66
free buffer requested271,50975.25424.90
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress82,49322.86129.10
hot buffers moved to head of LRU59,48416.4993.09
immediate (CR) block cleanout applications27,9557.7543.75
immediate (CURRENT) block cleanout applications165,18945.78258.51
index crx upgrade (positioned)00.000.00
index crx upgrade (prefetch)00.000.00
index fast full scans (full)810.020.13
index fetch by key229,83863.70359.68
index scans kdiixs12,507,429694.973,923.99
leaf node 90-10 splits12,8063.5520.04
leaf node splits48,54113.4575.96
lob reads00.000.00
lob writes10.000.00
lob writes unaligned10.000.00
local undo segment hints helped00.000.00
local undo segment hints were stale00.000.00
logons cumulative9240.261.45
max cf enq hold time00.000.00
messages received6,1701.719.66
messages sent6,1701.719.66
min active SCN optimization applied on CR10.000.00
no buffer to keep pinned count370.010.06
no work - consistent read gets689,953191.231,079.74
non-idle wait count62,75117.3998.20
non-idle wait time82,58422.89129.24
opened cursors cumulative22,1426.1434.65
parse count (describe)00.000.00
parse count (failures)70.000.01
parse count (hard)3370.090.53
parse count (total)17,6664.9027.65
parse time cpu4240.120.66
parse time elapsed4860.130.76
physical read IO requests34,4259.5453.87
physical read bytes610,836,480169,302.92955,925.63
physical read total IO requests39,95111.0762.52
physical read total bytes700,724,224194,216.721,096,595.03
physical read total multi block requests4320.120.68
physical reads74,56520.67116.69
physical reads cache7,3802.0511.55
physical reads cache prefetch6,1641.719.65
physical reads direct67,18518.62105.14
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace66,94318.55104.76
physical reads prefetch warmup00.000.00
physical write IO requests104,97029.09164.27
physical write bytes1,853,595,648513,753.142,900,775.66
physical write total IO requests111,41230.88174.35
physical write total bytes3,026,946,560838,965.774,737,005.57
physical write total multi block requests6,4781.8010.14
physical writes226,26962.71354.10
physical writes direct65,02218.02101.76
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace64,78017.95101.38
physical writes from cache161,24744.69252.34
physical writes non checkpoint224,70562.28351.65
pinned buffers inspected1670.050.26
pinned cursors current00.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use190.010.03
process last non-idle time15,7044.3524.58
recursive aborts on index block reclamation00.000.00
recursive calls173,96448.22272.24
recursive cpu usage16,9574.7026.54
redo blocks checksummed by FG (exclusive)1,114,416308.881,744.00
redo blocks written2,186,485606.023,421.73
redo buffer allocation retries5380.150.84
redo entries2,714,518752.374,248.07
redo log space requests1,2360.341.93
redo log space wait time8,8722.4613.88
redo ordering marks570.020.09
redo size1,088,196,568301,610.771,702,968.03
redo size for direct writes00.000.00
redo synch time4,6551.297.28
redo synch writes1,0340.291.62
redo wastage550,336152.53861.25
redo write time12,7713.5419.99
redo writes2,2080.613.46
rollback changes - undo records applied760.020.12
rollbacks only - consistent read gets3100.090.49
root node splits100.000.02
rows fetched via callback8,5462.3713.37
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits15,2224.2223.82
session logical reads25,061,1136,946.0839,219.27
shared hash latch upgrades - no wait4,0981.146.41
sorts (disk)20.000.00
sorts (memory)16,2814.5125.48
sorts (rows)9,053,6282,509.3614,168.43
space was found by tune down00.000.00
space was not found by tune down00.000.00
sql area evicted5230.140.82
sql area purged240.010.04
steps of tune down ret. in space pressure00.000.00
summed dirty queue length50,88414.1079.63
switch current to new buffer16,4074.5525.68
table fetch by rowid7,693,8432,132.4712,040.44
table fetch continued row2610.070.41
table scan blocks gotten134,41237.25210.35
table scan rows gotten21,050,4805,834.4732,942.85
table scans (direct read)00.000.00
table scans (long tables)100.000.02
table scans (short tables)2,7560.764.31
temp space allocated (bytes)392,167,424108,695.36613,720.54
total cf enq hold time31,2798.6748.95
total number of cf enq holders2560.070.40
total number of times SMON posted00.000.00
transaction rollbacks380.010.06
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
tune down retentions in space pressure00.000.00
undo change vector size849,706,864235,509.601,329,744.70
user I/O wait time16,5664.5925.92
user calls19,7875.4830.97
user commits6270.170.98
user rollbacks120.000.02
workarea executions - onepass140.000.02
workarea executions - optimal6,5271.8110.21
write clones created in background480.010.08
write clones created in foreground280.010.04

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max222,959,204,632223,324,214,352
session cursor cache count7,294,0757,299,914
session uga memory385,151,000,421,208385,443,102,813,256
opened cursors current108127
logons current5055
session uga memory max524,681,908,464525,219,102,496
session pga memory198,286,315,192198,434,375,552

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)2423.95

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR0M0.000M1.2G27.95.3489510 
LGWR25M0.45.0069291.1G1.01.298230192633.21
Direct Reads523M9.20.144957154M0.30.0426830 
Direct Writes2M0.00.000554325M0.79.0900780 
Others61M1.08.01690771M0.82.0196785301239047.04
Buffer Cache Reads57M0.34.0157980M0.000M124016.05
TOTAL:668M11.08.1851462.8G30.88.7996238467149671.93

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File11M0.32.0030481.2G26.96.32844110.99 
Temp File572M9.23.158538581M2.13.1610334.8018.72
Log File0M0.010M1G0.87.2960125.83 
Control File86M1.51.02383651M0.91.01413530.01 
Other0M0.000M0M0.000M67.50 
TOTAL:669M11.08.1854232.8G30.88.7996238.4718.72

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
DBWR 0M0.000M1.2G27.95.3489510 
DBWR (Data File) 0M0.000M1.2G27.95.3489510 
LGWR 25M0.45.0069291.1G1.01.298230168534.30
LGWR (Log File) 0M0.010M1G0.87.2960129615.14
LGWR (Control File) 25M0.44.0069298M0.13.002217158935.46
Direct Reads 523M9.20.144957154M0.30.0426830 
Direct Reads (Data File) 523M9.20.144957154M0.30.0426830 
Direct Writes 2M0.00.000554325M0.79.0900780 
Direct Writes (Data File) 2M0.00.000554325M0.79.0900780 
Others 61M1.08.01690771M0.82.019678388327.74
Others (Control File) 61M1.07.01690743M0.78.011918387227.77
Others (Data File) 0M0.000M28M0.04.0077601117.00
Buffer Cache Reads 57M0.34.0157980M0.000M124116.00
Buffer Cache Reads (Data File) 57M0.34.0157980M0.000M124116.00
TOTAL: 668M11.08.1851462.8G30.88.799623680927.22

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
UNDOTBS1 28041.791.0095,7362721745.71
TEMP 33,31090.392.207,702200.00
AS_INDEX 41903.911.00502000.00
SYSAUX 13009.461.05568000.00
SYSTEM 25108.131.0111501580.00
AS_DATA 11904.122.00213000.00
AS_REPORTS_DATA 2300.871.0024000.00
AS_DYN_DATA 2200.001.0022000.00
AS_DYN_INDEX 2200.001.0022000.00
AS_LOB 2200.001.0022000.00
AS_REPORTS_INDEX 2200.001.0022000.00
USERS 2200.001.0022000.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)
AS_DATAC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_DATA.DAT 11904.122.00213000.00
AS_DYN_DATAC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_DYN_DATA.DAT 2200.001.0022000.00
AS_DYN_INDEXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_DYN_INDEX.DAT 2200.001.0022000.00
AS_INDEXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_INDEX.DAT 41903.911.00502000.00
AS_LOBC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_LOB.DAT 2200.001.0022000.00
AS_REPORTS_DATAC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_REPORTS_DATA.DAT 2300.871.0024000.00
AS_REPORTS_INDEXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\AS_REPORTS_INDEX.DAT 2200.001.0022000.00
SYSAUXC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\SYSAUX01.DBF 13009.461.05568000.00
SYSTEMC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\SYSTEM01.DBF 25108.131.0111501580.00
TEMPC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\TEMP01.DBF 33,31090.392.207,70220 
UNDOTBS1C:\APP\ADMINISTRATOR\ORADATA\ORNAGE\UNDOTBS01.DBF 28041.791.0095,7362721745.71
USERSC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\USERS01.DBF 2200.001.0022000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D177,97710025,057,2997,373161,2470022

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0124,664001,26725,045

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B0123278133120981658882098   
E06175734157557165888165888511918   

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D1440.10181.5410,5711147297.00
D2880.20351.379,4181123819.00
D4320.30531.268,6681108533.00
D5760.40711.188,108197121.00
D7200.49891.127,702188849.00
D8640.591061.087,415182996.00
D1,0080.691241.057,224179115.00
D1,1520.791421.037,090176369.00
D1,2960.891601.026,971173964.00
D1,4400.991771.006,866171818.00
D1,4561.001791.006,856171605.00
D1,5841.091950.996,772169897.00
D1,7281.192130.976,683168077.00
D1,8721.292300.966,593166257.00
D2,0161.382480.956,499164340.00
D2,1601.482660.936,404162411.00
D2,3041.582840.926,318160639.00
D2,4481.683010.916,235158967.00
D2,5921.783190.906,154157299.00
D2,7361.883370.896,070155602.00
D2,8801.983550.875,979153744.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
71.222,170877

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K6,1766,17600
64K128K141400
128K256K2200
256K512K212100
512K1024K13713700
1M2M14014000
2M4M8800
4M8M111100
8M16M4400
32M64M16880
64M128M12660

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
1420.13432,792.88134,126.3476.0035,164,395,680
2840.25432,792.8856,347.0088.0004,455,858,535
5680.50432,792.8833,234.6193.0004,245,314,421
8520.75432,792.8830,657.6193.0004,221,838,990
1,1361.00432,792.8829,220.8194.0004,208,750,419
1,3631.20432,792.883,094.6299.0003,970,751,768
1,5901.40432,792.883,094.6299.0003,970,751,768
1,8181.60432,792.883,094.6299.0003,970,751,768
2,0451.80432,792.883,094.6299.0003,970,751,768
2,2722.00432,792.883,094.6299.0003,970,751,768
3,4083.00432,792.883,094.6299.0003,970,751,768
4,5444.00432,792.883,094.6299.0003,970,751,768
6,8166.00432,792.883,094.6299.0003,970,751,768
9,0888.00432,792.883,094.6299.0003,970,751,768

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)
5440.89322,4613,562,1271.008,2511.1617,987
6081.00966,6633,563,2491.007,1291.0035,741
6721.1115910,2933,565,4221.004,9560.7035,823
7361.2122313,4043,567,5041.002,8740.4035,902
8001.3228716,2993,569,5011.008770.1235,978
8641.4235119,9823,571,3891.0010.0036,051
9281.5341524,8403,573,1521.0010.0036,119
9921.6347928,4913,574,7741.0010.0036,183
1,0561.7454330,3123,576,2481.0010.0036,241
1,1201.8460732,5283,577,5771.0010.0036,295
1,1841.9567135,7523,578,7691.0010.0036,343
1,2482.0573539,9513,579,8341.0010.0036,388

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,0720.50358,3728,524,275
1,6080.75328,5847,104,477
2,1441.00315,8856,855,618
2,6801.25308,0836,483,358
3,2161.50300,6916,131,665
3,7521.75294,5315,880,064
4,2882.00294,5315,880,064

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)
161.000000
322.000000
483.000000
644.000000
805.000000
966.000000
1127.000000
1288.000000
1449.000000
16010.000000
17611.000000
19212.000000
20813.000000
22414.000000
24015.000000
25616.000000
27217.000000
28818.000000
30419.000000
32020.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header2116746
data block11580

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 1,7071,7007134302.92
RO-Multiple Object Reuse (fast object reuse) 171171018133.89

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
236.2024,204778315/24.70/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
02-Jun 20:5136,06122,9641813150/00/0/0/0/0/0
02-Jun 20:41102157781240/00/0/0/0/0/0
02-Jun 20:31102331701150/00/0/0/0/0/0
02-Jun 20:2192037681240/00/0/0/0/0/0
02-Jun 20:1172821611150/00/0/0/0/0/0
02-Jun 20:011013077583250/00/0/0/0/0/0

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
AQ deq hash table latch10.00 00 
ASM db client latch2,3380.00 00 
ASM map operation hash table10.00 00 
ASM network state latch840.00 00 
AWR Alerted Metric Element list26,7010.00 00 
Change Notification Hash table latch1,2240.00 00 
Consistent RBA2,2330.00 00 
DML lock allocation500,0080.00 00 
Event Group Locks8580.00 00 
FIB s.o chain latch40.00 00 
FOB s.o list latch4570.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch7,7130.00 01,5630.00
JS Sh mem access728.571.0000 
JS broadcast autostart latch660.00 00 
JS mem alloc latch80.00 00 
JS queue access latch90.00 00 
JS queue state obj latch25,9540.00 00 
JS slv state obj latch734,5340.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.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 latch2,5050.00 00 
KMG resize request state object freelist20.00 00 
KTF sga latch190.00 09230.00
KWQP Prop Status20.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch890.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0700.00
Memory Management Latch1,3670.00 02,5050.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 Latch180.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process3,3310.00 00 
OS process allocation3,4130.00 00 
OS process: request allocation1,7090.00 00 
PL/SQL warning settings1,1460.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch1,0210.00 00 
SGA IO buffer pool latch3250.00 01,4550.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1190.00 01,1400.00
SQL memory manager workarea list latch78,5340.00 00 
Shared B-Tree3710.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch3,9110.00 00 
active service list10,2840.00 041,7350.00
buffer pool30.00 00 
business card10.00 00 
cache buffer handles1,3260.00 00 
cache buffers chains67,337,6250.001.000639,2690.00
cache buffers lru chain496,3760.001.000190,8180.00
cache table scan latch1310.00 01310.00
call allocation3,3160.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch1,7390.00 00 
channel operations parent latch19,7520.00 00 
checkpoint queue latch203,6790.00 0157,5100.00
client/application info6,7800.00 00 
compile environment latch9240.00 00 
corrupted undo seg latch2660.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch840.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch840.00 00 
dml lock allocation840.00 00 
done queue latch10.00 00 
dummy allocation1,8440.00 00 
enqueue hash chains287,5120.00 010.00
enqueues98,9700.00 00 
fifth spare latch10.00 00 
file cache latch5480.00 00 
flashback copy10.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 SGA7270.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch370.00 0131,8650.00
hash table modification latch980.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch150.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch690.00 0680.00
job_queue_processes free list latch1400.00 00 
job_queue_processes parameter latch8450.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch240.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats2,0920.00 00 
kokc descriptor allocation latch7240.00 00 
ksfv messages10.00 00 
kss move lock230.00 00 
ksuosstats global area2430.00 00 
ksv allocation latch1280.00 00 
ksv class latch450.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch1,7090.00 00 
ktm global data190.00 00 
kwqbsn:qsga1300.00 00 
lgwr LWN SCN2,6850.00 00 
list of block allocation2,7130.00 00 
loader state object freelist3940.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.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 parent70.00 060.00
mapped buffers lru chain10.00 00 
message pool operations parent latch1900.00 00 
messages45,8260.00 00 
mostly latch-free SCN2,6850.00 00 
msg queue latch10.00 00 
multiblock read objects5780.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch840.00 00 
object queue header heap3,7070.00 01960.00
object queue header operation917,6970.001.0008750.00
object stats modification3720.00 00 
parallel query alloc buffer4650.00 00 
parallel query stats10.00 00 
parameter list2,9980.00 00 
parameter table management1,8470.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue2,8040.00 02,1600.00
process allocation1,8380.00 08570.00
process group creation1,7090.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch52425.001.0000 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation11,8360.031.0002,714,8930.00
redo copy20.00 02,714,8930.00
redo writing13,9460.00 00 
resmgr group change latch1,1380.00 00 
resmgr:active threads1,8440.00 00 
resmgr:actses change group8070.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list1,8430.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects320,3840.00 01100.00
rules engine rule set statistics1000.00 00 
second spare latch10.00 00 
sequence cache2,4450.00 00 
session allocation26,9430.00 00 
session idle bit45,3860.00 00 
session queue latch10.00 00 
session state list latch1,8420.00 00 
session switching4,3450.00 00 
session timer1,3940.00 00 
shared pool64,9410.00 00 
shared pool sim alloc10.00 00 
shared pool simulator4,0410.00 00 
sim partition latch10.00 00 
simulator hash latch1,611,0680.00 00 
simulator lru latch153,3880.00 01,424,9410.00
sort extent pool1,6150.00 00 
space background state object latch20.00 00 
space background task latch2,6480.191.0002,3720.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation30.00 00 
temporary table state object allocation50.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch2030.00 00 
transaction allocation116,8560.00 00 
undo global data656,2110.00 00 
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
qmn task queue latch5241311310
space background task latch2,648550
cache buffers lru chain496,376440
object queue header operation917,697330
redo allocation11,836330
JS Sh mem access7220
cache buffers chains67,337,625220

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
JS Sh mem accessjsksGetShMemLatch022
PC and Classifier lists for WLMNo latch050
cache buffers chainskcbgcur_2010
cache buffers chainskcbnew: new latch again010
cache buffers lru chainkcbzgws_1031
cache buffers lru chainkcbzgb010
object queue header operationkcbo_unlink_q030
qmn task queue latchkwqmnmvtsks: delay to ready list01280
qmn task queue latchkwqmnaddtsk: add task030
redo allocationkcrfw_redo_gen: redo allocation 1030

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
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,727,9846.90
BANKRECTEMPT_ACCOUNT_TREE_AP_IE7 INDEX503,3122.01
BANKRECTEMPT_ACCOUNT_TREE_AP_IE5 INDEX316,7841.26
BANKRECTEMPNXGT_ACCOUNT_TREE_AP_PK INDEX301,6801.20
BANKRECTEMPT_ACCOUNT_TREE_AP_IE2 INDEX301,3921.20

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET_PK INDEX2,2383.00
SYSTEMPSYS_TEMP_0FD9D685D_1BCA742 TABLE2,1822.93
BANKRECAS_INDEXBRT_ACCOUNTS_UNDER_GROUP_IE1 INDEX1510.20
BANKRECAS_INDEXBRT_ACCOUNTS_UNDER_GROUP_IE2 INDEX1440.19
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX1290.17

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
BANKRECAS_INDEXBRT_ACCOUNTS_UNDER_GROUP_IE1 INDEX1510.44
BANKRECAS_INDEXBRT_ACCOUNTS_UNDER_GROUP_IE2 INDEX1440.42
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX1240.36
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS TABLE900.26
BANKRECTEMPNXGT_ACTR_RESULT_SET_PK INDEX480.14

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
BANKRECAS_INDEXBRT_ACCOUNTS_UNDER_GROUP_IE1 INDEX1510.44
BANKRECAS_INDEXBRT_ACCOUNTS_UNDER_GROUP_IE2 INDEX1440.42
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX1240.36
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS TABLE900.26
BANKRECTEMPNXGT_ACTR_RESULT_SET_PK INDEX480.14

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE5 INDEX5,2762.33
BANKRECTEMPNXGT_ACTR_RESULT_SET_PK INDEX2,3931.06
SYSTEMPSYS_TEMP_0FD9D685D_1BCA742 TABLE2,1820.96
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_PK INDEX4380.19
BANKRECTEMPT_ACCOUNT_TREE_AP_IE6 INDEX4330.19

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE5 INDEX2,2022.10
BANKRECTEMPNXGT_ACTR_RESULT_SET_PK INDEX1,0310.98
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX1290.12
BANKRECTEMPT_ACCOUNT_TREE_AP_IE7 INDEX1120.11
BANKRECTEMPT_ACCOUNT_TREE_AP_IE5 INDEX1000.10

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSTEMPSYS_TEMP_0FD9D685D_1BCA742 TABLE2,1823.36
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS TABLE940.14

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX1819.78
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE66.59
BANKRECAS_INDEXBS_SUBACCOUNT_PK INDEX33.30
BANKRECTEMPNXGT_ACTR_RESULT_SET_IE2 INDEX33.30
BANKRECTEMPNXGT_ACCOUNT_TREE_AP TABLE22.20

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
BANKRECTEMPNXGT_ACTR_RESULT_SET TABLE1,341,32843.29
BANKRECTEMPT_ACCOUNT_TREE_AP_IE7 INDEX233,9367.55
BANKRECTEMPNXGT_ACTR_ALL_GROUPS_ASAS_IE2 INDEX233,4727.53
BANKRECTEMPT_ACCOUNT_TREE_AP_IE5 INDEX191,9846.20
BANKRECTEMPT_ACCOUNT_TREE_AP_IE6 INDEX184,8645.97

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSSYSTEMAUD$ TABLE1100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control640.000 21
dc_files110.000 011
dc_global_oids7082.400 059
dc_histogram_data2,5920.540 02,941
dc_histogram_defs5,4813.690 483,286
dc_object_grants37421.660 0131
dc_objects10,2801.330 382,202
dc_profiles8100.000 02
dc_rollback_segments8510.000 022
dc_segments1,8571.670 1921,158
dc_tablespace_quotas5280.760 04
dc_tablespaces30,4480.000 013
dc_users54,3790.010 0169
global database name2,5260.000 01
outstanding_alerts600.000 010
sch_lj_oids60.000 02


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1,4240.071,7560.0600
CLUSTER1850.00460.0000
DBLINK1,4560.000 00
EDITION950.001800.0000
INDEX3441.183441.1800
OBJECT ID6100.000 00
QUEUE660.002450.0000
SCHEMA1,7340.060 00
SQL AREA5,80613.6635,4882.637331
SUBSCRIPTION140.00140.0000
TABLE/PROCEDURE5,1951.877,9884.431790
TRIGGER1364.411873.2100


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 cache1,472.001,456.00784.001,552.001SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target1,136.001,136.001,136.001,136.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target2,144.002,144.002,144.002,144.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool16.0016.0016.0016.000STA/
large pool16.0016.0016.0016.000STA/
shared pool592.00608.00512.001,280.001GRO/DEF
streams pool16.0016.0016.0016.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

ComponentMin Size (Mb)Max Size (Mb)Avg Size (Mb)Re- SizesGrowsShrinks
DEFAULT buffer cache1,456.001,456.001,456.00101
shared pool608.00608.00608.00110

Back to Memory Statistics
Back to Top

Memory Resize Ops

StartEla (s)ComponentOper Typ/ModInit Size (M)DeltaTarget DeltaFinal (M)Sta
06/02 20:52:0716bufcacheSHR/DEF1,472-16 1,456COM
06/02 20:52:0716sharedGRO/DEF59216 608COM

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
BOther78.19 1.401.21795656
 Freeable61.440.002.196.5335 2828
 PL/SQL4.202.480.080.40345050
 SQL1.080.320.030.04053934
EOther81.81 1.341.147176161
 Freeable66.690.002.086.1035 3232
 SQL1.650.430.040.0601464337
 PL/SQL1.461.200.030.04025555

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers1,543,503,8721,526,726,656
Fixed Size2,180,544 
Redo Buffers16,007,168 
Variable Size1,862,273,6001,879,050,816

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largePX msg pool0.470.470.00
largefree memory15.5315.530.00
sharedCCUR22.8823.231.52
sharedFileOpenBlock10.5010.500.00
sharedKGH: NO ACCESS85.8585.850.00
sharedKGLHD10.8010.75-0.48
sharedKGLS11.029.40-14.70
sharedPCUR26.2626.731.79
sharedSQLA55.6357.823.95
sharedXDBSC9.559.550.00
sharedfree memory332.72346.564.16
sharedkglsim heap6.90 -100.00
sharedkglsim object batch8.568.560.00
sharedrow cache7.237.230.00
streamsfree memory16.0016.000.00
 buffer_cache1,472.001,456.00-1.09
 fixed_sga2.082.080.00
 log_buffer15.2715.270.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0409 05:05:100.030.000.00
QMON Coordinator0409 05:05:000.020.000.00

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 Capture Rate

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

Streams Apply Rate

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 Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 00  0.000.00  
SYS.AQ$_ALERT_QT_E(12342) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(66897) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(66567) 74740.000.000.030.410.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(12343) 0.000.00  
SYS.AQ$_ALERT_QT_E(12342) 0.000.00  
SYSMAN.MGMT_NOTIFY_Q(66897) 0.000.00  
SYSMAN.MGMT_TASK_Q(66567) 0.020.020.000.01

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
ACCQADB2150_F_1831_ORNAGE(41)/SYS.ALERT_QUE 0000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
001010

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
3,6030.00100.000.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.003,6030.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_destC:\APP\ADMINISTRATOR\ADMIN\ORNAGE\ADUMP  
audit_trailDB  
compatible11.2.0.0.0  
control_filesC:\APP\ADMINISTRATOR\ORADATA\ORNAGE\CONTROL01.CTL, C:\APP\ADMINISTRATOR\ORADATA\ORNAGE\CONTROL02.CTL  
db_block_size8192  
db_domain    
db_nameORNAGE  
diagnostic_destC:\APP\ADMINISTRATOR  
dispatchers(PROTOCOL=TCP) (SERVICE=ORNAGEXDB)  
memory_target3439329280  
open_cursors300  
processes150  
remote_login_passwordfileEXCLUSIVE  
undo_tablespaceUNDOTBS1  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report