WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
O10G166537304o10g109-Sep-12 14:0911.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
dbserver1AIX-Based Systems (64-bit) 32 8  30.88

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:660319-Nov-12 08:00:15261 2.2
End Snap:660419-Nov-12 09:00:20260 3.0
Elapsed:  60.09 (mins)  
DB Time:  883.34 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 9,024M 9,024MStd Block Size: 8K
Shared Pool Size: 2,944M 2,944MLog Buffer: 35,260K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 14.7 3.0 0.07 0.02
DB CPU(s): 6.3 1.3 0.03 0.01
Redo size: 55,291.8 11,421.6  
Logical reads: 662,383.2 136,828.5  
Block changes: 189.9 39.2  
Physical reads: 7.0 1.5  
Physical writes: 19.9 4.1  
User calls: 883.5 182.5  
Parses: 21.1 4.4  
Hard parses: 3.4 0.7  
W/A MB processed: 1,170.6 241.8  
Logons: 1.2 0.3  
Executes: 214.9 44.4  
Rollbacks: 0.0 0.0  
Transactions: 4.8   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 95.09Soft Parse %: 83.75
Execute to Parse %: 90.17Latch Hit %: 98.92
Parse CPU to Parse Elapsd %: 35.39% Non-Parse CPU: 99.84

Shared Pool Statistics

BeginEnd
Memory Usage %: 71.96 72.67
% SQL with executions>1: 96.61 82.03
% Memory for SQL w/exec>1: 94.19 69.51

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 22,574 42.59 
log file sync25,313310120.58Commit
db file sequential read10,6452420.05User I/O
direct path read9,1912220.04User I/O
enq: TX - row lock contention1154550.01Application

