WORKLOAD REPOSITORY PDB report (root snapshots)

DB Name DB Id Unique Name Role Edition Release RAC CDB

CDRDB 3758444401 cdrdb PRIMARY EE 19.0.0.0.0 NO YES

DB Name	DB Id	Unique Name	Role	Edition	Release	RAC	CDB
CDRDB	3758444401	cdrdb	PRIMARY	EE	19.0.0.0.0	NO	YES

Instance Inst Num Startup Time

cdrdb 1 31-Jan-21 15:29

Instance	Inst Num	Startup Time
cdrdb	1	31-Jan-21 15:29

Container DB Id Container Name Open Time

4100670825 PCDRDB 03-Feb-21 16:01

Container DB Id	Container Name	Open Time
4100670825	PCDRDB	03-Feb-21 16:01

Host Name Platform CPUs Cores Sockets Memory (GB)

mtccdrdb01.mtcdc.com.na Linux x86 64-bit 56 28 2 565.66

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
mtccdrdb01.mtcdc.com.na	Linux x86 64-bit	56	28	2	565.66

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 362 15-Feb-21 17:00:09 3 3.0

End Snap: 365 15-Feb-21 20:00:14 0 3.0

Elapsed: 180.08 (mins)

DB Time: 91.41 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	362	15-Feb-21 17:00:09	3	3.0
End Snap:	365	15-Feb-21 20:00:14	0	3.0
Elapsed:		180.08 (mins)
DB Time:		91.41 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per 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

	Per Second	Per Transaction	Per Exec	Per 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

Event	Waits	Total Wait Time (sec)	Avg Wait	% DB time	Wait Class
DB CPU		5235.3		95.5
log file sync	250,757	308.5	1.23ms	5.6	Commit
control file sequential read	120,435	81.2	674.20us	1.5	System I/O
SQL*Net more data from client	2,015,345	10.5	5.22us	.2	Network
PX Deq: Join ACK	34,410	9.1	265.04us	.2	Other
PX Deq: Slave Session Stats	68,477	4.9	72.03us	.1	Other
PGA memory operation	919,969	4.4	4.78us	.1	Other
Disk file operations I/O	57,171	3.6	63.55us	.1	User I/O
enq: PS - contention	17,310	1.2	67.94us	.0	Other
db file sequential read	767	.5	656.58us	.0	User I/O

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait Time	% DB time	Avg Active Sessions
DB CPU		5,235		95.5	0.5
Commit	250,757	308	1.23ms	5.6	0.0
System I/O	122,127	82	668.68us	1.5	0.0
Other	1,142,154	29	25.22us	.5	0.0
Network	2,806,427	11	3.92us	.2	0.0
User I/O	58,694	4	70.54us	.1	0.0
Configuration	48	1	12.35ms	.0	0.0
Concurrency	521	0	256.42us	.0	0.0
Application	31	0	531.84us	.0	0.0

IO Profile

Read+Write Per Second Read per Second Write 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

	Read+Write Per Second	Read per Second	Write 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

Wait Events Statistics

Time Model Statistics
Foreground Wait Class
Foreground Wait Events
Service Statistics
Service Wait Class Stats
Top Process Types by Wait Class
Top Process Types by CPU Used

Time Model Statistics

DB Time represents total time in user calls
DB CPU represents CPU time of foreground processes
Total CPU Time represents foreground and background processes
Statistics including the word "background" measure background process time, therefore do not contribute to the DB time statistic
Ordered by % of DB time in descending order, followed by Statistic Name

