WORKLOAD REPOSITORY PDB report (root snapshots)

DB NameDB IdUnique NameRoleEditionReleaseRACCDB
CDRDB3758444401cdrdbPRIMARYEE19.0.0.0.0NOYES

InstanceInst NumStartup Time
cdrdb131-Jan-21 15:29

Container DB IdContainer NameOpen Time
4100670825PCDRDB03-Feb-21 16:01

Host NamePlatformCPUsCoresSocketsMemory (GB)
mtccdrdb01.mtcdc.com.naLinux x86 64-bit 56 28 2 565.66

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:36215-Feb-21 17:00:093 3.0
End Snap:36515-Feb-21 20:00:140 3.0
Elapsed:  180.08 (mins)  
DB Time:  91.41 (mins)  

Report Summary

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.5 0.0 0.01 0.01
DB CPU(s): 0.5 0.0 0.01 0.00
Background CPU(s): 0.0 0.0 0.00 0.00
Redo size (bytes): 9,687,760.8 401,395.2  
Logical read (blocks): 93,791.4 3,886.1  
Block changes: 43,315.6 1,794.7  
Physical read (blocks): 0.1 0.0  
Physical write (blocks): 0.0 0.0  
Read IO requests: 0.1 0.0  
Write IO requests: 0.0 0.0  
Read IO (MB): 0.0 0.0  
Write IO (MB): 0.0 0.0  
IM scan rows: 0.0 0.0  
Session Logical Read IM: 0.0 0.0  
User calls: 100.8 4.2  
Parses (SQL): 39.8 1.7  
Hard parses (SQL): 0.0 0.0  
SQL Work Area (MB): 4.8 0.2  
Logons: 4.8 0.2  
User logons: 1.6 0.1  
Executes (SQL): 57.6 2.4  
Rollbacks: 0.0 0.0  
Transactions: 24.1   

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Avg Wait% DB timeWait Class
DB CPU 5235.3 95.5 
log file sync250,757308.51.23ms5.6Commit
control file sequential read120,43581.2674.20us1.5System I/O
SQL*Net more data from client2,015,34510.55.22us.2Network
PX Deq: Join ACK34,4109.1265.04us.2Other
PX Deq: Slave Session Stats68,4774.972.03us.1Other
PGA memory operation919,9694.44.78us.1Other
Disk file operations I/O57,1713.663.55us.1User I/O
enq: PS - contention17,3101.267.94us.0Other
db file sequential read767.5656.58us.0User I/O

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait Time% DB timeAvg Active Sessions
DB CPU 5,235 95.50.5
Commit250,7573081.23ms5.60.0
System I/O122,12782668.68us1.50.0
Other1,142,1542925.22us.50.0
Network2,806,427113.92us.20.0
User I/O58,694470.54us.10.0
Configuration48112.35ms.00.0
Concurrency5210256.42us.00.0
Application310531.84us.00.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 11.2 11.2 0.0
Database Requests: 0.1 0.1 0.0
Optimized Requests: 0.0 0.0 0.0
Redo Requests:   
Total (MB): 0.2 0.2 0.0
Database (MB): 0.0 0.0 0.0
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB):   
Database (blocks): 0.1 0.1 0.0
Via Buffer Cache (blocks): 0.1 0.1 0.0
Direct (blocks): 0.0 0.0 0.0

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time% of Total CPU Time
DB CPU5,235.2695.46100.00
sql execute elapsed time4,658.1284.93 
connection management call elapsed time173.183.16 
parse time elapsed20.010.36 
DB time5,484.40  
background elapsed time0.08  
background cpu time0.08 0.00
total CPU time5,235.34  


Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait%DB time
DB CPU  5,235 95.46
Commit250,75703081.23ms5.62
System I/O120,435081674.20us1.48
Other1,106,20102018.33us0.37
Network2,772,0170113.96us0.20
User I/O57,9380471.40us0.08
Configuration4281114.11ms0.01
Concurrency48200273.89us0.00
Application3100531.84us0.00


Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg waitWaits /txn% DB time
log file sync250,757 3081.23ms0.965.62
control file sequential read120,435 81674.20us0.461.48
SQL*Net more data from client2,015,345 115.22us7.730.19
PX Deq: Join ACK34,410 9265.04us0.130.17
PX Deq: Slave Session Stats68,477 572.03us0.260.09
PGA memory operation919,969 44.78us3.530.08
Disk file operations I/O57,171 463.55us0.220.07
enq: PS - contention17,310 167.94us0.070.02
db file sequential read767 1656.58us0.000.01
undo segment extension34100010.40ms0.000.01
SQL*Net message to client745,202 0449.22ns2.860.01
PX Deq: Signal ACK EXT34,410 09.43us0.130.01
latch free12,419 022.76us0.050.01
log file switch (private strand flush incomplete)3 065.80ms0.000.00
SQL*Net more data to client11,470 09.35us0.040.00
library cache: mutex X36 01.89ms0.000.00
library cache lock38 01.15ms0.000.00
enq: HW - contention5 08.29ms0.000.00
PX Deq Credit: free buffer17,204 01.49us0.070.00
enq: RC - Result Cache: Contention31 0531.84us0.000.00
enq: DA - Slave Process Array4 02.79ms0.000.00
latch: call allocation922 010.12us0.000.00
buffer busy waits294 031.20us0.000.00
latch: cache buffers chains50 088.62us0.000.00
library cache load lock27 0162.85us0.000.00
PX qref latch97010003.50us0.000.00
transaction65 035.46us0.000.00
cursor: mutex S1 01.06ms0.000.00
SQL*Net message from client745,209 22,38130.03ms2.86 
PX Deq: Execution Msg137,623 3502.55ms0.53 
PX Deq: Parse Reply34,409 22651.48us0.13 
PX Deq: Execute Reply172,050 21120.63us0.66 
PX Deq: Table Q Normal34,377 249.34us0.13 
PX Deq: Msg Fragment34,388 01.05us0.13 
PX Deq Credit: send blkd373 015.36us0.00 


Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
pcdrdb5,4845,23511,013,378


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
pcdrdb 579384482000277203111


Back to Wait Events Statistics
Back to Top

Top Process Types by Wait Class

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Top Process Types by CPU Used