Host CPU (CPUs: 32 Cores: 8 Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
12.49 17.10 39.6 6.7 0.2 53.7
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
19.6 42.3 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 31,616.0 31,616.0
SGA use (MB): 20,480.0 20,480.0
PGA use (MB): 933.4 1,007.1
% Host Mem used for SGA+PGA: 67.73 67.96

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time50,344.7094.99
DB CPU22,573.6042.59
parse time elapsed107.150.20
connection management call elapsed time73.280.14
hard parse elapsed time65.600.12
PL/SQL execution elapsed time1.710.00
PL/SQL compilation elapsed time1.100.00
hard parse (sharing criteria) elapsed time0.300.00
hard parse (bind mismatch) elapsed time0.050.00
repeated bind elapsed time0.030.00
sequence load elapsed time0.000.00
DB time53,000.12 
background elapsed time424.45 
background cpu time15.93 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME166,814 
AVG_IDLE_TIME193,417 
AVG_IOWAIT_TIME440 
AVG_SYS_TIME23,958 
AVG_USER_TIME142,687 
BUSY_TIME5,343,614 
IDLE_TIME6,194,890 
IOWAIT_TIME19,513 
SYS_TIME772,059 
USER_TIME4,571,555 
LOAD1217
OS_CPU_WAIT_TIME5,186,800 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES489,725,952 
VM_OUT_BYTES1,849,380,864 
PHYSICAL_MEMORY_BYTES33,151,778,816 
NUM_CPUS32 
NUM_CPU_CORES8 
NUM_LCPUS32 
NUM_VCPUS8 
GLOBAL_RECEIVE_SIZE_MAX1,048,576 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT16,384 
TCP_RECEIVE_SIZE_MAX9,223,372,036,854,775,807 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX9,223,372,036,854,775,807 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
19-Nov 08:00:1512.49     
19-Nov 09:00:2017.1046.3139.626.6953.690.17

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  22,574 42.59
Commit25,3130310120.58
User I/O22,89504720.09
Application20305250.01
Network2,516,0340400.01
Concurrency15,8410400.01
Configuration1700120.00
Other13292000.00
System I/O240000.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
log file sync25,3130310121.450.58
db file sequential read10,64502420.610.05
direct path read9,19102220.530.04
enq: TX - row lock contention11054550.000.01
SQL*Net message to client2,501,294040143.320.01
latch: cache buffers chains7,7030300.440.01
flashback log file sync6320120.040.00
SQL*Net more data to client13,7510100.790.00
buffer busy waits4,0220000.230.00
direct path write6420000.040.00
library cache: mutex X4,0790000.230.00
enq: HW - contention160090.000.00
Disk file operations I/O1,6130000.090.00
SQL*Net more data from client9890000.060.00
library cache load lock300250.000.00
latch free110060.000.00
log file switch completion100580.000.00
SQL*Net break/reset to client1920000.010.00
enq: TX - index contention20050.000.00
control file sequential read240000.000.00
direct path sync1710000.010.00
SQL*Net message from client2,501,2960715,566286143.32 
jobq slave wait7,5811003,7854990.43 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write28,1270290101.6168.36
db file parallel write49,85402712.866.32
os thread startup1520231540.015.50
control file parallel write3,44801950.204.38
control file sequential read8,8970510.511.26
flashback log file write2,1940420.131.00
log file sequential read19703140.010.67
db file async I/O submit49,8540202.860.58
db file sequential read4380010.030.08
log file sync1300150.000.05
change tracking file synchronous write570020.000.02
Disk file operations I/O4720000.030.02
change tracking file synchronous read570020.000.02
Log archive I/O300250.000.02
flashback log file read440020.000.02
direct path read110060.000.01
ADR block file write500110.000.01
ADR block file read200030.000.01
flashback log file sync140020.000.01
LGWR wait for redo copy2640000.020.01
SQL*Net message to client12,7920000.730.00
log file single write60020.000.00
enq: CF - contention100130.000.00
asynch descriptor resize4,347100000.250.00
direct path write110010.000.00
latch free80000.000.00
rdbms ipc message50,8464696,87419052.91 
DIAG idle wait7,2011007,20210000.41 
Space Manager: slave idle wait1,434977,04149100.08 
Streams AQ: qmn coordinator idle wait258503,612140010.01 
Streams AQ: qmn slave idle wait12903,612280010.01 
smon timer18563,6042002340.00 
pmon timer1,609563,60222390.09 
SQL*Net message from client17,01501810.97 
class slave wait340000.00 

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 read2060.0 15.010.015.0   
ADR block file write5  40.0 40.020.0  
ADR file lock6100.0       
ARCH wait for archivelog lock1100.0       
Disk file operations I/O209099.3.1.1.3.1   
LGWR wait for redo copy26599.2.4.4     
Log archive I/O333.3  33.3  33.3 
SQL*Net break/reset to client19297.41.0 1.0.5   
SQL*Net message to client2515.3K100.0.0.0     
SQL*Net more data from client99099.7.2    .1 
SQL*Net more data to client13.8K99.9.1.0.0.0   
asynch descriptor resize4462100.0       
buffer busy waits402098.6.5.5.3.1.0.0 
change tracking file synchronous read5869.010.38.66.95.2   
change tracking file synchronous write5886.25.21.71.7 5.2  
control file parallel write3453.03.141.239.514.51.5.1 
control file sequential read892793.22.12.01.8.8.0.0 
cursor: mutex X9100.0       
cursor: pin S16100.0       
db file async I/O submit49.9K100.0       
db file parallel write49.9K95.01.81.41.2.6.0.0 
db file scattered read1100.0       
db file sequential read11.1K58.92.515.619.62.9.3.1 
direct path read920952.34.516.922.73.4.2.1 
direct path sync182100.0       
direct path write65596.51.4.9.3.6.3  
enq: CF - contention1    100.0   
enq: HW - contention16  6.350.037.56.3  
enq: TX - index contention2   100.0    
enq: TX - row lock contention1154.5     27.318.2
flashback log file read4470.52.34.522.7    
flashback log file sync64871.010.811.04.22.5.5.2 
flashback log file write219654.414.522.07.02.0 .1 
latch free1957.915.8 15.8 10.5  
latch: active service list10100.0       
latch: cache buffers chains770796.1.6.71.0.8.5.1 
latch: cache buffers lru chain1100.0       
latch: call allocation43100.0       
latch: redo allocation1100.0       
latch: row cache objects1100.0       
latch: shared pool6100.0       
library cache load lock3    33.333.333.3 
library cache: mutex X406299.7.0.0.1.1.0  
log file parallel write28.2K.27.829.022.325.810.34.7 
log file sequential read1977.6.51.039.643.75.12.5 
log file single write650.016.716.716.7    
log file switch completion1      100.0 
log file sync25.4K.57.020.426.427.810.87.2 
os thread startup152      100.0 
DIAG idle wait7202      100.0 
SQL*Net message from client2521.3K62.714.87.73.02.82.15.91.1
Space Manager: slave idle wait1434  .2   1.198.7
Streams AQ: qmn coordinator idle wait25844.21.92.31.2.4  50.0
Streams AQ: qmn slave idle wait129       100.0
class slave wait3491.28.8      
jobq slave wait7575 .0.0.0.0 99.9 
pmon timer1608.6.1 .1.3.319.079.5
rdbms ipc message50.9K9.44.12.92.42.76.041.730.8
smon timer20      15.085.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
Log archive I/O166.7 33.3     
SQL*Net more data from client199.9.1      
buffer busy waits1100.0.0      
control file parallel write499.9 .1     
control file sequential read2100.0   .0.0  
db file parallel write18100.0.0.0.0.0   
db file sequential read1399.9.1.0.0    
direct path read699.9.1.0     
enq: TX - row lock contention454.59.1  9.19.19.19.1
flashback log file sync199.8 .2     
flashback log file write299.9 .0.0    
latch: cache buffers chains1199.9.1.1     
library cache load lock166.733.3      
log file parallel write132195.33.41.2.1.0.0  
log file sequential read597.5.51.0 .5.5  
log file switch completion1 100.0      
log file sync182992.85.21.9.2.0.0  
os thread startup152  25.773.7.7   

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
enq: TX - row lock contention190.99.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)
SYS$USERS52,99422,572252,387,940
SYS$BACKGROUND00141
o10g0000

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
SYS$USERS 22895471584140025160134
SYS$BACKGROUND 9701152230000
o10g 00000000

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
30,514.2090,7640.3457.5744.660.0008v35uwaj38aa JDBC Thin Client select * from ( select row_.*,...
9,923.2342,2990.2318.7240.880.00btn84j9rhuf4h JDBC Thin Client select * from ( select row_.*,...
7,669.52127,5060.0614.4737.280.00cp9wdanzmzj4q JDBC Thin Client select * from (select JOBID, S...
462.833,7910.120.8740.360.009dpwkhfwnqfqa JDBC Thin Client select * from (select JOBID, S...
409.632,3310.180.7742.160.00fqjyuzjgm89qv JDBC Thin Client select * from ( select trunc(P...
209.795810.360.4043.290.005902s014jdg6n JDBC Thin Client select * from ( select trunc(P...
208.901,6070.130.3945.380.008tptxzh309raz JDBC Thin Client select this_.PID as PID10_0_, ...
73.107990.090.1440.070.000nn3rt489dkqz JDBC Thin Client select * from ( select row_.*,...
44.971,9750.020.0840.970.006jn011b6rp1m2 JDBC Thin Client select * from ( select trunc(P...
35.563280.110.0739.730.005dpdd7s28hnaa JDBC Thin Client select * from ( select row_.*,...

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
13,626.3890,7640.1560.3630,514.2044.660.0008v35uwaj38aa JDBC Thin Client select * from ( select row_.*,...
4,056.8842,2990.1017.979,923.2340.880.00btn84j9rhuf4h JDBC Thin Client select * from ( select row_.*,...
2,859.10127,5060.0212.677,669.5237.280.00cp9wdanzmzj4q JDBC Thin Client select * from (select JOBID, S...
186.813,7910.050.83462.8340.360.009dpwkhfwnqfqa JDBC Thin Client select * from (select JOBID, S...
172.692,3310.070.77409.6342.160.00fqjyuzjgm89qv JDBC Thin Client select * from ( select trunc(P...
94.801,6070.060.42208.9045.380.008tptxzh309raz JDBC Thin Client select this_.PID as PID10_0_, ...
90.825810.160.40209.7943.290.005902s014jdg6n JDBC Thin Client select * from ( select trunc(P...
29.297990.040.1373.1040.070.000nn3rt489dkqz JDBC Thin Client select * from ( select row_.*,...
18.421,9750.010.0844.9740.970.006jn011b6rp1m2 JDBC Thin Client select * from ( select trunc(P...
14.133280.040.0635.5639.730.005dpdd7s28hnaa JDBC Thin Client select * from ( select row_.*,...

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
14.8911,1820.0031.0932.8717.6345.29djkdcyhxzmzv1 JDBC Thin Client insert into NCSS.STU_SEARCHJOB...
0.693560.001.431.6320.0441.93aar221wh7tqqz JDBC Thin Client update NCSS.REC_JOB set STATUS...
0.628970.001.300.909.3669.484pxrrbxm6024k JDBC Thin Client select job0_.JOBID as JOBID70_...
0.434,2260.000.913.1923.3013.63f711myt0q6cma JDBC Thin Client insert into sys.aud$( sessioni...
0.364,2240.000.753.0627.0611.774vs91dcv7u1p6 JDBC Thin Client insert into sys.aud$( sessioni...
0.306,6470.000.632.3526.3412.857c8s9hzb0jn1h JDBC Thin Client UPDATE ONLINE_USER SET LAST_AC...
0.072,1630.000.140.9626.747.226rhp7mz3vugaw JDBC Thin Client update stu_searchjob set VIEW_...
0.054130.000.110.3325.9515.56btyq1q2d6hd92 JDBC Thin Client insert into STU_RESUMEITEM (st...
0.03500.000.060.0924.3527.8234hggv6gbvc7a JDBC Thin Client insert into NCSS.REC_JOB (RECI...
0.015200.000.030.2825.544.52gb9fpmh2fzxbn JDBC Thin Client INSERT INTO ONLINE_USER VALUES...

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
1,171,388,99690,76412,905.8849.0530,514.2044.7008v35uwaj38aa JDBC Thin Client select * from ( select row_.*,...
554,429,81342,29913,107.4023.229,923.2340.90btn84j9rhuf4h JDBC Thin Client select * from ( select row_.*,...
503,809,511127,5063,951.2621.107,669.5237.30cp9wdanzmzj4q JDBC Thin Client select * from (select JOBID, S...
30,497,0692,33113,083.261.28409.6342.20fqjyuzjgm89qv JDBC Thin Client select * from ( select trunc(P...
24,457,8021,60715,219.541.02208.9045.408tptxzh309raz JDBC Thin Client select this_.PID as PID10_0_, ...
10,935,2413,7912,884.530.46462.8340.409dpwkhfwnqfqa JDBC Thin Client select * from (select JOBID, S...
8,294,72079910,381.380.3573.1040.100nn3rt489dkqz JDBC Thin Client select * from ( select row_.*,...
8,090,72458113,925.510.34209.7943.305902s014jdg6n JDBC Thin Client select * from ( select trunc(P...
4,568,22012337,140.000.1919.8337.9055u237k35a317 JDBC Thin Client select * from ( select rownum ...
4,151,73131613,138.390.1728.9537.80d1515xp5t2xtw JDBC Thin Client select * from (select JOBID, S...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
4,15111,1820.3716.3732.8717.6345.29djkdcyhxzmzv1 JDBC Thin Client insert into NCSS.STU_SEARCHJOB...
3503560.981.381.6320.0441.93aar221wh7tqqz JDBC Thin Client update NCSS.REC_JOB set STATUS...
1988970.220.780.909.3669.484pxrrbxm6024k JDBC Thin Client select job0_.JOBID as JOBID70_...
1844,2260.040.733.1923.3013.63f711myt0q6cma JDBC Thin Client insert into sys.aud$( sessioni...
1824,2240.040.723.0627.0611.774vs91dcv7u1p6 JDBC Thin Client insert into sys.aud$( sessioni...
1206,6470.020.472.3526.3412.857c8s9hzb0jn1h JDBC Thin Client UPDATE ONLINE_USER SET LAST_AC...
382,1630.020.150.9626.747.226rhp7mz3vugaw JDBC Thin Client update stu_searchjob set VIEW_...
314130.080.120.3325.9515.56btyq1q2d6hd92 JDBC Thin Client insert into STU_RESUMEITEM (st...
11500.220.040.0924.3527.8234hggv6gbvc7a JDBC Thin Client insert into NCSS.REC_JOB (RECI...
85200.020.030.2825.544.52gb9fpmh2fzxbn JDBC Thin Client INSERT INTO ONLINE_USER VALUES...

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
3,3683,36811,1820.300.0013.47djkdcyhxzmzv1 JDBC Thin Client insert into NCSS.STU_SEARCHJOB...
1981988970.220.000.794pxrrbxm6024k JDBC Thin Client select job0_.JOBID as JOBID70_...
1821824,2240.040.000.734vs91dcv7u1p6 JDBC Thin Client insert into sys.aud$( sessioni...
1201206,6470.020.000.487c8s9hzb0jn1h JDBC Thin Client UPDATE ONLINE_USER SET LAST_AC...
38382,1630.020.000.156rhp7mz3vugaw JDBC Thin Client update stu_searchjob set VIEW_...
161635.330.000.069dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
885200.020.000.03gb9fpmh2fzxbn JDBC Thin Client INSERT INTO ONLINE_USER VALUES...
337,1670.000.000.014rrtsdhkzfph5 JDBC Thin Client DELETE FROM ONLINE_USER WHERE ...
006750.00 0.0000a0rtu0xhh01 JDBC Thin Client select recsite0_.SITEID as col...
002,0500.00 0.0002qhsazjq77wp JDBC Thin Client select count(*) as y0_ from NC...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
134,088133,9321.0022.9631.706nxtvwbnujh7t JDBC Thin Client select this_.SITE_ID as SITE1_...
128,701128,5391.0021.6531.80fx40qmjn4x0bg JDBC Thin Client select this_.SITE_ID as SITE1_...
127,506911,3847.157,669.5237.30cp9wdanzmzj4q JDBC Thin Client select * from (select JOBID, S...
90,764541,7015.9730,514.2044.7008v35uwaj38aa JDBC Thin Client select * from ( select row_.*,...
42,2992,109,64649.879,923.2340.90btn84j9rhuf4h JDBC Thin Client select * from ( select row_.*,...
19,52653,6962.752.0834.80cm5vu20fhtnq1   select /*+ connect_by_filterin...
11,18211,1791.0032.8717.645.3djkdcyhxzmzv1 JDBC Thin Client insert into NCSS.STU_SEARCHJOB...
9,2569,2551.001.6430.20b53ms3cpq9mky JDBC Thin Client select this_.SITE_ID as SITE1_...
8,2596,871,398831.9918.5739.60ca76md7xwcbmc JDBC Thin Client select this_.ID as ID176_0_, t...
7,1672730.043.4635.4.34rrtsdhkzfph5 JDBC Thin Client DELETE FROM ONLINE_USER WHERE ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
4,29019,5265.63cm5vu20fhtnq1   select /*+ connect_by_filterin...
4,2834,2905.630k8522rmdzg4k   select privilege# from sysauth...
4,2224,2265.55f711myt0q6cma JDBC Thin Client insert into sys.aud$( sessioni...
4,2214,2245.544vs91dcv7u1p6 JDBC Thin Client insert into sys.aud$( sessioni...
4,1084,1065.400ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
4,1084,1085.40459f3z9u4fb3u   select value$ from props$ wher...
4,1074,1085.395ur69atw3vfhj   select decode(failover_method,...
1,6631,6632.18350f5yrnnmshs   lock table sys.mon_mods$ in ex...
4177,1670.554rrtsdhkzfph5 JDBC Thin Client DELETE FROM ONLINE_USER WHERE ...
4177,1670.556g6vfy6x3mcsd JDBC Thin Client SELECT COUNT(*) FROM ONLINE_US...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,180,0941060.0452xdu6bpaxhyh JDBC Thin Client select * from ( select row_.*,...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
7228dzr6gkrqft36c JDBC Thin Client select count(*) as y0_ from NC...
7228dzr6gkrqft36c JDBC Thin Client select count(*) as y0_ from NC...
6810652xdu6bpaxhyh JDBC Thin Client select * from ( select row_.*,...
6810652xdu6bpaxhyh JDBC Thin Client select * from ( select row_.*,...
6810652xdu6bpaxhyh JDBC Thin Client select * from ( select row_.*,...
32693c5cqqysuvgm JDBC Thin Client select count(*) as y0_ from NC...
32693c5cqqysuvgm JDBC Thin Client select count(*) as y0_ from NC...
32693c5cqqysuvgm JDBC Thin Client select count(*) as y0_ from NC...
29127,506cp9wdanzmzj4q JDBC Thin Client select * from (select JOBID, S...
277990nn3rt489dkqz JDBC Thin Client select * from ( select row_.*,...
253285dpdd7s28hnaa JDBC Thin Client select * from ( select row_.*,...
253285dpdd7s28hnaa JDBC Thin Client select * from ( select row_.*,...
253285dpdd7s28hnaa JDBC Thin Client select * from ( select row_.*,...
212,331fqjyuzjgm89qv JDBC Thin Client select * from ( select trunc(P...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00a0rtu0xhh01select recsite0_.SITEID as col_0_0_ from REC_SITE recsite0_ where recsite0_.RECID=:1
02qhsazjq77wpselect count(*) as y0_ from NCSS.STU_SEARCHJOB this_ where this_.SITEID=:1 and this_.IS_AUDITED=:2
08v35uwaj38aaselect * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.siteId = :1 and this_.IS_AUDITED = :2 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :3 and rownum_ > :4
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0nn3rt489dkqzselect * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.areaCode like :1 and this_.siteId = :2 and this_.IS_AUDITED = :3 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :4 and rownum_ > :5
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
34hggv6gbvc7ainsert into NCSS.REC_JOB (RECID, RECNAME, JOBNAME, JOBCODE, HEADCOUNT, APPLYCOUNT, JOBAREACODE, JOBAREANAME, JOBTYPE, CATEGORY, CATEGORYNAME, DEGREEREQCODE, DEGREE, DESCRIPTION, RECMAIL, DAYLIMIT, STATUS, CREATEDATE, MODIFYDATE, MODIFYBYID, MODIFYBYNAME, SOURCECODE, MAJOR, MAJORCODE, SITE_COUNT, JOBID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 )
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4pxrrbxm6024kselect job0_.JOBID as JOBID70_0_, job0_.RECID as RECID70_0_, job0_.RECNAME as RECNAME70_0_, job0_.JOBNAME as JOBNAME70_0_, job0_.JOBCODE as JOBCODE70_0_, job0_.HEADCOUNT as HEADCOUNT70_0_, job0_.APPLYCOUNT as APPLYCOUNT70_0_, job0_.JOBAREACODE as JOBAREAC8_70_0_, job0_.JOBAREANAME as JOBAREAN9_70_0_, job0_.JOBTYPE as JOBTYPE70_0_, job0_.CATEGORY as CATEGORY70_0_, job0_.CATEGORYNAME as CATEGOR12_70_0_, job0_.DEGREEREQCODE as DEGREER13_70_0_, job0_.DEGREE as DEGREE70_0_, job0_.DESCRIPTION as DESCRIP15_70_0_, job0_.RECMAIL as RECMAIL70_0_, job0_.DAYLIMIT as DAYLIMIT70_0_, job0_.STATUS as STATUS70_0_, job0_.CREATEDATE as CREATEDATE70_0_, job0_.MODIFYDATE as MODIFYDATE70_0_, job0_.MODIFYBYID as MODIFYBYID70_0_, job0_.MODIFYBYNAME as MODIFYB22_70_0_, job0_.SOURCECODE as SOURCECODE70_0_, job0_.MAJOR as MAJOR70_0_, job0_.MAJORCODE as MAJORCODE70_0_, job0_.SITE_COUNT as SITE26_70_0_ from NCSS.REC_JOB job0_ where job0_.JOBID=:1
4rrtsdhkzfph5DELETE FROM ONLINE_USER WHERE LAST_ACTIVE_TIME+ 1/(24*3) < SYSDATE AND PTP_ID IS NULL
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)
52xdu6bpaxhyhselect * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.areaCode like :2 and this_.siteId = :3 and this_.IS_AUDITED = :4 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :5 and rownum_ > :6
55u237k35a317select * from ( select rownum no , t.* from ( select a.studentid, a.realname, a.language, a.gender, a.degree, a.majorname, a.school, a.modifydate , a.department, a.edustartdate, a.graduatedate from STU_BASICINFO a inner join STU_SITE b on a.studentid = b.studentid where b.siteid = :1 and a.openstate!='1' and a.language='cn' and a.ISAUTHED = :2 order by a.createDate desc, a.schoolCode asc) t where rownum< 13) where no>0
5902s014jdg6nselect * from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobfairId = :1 and this_.IS_AUDITED = :2 order by y6_ desc, days desc, y12_ asc, y5_ desc ) where rownum <= :3
5dpdd7s28hnaaselect * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.areaCode like :2 and this_.siteId = :3 and postDate > trunc(sysdate , 'dd')-30 and this_.IS_AUDITED = :4 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :5 and rownum_ > :6
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6g6vfy6x3mcsdSELECT COUNT(*) FROM ONLINE_USER WHERE USER_ID = :B1
6jn011b6rp1m2select * from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.siteId = :1 and this_.IS_AUDITED = :2 order by y6_ desc, days desc, y12_ asc, y5_ desc ) where rownum <= :3
6nxtvwbnujh7tselect this_.SITE_ID as SITE1_52_0_, this_.SITE_NAME as SITE2_52_0_, this_.SITE_URL as SITE3_52_0_, this_.SITE_TYPE as SITE4_52_0_, this_.PARENT_ID as PARENT5_52_0_, this_.SERVICE_IP as SERVICE6_52_0_, this_.SERVICE_KEY as SERVICE7_52_0_, this_.IS_EFFECTIVE as IS8_52_0_, this_.CREATE_DATE as CREATE9_52_0_, this_.MODIFY_DATE as MODIFY10_52_0_, this_.CONTACT_NAME as CONTACT11_52_0_, this_.TELEPHONE as TELEPHONE52_0_, this_.FEX as FEX52_0_, this_.MOBILEPHONE as MOBILEP14_52_0_, this_.EMAIL as EMAIL52_0_, this_.DESCRIPTION as DESCRIP16_52_0_, this_.IS_ALLOW as IS17_52_0_, this_.TAGS as TAGS52_0_, this_.AREA_CODE as AREA19_52_0_, this_.AREA_NAME as AREA20_52_0_, this_.HAVE_THEME as HAVE21_52_0_, this_.PARENT_NAME as PARENT22_52_0_, this_.JOB_NEED_AUDIT as JOB23_52_0_, this_.WEB_NAME as WEB24_52_0_, this_.WEB_URL as WEB25_52_0_ from NCSS.PUB_SITE this_ where this_.SITE_URL like :1 and this_.IS_EFFECTIVE=:2
6rhp7mz3vugawupdate stu_searchjob set VIEW_COUNT = :1 where jobid = :2 and siteid = :3 and jobfairid = :4
7c8s9hzb0jn1hUPDATE ONLINE_USER SET LAST_ACTIVE_TIME = SYSDATE WHERE USER_ID = :B1
8tptxzh309razselect this_.PID as PID10_0_, this_.YEAR as YEAR10_0_, this_.C_NAME as C3_10_0_, this_.GENDER as GENDER10_0_, this_.RACE_CODE as RACE5_10_0_, this_.RACE as RACE10_0_, this_.POLICY as POLICY10_0_, this_.BIRTH as BIRTH10_0_, this_.IDCARD as IDCARD10_0_, this_.PHOTO as PHOTO10_0_, this_.FROM_AREA as FROM11_10_0_, this_.EDUCATION_CODE as EDUCATION12_10_0_, this_.EDUCATION as EDUCATION10_0_, this_.DEGREE_CODE as DEGREE14_10_0_, this_.DEGREE as DEGREE10_0_, this_.GRADUATE_SCHOOL as GRADUATE16_10_0_, this_.MAJOR as MAJOR10_0_, this_.IS_FRESH as IS18_10_0_, this_.IS_PEDAGOGIC as IS19_10_0_, this_.GRADUATE_DATE as GRADUATE20_10_0_, this_.EDUCATION_NO as EDUCATION21_10_0_, this_.TEACHER_KIND_CODE as TEACHER22_10_0_, this_.TEACHER_KIND as TEACHER23_10_0_, this_.TEACHER_NO as TEACHER24_10_0_, this_.MANDARIN as MANDARIN10_0_, this_.FOREIGN as FOREIGN10_0_, this_.POST_CODE as POST27_10_0_, this_.MOBILE as MOBILE10_0_, this_.TELEPHONE as TELEPHONE10_0_, this_.EMAIL as EMAIL10_0_, this_.FAMILY_ADDR as FAMILY31_10_0_, this_.RESUME as RESUME10_0_, this_.BEGIN_DATE as BEGIN33_10_0_, this_.AREA_CODE as AREA34_10_0_, this_.AREA as AREA10_0_, this_.LEVEL_CODE as LEVEL36_10_0_, this_.LEVEL_NAME as LEVEL37_10_0_, this_.SUBJECT_CODE as SUBJECT38_10_0_, this_.SUBJECT as SUBJECT10_0_, this_.LANGUAGE_CODE as LANGUAGE40_10_0_, this_.LANGUAGE as LANGUAGE10_0_, this_.REC_SCHOOL as REC42_10_0_, this_.POLICY_KIND as POLICY43_10_0_, this_.TEACHER_OFFICE as TEACHER44_10_0_, this_.NOTICE_TAG as NOTICE45_10_0_, this_.TEACH_STATE as TEACH46_10_0_ from stpsuser.TEACHER_INFO this_ where this_.IDCARD like :1
93c5cqqysuvgmselect count(*) as y0_ from NCSS.STU_SEARCHJOB this_ where this_.JOBTYPE=:1 and this_.AREACODE like :2 and this_.SITEID=:3 and postDate > trunc(sysdate , 'dd')-3 and this_.IS_AUDITED=:4
9dhn1b8d88dpf 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.obj# 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.owner# = 0 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.owner# = 0 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
9dpwkhfwnqfqaselect * from (select JOBID, SITEID, JOBFAIRID, RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, '' AS DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, "DEGREE", "CATEGORY", CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, INDUSTRY_CODE, REC_SCALE, INDUSTRY, NATURE, IS_AUDITED, ZIPCODE, ADDRESS, WEBSITE, PRIORITY, row_number() over(partition by RECNAME order by PRIORITY desc, POSTDATE desc) rn from STU_SEARCHJOB where IS_AUDITED='1' and SITEID=:1 order by PRIORITY desc, trunc(POSTDATE, 'dd') desc, FROMTYPE asc, POSTDATE desc) where rn=1 and rownum<:2
aar221wh7tqqzupdate NCSS.REC_JOB set STATUS=:1 , JOBNAME=:2 , JOBCODE=:3 , JOBTYPE=:4 , HEADCOUNT=:5 , JOBAREACODE=:6 , JOBAREANAME=:7 , CATEGORY=:8 , DEGREEREQCODE=:9 , DEGREE=:10 , DESCRIPTION=:11 , RECMAIL=:12 , MODIFYDATE=:13 , CATEGORYNAME=:14 , MODIFYBYID=:15 , MODIFYBYNAME=:16 , DAYLIMIT=:17 , SITE_COUNT=:18 where JOBID=:19
b53ms3cpq9mkyselect this_.SITE_ID as SITE1_241_0_, this_.SITE_NAME as SITE2_241_0_, this_.SITE_URL as SITE3_241_0_, this_.SITE_TYPE as SITE4_241_0_, this_.PARENT_ID as PARENT5_241_0_, this_.SERVICE_IP as SERVICE6_241_0_, this_.SERVICE_KEY as SERVICE7_241_0_, this_.IS_EFFECTIVE as IS8_241_0_, this_.CREATE_DATE as CREATE9_241_0_, this_.MODIFY_DATE as MODIFY10_241_0_, this_.CONTACT_NAME as CONTACT11_241_0_, this_.TELEPHONE as TELEPHONE241_0_, this_.FEX as FEX241_0_, this_.MOBILEPHONE as MOBILEP14_241_0_, this_.EMAIL as EMAIL241_0_, this_.DESCRIPTION as DESCRIP16_241_0_, this_.IS_ALLOW as IS17_241_0_, this_.TAGS as TAGS241_0_, this_.AREA_CODE as AREA19_241_0_, this_.AREA_NAME as AREA20_241_0_, this_.HAVE_THEME as HAVE21_241_0_, this_.PARENT_NAME as PARENT22_241_0_, this_.JOB_NEED_AUDIT as JOB23_241_0_, this_.WEB_NAME as WEB24_241_0_, this_.WEB_URL as WEB25_241_0_ from NCSS.PUB_SITE this_ where this_.SITE_URL like :1 and this_.IS_EFFECTIVE=:2
btn84j9rhuf4hselect * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.siteId = :2 and this_.IS_AUDITED = :3 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :4 and rownum_ > :5
btyq1q2d6hd92insert into STU_RESUMEITEM (studentId, language, ITEMLABEL, ITEMCONTENT, ITEMID) values (:1 , :2 , :3 , :4 , :5 )
ca76md7xwcbmcselect this_.ID as ID176_0_, this_.WORD as WORD176_0_ from NCSS.REC_BLACKDICT this_
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cp9wdanzmzj4qselect * from (select JOBID, SITEID, JOBFAIRID, RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, '' AS DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, "DEGREE", "CATEGORY", CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, INDUSTRY_CODE, REC_SCALE, INDUSTRY, NATURE, IS_AUDITED, ZIPCODE, ADDRESS, WEBSITE, PRIORITY, row_number() over(partition by RECNAME order by PRIORITY desc, POSTDATE desc) rn from STU_SEARCHJOB where IS_AUDITED='1' and SITEID=:1 and JOBTYPE=:2 order by PRIORITY desc, trunc(POSTDATE, 'dd') desc, FROMTYPE asc, POSTDATE desc) where rn=1 and rownum<:3
d1515xp5t2xtwselect * from (select JOBID, SITEID, JOBFAIRID, RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, '' AS DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, "DEGREE", "CATEGORY", CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, INDUSTRY_CODE, REC_SCALE, INDUSTRY, NATURE, IS_AUDITED, ZIPCODE, ADDRESS, WEBSITE, PRIORITY, row_number() over(partition by RECNAME order by PRIORITY desc, POSTDATE desc) rn from STU_SEARCHJOB where IS_AUDITED='1' and SITEID=:1 and JOBTYPE=:2 and postDate > sysdate-:3 order by PRIORITY desc, trunc(POSTDATE, 'dd') desc, FROMTYPE asc, POSTDATE desc) where rn=1 and rownum<:4
djkdcyhxzmzv1insert into NCSS.STU_SEARCHJOB (RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, DEGREE, CATEGORY, CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, NATURE, INDUSTRY_CODE, INDUSTRY, REC_SCALE, IS_AUDITED, WEBSITE, ZIPCODE, ADDRESS, PRIORITY, VIEW_COUNT, HAVA_BLACKWORD, JOBID, SITEID, JOBFAIRID) values (:1 , :2 , :3 , :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 )
dzr6gkrqft36cselect count(*) as y0_ from NCSS.STU_SEARCHJOB this_ where this_.JOBTYPE=:1 and this_.AREACODE like :2 and this_.SITEID=:3 and this_.IS_AUDITED=:4
f711myt0q6cmainsert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fqjyuzjgm89qvselect * from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.siteId = :2 and this_.IS_AUDITED = :3 order by y6_ desc, days desc, y12_ asc, y5_ desc ) where rownum <= :4
fx40qmjn4x0bgselect this_.SITE_ID as SITE1_72_0_, this_.SITE_NAME as SITE2_72_0_, this_.SITE_URL as SITE3_72_0_, this_.SITE_TYPE as SITE4_72_0_, this_.PARENT_ID as PARENT5_72_0_, this_.SERVICE_IP as SERVICE6_72_0_, this_.SERVICE_KEY as SERVICE7_72_0_, this_.IS_EFFECTIVE as IS8_72_0_, this_.CREATE_DATE as CREATE9_72_0_, this_.MODIFY_DATE as MODIFY10_72_0_, this_.CONTACT_NAME as CONTACT11_72_0_, this_.TELEPHONE as TELEPHONE72_0_, this_.FEX as FEX72_0_, this_.MOBILEPHONE as MOBILEP14_72_0_, this_.EMAIL as EMAIL72_0_, this_.DESCRIPTION as DESCRIP16_72_0_, this_.IS_ALLOW as IS17_72_0_, this_.TAGS as TAGS72_0_, this_.AREA_CODE as AREA19_72_0_, this_.AREA_NAME as AREA20_72_0_, this_.HAVE_THEME as HAVE21_72_0_, this_.PARENT_NAME as PARENT22_72_0_, this_.JOB_NEED_AUDIT as JOB23_72_0_, this_.WEB_NAME as WEB24_72_0_, this_.WEB_URL as WEB25_72_0_ from NCSS.PUB_SITE this_ where this_.SITE_URL like :1 and this_.IS_EFFECTIVE=:2
gb9fpmh2fzxbnINSERT INTO ONLINE_USER VALUES(:B3 , :B2 , SYSDATE, '', :B1 , '')

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 slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced2690.070.02
CCursor + sql area evicted380.010.00
CPU used by this session2,235,102619.95128.06
CPU used when call started2,234,650619.83128.04
CR blocks created19,4765.401.12
Cached Commit SCN referenced2,4090.670.14
Commit SCN cached3400.090.02
DB time5,661,3361,570.30324.38
DBWR checkpoint buffers written70,45019.544.04
DBWR checkpoints10.000.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes1270.040.01
DBWR undo block writes7,8052.160.45
DFO trees parallelized00.000.00
Effective IO time18,987,3135,266.551,087.91
HSC Heap Segment Block Changes72,93420.234.18
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts1410.040.01
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued12,9373.590.74
OS Integral shared text size00.000.00
OS Integral unshared data size00.000.00
OS Involuntary context switches00.000.00
OS Maximum resident set size00.000.00
OS Page reclaims00.000.00
OS Signals received00.000.00
OS System time used00.000.00
OS User time used00.000.00
OS Voluntary context switches00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations not downgraded00.000.00
Requests to/from client2,501,419693.82143.32
RowCR - row contention20.000.00
RowCR attempts6440.180.04
RowCR hits6430.180.04
SMON posted for dropping temp segment00.000.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client2,501,398693.82143.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 cleanout17,2754.790.99
application wait time5070.140.03
auto extends on undo tablespace00.000.00
background checkpoints completed10.000.00
background checkpoints started10.000.00
background timeouts23,6936.571.36
branch node splits00.000.00
buffer is not pinned count541,403,096150,170.0431,020.63
buffer is pinned count501,187,020139,015.2328,716.38
bytes received via SQL*Net from client725,758,884201,305.1741,583.62
bytes sent via SQL*Net to client2,594,021,636719,508.88148,628.98
calls to get snapshot scn: kcmgss917,477254.4852.57
calls to kcmgas77,26121.434.43
calls to kcmgcs3,436,905953.30196.92
cell physical IO interconnect bytes3,626,024,9601,005,757.68207,759.41
change write time2,0400.570.12
cleanout - number of ktugct calls17,3314.810.99
cleanouts and rollbacks - consistent read gets11,4463.170.66
cleanouts only - consistent read gets1350.040.01
cluster key scan block gets17,8914.961.03
cluster key scans14,8934.130.85
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed650.020.00
commit batch/immediate requested650.020.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure890.020.01
commit cleanout failures: cannot pin3620.100.02
commit cleanouts127,49035.367.30
commit cleanouts successfully completed127,03935.247.28
commit immediate performed650.020.00
commit immediate requested650.020.00
commit txn count during cleanout2,7300.760.16
concurrency wait time2,7350.760.16
consistent changes23,4606.511.34
consistent gets2,387,073,254662,107.20136,771.52
consistent gets - examination7,600,1592,108.07435.46
consistent gets direct13,5083.750.77
consistent gets from cache2,387,059,758662,103.46136,770.74
consistent gets from cache (fastpath)2,225,869,528617,393.81127,535.07
cursor authentications1,5320.420.09
data blocks consistent reads - undo records applied23,3446.471.34
db block changes684,553189.8839.22
db block gets995,204276.0457.02
db block gets direct1,1860.330.07
db block gets from cache994,018275.7156.95
db block gets from cache (fastpath)221,44361.4212.69
deferred (CURRENT) block cleanout applications40,67611.282.33
dirty buffers inspected10.000.00
enqueue conversions7270.200.04
enqueue deadlocks00.000.00
enqueue releases156,12643.308.95
enqueue requests156,12543.308.95
enqueue timeouts00.000.00
enqueue waits300.010.00
exchange deadlocks00.000.00
execute count774,865214.9344.40
failed probes on index block reclamation20.000.00
file io service time00.000.00
file io wait time53,802,12514,923.203,082.69
flashback cache read optimizations for block new1130.030.01
flashback direct read optimizations for block new00.000.00
flashback log write bytes499,875,840138,651.5528,641.26
flashback log writes2,1630.600.12
free buffer inspected8,3232.310.48
free buffer requested34,9779.702.00
global undo segment hints helped00.000.00
heap block compress6,8801.910.39
hot buffers moved to head of LRU14,9814.160.86
immediate (CR) block cleanout applications11,5813.210.66
immediate (CURRENT) block cleanout applications16,1784.490.93
in call idle wait time12,933,0653,587.27741.02
index crx upgrade (positioned)4,0051.110.23
index crx upgrade (prefetch)00.000.00
index fast full scans (full)3740.100.02
index fetch by key5,774,4041,601.66330.85
index scans kdiixs1557,987154.7731.97
leaf node 90-10 splits720.020.00
leaf node splits2580.070.01
lob reads54,59215.143.13
lob writes11,7843.270.68
lob writes unaligned9,7382.700.56
logical read bytes from cache19,562,936,696,8325,426,210,235.421,120,892,493.95
logons cumulative4,4431.230.25
max cf enq hold time20.000.00
messages received79,28921.994.54
messages sent79,28921.994.54
min active SCN optimization applied on CR560.020.00
no buffer to keep pinned count700.020.00
no work - consistent read gets2,376,273,695659,111.71136,152.74
non-idle wait count2,757,198764.77157.98
non-idle wait time74,57520.694.27
opened cursors cumulative794,277220.3145.51
parse count (describe)00.000.00
parse count (failures)00.000.00
parse count (hard)12,3713.430.71
parse count (total)76,13821.124.36
parse time cpu3,5430.980.20
parse time elapsed10,0122.780.57
physical read IO requests25,0126.941.43
physical read bytes207,724,54457,616.9711,901.94
physical read total IO requests34,5249.581.98
physical read total bytes803,490,304222,865.6946,037.37
physical read total multi block requests4380.120.03
physical reads25,3577.031.45
physical reads cache10,6432.950.61
physical reads cache prefetch10.000.00
physical reads direct14,7144.080.84
physical reads direct (lob)14,0703.900.81
physical reads direct temporary tablespace00.000.00
physical reads for flashback new6,7281.870.39
physical reads prefetch warmup00.000.00
physical write IO requests50,89514.122.92
physical write bytes587,243,520162,884.8933,647.14
physical write total IO requests153,11142.478.77
physical write total bytes2,822,534,656782,891.99161,722.03
physical write total multi block requests2,8530.790.16
physical writes71,68519.884.11
physical writes direct1,2330.340.07
physical writes direct (lob)9810.270.06
physical writes direct temporary tablespace00.000.00
physical writes from cache70,45219.544.04
physical writes non checkpoint11,4203.170.65
pinned buffers inspected00.000.00
pinned cursors current1940.050.01
prefetch clients - default00.000.00
prefetch clients - keep00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use10.000.00
process last non-idle time3,6011.000.21
queries parallelized00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls1,379,841382.7379.06
recursive cpu usage3,9741.100.23
redo KB read435,690120.8524.96
redo blocks checksummed by FG (exclusive)168,73546.809.67
redo blocks written418,102115.9723.96
redo buffer allocation retries10.000.00
redo entries452,789125.5925.94
redo log space requests10.000.00
redo log space wait time50.000.00
redo ordering marks11,2553.120.64
redo size199,341,85655,291.8411,421.64
redo size for direct writes9,768,8362,709.60559.72
redo subscn max counts16,5634.590.95
redo synch long waits5090.140.03
redo synch poll writes00.000.00
redo synch polls00.000.00
redo synch time31,0278.611.78
redo synch time (usec)310,470,24786,115.7417,788.93
redo synch writes25,3787.041.45
redo wastage7,871,5882,183.36451.02
redo write time29,0818.071.67
redo writes28,1277.801.61
rollback changes - undo records applied1840.050.01
rollbacks only - consistent read gets7,3602.040.42
root node splits00.000.00
rows fetched via callback1,730,696480.0599.16
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits650,986180.5737.30
session logical reads2,388,068,143662,383.16136,828.52
shared hash latch upgrades - no wait28,9038.021.66
shared hash latch upgrades - wait1110.030.01
sorts (disk)00.000.00
sorts (memory)478,469132.7127.41
sorts (rows)4,962,872,2411,376,561.64284,356.40
sql area evicted13,0533.620.75
sql area purged10.000.00
summed dirty queue length10.000.00
switch current to new buffer4,7411.320.27
table fetch by rowid500,228,316138,749.3128,661.45
table fetch continued row7,733,1432,144.96443.08
table scan blocks gotten1,851,177,574513,464.77106,066.44
table scan rows gotten9,365,913,1212,597,841.75536,636.29
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)183,31550.8510.50
temp space allocated (bytes)00.000.00
total cf enq hold time11,9213.310.68
total number of cf enq holders5830.160.03
total number of times SMON posted90.000.00
transaction rollbacks630.020.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size53,459,38814,828.143,063.05
user I/O wait time4,7881.330.27
user calls3,185,123883.46182.50
user commits17,4484.841.00
user rollbacks50.000.00
workarea executions - multipass00.000.00
workarea executions - onepass00.000.00
workarea executions - optimal630,545174.9036.13
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory502,317,915,042,112502,605,949,707,160
opened cursors current581775
workarea memory allocated121,730155,052
logons current261260
session uga memory max12,857,403,634,72012,865,197,183,648
session pga memory275,227,117,840275,429,827,856
session pga memory max298,892,752,000299,416,132,352
session cursor cache count74,665,36274,713,735

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)11.00

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)
Others572M2.74.1586561.5G4.17.42326915.1K1.58
LGWR0M0.010M616M24.47.17086128.3K9.75
DBWR0M0.000M550M13.83.1525540 
Direct Reads112M3.88.0310653M0.07.0008320 
Buffer Cache Reads84M2.97.0232990M0.000M10.7K1.89
Direct Writes0M0.000M1M0.03.0002770 
TOTAL:768M9.60.2130212.6G42.58.74779454.2K5.91

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
Log File426M0.12.118160616M24.47.1708611.2545.06
Archive Log0M0.000M851M0.24.236043  
Data File199M6.97.055197560M14.12.1553282.047.83
Flashback Log0M0.010M478M0.61.1325831.25 
Control File141M2.47.039109162M2.87.0449340.364.17
Other0M0.020M30M0.28.00832151.97 
TOTAL:766M9.60.2124662.6G42.58.7480721.6943.99

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)
Others 571M2.72.1583791.5G3.89.41494811.6K0.58
Others (Archive Log) 0M0.000M851M0.24.2360430 
Others (Flashback Log) 1M0.01.000277478M0.61.13258322451.43
Others (Log File) 425M0.12.1178830M0.000M100.10
Others (Control File) 141M2.47.039109161M2.86.04465688950.36
Others (Data File) 4M0.12.0011096M0.18.0016644400.90
LGWR 0M0.010M616M24.48.170861381.34
LGWR (Log File) 0M0.000M616M24.47.170861122.42
LGWR (Control File) 0M0.010M0M0.010M260.85
DBWR 0M0.000M550M13.83.1525540 
DBWR (Data File) 0M0.000M550M13.83.1525540 
Direct Reads 112M3.88.0310653M0.07.0008320 
Direct Reads (Data File) 112M3.88.0310653M0.07.0008320 
Buffer Cache Reads 84M2.97.0232990M0.000M10.7K1.89
Buffer Cache Reads (Data File) 84M2.97.0232990M0.000M10.7K1.89
Direct Writes 0M0.000M1M0.03.0002770 
Direct Writes (Data File) 0M0.000M1M0.03.0002770 
TOTAL: 767M9.58.2127442.6G42.30.73947322.3K1.21

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
NCSS 14,58040.141.017,3302101.00
NCSS_INDEX 25104.621.0012,7934210.48
UNDOTBS1 6,19720.881.007260940.21
NCSSJOBSITE00000 89504.391.005,971230.00
NCSSJOBSITE0000 41904.061.005,1541140.00
NCSSJOBSITE00001 39104.401.004,8801140.00
NCSSJOBSITE00002 76104.611.003,5961140.00
NCSSJOBSITE00003 19404.481.001,665000.00
NCSSJOBSITE00004 13304.291.001,302000.00
NCSSJOBSITE00006 11204.381.00934000.00
NCSSJOBSITE00010 13704.011.01904000.00
NCSSJOBSITE00 3504.861.0091203,3220.07
SYSAUX 22500.401.84708000.00
ZCMS 205.001.00831000.00
NCSSJOBSITE00007 9204.131.00619000.00
NCSSJOBSITE00009 19105.181.00488000.00
NCSSJOBSITE00008 2403.331.00614000.00
NCSSJOBSITE00005 8803.861.00504000.00
NCSSJOBSITE00017 1005.001.00430020.00
SYSTEM 24002.041.0010205850.44
NCSSJOBSITE00011 1203.331.00237000.00
STPS2 100.001.0085010.00
NCSSJOBSITE0 100.001.0046000.00
NCSSJOBSITE00012 100.001.0022000.00
NCSSJOBSITE00013 200.001.0019000.00
NCSSDELETED 504.001.003000.00
CSERAS 405.001.002000.00
APP_TEST 100.001.001000.00
EGTISDB 100.001.001000.00
JOB_SERVICE 100.001.001000.00
NCS 100.001.001000.00
NCSSJOBBAK 100.001.001000.00
NCSSJOBSITE00014 100.001.001000.00
NCSSJOBSITE00015 100.001.001000.00
NCSSJOBSITE00016 100.001.001000.00
NCSSNEWSJOB 100.001.001000.00
NCSSSIGN 100.001.001000.00
NCSSSTATUS 100.001.001000.00
SFS 100.001.001000.00
SPOTLIGHT 100.001.001000.00
STATSPACK 100.001.001000.00
STPS 100.001.001000.00
USERS 100.001.001000.00
WSGP 100.001.001000.00
ZCMS_TEST 100.001.001000.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)
APP_TEST/data/oradata/o10g/APP_TEST01.dbf 100.001.001000.00
CSERAS/data/oradata/o10g/CSERAS.dbf 405.001.002000.00
EGTISDB/data/oradata/o10g/EG.dbf 100.001.001000.00
JOB_SERVICE/data/oradata/o10g/job_service01.dbf 100.001.001000.00
NCS/data/oradata/o10g/NCS01.dbf 100.001.001000.00
NCSS/data/oradata/o10g/NCSS01.dbf 3,84710.121.002,361142.50
NCSS/data/oradata/o10g/NCSS02.dbf 6,83620.141.023,036120.00
NCSS/data/oradata/o10g/NCSS03.dbf 3,89710.141.011,933140.00
NCSSDELETED/data/oradata/o10g/NCSSDELETED.dbf 504.001.003000.00
NCSSJOBBAK/data/oradata/o10g/NCSSJOBBAK.dbf 100.001.001000.00
NCSSJOBSITE0/data/oradata/o10g/NCSSJOBSITE0.dbf 100.001.0046000.00
NCSSJOBSITE00/data/oradata/o10g/NCSSJOBSITE00.dbf 3504.861.0091203,3220.07
NCSSJOBSITE0000/data/oradata/o10g/NCSSJOBSITE0000.dbf 41904.061.005,1541140.00
NCSSJOBSITE00000/data/oradata/o10g/NCSSJOBSITE00000.dbf 89504.391.005,971230.00
NCSSJOBSITE00001/data/oradata/o10g/NCSSJOBSITE00001.dbf 39104.401.004,8801140.00
NCSSJOBSITE00002/data/oradata/o10g/NCSSJOBSITE00002.dbf 76104.611.003,5961140.00
NCSSJOBSITE00003/data/oradata/o10g/NCSSJOBSITE00003.dbf 19404.481.001,665000.00
NCSSJOBSITE00004/data/oradata/o10g/NCSSJOBSITE00004.dbf 13304.291.001,302000.00
NCSSJOBSITE00005/data/oradata/o10g/NCSSJOBSITE00005.dbf 8803.861.00504000.00
NCSSJOBSITE00006/data/oradata/o10g/NCSSJOBSITE00006.dbf 11204.381.00934000.00
NCSSJOBSITE00007/data/oradata/o10g/NCSSJOBSITE00007.dbf 9204.131.00619000.00
NCSSJOBSITE00008/data/oradata/o10g/NCSSJOBSITE00008.dbf 2403.331.00614000.00
NCSSJOBSITE00009/data/oradata/o10g/NCSSJOBSITE00009.dbf 19105.181.00488000.00
NCSSJOBSITE00010/data/oradata/o10g/NCSSJOBSITE00010.dbf 13704.011.01904000.00
NCSSJOBSITE00011/data/oradata/o10g/NCSSJOBSITE00011.dbf 1203.331.00237000.00
NCSSJOBSITE00012/data/oradata/o10g/NCSSJOBSITE00012.dbf 100.001.0022000.00
NCSSJOBSITE00013/data/oradata/o10g/NCSSJOBSITE00013.dbf 200.001.0019000.00
NCSSJOBSITE00014/data/oradata/o10g/NCSSJOBSITE00014.dbf 100.001.001000.00
NCSSJOBSITE00015/data/oradata/o10g/NCSSJOBSITE00015.dbf 100.001.001000.00
NCSSJOBSITE00016/data/oradata/o10g/NCSSJOBSITE00016.dbf 100.001.001000.00
NCSSJOBSITE00017/data/oradata/o10g/NCSSJOBSITE00017.dbf 1005.001.00430020.00
NCSSNEWSJOB/data/oradata/o10g/ncssnewsjob.dbf 100.001.001000.00
NCSSSIGN/data/oradata/o10g/NCSSSIGN.dbf 100.001.001000.00
NCSSSTATUS/data/oradata/o10g/NCSSSTATUS.dbf 100.001.001000.00
NCSS_INDEX/data/oradata/o10g/ncss_index01.dbf 25104.621.0012,7934210.48
SFS/data/oradata/o10g/SFS.dbf 100.001.001000.00
SPOTLIGHT/data/oradata/o10g/SPOTLIGHT01.dbf 100.001.001000.00
STATSPACK/data/oradata/o10g/statspack.dbf 100.001.001000.00
STPS/data/oradata/o10g/STPS.dbf 100.001.001000.00
STPS2/data/oradata/o10g/STPS2.dbf 100.001.0085010.00
SYSAUX/data/oradata/o10g/sysaux01.dbf 22500.401.84708000.00
SYSTEM/data/oradata/o10g/system01.dbf 24002.041.0010205850.44
UNDOTBS1/data/oradata/o10g/undotbs01.dbf 6,19720.881.007260940.21
USERS/data/oradata/o10g/users01.dbf 100.001.001000.00
WSGP/data/oradata/o10g/WSGP.dbf 100.001.001000.00
ZCMS/data/oradata/o10g/ZCMS.dbf 205.001.00831000.00
ZCMS_TEST/data/oradata/o10g/ZCMS_TEST.dbf 100.001.001000.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
D1,112,4901002,173,793,7427,16041,402004,056
K1,009,920100204,072,3573,48929,0500026

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000070,4500

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
B8332936701633033177603317760  3508 
E6483147762801933177603317760  4552 

Back to Advisory Statistics
Back to Top

MTTR Advisory

Size for Est (s)Dirty LimitEst Cache WritesEst Cache Write FctrEst Total WritesEst Total Write FctrEst Total IOsEst Total IO Fctr
9029,080115,7891.62127,0741.53640,2681.07
21084,48392,6321.29103,9171.25617,1111.04
330139,88680,7901.1392,0751.11605,2691.02
450195,28872,0771.0183,3631.01596,5561.00
458199,00871,5721.0082,8581.00596,0511.00

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
D8960.10110102.501,947,11512354674.00
D1,7920.2022112.52237,7571282654.00
D2,6880.303313.4265,003173248.00
D3,5840.404422.3444,415148291.00
D4,4800.505521.8334,745136570.00
D5,3760.606631.5228,860129436.00
D6,2720.707731.3124,945124691.00
D7,1680.798841.1822,337121530.00
D8,0640.899941.0820,494119296.00
D8,9600.991,1051.0019,087117590.00
D9,0241.001,1121.0018,996117480.00
D9,8561.091,2150.9417,826116061.00
D10,7521.191,3260.8816,653114639.00
D11,6481.291,4360.8115,346113056.00
D12,5441.391,5460.7313,928111337.00
D13,4401.491,6570.6712,67419816.00
D14,3361.591,7670.6111,62018538.00
D15,2321.691,8780.5510,50317184.00
D16,1281.791,9880.499,24915664.00
D17,0241.892,0990.428,00114152.00
D17,9201.992,2090.356,62112479.00
K7680.0995149.851,758,96015734493.00
K1,5360.1918916.31191,4231618778.00
K2,3040.282846.2973,8711235141.00
K3,0720.383793.8645,2861141854.00
K3,8400.474732.9734,8251107714.00
K4,6080.565682.5129,422190083.00
K5,3760.666632.1525,239176428.00
K6,1440.757571.8121,234163360.00
K6,9120.848521.4416,956149398.00
K7,6800.949471.1513,475138037.00
K8,1921.001,0101.0011,738132369.00
K8,4481.031,0410.9411,002129966.00
K9,2161.131,1360.779,038123557.00
K9,9841.221,2310.637,442118348.00
K10,7521.311,3260.536,169114194.00
K11,5201.411,4200.445,153110879.00
K12,2881.501,5150.374,38918387.00
K13,0561.591,6100.333,86116663.00
K13,8241.691,7040.303,49615472.00
K14,5921.781,7990.283,27814761.00
K15,3601.881,8940.273,16914404.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.004,220,0410

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B2,0483,120933.41107.1611.48100.000.00419,430
E2,0483,1091,007.09135.0113.41100.000.00419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K153,987153,98700
64K128K59,90859,90800
128K256K33,36533,36500
256K512K46,29246,29200
512K1024K39,63239,63200
1M2M36,86836,86800
2M4M19,04019,04000
4M8M11011000
8M16M61,97761,97700
16M32M179,037179,03700

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
5120.131,483,768,958.79233,182,580.1286.001,517,928172,228,965,053
1,0240.251,483,768,958.79160,258.20100.000148,854,284,738
2,0480.501,483,768,958.7910,316.60100.000148,839,243,960
3,0720.751,483,768,958.7910,316.60100.000148,839,243,960
4,0961.001,483,768,958.795,737.74100.000148,838,784,651
4,9151.201,483,768,958.795,598.17100.000148,838,770,650
5,7341.401,483,768,958.795,598.17100.000148,838,770,650
6,5541.601,483,768,958.795,598.17100.000148,838,770,650
7,3731.801,483,768,958.795,598.17100.000148,838,770,650
8,1922.001,483,768,958.795,598.17100.000148,838,770,650
12,2883.001,483,768,958.795,598.17100.000148,838,770,650
16,3844.001,483,768,958.795,598.17100.000148,838,770,650
24,5766.001,483,768,958.795,598.17100.000148,838,770,650
32,7688.001,483,768,958.795,598.17100.000148,838,770,650

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)
1,9840.676016,93314,750,6160.931,269,55916.54564,763
2,3040.7838028,95515,310,9750.96709,2009.24625,842
2,3680.8044431,45315,403,7860.97616,3898.03632,779
2,4320.8350833,67115,495,6330.97524,5426.83639,495
2,4960.8557136,20415,587,4750.98432,7005.64646,184
2,5600.8763338,56815,679,3670.98340,8084.44652,897
2,6240.8969741,13815,768,0480.99252,1273.28659,296
2,6880.9176143,74415,856,7850.99163,3902.13665,699
2,7520.9382446,39915,878,3991.00141,7761.85671,429
2,8160.9688848,98715,899,8861.00120,2891.57677,120
2,8800.9895251,69115,921,3561.0098,8191.29682,801
2,9441.001,01654,58215,943,4101.0076,7651.00688,671
3,0081.021,08057,50515,943,9851.0076,1900.99688,881
3,0721.041,14460,51715,944,0361.0076,1390.99688,903
3,1361.071,20863,18315,944,0921.0076,0830.99688,924
3,2001.091,27265,75415,944,1411.0076,0340.99688,943
3,2641.111,33668,53415,944,1931.0075,9820.99688,962
3,3281.131,40071,60215,944,2391.0075,9360.99688,981
3,3921.151,46474,60815,944,2841.0075,8910.99688,999
3,4561.171,52877,61515,944,3281.0075,8470.99689,016
3,5201.201,59280,60215,944,3691.0075,8060.99689,034
3,5841.221,65683,52215,944,4181.0075,7570.99689,052
3,9041.331,97598,13415,944,6181.0075,5570.98689,129
4,2241.432,295113,52915,944,8031.0075,3720.98689,198
4,5441.542,615127,88915,944,9541.0075,2210.98689,259
4,8641.652,934143,50415,945,0881.0075,0870.98689,312
5,1841.763,253159,09015,945,2111.0074,9640.98689,356
5,5041.873,573173,75115,945,3041.0074,8710.98689,390
5,8241.983,893186,57115,945,3541.0074,8210.97689,411
6,1442.094,213198,63615,945,3961.0074,7790.97689,426

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
12,8000.6316,531,898237,754,875
15,3600.7516,032,62844,414,723
17,9200.8816,010,22824,945,646
20,4801.0016,002,22118,996,075
23,0401.1315,997,42915,346,929
25,6001.2515,992,63311,619,899
28,1601.3815,989,4348,001,147
30,7201.5015,986,2386,620,132
33,2801.6315,986,2436,620,132
35,8401.7515,986,2476,620,132
38,4001.8815,986,2506,620,132
40,9602.0015,986,2536,620,132

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)
641.000000
1282.000000
1923.000000
2564.000000
3205.000000
3846.000000
4487.000000
5128.000000
5769.000000
64010.000000
70411.000000
76812.000000
83213.000000
89614.000000
96015.000000
1,02416.000000
1,08817.000000
1,15218.000000
1,21619.000000
1,28020.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)
data block65700
segment header3,32900
undo block3201
undo header6200
2nd level bmb200

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 13130115455.36
HW-Segment High Water Mark 3,3883,38801609.44
CF-Controlfile Transaction 2,3632,36301014.00
TX-Transaction (index contention) 330205.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
27.6628,50888146000/60000/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
19-Nov 08:543,0377,66114846,0000/00/0/0/0/0/0
19-Nov 08:442,0857,64887446,0000/00/0/0/0/0/0
19-Nov 08:341,6123,92314046,0000/00/0/0/0/0/0
19-Nov 08:242143,15987726,0000/00/0/0/0/0/0
19-Nov 08:141973,22427736,0000/00/0/0/0/0/0
19-Nov 08:045122,89388136,0000/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,3890.00 00 
ASM map operation hash table10.00 00 
ASM network state latch7240.00 00 
AWR Alerted Metric Element list37,5830.00 00 
Change Notification Hash table latch1,2100.00 00 
Consistent RBA28,1280.00 00 
DML lock allocation107,6680.000.0000 
Event Group Locks8,8200.00 00 
FAL Queue1710.00 00 
FIB s.o chain latch600.00 00 
FOB s.o list latch3,8650.280.0000 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch10.00 00 
JS Sh mem access70.00 00 
JS mem alloc latch280.00 00 
JS queue access latch290.00 00 
JS queue state obj latch21,6900.00 00 
JS slv state obj latch2390.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 latch1,2020.00 00 
KTF sga latch190.00 01,1910.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch20.00 00 
KWQS pqueue ctx latch870.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0720.00
Memory Management Latch10.00 01,2020.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 Latch400.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process18,2680.00 00 
OS process allocation16,5411.280.0000 
OS process: request allocation8,7531.690.0000 
PL/SQL warning settings4,6520.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch32,5800.00 00 
Result Cache: RC Latch33,9380.010.0000 
SGA IO buffer pool latch200.00 0210.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1210.00 01,1940.00
SQL memory manager workarea list latch603,1450.000.0000 
Shared B-Tree3720.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$KSFQP1,4970.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch54,6820.000.0000 
active service list32,6940.430.0702,5150.00
alert log latch20.00 00 
archive control630.00 00 
archive process latch5111.571.0000 
begin backup scn array9940.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles2660.00 00 
cache buffers chains4,772,184,2241.120.00330,2010.03
cache buffers lru chain80,0670.000.500121,1920.11
cache table scan latch10.00 010.00
call allocation17,9871.710.1400 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch8,7681.230.0000 
channel operations parent latch30,2800.250.0000 
checkpoint queue latch3,225,7790.00 071,4720.00
client/application info30,0580.00 00 
compile environment latch4,4410.00 00 
corrupted undo seg latch6150.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch7240.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch7240.00 00 
dml lock allocation7300.00 00 
done queue latch10.00 00 
dummy allocation8,8880.270.0000 
enqueue freelist latch10.00 0133,6810.00
enqueue hash chains312,9610.030.0000 
fifth spare latch10.00 00 
file cache latch9950.00 00 
flashback FBA barrier20.00 00 
flashback SCN barrier40.00 00 
flashback allocation65,6810.000.0000 
flashback copy10.00 060,7390.01
flashback hint SCN barrier20.00 00 
flashback mapping2,1560.00 00 
flashback marker cache20.00 00 
flashback prepare log info700.00 00 
flashback sync request2,0250.00 00 
fourth Audit Vault latch10.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 SGA4,2240.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch1880.00 0136,9030.01
hash table dml freq tracking latch40.00 00 
hash table modification latch8790.00 00 
heartbeat check10.00 00 
hint flashback FBA barrier20.00 00 
internal temp table object number allocation latch30.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch680.00 0671.49
job_queue_processes free list latch1380.00 00 
job_queue_processes parameter latch8470.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch4460.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock690.00 00 
ksuosstats global area3640.00 00 
ksv allocation latch8580.00 00 
ksv class latch1330.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch8,7532.490.0000 
ktm global data680.00 00 
kwqbsn:qsga1310.00 00 
lgwr LWN SCN28,2960.00 00 
list of block allocation15,3630.090.0000 
loader state object freelist19,2680.050.0000 
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 parent10.00 00 
managed standby latch1691.180.0000 
mapped buffers lru chain10.00 00 
message pool operations parent latch10.00 00 
messages240,1430.050.0000 
mostly latch-free SCN28,4220.260.0000 
msg queue latch10.00 00 
multiblock read objects40.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch7240.00 00 
object queue header heap8990.00 02020.00
object queue header operation237,4840.00 00 
object stats modification2,0770.00 00 
parallel query alloc buffer9610.00 00 
parallel query stats10.00 00 
parameter list2980.00 00 
parameter table management18,0070.130.0900 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue43,2090.040.00030,2430.03
process allocation8,9052.190.0004,2872.08
process group creation8,7530.050.0000 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5250.00 00 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation94,9110.070.010452,2300.23
redo copy1290.00 0452,7030.28
redo writing143,1960.000.0000 
resmgr group change latch4,3560.00 00 
resmgr:active threads8,8880.00 00 
resmgr:actses change group4,3260.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list8,8870.570.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config1110.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects6,743,2140.430.0003430.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache14,2350.010.0000 
session allocation638,8050.000.000629,9840.01
session idle bit6,995,5640.000.0000 
session queue latch10.00 00 
session state list latch9,0430.380.0000 
session switching5,1022.430.0000 
session timer1,6090.00 00 
shared pool1,136,0390.120.0000 
shared pool sim alloc420.00 00 
shared pool simulator53,8310.010.0000 
sim partition latch20.00 02170.00
simulator hash latch147,106,6050.000.0000 
simulator lru latch29,9320.100.000147,076,5811.55
sort extent pool8260.00 00 
space background state object latch100.00 00 
space background task latch5,3130.830.0002,4100.00
state object free list120.00 00 
statistics aggregation3360.00 00 
tablespace key chain20,4320.080.0000 
temp lob duration state obj allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch6350.00 00 
transaction allocation12,2470.010.0000 
transaction branch allocation1,6090.00 00 
undo global data140,6590.180.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains4,772,184,22453,330,2098,11953,333,135
row cache objects6,743,21428,975128,974
simulator hash latch147,106,6053,655103,646
shared pool1,136,0391,39861,392
call allocation17,98730843265
active service list32,69414110131
redo allocation94,91169168
parameter table management18,00723221
archive process latch511880
cache buffers lru chain80,067211

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
active service listkswslogon: session logout04040
archive process latchkcrrgpll066
archive process latchkcrrasgn021
cache buffers chainskcbgtcr: fast path (cr pin)013,956425
cache buffers chainskcbgtcr: kslbegin excl04,46712,542
cache buffers chainskcbgcur_201,105790
cache buffers chainskcbrls: fast release0310366
cache buffers chainskcbchg1: mod cr pin0274200
cache buffers chainskcbrls_202315,601
cache buffers chainskcbgtcr: fast path0399
cache buffers chainskcbgtcr_207120
cache buffers chainskcbzwb057
cache buffers chainskcbzar_fpin_104270
cache buffers chainskcbgcur: fast path (shr)010
cache buffers lru chainkcbzgws010
call allocationksuxds04343
parameter table managementkspcpy020
redo allocationkcrfw_redo_gen: redo allocation 1010
row cache objectskqrpre: find obj011
shared poolkghalo063
simulator hash latchkcbsacc: lookup dba01010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglget1 12,6130
Library Cachekglhdgn2 1065080
Library Cachekglhdgn1 623740
Library Cachekgllkdl1 852950
Library Cachekglpndl1 951020
Library Cachekgllkc1 57880
Library Cachekglpin1 4490
Library Cachekglpnal1 90350
Cursor Pinkksfbc [KKSCHLPIN1]160
Library Cachekglget2 290
Library Cachekglobpn1 7190
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]80
Library Cachekgldtin1 4250
Library Cachekglhdgh1 6430
Library Cachekglllal3 11120
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]10

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
NCSSNCSSJOBSITE00STU_SEARCHJOBSITE00TABLE PARTITION2,145,895,02489.86
STPSUSERSTPS2TEACHER_INFO TABLE35,438,1441.48
NCSSNCSS_INDEXSTU_SEARCHJOB_PK INDEX18,438,3840.77
NCSSNCSSJOBSITE0000STU_SEARCHJOBSITE2101TABLE PARTITION17,049,4880.71
NCSSNCSSSTU_BASICINFO TABLE5,766,4480.24

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
NCSSNCSSSYS_LOB0000306074C00031$$ LOB8,15832.17
NCSSNCSSSYS_LOB0000155267C00011$$ LOB2,86211.29
NCSSNCSSSYS_LOB0000307469C00011$$ LOB2,3659.33
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_166537304_6587TABLE PARTITION3811.50
SYSSYSTEMAUD$ TABLE2100.83

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
NCSSNCSSSYS_LOB0000306074C00031$$ LOB8,13932.54
NCSSNCSSSYS_LOB0000155267C00011$$ LOB2,84011.35
NCSSNCSSSYS_LOB0000307469C00011$$ LOB2,3589.43
SYSSYSTEMAUD$ TABLE2100.84
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_166537304_6587TABLE PARTITION1930.77

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
NCSSNCSSSYS_LOB0000306074C00031$$ LOB8,13932.54
NCSSNCSSSYS_LOB0000155267C00011$$ LOB2,84011.35
NCSSNCSSSYS_LOB0000307469C00011$$ LOB2,3589.43
SYSSYSTEMAUD$ TABLE2100.84
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_166537304_6587TABLE PARTITION1930.77

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

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Reads%Total
NCSSNCSSSYS_LOB0000306074C00031$$ LOB8,15755.44
NCSSNCSSSYS_LOB0000155267C00011$$ LOB2,86219.45
NCSSNCSSSYS_LOB0000307469C00011$$ LOB2,36516.07
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_166537304_6587TABLE PARTITION2051.39

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
NCSSNCSS_INDEXSTU_SEARCHJOB_PK INDEX7,74710.81
NCSSNCSSJOB_SITE TABLE1,2611.76
NCSSNCSSJOBSITE00STU_SEARCHJOBSITE00TABLE PARTITION8611.20
NCSSNCSSSYS_LOB0000155267C00011$$ LOB7951.11
NCSSNCSSJOBSITE00017STU_SEARCHJOBSITEOTHERTABLE PARTITION4610.64

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
NCSSNCSS_INDEXSTU_SEARCHJOB_PK INDEX6,12712.04
NCSSNCSSJOB_SITE TABLE1,1082.18
NCSSNCSSJOBSITE00STU_SEARCHJOBSITE00TABLE PARTITION8391.65
NCSSNCSSSYS_LOB0000155267C00011$$ LOB7591.49
NCSSNCSSJOBSITE00017STU_SEARCHJOBSITEOTHERTABLE PARTITION4110.81

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
NCSSNCSSSYS_LOB0000155267C00011$$ LOB72859.04
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_166537304_6587TABLE PARTITION20516.63
NCSSNCSSSYS_LOB0000306074C00031$$ LOB13711.11
NCSSNCSSSYS_LOB0000307469C00011$$ LOB1169.41

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSSYSTEMAUD$ TABLE68,51237.55
NCSSNCSS_INDEXSTU_SEARCHJOB_PK INDEX33,66418.45
NCSSNCSSJOB_SITE TABLE22,36812.26
NCSSNCSSJOBSITE00STU_SEARCHJOBSITE00TABLE PARTITION19,87210.89
NCSSNCSS_INDEXJOB_SITE_PK INDEX13,6487.48

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
NCSSNCSSONLINE_USER TABLE640.00
NCSSNCSSJOB_SITE TABLE320.00
NCSSNCSS_INDEXJOB_SITE_PK INDEX213.33
NCSSNCSS_INDEXSTU_SEARCHJOB_PK INDEX213.33
NCSSNCSSONLINE_USER_TEST TABLE16.67

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
NCSSNCSSJOBSITE00STU_SEARCHJOBSITE00TABLE PARTITION3,32183.38
SYSSYSTEMAUD$ TABLE58314.64
NCSSNCSSJOBSITE00002STU_SEARCHJOBSITE10710TABLE PARTITION140.35
NCSSNCSSJOBSITE00001STU_SEARCHJOBSITE10394TABLE PARTITION120.30
NCSSNCSSJOBSITE0000STU_SEARCHJOBSITE5001TABLE PARTITION110.28

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control830.000 21
dc_files470.000 047
dc_global_oids5010.200 024
dc_histogram_data2,292,8340.530 0117,601
dc_histogram_defs749,8500.950 948,376
dc_objects434,0990.050 86,077
dc_profiles4,2930.000 01
dc_rollback_segments4,1020.000 093
dc_segments72,6580.150 22541
dc_sequences60.000 62
dc_tablespaces8,9040.010 052
dc_users227,7790.000 0163
global database name6,7300.000 01
outstanding_alerts2640.000 044
sch_lj_oids40.000 07


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS8,4480.000 00
BODY1,5330.138,8440.0520
CLUSTER20.0020.0000
DBLINK8,4500.000 00
EDITION4,3190.008,6100.0000
INDEX10,1550.0710,1550.0700
OBJECT ID1100.000 00
QUEUE610.002400.0000
SCHEMA4,3180.000 00
SQL AREA74,81115.85863,6434.144581
SQL AREA BUILD12,35399.060 00
SQL AREA STATS12,33597.9312,33597.9300
SUBSCRIPTION70.0070.0000
TABLE/PROCEDURE20,3030.0472,5790.271270
TRIGGER3040.334260.7010


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 cache9,024.009,024.009,024.0014,144.000SHR/DEF
KEEP buffer cache8,192.008,192.001,024.008,192.000GRO/MAN
PGA Target4,096.004,096.004,096.0012,288.000SHR/DEF
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target20,480.0020,480.0012,288.0020,480.000GRO/MAN
Shared IO Pool0.000.000.000.000STA/
java pool64.0064.0064.0064.000STA/
large pool64.0064.0064.0064.000STA/
shared pool2,944.002,944.001,600.002,944.000GRO/DEF
streams pool64.0064.0064.0064.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther691.40 2.657.614242261261
Freeable147.130.001.412.0211 104104
SQL96.7594.610.412.071631235229
PL/SQL3.252.660.010.0201261261
EOther708.62 2.737.614242260260
Freeable176.190.001.522.5216 116116
SQL126.16123.430.542.321631235230
PL/SQL4.563.910.020.0300260260

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers18,052,284,416 
Fixed Size2,230,912 
Redo Buffers36,106,240 
Variable Size3,288,335,744 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory64.0064.000.00
largeCTWR dba buffer1.391.390.00
largePX msg pool7.817.810.00
largefree memory52.8252.820.00
largekrcc extent chunk1.981.980.00
sharedASH buffers64.0064.000.00
sharedKGLH0497.41488.71-1.75
sharedKGLHD97.3795.85-1.55
sharedKQR L SO35.2036.975.02
sharedKQR M SO36.8339.005.88
sharedKTC latch subh32.2332.230.00
sharedSQLA745.66774.023.80
shareddb_block_hash_buckets89.0089.000.00
sharedflashback generation buff60.8060.800.00
sharedfree memory825.41804.48-2.54
sharedobject queue31.1131.110.00
streamsfree memory64.0064.000.00
 buffer_cache17,216.0017,216.000.00
 fixed_sga2.132.130.00
 log_buffer34.4334.430.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0909 14:05:200.020.000.00
QMON Coordinator0909 14:05:100.010.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(12733) 00  0.000.00  
SYS.AQ$_ALERT_QT_E(12732) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 75750.000.000.040.130.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(12733) 0.000.00  
SYS.AQ$_ALERT_QT_E(12732) 0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 0.020.020.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
DBSERVER1_3938_O10G(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
000000

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

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/oracle/app/oracle/admin/o10g/adump  
audit_trailDB  
compatible11.2.0.0.0  
control_files/data/oradata/o10g/control01.ctl, /oracle/oradata/o10g/control02.ctl, /data_duplex/oradata/o10g/control03.ctl  
cursor_sharingEXACT  
db_block_checkingFULL  
db_block_checksumFULL  
db_block_size8192  
db_domain    
db_flashback_retention_target2880  
db_keep_cache_size8589934592  
db_nameo10g  
db_recovery_file_dest/data/flash_recovery_area  
db_recovery_file_dest_size42949672960  
diagnostic_dest/oracle/app/oracle  
dispatchers    
fast_start_mttr_target900  
java_pool_size67108864  
job_queue_processes50  
large_pool_size67108864  
log_archive_dest_1location=/archivelog/o10g  
log_archive_dest_2location=/archivelog_duplex/o10g/  
log_archive_max_processes10  
log_archive_min_succeed_dest2  
log_buffer10485760  
log_checkpoint_timeout0  
log_checkpoints_to_alertTRUE  
memory_max_target25769803776  
memory_target25769803776  
open_cursors300  
optimizer_modeALL_ROWS  
pga_aggregate_target2147483648  
processes800  
remote_login_passwordfileEXCLUSIVE  
resource_limitTRUE  
result_cache_max_size209715200  
result_cache_modeMANUAL  
sec_case_sensitive_logonFALSE  
sessions1248  
sga_max_size21474836480  
sga_target21474836480  
shared_servers0  
sort_area_retained_size65536  
statistics_levelTYPICAL  
undo_retention360000  
undo_tablespaceUNDOTBS1  
utl_file_dir/data/logmnrlog  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/data/oradata/o10g/control01.ctl  
/data_duplex/oradata/o10g/control03.ctl  
/oracle/oradata/o10g/control02.ctl  

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report