Statistic Name	Time (s)	% of DB Time	% of Total CPU Time
DB CPU	5,235.26	95.46	100.00
sql execute elapsed time	4,658.12	84.93
connection management call elapsed time	173.18	3.16
parse time elapsed	20.01	0.36
DB time	5,484.40
background elapsed time	0.08
background cpu time	0.08		0.00
total CPU time	5,235.34

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond, us - microsecond, ns - nanosecond
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 103.2% of Total DB time 5,484.40 (s)
Total FG Wait Time: 425.81 (s) DB CPU time: 5,235.26 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait	%DB time
DB CPU			5,235		95.46
Commit	250,757	0	308	1.23ms	5.62
System I/O	120,435	0	81	674.20us	1.48
Other	1,106,201	0	20	18.33us	0.37
Network	2,772,017	0	11	3.96us	0.20
User I/O	57,938	0	4	71.40us	0.08
Configuration	42	81	1	14.11ms	0.01
Concurrency	482	0	0	273.89us	0.00
Application	31	0	0	531.84us	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond, us - microsecond, ns - nanosecond
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait	Waits /txn	% DB time
log file sync	250,757		308	1.23ms	0.96	5.62
control file sequential read	120,435		81	674.20us	0.46	1.48
SQL*Net more data from client	2,015,345		11	5.22us	7.73	0.19
PX Deq: Join ACK	34,410		9	265.04us	0.13	0.17
PX Deq: Slave Session Stats	68,477		5	72.03us	0.26	0.09
PGA memory operation	919,969		4	4.78us	3.53	0.08
Disk file operations I/O	57,171		4	63.55us	0.22	0.07
enq: PS - contention	17,310		1	67.94us	0.07	0.02
db file sequential read	767		1	656.58us	0.00	0.01
undo segment extension	34	100	0	10.40ms	0.00	0.01
SQL*Net message to client	745,202		0	449.22ns	2.86	0.01
PX Deq: Signal ACK EXT	34,410		0	9.43us	0.13	0.01
latch free	12,419		0	22.76us	0.05	0.01
log file switch (private strand flush incomplete)	3		0	65.80ms	0.00	0.00
SQL*Net more data to client	11,470		0	9.35us	0.04	0.00
library cache: mutex X	36		0	1.89ms	0.00	0.00
library cache lock	38		0	1.15ms	0.00	0.00
enq: HW - contention	5		0	8.29ms	0.00	0.00
PX Deq Credit: free buffer	17,204		0	1.49us	0.07	0.00
enq: RC - Result Cache: Contention	31		0	531.84us	0.00	0.00
enq: DA - Slave Process Array	4		0	2.79ms	0.00	0.00
latch: call allocation	922		0	10.12us	0.00	0.00
buffer busy waits	294		0	31.20us	0.00	0.00
latch: cache buffers chains	50		0	88.62us	0.00	0.00
library cache load lock	27		0	162.85us	0.00	0.00
PX qref latch	970	100	0	3.50us	0.00	0.00
transaction	65		0	35.46us	0.00	0.00
cursor: mutex S	1		0	1.06ms	0.00	0.00
SQL*Net message from client	745,209		22,381	30.03ms	2.86
PX Deq: Execution Msg	137,623		350	2.55ms	0.53
PX Deq: Parse Reply	34,409		22	651.48us	0.13
PX Deq: Execute Reply	172,050		21	120.63us	0.66
PX Deq: Table Q Normal	34,377		2	49.34us	0.13
PX Deq: Msg Fragment	34,388		0	1.05us	0.13
PX Deq Credit: send blkd	373		0	15.36us	0.00

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
pcdrdb	5,484	5,235	1	1,013,378

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
pcdrdb	57938	4	482	0	0	0	2772031	11

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

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 85.6% of Total DB Time (s): 5,484
Captured PL/SQL account for 0.0% of Total DB Time (s): 5,484

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	PDB Name	SQL Text
2,828.21	173,070	0.02	51.57	96.86	0.02	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
1,114.89	61,372	0.02	20.33	97.16	0.01	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
276.10	26,326	0.01	5.03	94.25	0.01	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...
259.13	17,205	0.02	4.72	97.54	0.00	fd4b9db6ju2ck	SQL Loader Conventional Path Load	PCDRDB	SELECT C.COLUMN_NAME FROM SYS....
93.43	17,205	0.01	1.70	30.58	3.75	1abbtfgtkqj15	sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3)	PCDRDB	SELECT RESULTS FROM SYS.LOADER...
26.65	51,831	0.00	0.49	83.49	0.00	5dqz0hqtp9fru		PCDRDB	select /*+ connect_by_filterin...
14.46	17,198	0.00	0.26	72.20	0.00	cf960s7s4nvb5	SQL Loader Conventional Path Load	PCDRDB	SELECT /*+ NO_STATEMENT_QUEUIN...
14.06	17,205	0.00	0.26	98.68	0.00	bd13sdj0ty0q4	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.ALL_OBJECT...
10.52	17,199	0.00	0.19	63.55	0.00	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
9.93	17,171	0.00	0.18	101.99	0.00	9zg9qd9bm4spu	Toad.exe	PCDRDB	update user$ set spare6=DECODE...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 85.2% of Total CPU Time (s): 5,235
Captured PL/SQL account for 0.0% of Total CPU Time (s): 5,235

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	PDB Name	SQL Text
2,739.39	173,070	0.02	52.33	2,828.21	96.86	0.02	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
1,083.25	61,372	0.02	20.69	1,114.89	97.16	0.01	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
260.22	26,326	0.01	4.97	276.10	94.25	0.01	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...
252.75	17,205	0.01	4.83	259.13	97.54	0.00	fd4b9db6ju2ck	SQL Loader Conventional Path Load	PCDRDB	SELECT C.COLUMN_NAME FROM SYS....
28.57	17,205	0.00	0.55	93.43	30.58	3.75	1abbtfgtkqj15	sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3)	PCDRDB	SELECT RESULTS FROM SYS.LOADER...
22.25	51,831	0.00	0.43	26.65	83.49	0.00	5dqz0hqtp9fru		PCDRDB	select /*+ connect_by_filterin...
13.88	17,205	0.00	0.27	14.06	98.68	0.00	bd13sdj0ty0q4	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.ALL_OBJECT...
10.44	17,198	0.00	0.20	14.46	72.20	0.00	cf960s7s4nvb5	SQL Loader Conventional Path Load	PCDRDB	SELECT /*+ NO_STATEMENT_QUEUIN...
10.13	17,171	0.00	0.19	9.93	101.99	0.00	9zg9qd9bm4spu	Toad.exe	PCDRDB	update user$ set spare6=DECODE...
8.13	17,202	0.00	0.16	8.19	99.23	0.00	6an16x3f6ducn	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

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 99.9% of Total User I/O Wait Time (s): 4
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 4

User I/O Time (s)	Executions	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	PDB Name	SQL Text
3.50	17,205	84.57	93.43	30.58	3.75	1abbtfgtkqj15	sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3)	PCDRDB	SELECT RESULTS FROM SYS.LOADER...
0.51	173,070	12.30	2,828.21	96.86	0.02	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
0.10	61,372	2.52	1,114.89	97.16	0.01	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
0.02	26,326	0.52	276.10	94.25	0.01	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...
0.00	17,171	0.01	9.93	101.99	0.00	9zg9qd9bm4spu	Toad.exe	PCDRDB	update user$ set spare6=DECODE...
0.00	17,199	0.00	10.52	63.55	0.00	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
0.00	2	0.00	0.02	100.33	0.00	0nakmm882vmq0		PCDRDB	select /* QOSH:DROP_STAT_HIST_...
0.00	39	0.00	0.00	97.76	0.00	2ajc7pwz9jsx3		PCDRDB	select max(scn) from smon_scn_...
0.00	509	0.00	0.02	96.28	0.00	2p9fv35c7zxtg		PCDRDB	select /* KSXM:LOAD_DML_INF */...
0.00	213	0.00	0.03	103.52	0.00	3dbzmtf9ahvzt		PCDRDB	merge /* KSXM:OPTIM_DML_INF */...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - Buffer Gets as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 1,013,381,197
Captured SQL account for 100.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	SQL Id	SQL Module	PDB Name	SQL Text
599,929,227	173,070	3,466.40	59.20	2,828.21	96.9	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
333,634,888	61,372	5,436.27	32.92	1,114.89	97.2	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
67,123,539	26,326	2,549.71	6.62	276.10	94.2	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...
6,052,010	17,205	351.76	0.60	259.13	97.5	fd4b9db6ju2ck	SQL Loader Conventional Path Load	PCDRDB	SELECT C.COLUMN_NAME FROM SYS....
2,253,855	17,205	131.00	0.22	8.81	73.1	7ac05552jb0v9	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.LOADER_PAR...
1,293,392	51,831	24.95	0.13	26.65	83.5	5dqz0hqtp9fru		PCDRDB	select /*+ connect_by_filterin...
1,060,975	17,202	61.68	0.10	8.19	99.2	6an16x3f6ducn	SQL Loader Conventional Path Load	PCDRDB	select count(*) from sys.all_t...
1,015,095	17,205	59.00	0.10	8.40	80.7	8uc59s4afypr0	SQL Loader Conventional Path Load	PCDRDB	SELECT COLUMN_NAME FROM SYS.LO...
1,010,075	17,198	58.73	0.10	14.46	72.2	cf960s7s4nvb5	SQL Loader Conventional Path Load	PCDRDB	SELECT /*+ NO_STATEMENT_QUEUIN...
286,750	17,203	16.67	0.03	2.65	95.1	6csvyhgf6b0s5	SQL Loader Conventional Path Load	PCDRDB	SELECT COLNAME FROM SYS.LOADER...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 767
Captured SQL account for 100.0% of Total

Physical Reads	Executions	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	PDB Name	SQL Text
665	173,070	86.70	2,828.21	96.86	0.02	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
102	61,372	13.30	1,114.89	97.16	0.01	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
0	17,199	0.00	10.52	63.55	0.00	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
0	2	0.00	0.02	100.33	0.00	0nakmm882vmq0		PCDRDB	select /* QOSH:DROP_STAT_HIST_...
0	17,205	0.00	93.43	30.58	3.75	1abbtfgtkqj15	sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3)	PCDRDB	SELECT RESULTS FROM SYS.LOADER...
0	39	0.00	0.00	97.76	0.00	2ajc7pwz9jsx3		PCDRDB	select max(scn) from smon_scn_...
0	509	0.00	0.02	96.28	0.00	2p9fv35c7zxtg		PCDRDB	select /* KSXM:LOAD_DML_INF */...
0	26,326	0.00	276.10	94.25	0.01	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...
0	213	0.00	0.03	103.52	0.00	3dbzmtf9ahvzt		PCDRDB	merge /* KSXM:OPTIM_DML_INF */...
0	51,831	0.00	26.65	83.49	0.00	5dqz0hqtp9fru		PCDRDB	select /*+ connect_by_filterin...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqs - (Optimized Read Reqs - Cell Flash Cache Read Hits for Controlfile)
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 767
Captured SQL account for 1.6E+04% of Total
Total UnOptimized Read Requests: 767
Captured SQL account for 1.6E+04% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	PDB Name	SQL Text
120,435	120,435	17,205	7.00	0.00	15702.09	1abbtfgtkqj15	sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3)	PCDRDB	SELECT RESULTS FROM SYS.LOADER...
0	0	17,199	0.00		0.00	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
0	0	61,372	0.00		0.00	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
0	0	2	0.00		0.00	0nakmm882vmq0		PCDRDB	select /* QOSH:DROP_STAT_HIST_...
0	0	39	0.00		0.00	2ajc7pwz9jsx3		PCDRDB	select max(scn) from smon_scn_...
0	0	509	0.00		0.00	2p9fv35c7zxtg		PCDRDB	select /* KSXM:LOAD_DML_INF */...
0	0	26,326	0.00		0.00	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...
0	0	213	0.00		0.00	3dbzmtf9ahvzt		PCDRDB	merge /* KSXM:OPTIM_DML_INF */...
0	0	51,831	0.00		0.00	5dqz0hqtp9fru		PCDRDB	select /*+ connect_by_filterin...
0	0	17,202	0.00		0.00	6an16x3f6ducn	SQL Loader Conventional Path Load	PCDRDB	select count(*) from sys.all_t...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 622,296
Captured SQL account for 91.3% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	PDB Name	SQL Text
173,070	25,200,894	145.61	2,828.21	96.9	0	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
61,372	35,127,229	572.37	1,114.89	97.2	0	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
51,831	774,491	14.94	26.65	83.5	0	5dqz0hqtp9fru		PCDRDB	select /*+ connect_by_filterin...
30,781	31,153	1.01	1.07	100	0	9xhc0db70kgyq	PL/SQL Developer	PCDRDB	select '''' \|\| SYS_CONTEXT('US...
26,326	8,877,301	337.21	276.10	94.2	0	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...
17,205	17,205	1.00	93.43	30.6	3.7	1abbtfgtkqj15	sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3)	PCDRDB	SELECT RESULTS FROM SYS.LOADER...
17,205	0	0.00	8.81	73.1	0	7ac05552jb0v9	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.LOADER_PAR...
17,205	0	0.00	8.40	80.7	0	8uc59s4afypr0	SQL Loader Conventional Path Load	PCDRDB	SELECT COLUMN_NAME FROM SYS.LO...
17,205	17,205	1.00	14.06	98.7	0	bd13sdj0ty0q4	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.ALL_OBJECT...
17,205	0	0.00	2.72	100	0	d9q2q82g1tuzx		PCDRDB	select decode(upper(failover_m...
17,205	17,205	1.00	5.56	99.9	0	f0h5rpzmhju11		PCDRDB	select SYS_CONTEXT('USERENV', ...
17,205	0	0.00	259.13	97.5	0	fd4b9db6ju2ck	SQL Loader Conventional Path Load	PCDRDB	SELECT C.COLUMN_NAME FROM SYS....
17,203	0	0.00	2.65	95.1	0	6csvyhgf6b0s5	SQL Loader Conventional Path Load	PCDRDB	SELECT COLNAME FROM SYS.LOADER...
17,202	17,205	1.00	8.19	99.2	0	6an16x3f6ducn	SQL Loader Conventional Path Load	PCDRDB	select count(*) from sys.all_t...
17,199	51,614	3.00	10.52	63.5	0	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
17,198	63,085	3.67	14.46	72.2	0	cf960s7s4nvb5	SQL Loader Conventional Path Load	PCDRDB	SELECT /*+ NO_STATEMENT_QUEUIN...
17,171	17,171	1.00	1.29	99.9	0	865qwpcdyggkk		PCDRDB	select spare6 from user$ where...
17,171	17,171	1.00	9.93	102	0	9zg9qd9bm4spu	Toad.exe	PCDRDB	update user$ set spare6=DECODE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 430,364
Captured SQL account for 84.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	PDB Name	SQL Text
51,834	51,831	12.04	5dqz0hqtp9fru		PCDRDB	select /*+ connect_by_filterin...
51,087	17,205	11.87	fd4b9db6ju2ck	SQL Loader Conventional Path Load	PCDRDB	SELECT C.COLUMN_NAME FROM SYS....
34,132	30,781	7.93	9xhc0db70kgyq	PL/SQL Developer	PCDRDB	select '''' \|\| SYS_CONTEXT('US...
17,205	17,199	4.00	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
17,205	17,205	4.00	1abbtfgtkqj15	sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3)	PCDRDB	SELECT RESULTS FROM SYS.LOADER...
17,205	17,202	4.00	6an16x3f6ducn	SQL Loader Conventional Path Load	PCDRDB	select count(*) from sys.all_t...
17,205	17,203	4.00	6csvyhgf6b0s5	SQL Loader Conventional Path Load	PCDRDB	SELECT COLNAME FROM SYS.LOADER...
17,205	17,205	4.00	7ac05552jb0v9	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.LOADER_PAR...
17,205	17,205	4.00	8uc59s4afypr0	SQL Loader Conventional Path Load	PCDRDB	SELECT COLUMN_NAME FROM SYS.LO...
17,205	17,205	4.00	bd13sdj0ty0q4	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.ALL_OBJECT...
17,205	17,205	4.00	d9q2q82g1tuzx		PCDRDB	select decode(upper(failover_m...
17,205	17,205	4.00	f0h5rpzmhju11		PCDRDB	select SYS_CONTEXT('USERENV', ...
17,204	17,198	4.00	cf960s7s4nvb5	SQL Loader Conventional Path Load	PCDRDB	SELECT /*+ NO_STATEMENT_QUEUIN...
17,171	17,171	3.99	865qwpcdyggkk		PCDRDB	select spare6 from user$ where...
17,171	17,171	3.99	9zg9qd9bm4spu	Toad.exe	PCDRDB	update user$ set spare6=DECODE...
5,735	173,070	1.33	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
5,734	61,372	1.33	0f0zjv1c0rq3q	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_COC...
5,734	26,326	1.33	32vhwk4a4fh6z	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_SER...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	PDB Name	SQL Text
59,333,328	17,205	0.38	fd4b9db6ju2ck	SQL Loader Conventional Path Load	PCDRDB	SELECT C.COLUMN_NAME FROM SYS....
17,684,635	17,205	0.11	bd13sdj0ty0q4	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.ALL_OBJECT...
15,729,157	17,202	0.10	6an16x3f6ducn	SQL Loader Conventional Path Load	PCDRDB	select count(*) from sys.all_t...
13,153,159	17,205	0.09	8uc59s4afypr0	SQL Loader Conventional Path Load	PCDRDB	SELECT COLUMN_NAME FROM SYS.LO...
10,510,492	3	0.07	f705bwx3q0ydq		PCDRDB	select count(*) from dba_autot...
7,833,681	17,198	0.05	cf960s7s4nvb5	SQL Loader Conventional Path Load	PCDRDB	SELECT /*+ NO_STATEMENT_QUEUIN...
6,646,628	213	0.04	3dbzmtf9ahvzt		PCDRDB	merge /* KSXM:OPTIM_DML_INF */...
3,849,464	509	0.02	2p9fv35c7zxtg		PCDRDB	select /* KSXM:LOAD_DML_INF */...
3,073,351	17,205	0.02	7ac05552jb0v9	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.LOADER_PAR...
2,629,548	17,203	0.02	6csvyhgf6b0s5	SQL Loader Conventional Path Load	PCDRDB	SELECT COLNAME FROM SYS.LOADER...
1,656,869	173,070	0.01	85zarqwvf599k	SQL Loader Conventional Path Load	PCDRDB	INSERT INTO CDRDBUSER.HD4G_TB ...
1,562,728	93	0.01	b9nbhsbx8tqz5		PCDRDB	SELECT /*+ OPT_PARAM('_paralle...
1,428,935	3	0.01	c8h20n1d0k95m		PCDRDB	select /+ no_parallel / spar...
1,344,013	17,199	0.01	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
1,328,301	3	0.01	ajkubg7upg9pu		PCDRDB	update /* KSXM:TIME_UPD */ opt...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	PDB Name	SQL Text
68	93	b9nbhsbx8tqz5		PCDRDB	SELECT /*+ OPT_PARAM('_paralle...
60	509	2p9fv35c7zxtg		PCDRDB	select /* KSXM:LOAD_DML_INF */...
60	3	c8h20n1d0k95m		PCDRDB	select /+ no_parallel / spar...
57	213	3dbzmtf9ahvzt		PCDRDB	merge /* KSXM:OPTIM_DML_INF */...
51	17,205	fd4b9db6ju2ck	SQL Loader Conventional Path Load	PCDRDB	SELECT C.COLUMN_NAME FROM SYS....
48	3	ajkubg7upg9pu		PCDRDB	update /* KSXM:TIME_UPD */ opt...
38	39	2ajc7pwz9jsx3		PCDRDB	select max(scn) from smon_scn_...
33	17,205	8uc59s4afypr0	SQL Loader Conventional Path Load	PCDRDB	SELECT COLUMN_NAME FROM SYS.LO...
32	17,203	6csvyhgf6b0s5	SQL Loader Conventional Path Load	PCDRDB	SELECT COLNAME FROM SYS.LOADER...
30	17,202	6an16x3f6ducn	SQL Loader Conventional Path Load	PCDRDB	select count(*) from sys.all_t...
30	17,205	7ac05552jb0v9	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.LOADER_PAR...
30	17,205	bd13sdj0ty0q4	SQL Loader Conventional Path Load	PCDRDB	SELECT 'X' FROM SYS.ALL_OBJECT...
27	17,199	05uqdabhzncdc		PCDRDB	select role# from defrole$ d, ...
26	17,171	9zg9qd9bm4spu	Toad.exe	PCDRDB	update user$ set spare6=DECODE...
25	17,198	cf960s7s4nvb5	SQL Loader Conventional Path Load	PCDRDB	SELECT /*+ NO_STATEMENT_QUEUIN...
23	17,171	865qwpcdyggkk		PCDRDB	select spare6 from user$ where...
21	3	f705bwx3q0ydq		PCDRDB	select count(*) from dba_autot...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

05uqdabhzncdc select 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

0f0zjv1c0rq3q INSERT 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)

0nakmm882vmq0 select /* 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

1abbtfgtkqj15 SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE

2ajc7pwz9jsx3 select max(scn) from smon_scn_time

2p9fv35c7zxtg select /* 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

32vhwk4a4fh6z INSERT 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)

3dbzmtf9ahvzt merge /* 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

5dqz0hqtp9fru select /*+ 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

6an16x3f6ducn select 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

6csvyhgf6b0s5 SELECT COLNAME FROM SYS.LOADER_COL_FLAGS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ISVIRTUAL = 'YES'

7ac05552jb0v9 SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTYPE = 3

85zarqwvf599k INSERT 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)

865qwpcdyggkk select spare6 from user$ where user#=:1

8uc59s4afypr0 SELECT COLUMN_NAME FROM SYS.LOADER_LOB_INDEX_COL WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2

9xhc0db70kgyq select '''' || SYS_CONTEXT('USERENV', 'CON_ID') || '''' from sys.dual

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1

ajkubg7upg9pu update /* KSXM:TIME_UPD */ optstat_hist_control$ set sval2 = systimestamp where sname = :param_name