No data exists for this section of the report.

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 ModulePDB NameSQL Text
2,828.21173,0700.0251.5796.860.0285zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
1,114.8961,3720.0220.3397.160.010f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
276.1026,3260.015.0394.250.0132vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...
259.1317,2050.024.7297.540.00fd4b9db6ju2ck SQL Loader Conventional Path Load PCDRDB SELECT C.COLUMN_NAME FROM SYS....
93.4317,2050.011.7030.583.751abbtfgtkqj15 sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PCDRDB SELECT RESULTS FROM SYS.LOADER...
26.6551,8310.000.4983.490.005dqz0hqtp9fru   PCDRDB select /*+ connect_by_filterin...
14.4617,1980.000.2672.200.00cf960s7s4nvb5 SQL Loader Conventional Path Load PCDRDB SELECT /*+ NO_STATEMENT_QUEUIN...
14.0617,2050.000.2698.680.00bd13sdj0ty0q4 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.ALL_OBJECT...
10.5217,1990.000.1963.550.0005uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
9.9317,1710.000.18101.990.009zg9qd9bm4spu Toad.exe PCDRDB update user$ set spare6=DECODE...


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 ModulePDB NameSQL Text
2,739.39173,0700.0252.332,828.2196.860.0285zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
1,083.2561,3720.0220.691,114.8997.160.010f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
260.2226,3260.014.97276.1094.250.0132vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...
252.7517,2050.014.83259.1397.540.00fd4b9db6ju2ck SQL Loader Conventional Path Load PCDRDB SELECT C.COLUMN_NAME FROM SYS....
28.5717,2050.000.5593.4330.583.751abbtfgtkqj15 sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PCDRDB SELECT RESULTS FROM SYS.LOADER...
22.2551,8310.000.4326.6583.490.005dqz0hqtp9fru   PCDRDB select /*+ connect_by_filterin...
13.8817,2050.000.2714.0698.680.00bd13sdj0ty0q4 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.ALL_OBJECT...
10.4417,1980.000.2014.4672.200.00cf960s7s4nvb5 SQL Loader Conventional Path Load PCDRDB SELECT /*+ NO_STATEMENT_QUEUIN...
10.1317,1710.000.199.93101.990.009zg9qd9bm4spu Toad.exe PCDRDB update user$ set spare6=DECODE...
8.1317,2020.000.168.1999.230.006an16x3f6ducn SQL Loader Conventional Path Load PCDRDB select count(*) from sys.all_t...


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 ModulePDB NameSQL Text
3.5017,2050.0084.5793.4330.583.751abbtfgtkqj15 sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PCDRDB SELECT RESULTS FROM SYS.LOADER...
0.51173,0700.0012.302,828.2196.860.0285zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
0.1061,3720.002.521,114.8997.160.010f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
0.0226,3260.000.52276.1094.250.0132vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...
0.0017,1710.000.019.93101.990.009zg9qd9bm4spu Toad.exe PCDRDB update user$ set spare6=DECODE...
0.0017,1990.000.0010.5263.550.0005uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
0.0020.000.000.02100.330.000nakmm882vmq0   PCDRDB select /* QOSH:DROP_STAT_HIST_...
0.00390.000.000.0097.760.002ajc7pwz9jsx3   PCDRDB select max(scn) from smon_scn_...
0.005090.000.000.0296.280.002p9fv35c7zxtg   PCDRDB select /* KSXM:LOAD_DML_INF */...
0.002130.000.000.03103.520.003dbzmtf9ahvzt   PCDRDB merge /* KSXM:OPTIM_DML_INF */...


Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModulePDB NameSQL Text
599,929,227173,0703,466.4059.202,828.2196.9085zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
333,634,88861,3725,436.2732.921,114.8997.200f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
67,123,53926,3262,549.716.62276.1094.2032vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...
6,052,01017,205351.760.60259.1397.50fd4b9db6ju2ck SQL Loader Conventional Path Load PCDRDB SELECT C.COLUMN_NAME FROM SYS....
2,253,85517,205131.000.228.8173.107ac05552jb0v9 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.LOADER_PAR...
1,293,39251,83124.950.1326.6583.505dqz0hqtp9fru   PCDRDB select /*+ connect_by_filterin...
1,060,97517,20261.680.108.1999.206an16x3f6ducn SQL Loader Conventional Path Load PCDRDB select count(*) from sys.all_t...
1,015,09517,20559.000.108.4080.708uc59s4afypr0 SQL Loader Conventional Path Load PCDRDB SELECT COLUMN_NAME FROM SYS.LO...
1,010,07517,19858.730.1014.4672.20cf960s7s4nvb5 SQL Loader Conventional Path Load PCDRDB SELECT /*+ NO_STATEMENT_QUEUIN...
286,75017,20316.670.032.6595.106csvyhgf6b0s5 SQL Loader Conventional Path Load PCDRDB SELECT COLNAME FROM SYS.LOADER...


Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModulePDB NameSQL Text
665173,0700.0086.702,828.2196.860.0285zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
10261,3720.0013.301,114.8997.160.010f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
017,1990.000.0010.5263.550.0005uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
020.000.000.02100.330.000nakmm882vmq0   PCDRDB select /* QOSH:DROP_STAT_HIST_...
017,2050.000.0093.4330.583.751abbtfgtkqj15 sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PCDRDB SELECT RESULTS FROM SYS.LOADER...
0390.000.000.0097.760.002ajc7pwz9jsx3   PCDRDB select max(scn) from smon_scn_...
05090.000.000.0296.280.002p9fv35c7zxtg   PCDRDB select /* KSXM:LOAD_DML_INF */...
026,3260.000.00276.1094.250.0132vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...
02130.000.000.03103.520.003dbzmtf9ahvzt   PCDRDB merge /* KSXM:OPTIM_DML_INF */...
051,8310.000.0026.6583.490.005dqz0hqtp9fru   PCDRDB select /*+ connect_by_filterin...


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 ModulePDB NameSQL Text
120,435120,43517,2057.000.0015702.091abbtfgtkqj15 sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PCDRDB SELECT RESULTS FROM SYS.LOADER...
0017,1990.00 0.0005uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
0061,3720.00 0.000f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
0020.00 0.000nakmm882vmq0   PCDRDB select /* QOSH:DROP_STAT_HIST_...
00390.00 0.002ajc7pwz9jsx3   PCDRDB select max(scn) from smon_scn_...
005090.00 0.002p9fv35c7zxtg   PCDRDB select /* KSXM:LOAD_DML_INF */...
0026,3260.00 0.0032vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...
002130.00 0.003dbzmtf9ahvzt   PCDRDB merge /* KSXM:OPTIM_DML_INF */...
0051,8310.00 0.005dqz0hqtp9fru   PCDRDB select /*+ connect_by_filterin...
0017,2020.00 0.006an16x3f6ducn SQL Loader Conventional Path Load PCDRDB select count(*) from sys.all_t...


Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModulePDB NameSQL Text
173,07025,200,894145.612,828.2196.9085zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
61,37235,127,229572.371,114.8997.200f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
51,831774,49114.9426.6583.505dqz0hqtp9fru   PCDRDB select /*+ connect_by_filterin...
30,78131,1531.011.0710009xhc0db70kgyq PL/SQL Developer PCDRDB select '''' || SYS_CONTEXT('US...
26,3268,877,301337.21276.1094.2032vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...
17,20517,2051.0093.4330.63.71abbtfgtkqj15 sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PCDRDB SELECT RESULTS FROM SYS.LOADER...
17,20500.008.8173.107ac05552jb0v9 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.LOADER_PAR...
17,20500.008.4080.708uc59s4afypr0 SQL Loader Conventional Path Load PCDRDB SELECT COLUMN_NAME FROM SYS.LO...
17,20517,2051.0014.0698.70bd13sdj0ty0q4 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.ALL_OBJECT...
17,20500.002.721000d9q2q82g1tuzx   PCDRDB select decode(upper(failover_m...
17,20517,2051.005.5699.90f0h5rpzmhju11   PCDRDB select SYS_CONTEXT('USERENV', ...
17,20500.00259.1397.50fd4b9db6ju2ck SQL Loader Conventional Path Load PCDRDB SELECT C.COLUMN_NAME FROM SYS....
17,20300.002.6595.106csvyhgf6b0s5 SQL Loader Conventional Path Load PCDRDB SELECT COLNAME FROM SYS.LOADER...
17,20217,2051.008.1999.206an16x3f6ducn SQL Loader Conventional Path Load PCDRDB select count(*) from sys.all_t...
17,19951,6143.0010.5263.5005uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
17,19863,0853.6714.4672.20cf960s7s4nvb5 SQL Loader Conventional Path Load PCDRDB SELECT /*+ NO_STATEMENT_QUEUIN...
17,17117,1711.001.2999.90865qwpcdyggkk   PCDRDB select spare6 from user$ where...
17,17117,1711.009.9310209zg9qd9bm4spu Toad.exe PCDRDB update user$ set spare6=DECODE...


Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModulePDB NameSQL Text
51,83451,83112.045dqz0hqtp9fru   PCDRDB select /*+ connect_by_filterin...
51,08717,20511.87fd4b9db6ju2ck SQL Loader Conventional Path Load PCDRDB SELECT C.COLUMN_NAME FROM SYS....
34,13230,7817.939xhc0db70kgyq PL/SQL Developer PCDRDB select '''' || SYS_CONTEXT('US...
17,20517,1994.0005uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
17,20517,2054.001abbtfgtkqj15 sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PCDRDB SELECT RESULTS FROM SYS.LOADER...
17,20517,2024.006an16x3f6ducn SQL Loader Conventional Path Load PCDRDB select count(*) from sys.all_t...
17,20517,2034.006csvyhgf6b0s5 SQL Loader Conventional Path Load PCDRDB SELECT COLNAME FROM SYS.LOADER...
17,20517,2054.007ac05552jb0v9 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.LOADER_PAR...
17,20517,2054.008uc59s4afypr0 SQL Loader Conventional Path Load PCDRDB SELECT COLUMN_NAME FROM SYS.LO...
17,20517,2054.00bd13sdj0ty0q4 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.ALL_OBJECT...
17,20517,2054.00d9q2q82g1tuzx   PCDRDB select decode(upper(failover_m...
17,20517,2054.00f0h5rpzmhju11   PCDRDB select SYS_CONTEXT('USERENV', ...
17,20417,1984.00cf960s7s4nvb5 SQL Loader Conventional Path Load PCDRDB SELECT /*+ NO_STATEMENT_QUEUIN...
17,17117,1713.99865qwpcdyggkk   PCDRDB select spare6 from user$ where...
17,17117,1713.999zg9qd9bm4spu Toad.exe PCDRDB update user$ set spare6=DECODE...
5,735173,0701.3385zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
5,73461,3721.330f0zjv1c0rq3q SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_COC...
5,73426,3261.3332vhwk4a4fh6z SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_SER...


Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModulePDB NameSQL Text
59,333,32817,2050.38fd4b9db6ju2ck SQL Loader Conventional Path Load PCDRDB SELECT C.COLUMN_NAME FROM SYS....
17,684,63517,2050.11bd13sdj0ty0q4 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.ALL_OBJECT...
15,729,15717,2020.106an16x3f6ducn SQL Loader Conventional Path Load PCDRDB select count(*) from sys.all_t...
13,153,15917,2050.098uc59s4afypr0 SQL Loader Conventional Path Load PCDRDB SELECT COLUMN_NAME FROM SYS.LO...
10,510,49230.07f705bwx3q0ydq   PCDRDB select count(*) from dba_autot...
7,833,68117,1980.05cf960s7s4nvb5 SQL Loader Conventional Path Load PCDRDB SELECT /*+ NO_STATEMENT_QUEUIN...
6,646,6282130.043dbzmtf9ahvzt   PCDRDB merge /* KSXM:OPTIM_DML_INF */...
3,849,4645090.022p9fv35c7zxtg   PCDRDB select /* KSXM:LOAD_DML_INF */...
3,073,35117,2050.027ac05552jb0v9 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.LOADER_PAR...
2,629,54817,2030.026csvyhgf6b0s5 SQL Loader Conventional Path Load PCDRDB SELECT COLNAME FROM SYS.LOADER...
1,656,869173,0700.0185zarqwvf599k SQL Loader Conventional Path Load PCDRDB INSERT INTO CDRDBUSER.HD4G_TB ...
1,562,728930.01b9nbhsbx8tqz5   PCDRDB SELECT /*+ OPT_PARAM('_paralle...
1,428,93530.01c8h20n1d0k95m   PCDRDB select /*+ no_parallel */ spar...
1,344,01317,1990.0105uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
1,328,30130.01ajkubg7upg9pu   PCDRDB update /* KSXM:TIME_UPD */ opt...


Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModulePDB NameSQL Text
6893b9nbhsbx8tqz5   PCDRDB SELECT /*+ OPT_PARAM('_paralle...
605092p9fv35c7zxtg   PCDRDB select /* KSXM:LOAD_DML_INF */...
603c8h20n1d0k95m   PCDRDB select /*+ no_parallel */ spar...
572133dbzmtf9ahvzt   PCDRDB merge /* KSXM:OPTIM_DML_INF */...
5117,205fd4b9db6ju2ck SQL Loader Conventional Path Load PCDRDB SELECT C.COLUMN_NAME FROM SYS....
483ajkubg7upg9pu   PCDRDB update /* KSXM:TIME_UPD */ opt...
38392ajc7pwz9jsx3   PCDRDB select max(scn) from smon_scn_...
3317,2058uc59s4afypr0 SQL Loader Conventional Path Load PCDRDB SELECT COLUMN_NAME FROM SYS.LO...
3217,2036csvyhgf6b0s5 SQL Loader Conventional Path Load PCDRDB SELECT COLNAME FROM SYS.LOADER...
3017,2026an16x3f6ducn SQL Loader Conventional Path Load PCDRDB select count(*) from sys.all_t...
3017,2057ac05552jb0v9 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.LOADER_PAR...
3017,205bd13sdj0ty0q4 SQL Loader Conventional Path Load PCDRDB SELECT 'X' FROM SYS.ALL_OBJECT...
2717,19905uqdabhzncdc   PCDRDB select role# from defrole$ d, ...
2617,1719zg9qd9bm4spu Toad.exe PCDRDB update user$ set spare6=DECODE...
2517,198cf960s7s4nvb5 SQL Loader Conventional Path Load PCDRDB SELECT /*+ NO_STATEMENT_QUEUIN...
2317,171865qwpcdyggkk   PCDRDB select spare6 from user$ where...
213f705bwx3q0ydq   PCDRDB select count(*) from dba_autot...


Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
05uqdabhzncdcselect role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
0f0zjv1c0rq3qINSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE, COCC_LOCAL_SEQ_NR, COCC_LINE_NR, COCC_REQ_QOS_INFO, COCC_NEG_QOS_INFO, COCC_UPL, COCC_DOWNL, COCC_CHNG_CONDITION, COCC_CHANGE_DATE, COCC_FAIL_HANDL_CONTIN, COCC_MCC, COCC_MNC, COCC_QCI, COCC_MAXREQ_BANDW_UPL, COCC_MAXREQ_BANDW_DOWNL, COCC_GUAR_BIT_UPL, COCC_GUAR_BIT_DOWNL, COCC_ARP, COCC_APN_AGGR_MAXBIT_UPL, COCC_APN_AGGR_MAXBIT_DOWNL, COCC_MCC2, COCC_MNC2, COCC_TAC, COCC_E_CELL_ID, COCC_GW_ADDRESS) VALUES (CAST(TO_TIMESTAMP(:COCC_DATE, 'rrmmdd hh24miss') AS DATE) , :COCC_LOCAL_SEQ_NR, :COCC_LINE_NR, :COCC_REQ_QOS_INFO, :COCC_NEG_QOS_INFO, :COCC_UPL, :COCC_DOWNL, :COCC_CHNG_CONDITION, CAST(TO_TIMESTAMP(:COCC_CHANGE_DATE, 'rrmmdd hh24miss') AS DATE) , :COCC_FAIL_HANDL_CONTIN, :COCC_MCC, :COCC_MNC, :COCC_QCI, :COCC_MAXREQ_BANDW_UPL, :COCC_MAXREQ_BANDW_DOWNL, :COCC_GUAR_BIT_UPL, :COCC_GUAR_BIT_DOWNL, :COCC_ARP, :COCC_APN_AGGR_MAXBIT_UPL, :COCC_APN_AGGR_MAXBIT_DOWNL, :COCC_MCC2, :COCC_MNC2, :COCC_TAC, :COCC_E_CELL_ID, :COCC_GW_ADDRESS)
0nakmm882vmq0select /* QOSH:DROP_STAT_HIST_PARTS */ partition_name, high_value from (select partition_name, high_value, rownum rn from (select PARTITION_NAME, HIGH_VALUE from dba_tab_partitions where table_name = :1 and table_owner = 'SYS' and partition_name <> 'P_PERMANENT' order by partition_position asc)) v where rn < :2
1abbtfgtkqj15SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE
2ajc7pwz9jsx3select max(scn) from smon_scn_time
2p9fv35c7zxtgselect /* KSXM:LOAD_DML_INF *//*+ leading(o) index(m) use_nl(m) */ nvl(m.inserts, 0) ins, nvl(m.updates, 0) upd, nvl(m.deletes, 0) del, nvl(m.drop_segments, 0) dropseg, nvl(m.flags, 0) flags, nvl(rowcnt, 0) rowcnt, o.pobjn pobjn from (select :objn objn, 0 pobjn, rowcnt from tab$ t where t.obj# = :objn union all select :objn objn, tp.bo# pobjn, rowcnt from tabpart$ tp where tp.obj# = :objn union all select :objn objn, tcp.bo# pobjn, rowcnt from tabcompart$ tcp where tcp.obj# = :objn union all select :objn objn, tsp.pobj# pobjn, rowcnt from tabsubpart$ tsp where tsp.obj# = :objn) o, sys.mon_mods_all$ m where o.objn = m.obj#(+) and rownum < 2
32vhwk4a4fh6zINSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE, SERVD_LOCAL_SEQ_NR, SERVD_LINE_NR, SERVD_RATING_GRP, SERVD_CHARG_RULE, SERVD_RESULT, SERVD_FIRST_USED, SERVD_LAST_USED, SERVD_CHNG_CONDIT, SERVD_NEG_QOS, SERVD_SGSN_ADDR, SERVD_SGSN_PLMNID_MCC, SERVD_SGSN_PLMNID_MNC, SERVD_FBC_UPL, SERVD_FBC_DOWNL, SERVD_REPORT_TIME, SERVD_RATTYPE, SERVD_FAIL_HANDL_CONTIN, SERVD_IDENTIFIER, SERVD_PLMNID_MCC, SERVD_PLMNID_MNC, SERVD_LOCATION, SERVD_CELL_ID, SERVD_TIME_QUOTA_TYPE, SERVD_BASETIME_INTERVAL, SERVD_PS_FREEF_DATA, SERVD_PSFFD_APP_IND, SERVD_NROFEVENTS, SERVD_PLMNID_MCC2, SERVD_PLMNID_MNC2, SERVD_DET_LOC_SEQ_NR, SERVD_USAGE_TIME, SERVD_GW_ADDRESS) VALUES (CAST(TO_TIMESTAMP(:SERVD_ORIG_DATE, 'rrmmdd hh24miss') AS DATE) , :SERVD_LOCAL_SEQ_NR, :SERVD_LINE_NR, :SERVD_RATING_GRP, :SERVD_CHARG_RULE, :SERVD_RESULT, CAST(TO_TIMESTAMP(:SERVD_FIRST_USED, 'rrmmdd hh24miss') AS DATE) , CAST(TO_TIMESTAMP(:SERVD_LAST_USED, 'rrmmdd hh24miss') AS DATE) , :SERVD_CHNG_CONDIT, :SERVD_NEG_QOS, :SERVD_SGSN_ADDR, :SERVD_SGSN_PLMNID_MCC, :SERVD_SGSN_PLMNID_MNC, :SERVD_FBC_UPL, :SERVD_FBC_DOWNL, CAST(TO_TIMESTAMP(:SERVD_REPORT_TIME, 'rrmmdd hh24miss') AS DATE) , :SERVD_RATTYPE, :SERVD_FAIL_HANDL_CONTIN, :SERVD_IDENTIFIER, :SERVD_PLMNID_MCC, :SERVD_PLMNID_MNC, :SERVD_LOCATION, :SERVD_CELL_ID, :SERVD_TIME_QUOTA_TYPE, :SERVD_BASETIME_INTERVAL, :SERVD_PS_FREEF_DATA, :SERVD_PSFFD_APP_IND, :SERVD_NROFEVENTS, :SERVD_PLMNID_MCC2, :SERVD_PLMNID_MNC2, :SERVD_DET_LOC_SEQ_NR, :SERVD_USAGE_TIME, :SERVD_GW_ADDRESS)
3dbzmtf9ahvztmerge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn or m.obj# in (select obj# from tabpart$ where bo# = :pobjn and obj# = :objn union all select obj# from tabcompart$ where bo# = :pobjn and obj# = :objn union all select tsp.obj# from tabsubpart$ tsp, tabcompart$ tcp where tsp.pobj# = tcp.obj# and (tcp.bo# = :pobjn or tcp.obj# = :pobjn) and tsp.obj# = :objn))) when matched then update set inserts = decode(:reset, 1, 0, inserts) + :ins, updates = decode(:reset, 1, 0, updates) + :upd, deletes = decode(:reset, 1, 0, deletes) + :del, flags = decode(:reset, 1, 0, flags - bitand(flags, :flag)) + :flag, drop_segments = decode(:reset, 1, 0, drop_segments) + :dropseg, timestamp = :time when NOT matched then insert (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:objn, :ins, :upd, :del, :time, :flag, :dropseg) where :ins != 0 or :upd != 0 or :del != 0 or :flag != 0 or :dropseg !=0
5dqz0hqtp9fruselect /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
6an16x3f6ducnselect count(*) from sys.all_tables at, sys.all_part_tables apt where at.owner = apt.owner and at.table_name = apt.table_name and at.sharded = 'Y' and apt.partition_count = 1 and at.owner = :1 and at.table_name = :2
6csvyhgf6b0s5SELECT COLNAME FROM SYS.LOADER_COL_FLAGS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ISVIRTUAL = 'YES'
7ac05552jb0v9SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTYPE = 3
85zarqwvf599kINSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE, RECORD_TYPE_DESCR, OPEN_DATE, IMSI_NR, IMEI_NR, MSISDN_NR, DURATION, LOCAL_SEQ_NR, RECORD_SEQ_NR, CELL_ID, LOCATION_AREA, GW_PLMNID_MCC, GW_PLMNID_MNC, SERV_NODE_PLMNID_MCC, SERV_NODE_PLMNID_MNC, CELL_PLMNID_MCC, CELL_PLMNID_MNC, CELL_PLMNID_MCC2, CELL_PLMNID_MNC2, CELL_PLMNID_TAC, E_CELL_ID, CHARGING_ID, NODE_ID, APN_SELECTION_MODE, CHARGE_CHARACTERISTICS, CH_SELECTION_MODE, APN_NI, APN_OI, PDP_TYPE, PDP_ADDRESS, RAT_TYPE, CONN_ID, DYNAM_ADDRESS_FLAG, GW_ADDRESS, PDP_PDN_ADDRESS_EXT, SERV_NODE_ADDRESS1, SERV_NODE_ADDRESS2, SERV_NODE_ADDRESS3, SERV_NODE_ADDRESS4, SERV_NODE_ADDRESS5, SERV_NODE_TYPE1, SERV_NODE_TYPE2, SERV_NODE_TYPE3, SERV_NODE_TYPE4, SERV_NODE_TYPE5, CAUSE_FOR_REC_CLOSE, DIAGNOSTICS, EXT_CHARGE_ID, MS_TIMEZONE, START_DATE, STOP_DATE, NETWORK_INIT, SGSNADDRESS1, SGSNADDRESS2, SGSNADDRESS3, SGSNADDRESS4, SGSNADDRESS5, MS_NETWORK_CAPABILITY, ROUTING_AREA, GGSNADDRESS, SGSNCHANGE, IMSI_SIGNAL_CONTEXT, CAMEL_APN_NI, CAMEL_APN_OI, CAMEL_CALLING_NR, CAMEL_DEST_NR, CAMEL_SMSC, CAMEL_SCFADDRESS, CAMEL_SERV_KEY, CAMEL_DEF_HANDL, CAMEL_FREEF_DATA, CAMEL_FFD_APPEND_IND, CAMEL_LEVEL_SERV, CAMEL_NR_DP, CAMEL_REF_NR, RNC_UNSENT_DOWNLINK, SGSN_PLMNID_MCC, SGSN_PLMNID_MNC, PS_FREEF_DATA, PSFFD_APPEND_IND, FILE_NAME, IMEI_14, SERVED_MNNAI, MOB_EQUIPM_ID, TGPP2_PLMNID_MCC, TGPP2_PLMNID_MNC, TGPP2_PLMNID_MCC2, TGPP2_PLMNID_MNC2, TGPP2_PLMNID_TAC, TGPP2_PLMNID_CELLID, DYNAM_ADDRESS_FLAG_EXT) VALUES (:RECORD_TYPE, :RECORD_TYPE_DESCR, CAST(TO_TIMESTAMP(:OPEN_DATE, 'rrmmdd hh24miss') AS DATE) , :IMSI_NR, :IMEI_NR, :MSISDN_NR, :DURATION, :LOCAL_SEQ_NR, :RECORD_SEQ_NR, :CELL_ID, :LOCATION_AREA, :GW_PLMNID_MCC, :GW_PLMNID_MNC, :SERV_NODE_PLMNID_MCC, :SERV_NODE_PLMNID_MNC, :CELL_PLMNID_MCC, :CELL_PLMNID_MNC, :CELL_PLMNID_MCC2, :CELL_PLMNID_MNC2, :CELL_PLMNID_TAC, :E_CELL_ID, :CHARGING_ID, :NODE_ID, :APN_SELECTION_MODE, :CHARGE_CHARACTERISTICS, :CH_SELECTION_MODE, :APN_NI, :APN_OI, :PDP_TYPE, :PDP_ADDRESS, :RAT_TYPE, :CONN_ID, :DYNAM_ADDRESS_FLAG, :GW_ADDRESS, :PDP_PDN_ADDRESS_EXT, :SERV_NODE_ADDRESS1, :SERV_NODE_ADDRESS2, :SERV_NODE_ADDRESS3, :SERV_NODE_ADDRESS4, :SERV_NODE_ADDRESS5, :SERV_NODE_TYPE1, :SERV_NODE_TYPE2, :SERV_NODE_TYPE3, :SERV_NODE_TYPE4, :SERV_NODE_TYPE5, :CAUSE_FOR_REC_CLOSE, :DIAGNOSTICS, :EXT_CHARGE_ID, :MS_TIMEZONE, :START_DATE, :STOP_DATE, :NETWORK_INIT, :SGSNADDRESS1, :SGSNADDRESS2, :SGSNADDRESS3, :SGSNADDRESS4, :SGSNADDRESS5, :MS_NETWORK_CAPABILITY, :ROUTING_AREA, :GGSNADDRESS, :SGSNCHANGE, :IMSI_SIGNAL_CONTEXT, :CAMEL_APN_NI, :CAMEL_APN_OI, :CAMEL_CALLING_NR, :CAMEL_DEST_NR, :CAMEL_SMSC, :CAMEL_SCFADDRESS, :CAMEL_SERV_KEY, :CAMEL_DEF_HANDL, :CAMEL_FREEF_DATA, :CAMEL_FFD_APPEND_IND, :CAMEL_LEVEL_SERV, :CAMEL_NR_DP, :CAMEL_REF_NR, :RNC_UNSENT_DOWNLINK, :SGSN_PLMNID_MCC, :SGSN_PLMNID_MNC, :PS_FREEF_DATA, :PSFFD_APPEND_IND, :FILE_NAME, :IMEI_14, :SERVED_MNNAI, :MOB_EQUIPM_ID, :TGPP2_PLMNID_MCC, :TGPP2_PLMNID_MNC, :TGPP2_PLMNID_MCC2, :TGPP2_PLMNID_MNC2, :TGPP2_PLMNID_TAC, :TGPP2_PLMNID_CELLID, :DYNAM_ADDRESS_FLAG_EXT)
865qwpcdyggkkselect spare6 from user$ where user#=:1
8uc59s4afypr0SELECT COLUMN_NAME FROM SYS.LOADER_LOB_INDEX_COL WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2
9xhc0db70kgyqselect '''' || SYS_CONTEXT('USERENV', 'CON_ID') || '''' from sys.dual
9zg9qd9bm4spuupdate user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1
ajkubg7upg9puupdate /* KSXM:TIME_UPD */ optstat_hist_control$ set sval2 = systimestamp where sname = :param_name
b9nbhsbx8tqz5SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
bd13sdj0ty0q4SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
c8h20n1d0k95mselect /*+ no_parallel */ spare4 from sys.optstat_hist_control$ where sname=:1
cf960s7s4nvb5SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VIEW_PDB', 'FALSE') */ "OWNER", "OWNERID", "CONSTRAINT_NAME", "CONSTRAINT_TYPE", "TABLE_NAME", "OBJECT_ID", "OBJECT_TYPE#", "STATUS", "ORIGIN_CON_ID" FROM NO_CROSS_CONTAINER("SYS"."INT$INT$DBA_CONSTRAINTS") "INT$INT$DBA_CONSTRAINTS" WHERE "INT$INT$DBA_CONSTRAINTS"."CONSTRAINT_TYPE"='C' AND "INT$INT$DBA_CONSTRAINTS"."OWNER"=:1 AND "INT$INT$DBA_CONSTRAINTS"."TABLE_NAME"=:2 AND "INT$INT$DBA_CONSTRAINTS"."STATUS"='ENABLED' AND ("INT$INT$DBA_CONSTRAINTS"."OBJECT_TYPE#"=4 OR "INT$INT$DBA_CONSTRAINTS"."OBJECT_TYPE#"=2 AND "INT$INT$DBA_CONSTRAINTS"."ORIGIN_CON_ID"=TO_NUMBER('3'))
d9q2q82g1tuzxselect decode(upper(failover_method), NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(upper(failover_type), NULL, 1, 'NONE', 1, 'SESSION', 2, 'SELECT', 4, 'TRANSACTION', 8, 'AUTO' , 32, 1 ), failover_retries, failover_delay, flags, nvl(replay_initiation_timeout, 900), decode(upper(session_state_consistency), 'STATIC', 16, 0), failover_restore from sys.service$ where name = :1
f0h5rpzmhju11select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE'), STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN'), SYS_CONTEXT('USERENV', 'SERVICE_NAME') from v$instance
f705bwx3q0ydqselect count(*) from dba_autotask_window_clients c, (select window_name, max(log_date) max_log_date from dba_scheduler_window_log where operation = 'OPEN' group by window_name) wo, (select window_name, max(log_date) max_log_date from dba_scheduler_window_log where operation = 'CLOSE' group by window_name) wc where c.window_name = wo.window_name and c.optimizer_stats = 'ENABLED' and wo.window_name = wc.window_name and wo.max_log_date < wc.max_log_date and wc.window_name not in (select h.window_name from dba_autotask_job_history h where h.client_name = 'auto optimizer stats collection' and h.job_start_time between wo.max_log_date and wc.max_log_date)
fd4b9db6ju2ckSELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHERE A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A.OWNER = C.OWNER AND A.OWNER = T.OWNER AND A.OWNER = :1 AND A.TABLE_NAME = C.TABLE_NAME AND A.TABLE_NAME = :2 AND A.TABLE_NAME = T.TABLE_NAME AND T.QUALIFIED_COL_NAME = C.COLUMN_NAME AND T.DATA_TYPE IN ('CLOB', 'BLOB', 'NCLOB') AND A.STATUS = 'ENABLED'

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes468,008,58943,315.581,794.70
execute count622,29657.602.39
logons cumulative51,6254.780.20
opened cursors cumulative430,34439.831.65
parse count (total)430,36439.831.65
parse time elapsed1,9780.180.01
physical reads7670.070.00
physical writes00.000.00
redo size104,672,622,6969,687,760.82401,395.18
session cursor cache hits34,6263.200.13
session logical reads1,013,381,19793,791.433,886.08
user calls1,089,332100.824.18
user commits260,77224.141.00
user rollbacks00.000.00
workarea executions - optimal241,26922.330.93


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
ASSM cbk:blocks examined6,314,914584.4624.22
ASSM cbk:blocks marked full3,076,020284.6911.80
ASSM gsp:L1 bitmaps examined3,629,353335.9113.92
ASSM gsp:L2 bitmap full7500.070.00
ASSM gsp:L2 bitmaps examined73,6246.810.28
ASSM gsp:Optimized reject DB00.000.00
ASSM gsp:Optimized reject l100.000.00
ASSM gsp:Search all4470.040.00
ASSM gsp:Search hint3,2470.300.01
ASSM gsp:Search steal4470.040.00
ASSM gsp:bump HWM4470.040.00
ASSM gsp:get free block3,238,894299.7712.42
ASSM gsp:good hint3,170,259293.4212.16
ASSM gsp:reject L100.000.00
ASSM gsp:reject db00.000.00
ASSM rsv:alloc from reserve00.000.00
ASSM rsv:alloc from reserve succ00.000.00
ASSM rsv:clear reserve00.000.00
ASSM rsv:fill reserve00.000.00
ASSM wasted db state change00.000.00
Batched IO (bound) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced307,13128.431.18
CCursor + sql area evicted00.000.00
CPU used by this session487,08845.081.87
CPU used when call started487,11945.081.87
CR blocks created9,6130.890.04
Cached Commit SCN referenced00.000.00
Client Advertised Receive Window120,43511.150.46
Client Advertised Send Window120,43511.150.46
Client Path Maximum Transmission Unit(MTU)1,127,529,675104,356.214,323.81
Client Send Congestion Window172,05015.920.66
Client Time (usec) Last Ack Received3,4920.320.01
Client Time (usec) Last Data Received3,4930.320.01
Client Time (usec) Last Data Sent3,9110.360.01
Client Time (usec) Round Trip Time38,627,1383,575.06148.13
Client Time (usec) Round Trip Time Variance55,497,5275,136.46212.82
Client Total Bytes Acked18,202,220,1281,684,669.3169,801.28
Client Total Bytes Received332,938,24930,814.421,276.74
Commit SCN cached00.000.00
DFO trees parallelized17,2051.590.07
DML statements retried00.000.00
Effective IO time00.000.00
HSC Heap Segment Block Changes4,309,959398.9016.53
Heap Segment Array Inserts4,292,713397.3016.46
Heap Segment Array Updates9,6710.900.04
Heatmap BlkLevel Flushed00.000.00
Heatmap BlkLevel Flushed to BF00.000.00
Heatmap BlkLevel Ranges Flushed00.000.00
Heatmap Blklevel Flush Task Count00.000.00
IMU Flushes260,20124.081.00
IMU Redo allocation size3,762,103,532348,193.8114,426.79
IMU commits2730.030.00
IMU contention10.000.00
IMU ktichg flush12,2321.130.05
IMU pool not allocated2990.030.00
IMU recursive-transaction flush20.000.00
IMU undo allocation size272,533,20025,223.751,045.10
IMU- failed to get a private strand2990.030.00
KTFB alloc req6160.060.00
KTFB alloc space (block)28,900,851,7122,674,859.30110,828.05
KTFB alloc time (ms)83,3307.710.32
KTFB apply req1690.020.00
KTFB apply time (ms)2,9610.270.01
KTFB commit req00.000.00
KTFB commit time (ms)00.000.00
KTFB free req00.000.00
KTFB free space (block)00.000.00
KTFB free time (ms)00.000.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued00.000.00
PX local messages recv'd378,51035.031.45
PX local messages sent378,51035.031.45
Parallel operations not downgraded17,2051.590.07
Requests to/from client745,20968.972.86
RowCR - row contention00.000.00
RowCR attempts00.000.00
RowCR hits00.000.00
SQL*Net roundtrips to/from client745,20968.972.86
TBS Extension: tasks created00.000.00
active txn count during cleanout2,437,437225.599.35
auto extends on undo tablespace00.000.00
blocks cleaned out using minact63,674,8125,893.29244.18
branch node splits3,2820.300.01
buffer is not pinned count9,595,162888.0636.80
buffer is pinned count20,876,4391,932.1880.06
bytes received via SQL*Net from client18,159,133,0001,680,681.4769,636.05
bytes sent via SQL*Net to client317,680,82429,402.301,218.23
calls to get snapshot scn: kcmgss92,583,1908,568.85355.04
calls to kcmgas1,264,395117.024.85
calls to kcmgcs6,009,019556.1523.04
cell physical IO interconnect bytes1,979,490,304183,207.687,590.89
change write time86,9368.050.33
cleanout - number of ktugct calls3,065,949283.7611.76
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets00.000.00
cluster key scan block gets2,947,326272.7811.30
cluster key scans1,221,091113.024.68
commit batch/immediate performed640.010.00
commit batch/immediate requested640.010.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written7230.070.00
commit cleanout failures: callback failure181,70416.820.70
commit cleanout failures: cannot pin00.000.00
commit cleanouts157,093,18214,539.44602.42
commit cleanouts successfully completed156,910,75514,522.55601.72
commit immediate performed640.010.00
commit immediate requested640.010.00
commit txn count during cleanout945,88787.543.63
consistent changes00.000.00
consistent gets15,928,3861,474.2261.08
consistent gets direct00.000.00
consistent gets examination7,766,953718.8529.78
consistent gets examination (fastpath)7,765,151718.6929.78
consistent gets from cache15,928,3861,474.2261.08
consistent gets pin8,161,433755.3631.30
consistent gets pin (fastpath)8,151,820754.4831.26
cursor authentications00.000.00
cursor reload failures00.000.00
data blocks consistent reads - undo records applied00.000.00
db block changes468,008,58943,315.581,794.70
db block gets997,452,81192,317.213,825.00
db block gets direct00.000.00
db block gets from cache997,452,81192,317.213,825.00
db block gets from cache (fastpath)778,457,64072,048.562,985.20
deferred (CURRENT) block cleanout applications142,832,81313,219.60547.73
dirty buffers inspected8650.080.00
enqueue conversions68,8206.370.26
enqueue releases3,013,478278.9111.56
enqueue requests3,013,530278.9111.56
enqueue timeouts450.000.00
enqueue waits17,3501.610.07
execute count622,29657.602.39
failed probes on index block reclamation00.000.00
file io service time00.000.00
free buffer inspected3,100,362286.9511.89
free buffer requested3,569,329330.3513.69
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress100.000.00
hot buffers moved to head of LRU3,853,821356.6814.78
immediate (CR) block cleanout applications00.000.00
immediate (CURRENT) block cleanout applications10,562,443977.5940.50
index crx upgrade (positioned)00.000.00
index fast full scans (direct read)00.000.00
index fast full scans (full)00.000.00
index fast full scans (rowid ranges)00.000.00
index fetch by key5,206,615481.8919.97
index range scans1,439,276133.215.52
index reclamation/extension switch30.000.00
leaf node 90-10 splits00.000.00
leaf node splits957,90088.663.67
lob reads00.000.00
lob writes00.000.00
lob writes unaligned00.000.00
logical read bytes from cache8,301,618,765,824768,339,370.0231,834,778.14
logons cumulative51,6254.780.20
max cf enq hold time00.000.00
messages sent277,99925.731.07
min active SCN optimization applied on CR00.000.00
no work - consistent read gets7,742,364716.5829.69
non-idle wait count4,755,726440.1618.24
opened cursors cumulative430,34439.831.65
parse count (describe)00.000.00
parse count (failures)00.000.00
parse count (hard)00.000.00
parse count (total)430,36439.831.65
parse time cpu2,0550.190.01
parse time elapsed1,9780.180.01
physical read IO requests7670.070.00
physical read bytes6,283,264581.5324.09
physical read total IO requests121,20211.220.46
physical read total bytes1,979,490,304183,207.687,590.89
physical read total multi block requests00.000.00
physical reads7670.070.00
physical reads cache7670.070.00
physical reads cache prefetch00.000.00
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests00.000.00
physical write bytes00.000.00
physical write total IO requests00.000.00
physical write total bytes00.000.00
physical write total multi block requests00.000.00
physical writes00.000.00
physical writes direct00.000.00
physical writes direct temporary tablespace00.000.00
physical writes non checkpoint00.000.00
pinned buffers inspected10.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time00.000.00
queries parallelized17,2051.590.07
recursive calls2,672,799247.3810.25
recursive cpu usage28,0492.600.11
redo buffer allocation retries30.000.00
redo entries241,769,71622,376.50927.13
redo log space requests40.000.00
redo ordering marks1,2270.110.00
redo size104,672,622,6969,687,760.82401,395.18
redo subscn max counts1,5620.140.01
redo synch long waits00.000.00
redo synch time30,2312.800.12
redo synch time (usec)309,316,08528,628.121,186.16
redo synch time overhead (usec)3,907,153361.6214.98
redo synch time overhead count ( 2ms)250,95123.230.96
redo synch time overhead count ( 8ms)00.000.00
redo synch time overhead count (128ms)00.000.00
redo synch time overhead count (inf)00.000.00
redo synch writes278,00925.731.07
redo write info find250,95123.230.96
rollback changes - undo records applied1320.010.00
rollbacks only - consistent read gets00.000.00
root node splits30.000.00
rows fetched via callback1,588,282147.006.09
securefile bytes non-transformed00.000.00
securefile direct read bytes00.000.00
securefile direct read ops00.000.00
securefile number of non-transformed flushes00.000.00
session cursor cache hits34,6263.200.13
session logical reads1,013,381,19793,791.433,886.08
shared hash latch upgrades - no wait21,9512.030.08
shared hash latch upgrades - wait10.000.00
shared io pool buffer get success00.000.00
sorts (memory)224,22020.750.86
sorts (rows)1,170,447108.334.49
sql area evicted00.000.00
sql area purged00.000.00
switch current caused by our pin17,1691.590.07
switch current to new buffer17,1721.590.07
table fetch by rowid12,796,2411,184.3349.07
table fetch continued row00.000.00
table scan blocks gotten68,8266.370.26
table scan disk non-IMC rows gotten5,333,562493.6420.45
table scan rows gotten5,333,562493.6420.45
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)34,4163.190.13
total cf enq hold time00.000.00
total number of cf enq holders00.000.00
transaction rollbacks640.010.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size31,108,223,0802,879,158.05119,292.80
user calls1,089,332100.824.18
user commits260,77224.141.00
user logons cumulative17,2051.590.07
user logouts cumulative17,2081.590.07
user rollbacks00.000.00
workarea executions - optimal241,26922.330.93
write clones created in foreground3480.030.00


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current93
session cursor cache count9,772,82910,134,171
session pga memory14,224,3204,883,664
session uga memory336,898,926,232349,096,386,928
session uga memory max3,326,064,138,3283,446,552,778,088


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File5M0.110M284G1116.2426.919M131.81us 
TOTAL:5M0.110M284G1116.2426.919M131.81us 