b9nbhsbx8tqz5 SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1

bd13sdj0ty0q4 SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'

c8h20n1d0k95m select /*+ no_parallel */ spare4 from sys.optstat_hist_control$ where sname=:1

cf960s7s4nvb5 SELECT /*+ 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'))

d9q2q82g1tuzx select 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

f0h5rpzmhju11 select 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

f705bwx3q0ydq select 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)

fd4b9db6ju2ck SELECT 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'

SQL Id	SQL Text
05uqdabhzncdc	select 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
0f0zjv1c0rq3q	INSERT 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)
0nakmm882vmq0	select /* 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
1abbtfgtkqj15	SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE
2ajc7pwz9jsx3	select max(scn) from smon_scn_time
2p9fv35c7zxtg	select /* 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
32vhwk4a4fh6z	INSERT 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)
3dbzmtf9ahvzt	merge /* 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
5dqz0hqtp9fru	select /+ 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
6an16x3f6ducn	select 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
6csvyhgf6b0s5	SELECT COLNAME FROM SYS.LOADER_COL_FLAGS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ISVIRTUAL = 'YES'
7ac05552jb0v9	SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTYPE = 3
85zarqwvf599k	INSERT 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)
865qwpcdyggkk	select spare6 from user$ where user#=:1
8uc59s4afypr0	SELECT COLUMN_NAME FROM SYS.LOADER_LOB_INDEX_COL WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2
9xhc0db70kgyq	select '''' \|\| SYS_CONTEXT('USERENV', 'CON_ID') \|\| '''' from sys.dual
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1
ajkubg7upg9pu	update /* KSXM:TIME_UPD */ optstat_hist_control$ set sval2 = systimestamp where sname = :param_name
b9nbhsbx8tqz5	SELECT /+ OPT_PARAM('_parallel_syspls_obey_force' 'false') / SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
bd13sdj0ty0q4	SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
c8h20n1d0k95m	select /+ no_parallel / spare4 from sys.optstat_hist_control$ where sname=:1
cf960s7s4nvb5	SELECT /+ 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'))
d9q2q82g1tuzx	select 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
f0h5rpzmhju11	select 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
f705bwx3q0ydq	select 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)
fd4b9db6ju2ck	SELECT 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

Key Instance Activity Stats
Instance Activity Stats
Instance Activity Stats - Absolute Values

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	468,008,589	43,315.58	1,794.70
execute count	622,296	57.60	2.39
logons cumulative	51,625	4.78	0.20
opened cursors cumulative	430,344	39.83	1.65
parse count (total)	430,364	39.83	1.65
parse time elapsed	1,978	0.18	0.01
physical reads	767	0.07	0.00
physical writes	0	0.00	0.00
redo size	104,672,622,696	9,687,760.82	401,395.18
session cursor cache hits	34,626	3.20	0.13
session logical reads	1,013,381,197	93,791.43	3,886.08
user calls	1,089,332	100.82	4.18
user commits	260,772	24.14	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	241,269	22.33	0.93

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
ASSM cbk:blocks examined	6,314,914	584.46	24.22
ASSM cbk:blocks marked full	3,076,020	284.69	11.80
ASSM gsp:L1 bitmaps examined	3,629,353	335.91	13.92
ASSM gsp:L2 bitmap full	750	0.07	0.00
ASSM gsp:L2 bitmaps examined	73,624	6.81	0.28
ASSM gsp:Optimized reject DB	0	0.00	0.00
ASSM gsp:Optimized reject l1	0	0.00	0.00
ASSM gsp:Search all	447	0.04	0.00
ASSM gsp:Search hint	3,247	0.30	0.01
ASSM gsp:Search steal	447	0.04	0.00
ASSM gsp:bump HWM	447	0.04	0.00
ASSM gsp:get free block	3,238,894	299.77	12.42
ASSM gsp:good hint	3,170,259	293.42	12.16
ASSM gsp:reject L1	0	0.00	0.00
ASSM gsp:reject db	0	0.00	0.00
ASSM rsv:alloc from reserve	0	0.00	0.00
ASSM rsv:alloc from reserve succ	0	0.00	0.00
ASSM rsv:clear reserve	0	0.00	0.00
ASSM rsv:fill reserve	0	0.00	0.00
ASSM wasted db state change	0	0.00	0.00
Batched IO (bound) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	307,131	28.43	1.18
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	487,088	45.08	1.87
CPU used when call started	487,119	45.08	1.87
CR blocks created	9,613	0.89	0.04
Cached Commit SCN referenced	0	0.00	0.00
Client Advertised Receive Window	120,435	11.15	0.46
Client Advertised Send Window	120,435	11.15	0.46
Client Path Maximum Transmission Unit(MTU)	1,127,529,675	104,356.21	4,323.81
Client Send Congestion Window	172,050	15.92	0.66
Client Time (usec) Last Ack Received	3,492	0.32	0.01
Client Time (usec) Last Data Received	3,493	0.32	0.01
Client Time (usec) Last Data Sent	3,911	0.36	0.01
Client Time (usec) Round Trip Time	38,627,138	3,575.06	148.13
Client Time (usec) Round Trip Time Variance	55,497,527	5,136.46	212.82
Client Total Bytes Acked	18,202,220,128	1,684,669.31	69,801.28
Client Total Bytes Received	332,938,249	30,814.42	1,276.74
Commit SCN cached	0	0.00	0.00
DFO trees parallelized	17,205	1.59	0.07
DML statements retried	0	0.00	0.00
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	4,309,959	398.90	16.53
Heap Segment Array Inserts	4,292,713	397.30	16.46
Heap Segment Array Updates	9,671	0.90	0.04
Heatmap BlkLevel Flushed	0	0.00	0.00
Heatmap BlkLevel Flushed to BF	0	0.00	0.00
Heatmap BlkLevel Ranges Flushed	0	0.00	0.00
Heatmap Blklevel Flush Task Count	0	0.00	0.00
IMU Flushes	260,201	24.08	1.00
IMU Redo allocation size	3,762,103,532	348,193.81	14,426.79
IMU commits	273	0.03	0.00
IMU contention	1	0.00	0.00
IMU ktichg flush	12,232	1.13	0.05
IMU pool not allocated	299	0.03	0.00
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	272,533,200	25,223.75	1,045.10
IMU- failed to get a private strand	299	0.03	0.00
KTFB alloc req	616	0.06	0.00
KTFB alloc space (block)	28,900,851,712	2,674,859.30	110,828.05
KTFB alloc time (ms)	83,330	7.71	0.32
KTFB apply req	169	0.02	0.00
KTFB apply time (ms)	2,961	0.27	0.01
KTFB commit req	0	0.00	0.00
KTFB commit time (ms)	0	0.00	0.00
KTFB free req	0	0.00	0.00
KTFB free space (block)	0	0.00	0.00
KTFB free time (ms)	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	378,510	35.03	1.45
PX local messages sent	378,510	35.03	1.45
Parallel operations not downgraded	17,205	1.59	0.07
Requests to/from client	745,209	68.97	2.86
RowCR - row contention	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SQL*Net roundtrips to/from client	745,209	68.97	2.86
TBS Extension: tasks created	0	0.00	0.00
active txn count during cleanout	2,437,437	225.59	9.35
auto extends on undo tablespace	0	0.00	0.00
blocks cleaned out using minact	63,674,812	5,893.29	244.18
branch node splits	3,282	0.30	0.01
buffer is not pinned count	9,595,162	888.06	36.80
buffer is pinned count	20,876,439	1,932.18	80.06
bytes received via SQL*Net from client	18,159,133,000	1,680,681.47	69,636.05
bytes sent via SQL*Net to client	317,680,824	29,402.30	1,218.23
calls to get snapshot scn: kcmgss	92,583,190	8,568.85	355.04
calls to kcmgas	1,264,395	117.02	4.85
calls to kcmgcs	6,009,019	556.15	23.04
cell physical IO interconnect bytes	1,979,490,304	183,207.68	7,590.89
change write time	86,936	8.05	0.33
cleanout - number of ktugct calls	3,065,949	283.76	11.76
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	0	0.00	0.00
cluster key scan block gets	2,947,326	272.78	11.30
cluster key scans	1,221,091	113.02	4.68
commit batch/immediate performed	64	0.01	0.00
commit batch/immediate requested	64	0.01	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	723	0.07	0.00
commit cleanout failures: callback failure	181,704	16.82	0.70
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	157,093,182	14,539.44	602.42
commit cleanouts successfully completed	156,910,755	14,522.55	601.72
commit immediate performed	64	0.01	0.00
commit immediate requested	64	0.01	0.00
commit txn count during cleanout	945,887	87.54	3.63
consistent changes	0	0.00	0.00
consistent gets	15,928,386	1,474.22	61.08
consistent gets direct	0	0.00	0.00
consistent gets examination	7,766,953	718.85	29.78
consistent gets examination (fastpath)	7,765,151	718.69	29.78
consistent gets from cache	15,928,386	1,474.22	61.08
consistent gets pin	8,161,433	755.36	31.30
consistent gets pin (fastpath)	8,151,820	754.48	31.26
cursor authentications	0	0.00	0.00
cursor reload failures	0	0.00	0.00
data blocks consistent reads - undo records applied	0	0.00	0.00
db block changes	468,008,589	43,315.58	1,794.70
db block gets	997,452,811	92,317.21	3,825.00
db block gets direct	0	0.00	0.00
db block gets from cache	997,452,811	92,317.21	3,825.00
db block gets from cache (fastpath)	778,457,640	72,048.56	2,985.20
deferred (CURRENT) block cleanout applications	142,832,813	13,219.60	547.73
dirty buffers inspected	865	0.08	0.00
enqueue conversions	68,820	6.37	0.26
enqueue releases	3,013,478	278.91	11.56
enqueue requests	3,013,530	278.91	11.56
enqueue timeouts	45	0.00	0.00
enqueue waits	17,350	1.61	0.07
execute count	622,296	57.60	2.39
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
free buffer inspected	3,100,362	286.95	11.89
free buffer requested	3,569,329	330.35	13.69
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	10	0.00	0.00
hot buffers moved to head of LRU	3,853,821	356.68	14.78
immediate (CR) block cleanout applications	0	0.00	0.00
immediate (CURRENT) block cleanout applications	10,562,443	977.59	40.50
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	5,206,615	481.89	19.97
index range scans	1,439,276	133.21	5.52
index reclamation/extension switch	3	0.00	0.00
leaf node 90-10 splits	0	0.00	0.00
leaf node splits	957,900	88.66	3.67
lob reads	0	0.00	0.00
lob writes	0	0.00	0.00
lob writes unaligned	0	0.00	0.00
logical read bytes from cache	8,301,618,765,824	768,339,370.02	31,834,778.14
logons cumulative	51,625	4.78	0.20
max cf enq hold time	0	0.00	0.00
messages sent	277,999	25.73	1.07
min active SCN optimization applied on CR	0	0.00	0.00
no work - consistent read gets	7,742,364	716.58	29.69
non-idle wait count	4,755,726	440.16	18.24
opened cursors cumulative	430,344	39.83	1.65
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	0	0.00	0.00
parse count (total)	430,364	39.83	1.65
parse time cpu	2,055	0.19	0.01
parse time elapsed	1,978	0.18	0.01
physical read IO requests	767	0.07	0.00
physical read bytes	6,283,264	581.53	24.09
physical read total IO requests	121,202	11.22	0.46
physical read total bytes	1,979,490,304	183,207.68	7,590.89
physical read total multi block requests	0	0.00	0.00
physical reads	767	0.07	0.00
physical reads cache	767	0.07	0.00
physical reads cache prefetch	0	0.00	0.00
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	0	0.00	0.00
physical write bytes	0	0.00	0.00
physical write total IO requests	0	0.00	0.00
physical write total bytes	0	0.00	0.00
physical write total multi block requests	0	0.00	0.00
physical writes	0	0.00	0.00
physical writes direct	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes non checkpoint	0	0.00	0.00
pinned buffers inspected	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	17,205	1.59	0.07
recursive calls	2,672,799	247.38	10.25
recursive cpu usage	28,049	2.60	0.11
redo buffer allocation retries	3	0.00	0.00
redo entries	241,769,716	22,376.50	927.13
redo log space requests	4	0.00	0.00
redo ordering marks	1,227	0.11	0.00
redo size	104,672,622,696	9,687,760.82	401,395.18
redo subscn max counts	1,562	0.14	0.01
redo synch long waits	0	0.00	0.00
redo synch time	30,231	2.80	0.12
redo synch time (usec)	309,316,085	28,628.12	1,186.16
redo synch time overhead (usec)	3,907,153	361.62	14.98
redo synch time overhead count ( 2ms)	250,951	23.23	0.96
redo synch time overhead count ( 8ms)	0	0.00	0.00
redo synch time overhead count (128ms)	0	0.00	0.00
redo synch time overhead count (inf)	0	0.00	0.00
redo synch writes	278,009	25.73	1.07
redo write info find	250,951	23.23	0.96
rollback changes - undo records applied	132	0.01	0.00
rollbacks only - consistent read gets	0	0.00	0.00
root node splits	3	0.00	0.00
rows fetched via callback	1,588,282	147.00	6.09
securefile bytes non-transformed	0	0.00	0.00
securefile direct read bytes	0	0.00	0.00
securefile direct read ops	0	0.00	0.00
securefile number of non-transformed flushes	0	0.00	0.00
session cursor cache hits	34,626	3.20	0.13
session logical reads	1,013,381,197	93,791.43	3,886.08
shared hash latch upgrades - no wait	21,951	2.03	0.08
shared hash latch upgrades - wait	1	0.00	0.00
shared io pool buffer get success	0	0.00	0.00
sorts (memory)	224,220	20.75	0.86
sorts (rows)	1,170,447	108.33	4.49
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
switch current caused by our pin	17,169	1.59	0.07
switch current to new buffer	17,172	1.59	0.07
table fetch by rowid	12,796,241	1,184.33	49.07
table fetch continued row	0	0.00	0.00
table scan blocks gotten	68,826	6.37	0.26
table scan disk non-IMC rows gotten	5,333,562	493.64	20.45
table scan rows gotten	5,333,562	493.64	20.45
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	34,416	3.19	0.13
total cf enq hold time	0	0.00	0.00
total number of cf enq holders	0	0.00	0.00
transaction rollbacks	64	0.01	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	31,108,223,080	2,879,158.05	119,292.80
user calls	1,089,332	100.82	4.18
user commits	260,772	24.14	1.00
user logons cumulative	17,205	1.59	0.07
user logouts cumulative	17,208	1.59	0.07
user rollbacks	0	0.00	0.00
workarea executions - optimal	241,269	22.33	0.93
write clones created in foreground	348	0.03	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
opened cursors current	9	3
session cursor cache count	9,772,829	10,134,171
session pga memory	14,224,320	4,883,664
session uga memory	336,898,926,232	349,096,386,928
session uga memory max	3,326,064,138,328	3,446,552,778,088

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Filetype summary
Tablespace IO Stats
File IO Stats

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	5M	0.11	0M	284G	1116.24	26.919M	131.81us
TOTAL:	5M	0.11	0M	284G	1116.24	26.919M	131.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

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
undo header	334	0	0