Back to IO Stats
Back to Top

Tablespace IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

File IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header33400



Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Logical Reads%TotalPDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_UQHD4G_09OCT20INDEX PARTITION747077470789,178,0968.80 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_UQHD4G_05OCT20INDEX PARTITION746797467988,142,4008.70 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_UQHD4G_06OCT20INDEX PARTITION746867468687,561,6008.64 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_09OCT20INDEX PARTITION749357493548,801,4564.82 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_05OCT20INDEX PARTITION749237492347,760,3844.71 PCDRDB


Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Physical Reads%TotalPDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_06OCT20INDEX PARTITION74685746859712.65 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_09OCT20INDEX PARTITION74706747067810.17 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_05OCT20INDEX PARTITION7467874678719.26 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMSI_NR_IDXHD4G_06OCT20INDEX PARTITION7468374683557.17 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_MSISDN_NR_IDXHD4G_06OCT20INDEX PARTITION7468174681516.65 PCDRDB


Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Phys Read Requests%TotalPDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_06OCT20INDEX PARTITION74685746859712.65 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_09OCT20INDEX PARTITION74706747067810.17 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_05OCT20INDEX PARTITION7467874678719.26 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMSI_NR_IDXHD4G_06OCT20INDEX PARTITION7468374683557.17 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_MSISDN_NR_IDXHD4G_06OCT20INDEX PARTITION7468174681516.65 PCDRDB


Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#UnOptimized Reads%TotalPDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_06OCT20INDEX PARTITION74685746859712.65 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_09OCT20INDEX PARTITION74706747067810.17 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_E_CELL_ID_IDXHD4G_05OCT20INDEX PARTITION7467874678719.26 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMSI_NR_IDXHD4G_06OCT20INDEX PARTITION7468374683557.17 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_MSISDN_NR_IDXHD4G_06OCT20INDEX PARTITION7468174681516.65 PCDRDB


Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Physical Writes%TotalPDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMSI_NR_IDXHD4G_06OCT20INDEX PARTITION74683746832,725,541272554100.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_MSISDN_NR_IDXHD4G_06OCT20INDEX PARTITION74681746812,724,199272419900.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMEI_14_IDXHD4G_06OCT20INDEX PARTITION74684746842,712,399271239900.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMSI_NR_IDXHD4G_05OCT20INDEX PARTITION74676746762,617,165261716500.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_MSISDN_NR_IDXHD4G_05OCT20INDEX PARTITION74674746742,615,763261576300.00 PCDRDB


Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Phys Write Requests%TotalPDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMSI_NR_IDXHD4G_06OCT20INDEX PARTITION7468374683981,56598156500.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMEI_14_IDXHD4G_06OCT20INDEX PARTITION7468474684981,39198139100.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_MSISDN_NR_IDXHD4G_06OCT20INDEX PARTITION7468174681978,09997809900.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMSI_NR_IDXHD4G_05OCT20INDEX PARTITION7467674676967,95396795300.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_IMEI_14_IDXHD4G_05OCT20INDEX PARTITION7467774677965,93496593400.00 PCDRDB


Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

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. TypeObj#Dataobj#DB Block Changes% of CapturePDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_09OCT20INDEX PARTITION749357493513,120,1605.44 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_05OCT20INDEX PARTITION749237492312,856,6885.33 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_06OCT20INDEX PARTITION749267492612,692,0805.26 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_UQHD4G_06OCT20INDEX PARTITION746867468611,802,0644.89 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_UQHD4G_05OCT20INDEX PARTITION746797467911,718,5124.86 PCDRDB


Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Row Lock Waits% of CapturePDB Name
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_09OCT20INDEX PARTITION74935749355610.98 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_05OCT20INDEX PARTITION74923749235110.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_UQHD4G_06OCT20INDEX PARTITION74686746865110.00 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_UQHD4G_09OCT20INDEX PARTITION7470774707458.82 PCDRDB
CDRDBUSERCDRDB_DEFAULT_INDEX01 HD4G_COCC_UQHD4GCOCC_06OCT20INDEX PARTITION7492674926448.63 PCDRDB


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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Initialization Parameters

Back to Top

Parameters modified by this container

Parameter NameBegin valueEnd value (if different)PDB Name
sga_target0   PCDRDB
undo_tablespaceUNDOTBS1   PCDRDB


Back to Initialization Parameters
Back to Top

Parameters modified by other containers

Parameter NameBegin valueEnd value (if different)PDB Name
audit_file_dest/oracle/app/oracle/admin/cdrdb/adump    
audit_trailDB    
compatible19.0.0    
control_files+DATA/CDRDB/CONTROLFILE/current.261.1063293425, +FRA/CDRDB/CONTROLFILE/current.256.1063293427    
db_block_size8192    
db_create_file_dest+DATA    
db_namecdrdb    
db_recovery_file_dest+FRA    
db_recovery_file_dest_size13350469632    
diagnostic_dest/oracle/app/oracle    
dispatchers(PROTOCOL=TCP) (SERVICE=cdrdbXDB)    
enable_pluggable_databaseTRUE    
local_listenerLISTENER_CDRDB    
open_cursors300    
pga_aggregate_target60737716224    
processes4480    
remote_login_passwordfileEXCLUSIVE    
sga_target182536110080    
undo_tablespaceUNDOTBS1    


Back to Initialization Parameters
Back to Top

Multi-Valued Parameters modified by this container