Undo Statistics

Undo Segment Summary
Undo Segment Stats

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

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 1,013,381,197
Captured Segments account for 97.2% of Total
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	Logical Reads	%Total	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_UQ	HD4G_09OCT20	INDEX PARTITION	74707	74707	89,178,096	8.80	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_UQ	HD4G_05OCT20	INDEX PARTITION	74679	74679	88,142,400	8.70	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_UQ	HD4G_06OCT20	INDEX PARTITION	74686	74686	87,561,600	8.64	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_09OCT20	INDEX PARTITION	74935	74935	48,801,456	4.82	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_05OCT20	INDEX PARTITION	74923	74923	47,760,384	4.71	PCDRDB

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 767
Captured Segments account for 100.0% of Total
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	Physical Reads	%Total	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_06OCT20	INDEX PARTITION	74685	74685	97	12.65	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_09OCT20	INDEX PARTITION	74706	74706	78	10.17	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_05OCT20	INDEX PARTITION	74678	74678	71	9.26	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMSI_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74683	74683	55	7.17	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_MSISDN_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74681	74681	51	6.65	PCDRDB

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 767
Captured Segments account for 100.0% of Total
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	Phys Read Requests	%Total	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_06OCT20	INDEX PARTITION	74685	74685	97	12.65	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_09OCT20	INDEX PARTITION	74706	74706	78	10.17	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_05OCT20	INDEX PARTITION	74678	74678	71	9.26	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMSI_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74683	74683	55	7.17	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_MSISDN_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74681	74681	51	6.65	PCDRDB

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 767
Captured Segments account for 100.0% of Total
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	UnOptimized Reads	%Total	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_06OCT20	INDEX PARTITION	74685	74685	97	12.65	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_09OCT20	INDEX PARTITION	74706	74706	78	10.17	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_E_CELL_ID_IDX	HD4G_05OCT20	INDEX PARTITION	74678	74678	71	9.26	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMSI_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74683	74683	55	7.17	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_MSISDN_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74681	74681	51	6.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