No data exists for this section of the report.

Back to Initialization Parameters
Back to Top

Multi-Valued Parameters modified by other containers

Parameter NameBegin valueEnd value (if different)PDB Name
control_files+DATA/CDRDB/CONTROLFILE/current.261.1063293425    
+FRA/CDRDB/CONTROLFILE/current.256.1063293427    


Back to Initialization Parameters
Back to Top

Active Session History (ASH) Report

Back to Top

Top SQL with Top Events

SQL IDPlan HashExecutions% ActivityEvent% EventTop Row Source% Row SourceSQL TextContainer Name
85zarqwvf599k 23142.49 CPU + Wait for CPU42.49** Row Source Not Available **42.49 INSERT INTO CDRDBUSER.HD4G_TB ...PCDRDB
0f0zjv1c0rq3q 9216.85 CPU + Wait for CPU16.85** Row Source Not Available **16.85 INSERT INTO CDRDBUSER.HD4G_COC...PCDRDB
85zarqwvf599k2447725225539.71 CPU + Wait for CPU9.71** Row Source Not Available **9.71 INSERT INTO CDRDBUSER.HD4G_TB ...PCDRDB
fd4b9db6ju2ck68411257203.66 CPU + Wait for CPU3.48PX COORDINATOR2.93 SELECT C.COLUMN_NAME FROM SYS....PCDRDB
32vhwk4a4fh6z2447725225173.11 CPU + Wait for CPU3.11** Row Source Not Available **3.11 INSERT INTO CDRDBUSER.HD4G_SER...PCDRDB


Back to Active Session History (ASH) Report
Back to Top

Top SQL with Top Row Sources

SQL IDPlan HashExecutions% ActivityRow Source% Row SourceTop Event% EventSQL TextContainer Name
85zarqwvf599k 23142.49 ** Row Source Not Available **42.49CPU + Wait for CPU42.49 INSERT INTO CDRDBUSER.HD4G_TB ...PCDRDB
0f0zjv1c0rq3q 9216.85 ** Row Source Not Available **16.85CPU + Wait for CPU16.85 INSERT INTO CDRDBUSER.HD4G_COC...PCDRDB
85zarqwvf599k2447725225539.71 ** Row Source Not Available **9.71CPU + Wait for CPU9.71 INSERT INTO CDRDBUSER.HD4G_TB ...PCDRDB
fd4b9db6ju2ck68411257203.66 PX COORDINATOR3.11CPU + Wait for CPU2.93 SELECT C.COLUMN_NAME FROM SYS....PCDRDB
32vhwk4a4fh6z2447725225173.11 ** Row Source Not Available **3.11CPU + Wait for CPU3.11 INSERT INTO CDRDBUSER.HD4G_SER...PCDRDB


Back to Active Session History (ASH) Report
Back to Top

Top Sessions

No data exists for this section of the report.