Total Physical Writes: 1
Captured Segments account for 3.2E+09% of Total
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	Physical Writes	%Total	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMSI_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74683	74683	2,725,541	272554100.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_MSISDN_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74681	74681	2,724,199	272419900.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMEI_14_IDX	HD4G_06OCT20	INDEX PARTITION	74684	74684	2,712,399	271239900.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMSI_NR_IDX	HD4G_05OCT20	INDEX PARTITION	74676	74676	2,617,165	261716500.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_MSISDN_NR_IDX	HD4G_05OCT20	INDEX PARTITION	74674	74674	2,615,763	261576300.00	PCDRDB

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requests: 1
Captured Segments account for 1.2E+09% of Total
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	Phys Write Requests	%Total	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMSI_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74683	74683	981,565	98156500.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMEI_14_IDX	HD4G_06OCT20	INDEX PARTITION	74684	74684	981,391	98139100.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_MSISDN_NR_IDX	HD4G_06OCT20	INDEX PARTITION	74681	74681	978,099	97809900.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMSI_NR_IDX	HD4G_05OCT20	INDEX PARTITION	74676	74676	967,953	96795300.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_IMEI_14_IDX	HD4G_05OCT20	INDEX PARTITION	74677	74677	965,934	96593400.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

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	DB Block Changes	% of Capture	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_09OCT20	INDEX PARTITION	74935	74935	13,120,160	5.44	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_05OCT20	INDEX PARTITION	74923	74923	12,856,688	5.33	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_06OCT20	INDEX PARTITION	74926	74926	12,692,080	5.26	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_UQ	HD4G_06OCT20	INDEX PARTITION	74686	74686	11,802,064	4.89	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_UQ	HD4G_05OCT20	INDEX PARTITION	74679	74679	11,718,512	4.86	PCDRDB

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot
When ** MISSING ** occurs, some of the object attributes may not be available

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	Row Lock Waits	% of Capture	PDB Name
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_09OCT20	INDEX PARTITION	74935	74935	56	10.98	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_05OCT20	INDEX PARTITION	74923	74923	51	10.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_UQ	HD4G_06OCT20	INDEX PARTITION	74686	74686	51	10.00	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_UQ	HD4G_09OCT20	INDEX PARTITION	74707	74707	45	8.82	PCDRDB
CDRDBUSER	CDRDB_DEFAULT_INDEX01	HD4G_COCC_UQ	HD4GCOCC_06OCT20	INDEX PARTITION	74926	74926	44	8.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

Parameters modified by this container
Parameters modified by other containers
Multi-Valued Parameters modified by this container
Multi-Valued Parameters modified by other containers

Parameters modified by this container

This section shows all the modified initialization parameters that were in effect during the entire snapshot interval
End Value is displayed only if the parameter value was modified within the snapshot interval

Parameter Name	Begin value	End value (if different)	PDB Name
sga_target	0		PCDRDB
undo_tablespace	UNDOTBS1		PCDRDB

Back to Initialization Parameters
Back to Top

Parameters modified by other containers

This section shows all the modified initialization parameters that were in effect during the snapshot interval
End Value is displayed only if the parameter value was changed within the snapshot interval

Parameter Name	Begin value	End value (if different)	PDB Name
audit_file_dest	/oracle/app/oracle/admin/cdrdb/adump
audit_trail	DB
compatible	19.0.0
control_files	+DATA/CDRDB/CONTROLFILE/current.261.1063293425, +FRA/CDRDB/CONTROLFILE/current.256.1063293427
db_block_size	8192
db_create_file_dest	+DATA
db_name	cdrdb
db_recovery_file_dest	+FRA
db_recovery_file_dest_size	13350469632
diagnostic_dest	/oracle/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=cdrdbXDB)
enable_pluggable_database	TRUE
local_listener	LISTENER_CDRDB
open_cursors	300
pga_aggregate_target	60737716224
processes	4480
remote_login_passwordfile	EXCLUSIVE
sga_target	182536110080
undo_tablespace	UNDOTBS1

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

This section only displays parameters that have more than one value
'(NULL)' indicates a missing parameter value
A blank in the 'End Snapshot' indicates the same value as the 'Begin Snapshot'

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