Back to Active Session History (ASH) Report
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
3147,42395( 1)6.59log file sync6.59 ** NOT FOUND **BLOCKING SESSION NOT FOUND0/1,081 [ 0%] 


Back to Active Session History (ASH) Report
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.

Back to Active Session History (ASH) Report
Back to Top

Top Events

EventEvent ClassSession Type% ActivityAvg Active Sessions
CPU + Wait for CPUCPUFOREGROUND 90.660.46
log file syncCommitFOREGROUND 6.590.03
CPU + Wait for CPUCPUBACKGROUND 1.280.01
control file sequential readSystem I/OFOREGROUND 0.01


Back to Active Session History (ASH) Report
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1, P2, P3 Values% ActivityParameter 1Parameter 2Parameter 3
log file sync6.59"12434","63413006","0"0.18 buffer#sync scnNOT DEFINED
control file sequential read1.28"0","1","1"0.18 file#block#blocks


Back to Active Session History (ASH) Report
Back to Top

Top DB Objects

No data exists for this section of the report.

Back to Active Session History (ASH) Report
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
17:00:09 (19.9 min)68CPU + Wait for CPU6511.90
log file sync20.37
control file sequential read10.18
17:20:00 (20.0 min)48CPU + Wait for CPU458.24
log file sync30.55
17:40:00 (20.0 min)77CPU + Wait for CPU6912.64
log file sync81.47
18:00:00 (20.0 min)65CPU + Wait for CPU5810.62
log file sync61.10
control file sequential read10.18
18:20:00 (20.0 min)57CPU + Wait for CPU529.52
control file sequential read20.37
log file sync20.37
18:40:00 (20.0 min)63CPU + Wait for CPU5810.62
log file sync50.92
19:00:00 (20.0 min)56CPU + Wait for CPU519.34
log file sync50.92
19:20:00 (20.0 min)55CPU + Wait for CPU509.16
log file sync40.73
control file sequential read10.18
19:40:00 (20.0 min)56CPU + Wait for CPU539.71
control file sequential read20.37
log file sync10.18
20:00:00 (14 secs)1CPU + Wait for CPU10.18


Back to Active Session History (ASH) Report
Back to Top


Back to Top

End of Report