Back to Initialization Parameters
Back to Top

Active Session History (ASH) Report

Top SQL with Top Events
Top SQL with Top Row Sources
Top Sessions
Top Blocking Sessions
Top PL/SQL Procedures
Top Events
Top Event P1/P2/P3 Values
Top DB Objects
Activity Over Time

Top SQL with Top Events

Top SQL statements by DB Time along with the top events by DB Time for those SQLs.
% Activity is the percentage of DB Time due to the SQL.
% Event is the percentage of DB Time due to the event that the SQL is waiting on.
% Row Source is the percentage of DB Time due to the row source for the SQL waiting on the event.
Executions is the number of executions of the SQL that were sampled in ASH.

SQL ID	Plan Hash	Executions	% Activity	Event	% Event	Top Row Source	% Row Source	SQL Text	Container Name
85zarqwvf599k		231	42.49	CPU + Wait for CPU	42.49	Row Source Not Available	42.49	INSERT INTO CDRDBUSER.HD4G_TB ...	PCDRDB
0f0zjv1c0rq3q		92	16.85	CPU + Wait for CPU	16.85	Row Source Not Available	16.85	INSERT INTO CDRDBUSER.HD4G_COC...	PCDRDB
85zarqwvf599k	2447725225	53	9.71	CPU + Wait for CPU	9.71	Row Source Not Available	9.71	INSERT INTO CDRDBUSER.HD4G_TB ...	PCDRDB
fd4b9db6ju2ck	68411257	20	3.66	CPU + Wait for CPU	3.48	PX COORDINATOR	2.93	SELECT C.COLUMN_NAME FROM SYS....	PCDRDB
32vhwk4a4fh6z	2447725225	17	3.11	CPU + Wait for CPU	3.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

Top SQL statements by DB Time along with the top row sources by DB Time for those SQLs.
% Activity is the percentage of DB Time due to the SQL.
% Row Source is the percentage of DB Time spent on the row source by that SQL.
% Event is the percentage of DB Time spent on the event by the SQL executing the row source.
Executions is the number of executions of the SQL that were sampled in ASH.

SQL ID	Plan Hash	Executions	% Activity	Row Source	% Row Source	Top Event	% Event	SQL Text	Container Name
85zarqwvf599k		231	42.49	Row Source Not Available	42.49	CPU + Wait for CPU	42.49	INSERT INTO CDRDBUSER.HD4G_TB ...	PCDRDB
0f0zjv1c0rq3q		92	16.85	Row Source Not Available	16.85	CPU + Wait for CPU	16.85	INSERT INTO CDRDBUSER.HD4G_COC...	PCDRDB
85zarqwvf599k	2447725225	53	9.71	Row Source Not Available	9.71	CPU + Wait for CPU	9.71	INSERT INTO CDRDBUSER.HD4G_TB ...	PCDRDB
fd4b9db6ju2ck	68411257	20	3.66	PX COORDINATOR	3.11	CPU + Wait for CPU	2.93	SELECT C.COLUMN_NAME FROM SYS....	PCDRDB
32vhwk4a4fh6z	2447725225	17	3.11	Row Source Not Available	3.11	CPU + Wait for CPU	3.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 session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only
'% Activity' represents the load on the database caused by a particular blocking session
'# Samples Active' shows the number of ASH samples in which the blocking session was found active.
'XIDs' shows the number of distinct transaction IDs sampled in ASH when the blocking session was found active.

Blocking Sid (Inst)	% Activity	Event Caused	% Event	User	Program	# Samples Active	XIDs
3147,42395( 1)	6.59	log file sync	6.59	NOT FOUND	BLOCKING SESSION NOT FOUND	0/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

Top Events by DB Time
% Activity is the percentage of DB Time due to the event

Event	Event Class	Session Type	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	FOREGROUND	90.66	0.46
log file sync	Commit	FOREGROUND	6.59	0.03
CPU + Wait for CPU	CPU	BACKGROUND	1.28	0.01
control file sequential read	System I/O	FOREGROUND	1.28205128205128205128205128205128205128	0.01

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

Top Event P1/P2/P3 Values

Top Events by DB Time and the top P1/P2/P3 values for those events.
% Event is the percentage of DB Time due to the event
% Activity is the percentage of DB Time due to the event with the given P1,P2,P3 Values.

Event	% Event	P1, P2, P3 Values	% Activity	Parameter 1	Parameter 2	Parameter 3
log file sync	6.59	"12434","63413006","0"	0.18	buffer#	sync scn	NOT DEFINED
control file sequential read	1.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

Analysis period is divided into smaller time slots as indicated in the 'Slot Time (Duration)'.
Top 3 events are reported in each of those slots
'Slot Count' shows the number of ASH samples in that slot
'Event Count' shows the number of ASH samples waiting for that event in that slot
'% Event' is 'Event Count' over all ASH samples in the analysis period

Slot Time (Duration)	Slot Count	Event	Event Count	% Event
17:00:09 (19.9 min)	68	CPU + Wait for CPU	65	11.90
17:00:09 (19.9 min)	68	log file sync	2	0.37
17:00:09 (19.9 min)	68	control file sequential read	1	0.18
17:20:00 (20.0 min)	48	CPU + Wait for CPU	45	8.24
17:20:00 (20.0 min)	48	log file sync	3	0.55
17:40:00 (20.0 min)	77	CPU + Wait for CPU	69	12.64
17:40:00 (20.0 min)	77	log file sync	8	1.47
18:00:00 (20.0 min)	65	CPU + Wait for CPU	58	10.62
18:00:00 (20.0 min)	65	log file sync	6	1.10
18:00:00 (20.0 min)	65	control file sequential read	1	0.18
18:20:00 (20.0 min)	57	CPU + Wait for CPU	52	9.52
18:20:00 (20.0 min)	57	control file sequential read	2	0.37
18:20:00 (20.0 min)	57	log file sync	2	0.37
18:40:00 (20.0 min)	63	CPU + Wait for CPU	58	10.62
18:40:00 (20.0 min)	63	log file sync	5	0.92
19:00:00 (20.0 min)	56	CPU + Wait for CPU	51	9.34
19:00:00 (20.0 min)	56	log file sync	5	0.92
19:20:00 (20.0 min)	55	CPU + Wait for CPU	50	9.16
19:20:00 (20.0 min)	55	log file sync	4	0.73
19:20:00 (20.0 min)	55	control file sequential read	1	0.18
19:40:00 (20.0 min)	56	CPU + Wait for CPU	53	9.71
19:40:00 (20.0 min)	56	control file sequential read	2	0.37
19:40:00 (20.0 min)	56	log file sync	1	0.18
20:00:00 (14 secs)	1	CPU + Wait for CPU	1	0.18

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

End of Report