WORKLOAD REPOSITORY PDB report (PDB snapshots)

DB Name DB Id Unique Name Role Edition Release RAC CDB

ORCL 2023258078 ORCL PRIMARY EE 12.2.0.1.0 NO NO

DB Name	DB Id	Unique Name	Role	Edition	Release	RAC	CDB
ORCL	2023258078	ORCL	PRIMARY	EE	12.2.0.1.0	NO	NO

Instance Inst Num Startup Time

ORCL 1 03-Mar-17 08:03

Instance	Inst Num	Startup Time
ORCL	1	03-Mar-17 08:03

PDB Name PDB Id PDB DB Id Open Time

PDB1 3 2023258078 03-Mar-17 08:03

PDB Name	PDB Id	PDB DB Id	Open Time
PDB1	3	2023258078	03-Mar-17 08:03

Host Name Platform CPUs Cores Sockets Memory (GB)

dbconnectJ.XXXXXXXXXXXXXXX.oraclecloud.internal Linux x86 64-bit 4 4 1 14.44

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dbconnectJ.XXXXXXXXXXXXXXX.oraclecloud.internal	Linux x86 64-bit	4	4	1	14.44

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 204 03-Mar-17 17:31:09 43 1.5

End Snap: 205 03-Mar-17 17:34:24 9 3.3

Elapsed: 3.24 (mins)

DB Time: 62.01 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	204	03-Mar-17 17:31:09	43	1.5
End Snap:	205	03-Mar-17 17:34:24	9	3.3
Elapsed:		3.24 (mins)
DB Time:		62.01 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 19.2 0.4 0.08 0.04

DB CPU(s): 3.1 0.1 0.01 0.01

Background CPU(s): 0.0 0.0 0.00 0.00

Redo size (bytes): 82,364.6 1,726.1

Logical read (blocks): 126,603.2 2,653.2

Block changes: 551.3 11.6

Physical read (blocks): 124,699.4 2,613.3

Physical write (blocks): 0.0 0.0

Read IO requests: 1,323.5 27.7

Write IO requests: 0.0 0.0

Read IO (MB): 974.2 20.4

Write IO (MB): 0.0 0.0

IM scan rows: 0.0 0.0

Session Logical Read IM: 0.0 0.0

User calls: 472.3 9.9

Parses (SQL): 208.0 4.4

Hard parses (SQL): 1.6 0.0

SQL Work Area (MB): 34.1 0.7

Logons: 8.4 0.2

Executes (SQL): 240.7 5.1

Rollbacks: 0.0 0.0

Transactions: 47.7

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	19.2	0.4	0.08	0.04
DB CPU(s):	3.1	0.1	0.01	0.01
Background CPU(s):	0.0	0.0	0.00	0.00
Redo size (bytes):	82,364.6	1,726.1
Logical read (blocks):	126,603.2	2,653.2
Block changes:	551.3	11.6
Physical read (blocks):	124,699.4	2,613.3
Physical write (blocks):	0.0	0.0
Read IO requests:	1,323.5	27.7
Write IO requests:	0.0	0.0
Read IO (MB):	974.2	20.4
Write IO (MB):	0.0	0.0
IM scan rows:	0.0	0.0
Session Logical Read IM:	0.0	0.0
User calls:	472.3	9.9
Parses (SQL):	208.0	4.4
Hard parses (SQL):	1.6	0.0
SQL Work Area (MB):	34.1	0.7
Logons:	8.4	0.2
Executes (SQL):	240.7	5.1
Rollbacks:	0.0	0.0
Transactions:	47.7

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Avg Wait	% DB time	Wait Class
direct path read	135,343	1505.5	11.12ms	40.5	User I/O
db file sequential read	60,811	687	11.30ms	18.5	User I/O
DB CPU		595.3		16.0
log file sync	9,292	349.7	37.64ms	9.4	Commit
cursor: pin S wait on X	266	55.5	208.74ms	1.5	Concurrency
PX Deq: Slave Session Stats	3,328	4.1	1.24ms	.1	Other
library cache lock	8	1.4	180.98ms	.0	Concurrency
kksfbc child completion	12	.6	49.41ms	.0	Other
PX Deq: Join ACK	3,077	.5	166.87us	.0	Other
latch free	701	.5	694.40us	.0	Other

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait Time	% DB time	Avg Active Sessions
User I/O	196,395	2,193	11.17ms	58.9	11.3
DB CPU		595		16.0	3.1
Commit	9,292	350	37.64ms	9.4	1.8
Concurrency	886	58	65.28ms	1.6	0.3
Other	27,672	7	236.71us	.2	0.0
System I/O	156	1	8.80ms	.0	0.0
Network	46,524	0	2.36us	.0	0.0

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 1,324.3 1,324.2 0.0

Database Requests: 1,323.5 1,323.5 0.0

Optimized Requests: 0.0 0.0 0.0

Redo Requests:

Total (MB): 974.4 974.4 0.0

Database (MB): 974.2 974.2 0.0

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB):

Database (blocks): 124,699.4 124,699.4 0.0

Via Buffer Cache (blocks): 318.3 318.3 0.0

Direct (blocks): 124,381.1 124,381.1 0.0

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	1,324.3	1,324.2	0.0
Database Requests:	1,323.5	1,323.5	0.0
Optimized Requests:	0.0	0.0	0.0
Redo Requests:
Total (MB):	974.4	974.4	0.0
Database (MB):	974.2	974.2	0.0
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):
Database (blocks):	124,699.4	124,699.4	0.0
Via Buffer Cache (blocks):	318.3	318.3	0.0
Direct (blocks):	124,381.1	124,381.1	0.0

Wait Events Statistics

Time Model Statistics
Foreground Wait Class
Foreground Wait Events
Service Statistics
Service Wait Class Stats

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
sql execute elapsed time	3,288.94	88.39
DB CPU	595.34	16.00	100.00
Tablespace encryption elapsed time	217.52	5.85
Tablespace encryption cpu time	105.97	2.85	17.80
parse time elapsed	68.98	1.85
hard parse elapsed time	9.92	0.27
hard parse (sharing criteria) elapsed time	4.85	0.13
PL/SQL execution elapsed time	0.23	0.01
PL/SQL compilation elapsed time	0.06	0.00
connection management call elapsed time	0.02	0.00
repeated bind elapsed time	0.01	0.00
DB time	3,720.79
total CPU time	595.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 86.1% of Total DB time 3,720.79 (s)
Total FG Wait Time: 2,607.27 (s) DB CPU time: 595.34 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait	%DB time
User I/O	196,205	0	2,193	11.18ms	58.93
DB CPU			595		16.00
Commit	9,292	0	350	37.64ms	9.40
Concurrency	832	0	58	69.45ms	1.55
Other	27,667	37	7	236.76us	0.18
System I/O	104	0	0	4.18ms	0.01
Network	46,524	0	0	2.36us	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
direct path read	135,343		1,505	11.12ms	14.61	40.46
db file sequential read	60,811		687	11.30ms	6.57	18.46
log file sync	9,292		350	37.64ms	1.00	9.40
cursor: pin S wait on X	266		56	208.74ms	0.03	1.49
PX Deq: Slave Session Stats	3,328		4	1.24ms	0.36	0.11
library cache lock	8		1	180.98ms	0.00	0.04
kksfbc child completion	12	100	1	49.41ms	0.00	0.02
PX Deq: Join ACK	3,077		1	166.87us	0.33	0.01
latch free	701		0	694.40us	0.08	0.01
control file sequential read	104		0	4.18ms	0.01	0.01
enq: KV - IMA key vector access	344		0	1.13ms	0.04	0.01
PGA memory operation	8,178		0	44.33us	0.88	0.01
library cache: mutex X	97		0	2.63ms	0.01	0.01
PX qref latch	10,258	100	0	15.67us	1.11	0.00
PX Deq: Signal ACK EXT	1,664		0	96.52us	0.18	0.00
latch: shared pool	85		0	1.51ms	0.01	0.00
db file scattered read	42		0	2.91ms	0.00	0.00
SQL*Net message to client	46,524		0	2.36us	5.02	0.00
latch: enqueue hash chains	28		0	3.01ms	0.00	0.00
latch: undo global data	5		0	7.00ms	0.00	0.00
enq: PS - contention	117		0	286.13us	0.01	0.00
library cache: bucket mutex X	6		0	2.63ms	0.00	0.00
cursor: mutex S	7		0	1.47ms	0.00	0.00
cursor: pin S	6		0	1.20ms	0.00	0.00
cursor: mutex X	1		0	6.71ms	0.00	0.00
latch: active service list	6		0	551.17us	0.00	0.00
Disk file operations I/O	9		0	325.56us	0.00	0.00
latch: call allocation	11		0	192.09us	0.00	0.00
latch: object queue header operation	1		0	1.84ms	0.00	0.00
PX Deq: Execution Msg	23,246		2,794	120.20ms	2.51
SQL*Net message from client	46,548		662	14.22ms	5.03
PX Deq: Execute Reply	24,497		335	13.69ms	2.64
PX Deq: Parse Reply	1,632		5	2.88ms	0.18
PX Deq: Table Q Normal	13,526		3	233.07us	1.46
PX Deq Credit: send blkd	3,118		1	312.22us	0.34
PX Deq Credit: need buffer	117		0	495.49us	0.01

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)
pdb1.XXXXXXXX.oraclecloud.internal	3,643	582	23,670	24,035

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
pdb1.XXXXXXXX.oraclecloud.internal	191934	2135	832	58	0	0	45815	0

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 50.6% of Total DB Time (s): 3,721
Captured PL/SQL account for 0.1% of Total DB Time (s): 3,721

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,221.51	0		32.83	21.14	55.68	cvzdzp00jap4v	SQL*Plus	SELECT SUM(amount_sold), t.cal...
196.41	8,924	0.02	5.28	1.55	98.85	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
175.23	8,924	0.02	4.71	1.58	98.74	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
156.01	8,923	0.02	4.19	2.21	98.19	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
131.63	8,925	0.01	3.54	1.88	98.41	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
2.05	1	2.05	0.06	53.39	33.36	btqubgr940awu	sqlplus@dbconnectJ.XXXXXXXXXXXXXXXXX.oracleclo	BEGIN dbms_workload_repository...
0.85	1	0.85	0.02	97.44	0.35	7n3tj1q2zfmq2		insert into wrh$_mvparameter (...
0.38	498	0.00	0.01	12.47	90.42	2sxqgx5hx76qr		select /+ rule / bucket, end...
0.33	2	0.17	0.01	16.13	75.30	d1740uhzzmz1j		select s.file#, s.block#, s.t...
0.28	1	0.28	0.01	8.85	79.02	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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 45.6% of Total CPU Time (s): 595
Captured PL/SQL account for 0.2% of Total CPU Time (s): 595

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
258.22	0		43.37	1,221.51	21.14	55.68	cvzdzp00jap4v	SQL*Plus	SELECT SUM(amount_sold), t.cal...
3.44	8,923	0.00	0.58	156.01	2.21	98.19	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
3.04	8,924	0.00	0.51	196.41	1.55	98.85	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
2.78	8,924	0.00	0.47	175.23	1.58	98.74	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
2.48	8,925	0.00	0.42	131.63	1.88	98.41	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
1.10	1	1.10	0.18	2.05	53.39	33.36	btqubgr940awu	sqlplus@dbconnectJ.XXXXXXXXXXXXXXXXX.oracleclo	BEGIN dbms_workload_repository...
0.83	1	0.83	0.14	0.85	97.44	0.35	7n3tj1q2zfmq2		insert into wrh$_mvparameter (...
0.06	2,065	0.00	0.01	0.16	38.52	65.24	0sbbcuruzd66f		select /+ rule / bucket_cnt,...
0.05	2	0.03	0.01	0.33	16.13	75.30	d1740uhzzmz1j		select s.file#, s.block#, s.t...
0.05	1	0.05	0.01	0.09	60.48	17.10	gnyk3hbabn28r		insert into wrh$_tablespace_st...

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 60.7% of Total User I/O Wait Time (s): 2,193
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 2,193

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
680.17	0		31.01	1,221.51	21.14	55.68	cvzdzp00jap4v	SQL*Plus	SELECT SUM(amount_sold), t.cal...
194.15	8,924	0.02	8.85	196.41	1.55	98.85	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
173.03	8,924	0.02	7.89	175.23	1.58	98.74	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
153.18	8,923	0.02	6.98	156.01	2.21	98.19	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
129.53	8,925	0.01	5.91	131.63	1.88	98.41	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
0.68	1	0.68	0.03	2.05	53.39	33.36	btqubgr940awu	sqlplus@dbconnectJ.XXXXXXXXXXXXXXXXX.oracleclo	BEGIN dbms_workload_repository...
0.34	498	0.00	0.02	0.38	12.47	90.42	2sxqgx5hx76qr		select /+ rule / bucket, end...
0.25	2	0.13	0.01	0.33	16.13	75.30	d1740uhzzmz1j		select s.file#, s.block#, s.t...
0.22	1	0.22	0.01	0.28	8.85	79.02	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.18	37	0.00	0.01	0.19	4.68	95.81	3un99a0zwp4vd		select owner#, name, namespace...

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: 24,574,188
Captured SQL account for 46.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
11,085,873	0		45.11	1,221.51	21.1	55.7	cvzdzp00jap4v	SQL*Plus	SELECT SUM(amount_sold), t.cal...
66,726	8,923	7.48	0.27	156.01	2.2	98.2	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
53,624	8,924	6.01	0.22	196.41	1.5	98.9	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
51,308	8,924	5.75	0.21	175.23	1.6	98.7	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
47,110	8,925	5.28	0.19	131.63	1.9	98.4	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
19,905	1	19,905.00	0.08	2.05	53.4	33.4	btqubgr940awu	sqlplus@dbconnectJ.XXXXXXXXXXXXXXXXX.oracleclo	BEGIN dbms_workload_repository...
6,226	2,065	3.02	0.03	0.16	38.5	65.2	0sbbcuruzd66f		select /+ rule / bucket_cnt,...
2,952	984	3.00	0.01	0.05	38.7	0	9tgj4g8y4rwy8		select type#, blocks, extents,...
1,970	2	985.00	0.01	0.33	16.1	75.3	d1740uhzzmz1j		select s.file#, s.block#, s.t...
1,676	498	3.37	0.01	0.38	12.5	90.4	2sxqgx5hx76qr		select /+ rule / bucket, end...

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: 24,204,655
Captured SQL account for 45.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
11,016,414	0		45.51	1,221.51	21.14	55.68	cvzdzp00jap4v	SQL*Plus	SELECT SUM(amount_sold), t.cal...
17,459	8,924	1.96	0.07	196.41	1.55	98.85	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
15,082	8,924	1.69	0.06	175.23	1.58	98.74	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
12,821	8,923	1.44	0.05	156.01	2.21	98.19	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
12,123	8,925	1.36	0.05	131.63	1.88	98.41	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
426	1	426.00	0.00	2.05	53.39	33.36	btqubgr940awu	sqlplus@dbconnectJ.XXXXXXXXXXXXXXXXX.oracleclo	BEGIN dbms_workload_repository...
111	498	0.22	0.00	0.38	12.47	90.42	2sxqgx5hx76qr		select /+ rule / bucket, end...
47	2,065	0.02	0.00	0.16	38.52	65.24	0sbbcuruzd66f		select /+ rule / bucket_cnt,...
46	26	1.77	0.00	0.03	43.61	69.77	c3zymn7x3k6wy		select obj#, dataobj#, part#, ...
43	26	1.65	0.00	0.03	65.53	67.54	adds4wma0y8c4		select t.obj#, t.dataobj#, t.p...

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: 256,904
Captured SQL account for 22.6% of Total
Total UnOptimized Read Requests: 256,904
Captured SQL account for 22.6% 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	%Total	SQL Id	SQL Module	SQL Text
17,459	17,459	8,924	1.96	6.80	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
15,082	15,082	8,924	1.69	5.87	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
12,824	12,824	8,923	1.44	4.99	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
12,124	12,124	8,925	1.36	4.72	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
436	436	1	436.00	0.17	btqubgr940awu	sqlplus@dbconnectJ.XXXXXXXXXXXXXXXXX.oracleclo	BEGIN dbms_workload_repository...
111	111	498	0.22	0.04	2sxqgx5hx76qr		select /+ rule / bucket, end...
63	63	1	63.00	0.02	gnyk3hbabn28r		insert into wrh$_tablespace_st...
47	47	2,065	0.02	0.02	0sbbcuruzd66f		select /+ rule / bucket_cnt,...
46	46	26	1.77	0.02	c3zymn7x3k6wy		select obj#, dataobj#, part#, ...
43	43	26	1.65	0.02	adds4wma0y8c4		select t.obj#, t.dataobj#, t.p...

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: 46,729
Captured SQL account for 89.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
8,925	8,925	1.00	131.63	1.9	98.4	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
8,924	8,924	1.00	175.23	1.6	98.7	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
8,924	8,924	1.00	196.41	1.5	98.9	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
8,923	8,923	1.00	156.01	2.2	98.2	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
2,065	2,008	0.97	0.16	38.5	65.2	0sbbcuruzd66f		select /+ rule / bucket_cnt,...
984	984	1.00	0.05	38.7	0	9tgj4g8y4rwy8		select type#, blocks, extents,...
769	58	0.08	0.04	56.1	49.8	87gaftwrm2h68		select o.owner#, o.name, o.nam...
498	7,530	15.12	0.38	12.5	90.4	2sxqgx5hx76qr		select /+ rule / bucket, end...
256	0	0.00	0.03	23.4	0	0b639nx4zdzxr		select domain# from sys.im_dom...
225	107	0.48	0.01	64.3	0	asvzxj61dc5vs		select timestamp, flags from f...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 40,365
Captured SQL account for 93.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
8,924	8,924	22.11	074808uwja6ju	Swingbench User Thread	update stressTestTable set abi...
8,924	8,925	22.11	78thn3afd414y	Swingbench User Thread	update stressTestTable set ain...
8,922	8,924	22.10	4fdqbmxywh33t	Swingbench User Thread	update stressTestTable set abi...
8,855	8,923	21.94	39sc3dh4841x8	Swingbench User Thread	update stressTestTable set abi...
768	0	1.90	cvzdzp00jap4v	SQL*Plus	SELECT SUM(amount_sold), t.cal...
256	256	0.63	0b639nx4zdzxr		select domain# from sys.im_dom...
225	225	0.56	asvzxj61dc5vs		select timestamp, flags from f...
112	112	0.28	300nk5dz6augc		SELECT /* OPT_DYN_SAMP / /+ ...
102	102	0.25	afx304d90ps3z		select rowcnt, blkcnt, empcnt,...
96	96	0.24	b6tu2v5fyvtt0		SELECT /* OPT_DYN_SAMP / /+ ...

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	SQL Text
2,212,776	0	1.95	cvzdzp00jap4v	SQL*Plus	SELECT SUM(amount_sold), t.cal...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

074808uwja6ju update stressTestTable set abigchar1 = abigvarchar where id = :1

0b639nx4zdzxr select domain# from sys.im_domain$ where objn = :1 and col# = :2

0sbbcuruzd66f select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln, minimum_enc, maximum_enc from hist_head$ where obj#=:1 and intcol#=:2

2sxqgx5hx76qr select /*+ rule */ bucket, endpoint, col#, epvalue, epvalue_raw, ep_repeat_count, endpoint_enc from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

300nk5dz6augc SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("T") FULL("T") NO_PARALLEL_INDEX("T") */ :"SYS_B_2" AS C1, CASE WHEN "T"."CALENDAR_YEAR"=:"SYS_B_3" AND "T"."CALENDAR_WEEK_NUMBER"=:"SYS_B_4" THEN :"SYS_B_5" ELSE :"SYS_B_6" END AS C2 FROM "SH"."TIMES" SAMPLE BLOCK (:"SYS_B_7" , :"SYS_B_8") SEED (:"SYS_B_9") "T") SAMPLESUB

39sc3dh4841x8 update stressTestTable set abigchar0 = abigvarchar where id = :1

3un99a0zwp4vd select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, flags, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

4fdqbmxywh33t update stressTestTable set abigchar2 = abigvarchar where id = :1

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

78thn3afd414y update stressTestTable set aint = aint + 1 where id = :1

7n3tj1q2zfmq2 insert into wrh$_mvparameter (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, ordinal, value, isdefault, ismodified) select :dbid, sv.con_id, con_id_to_dbid(sv.con_id) con_dbid, :snap_id, :instance_number, p.hash, sv.ordinal, substr(sv.value, 1, 512), sv.isdefault, case when sv.ismodified <> 'FALSE' or sv.isadjusted <> 'FALSE' then 'MODIFIED' else 'FALSE' end from v$system_parameter2 sv, v$system_parameter p where exists (select 1 from v$system_parameter4 i where i.num = sv.num and bitand(i.param_flag, 32) = 32) and p.num = sv.num

87gaftwrm2h68 select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

adds4wma0y8c4 select t.obj#, t.dataobj#, t.part#, t.hiboundlen, t.hiboundval, t.ts#, t.file#, t.block#, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.flags, t.analyzetime, t.samplesize, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, length(t.bhiboundval), t.bhiboundval, ts.im_imcu_count, ts.im_block_count, ts.im_sys_incarnation, ts.im_stat_update_time from tabpart$ t, tab_stats$ ts where t.bo# = :1 and t.obj# = ts.obj#(+) order by t.part#

afx304d90ps3z select rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, analyzetime, samplesize, avgspc_flb, flbcnt, flags from tab_stats$ where obj#=:1

asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1

b6tu2v5fyvtt0 SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("T") FULL("T") NO_PARALLEL_INDEX("T") */ :"SYS_B_2" AS C1, CASE WHEN "T"."CALENDAR_WEEK_NUMBER"=:"SYS_B_3" AND "T"."CALENDAR_YEAR"=:"SYS_B_4" THEN :"SYS_B_5" ELSE :"SYS_B_6" END AS C2 FROM "SH"."TIMES" SAMPLE BLOCK (:"SYS_B_7" , :"SYS_B_8") SEED (:"SYS_B_9") "T") SAMPLESUB

btqubgr940awu BEGIN dbms_workload_repository.create_snapshot(); END;

c3zymn7x3k6wy select obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval from indpart$ where bo# = :1 order by part#

cvzdzp00jap4v SELECT SUM(amount_sold), t.calendar_year, t.calendar_week_number, c.country_name FROM sales s, times t, countries c, customers cu WHERE s.time_id = t.time_id AND t.calendar_week_number = '15' AND t.calendar_year = '2008' AND cu.country_id = c.country_id AND s.cust_id = cu.cust_id AND c.country_iso_code = 'JP' GROUP BY t.calendar_year, t.calendar_week_number, c.country_name

d1740uhzzmz1j select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, bitand(s.spare1, 61572651155456), t.kernelcols, s.blocks, t.obj#, s.user# from tab$ t, seg$ s where bitand(s.spare1, 61572651155456) <= 52776558133248 and bitand(s.spare1, 61572651155456) >= 8796093022208 and bitand(s.spare1, 4294967296) = 4294967296 and bitand(s.spare1, 65536) <> 65536 and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# UNION select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, bitand(s.spare1, 61572651155456), tab.kernelcols, s.blocks, tab.obj#, s.user# from tabpart$ t, seg$ s, tab$ tab where bitand(s.spare1, 61572651155456) <= 52776558133248 and bitand(s.spare1, 61572651155456) >= 8796093022208 and bitand(s.spare1, 4294967296) = 4294967296 and bitand(s.spare1, 65536) <> 65536 and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# and tab.obj# = t.bo# UNION select /*+ ordered */ s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, bitand(s.spare1, 61572651155456), tab.kernelcols, s.blocks, tab.obj#, s.user# from tabsubpart$ t, seg$ s, tab$ tab, tabcompart$ tcp where bitand(s.spare1, 61572651155456) <= 52776558133248 and bitand(s.spare1, 61572651155456) >= 8796093022208 and bitand(s.spare1, 4294967296) = 4294967296 and bitand(s.spare1, 65536) <> 65536 and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# and t.pobj# = tcp.obj# and tab.obj# = tcp.bo# order by 6 desc

gnyk3hbabn28r insert into wrh$_tablespace_stat (dbid, per_pdb, con_dbid, snap_id, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select /*+ opt_param('_optimizer_mjc_enabled', 'false') */ :dbid, b.con_id, b.con_dbid, :snap_id, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup FROM awri$_cdb_ts$ ts, (select bkup.con_id, con_id_to_dbid(bkup.con_id) con_dbid, dfile.ts#, sum( case when bk up.status = 'ACTIVE' then 1 else 0 end ) as active_count FROM v$backup bkup, v$datafile dfile WHERE (1 = 1) AND ((bkup.con_id = dfile.con_id)) and bkup.file# = dfile.file# and dfile.status in ('ONLINE', 'SYSTEM') group by bkup.con_id, dfile.ts#) b WHERE (1 = 1) AND ((ts.con_id = b.con_id)) and ts.online$ != 3 and b.ts# = ts.ts# and bitand(ts.flags, 2048) != 2048

SQL Id	SQL Text
074808uwja6ju	update stressTestTable set abigchar1 = abigvarchar where id = :1
0b639nx4zdzxr	select domain# from sys.im_domain$ where objn = :1 and col# = :2
0sbbcuruzd66f	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln, minimum_enc, maximum_enc from hist_head$ where obj#=:1 and intcol#=:2
2sxqgx5hx76qr	select /+ rule / bucket, endpoint, col#, epvalue, epvalue_raw, ep_repeat_count, endpoint_enc from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
300nk5dz6augc	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ IGNORE_WHERE_CLAUSE NO_PARALLEL("T") FULL("T") NO_PARALLEL_INDEX("T") */ :"SYS_B_2" AS C1, CASE WHEN "T"."CALENDAR_YEAR"=:"SYS_B_3" AND "T"."CALENDAR_WEEK_NUMBER"=:"SYS_B_4" THEN :"SYS_B_5" ELSE :"SYS_B_6" END AS C2 FROM "SH"."TIMES" SAMPLE BLOCK (:"SYS_B_7" , :"SYS_B_8") SEED (:"SYS_B_9") "T") SAMPLESUB
39sc3dh4841x8	update stressTestTable set abigchar0 = abigvarchar where id = :1
3un99a0zwp4vd	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, flags, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4fdqbmxywh33t	update stressTestTable set abigchar2 = abigvarchar where id = :1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
78thn3afd414y	update stressTestTable set aint = aint + 1 where id = :1
7n3tj1q2zfmq2	insert into wrh$_mvparameter (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, ordinal, value, isdefault, ismodified) select :dbid, sv.con_id, con_id_to_dbid(sv.con_id) con_dbid, :snap_id, :instance_number, p.hash, sv.ordinal, substr(sv.value, 1, 512), sv.isdefault, case when sv.ismodified <> 'FALSE' or sv.isadjusted <> 'FALSE' then 'MODIFIED' else 'FALSE' end from v$system_parameter2 sv, v$system_parameter p where exists (select 1 from v$system_parameter4 i where i.num = sv.num and bitand(i.param_flag, 32) = 32) and p.num = sv.num
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
adds4wma0y8c4	select t.obj#, t.dataobj#, t.part#, t.hiboundlen, t.hiboundval, t.ts#, t.file#, t.block#, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.flags, t.analyzetime, t.samplesize, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, length(t.bhiboundval), t.bhiboundval, ts.im_imcu_count, ts.im_block_count, ts.im_sys_incarnation, ts.im_stat_update_time from tabpart$ t, tab_stats$ ts where t.bo# = :1 and t.obj# = ts.obj#(+) order by t.part#
afx304d90ps3z	select rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, analyzetime, samplesize, avgspc_flb, flbcnt, flags from tab_stats$ where obj#=:1
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
b6tu2v5fyvtt0	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ IGNORE_WHERE_CLAUSE NO_PARALLEL("T") FULL("T") NO_PARALLEL_INDEX("T") */ :"SYS_B_2" AS C1, CASE WHEN "T"."CALENDAR_WEEK_NUMBER"=:"SYS_B_3" AND "T"."CALENDAR_YEAR"=:"SYS_B_4" THEN :"SYS_B_5" ELSE :"SYS_B_6" END AS C2 FROM "SH"."TIMES" SAMPLE BLOCK (:"SYS_B_7" , :"SYS_B_8") SEED (:"SYS_B_9") "T") SAMPLESUB
btqubgr940awu	BEGIN dbms_workload_repository.create_snapshot(); END;
c3zymn7x3k6wy	select obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval from indpart$ where bo# = :1 order by part#
cvzdzp00jap4v	SELECT SUM(amount_sold), t.calendar_year, t.calendar_week_number, c.country_name FROM sales s, times t, countries c, customers cu WHERE s.time_id = t.time_id AND t.calendar_week_number = '15' AND t.calendar_year = '2008' AND cu.country_id = c.country_id AND s.cust_id = cu.cust_id AND c.country_iso_code = 'JP' GROUP BY t.calendar_year, t.calendar_week_number, c.country_name
d1740uhzzmz1j	select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, bitand(s.spare1, 61572651155456), t.kernelcols, s.blocks, t.obj#, s.user# from tab$ t, seg$ s where bitand(s.spare1, 61572651155456) <= 52776558133248 and bitand(s.spare1, 61572651155456) >= 8796093022208 and bitand(s.spare1, 4294967296) = 4294967296 and bitand(s.spare1, 65536) <> 65536 and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# UNION select s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, bitand(s.spare1, 61572651155456), tab.kernelcols, s.blocks, tab.obj#, s.user# from tabpart$ t, seg$ s, tab$ tab where bitand(s.spare1, 61572651155456) <= 52776558133248 and bitand(s.spare1, 61572651155456) >= 8796093022208 and bitand(s.spare1, 4294967296) = 4294967296 and bitand(s.spare1, 65536) <> 65536 and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# and tab.obj# = t.bo# UNION select /+ ordered / s.file#, s.block#, s.ts#, t.obj#, s.hwmincr, bitand(s.spare1, 61572651155456), tab.kernelcols, s.blocks, tab.obj#, s.user# from tabsubpart$ t, seg$ s, tab$ tab, tabcompart$ tcp where bitand(s.spare1, 61572651155456) <= 52776558133248 and bitand(s.spare1, 61572651155456) >= 8796093022208 and bitand(s.spare1, 4294967296) = 4294967296 and bitand(s.spare1, 65536) <> 65536 and s.file# = t.file# and s.ts# = t.ts# and s.block# = t.block# and t.pobj# = tcp.obj# and tab.obj# = tcp.bo# order by 6 desc
gnyk3hbabn28r	insert into wrh$_tablespace_stat (dbid, per_pdb, con_dbid, snap_id, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select /+ opt_param('_optimizer_mjc_enabled', 'false') / :dbid, b.con_id, b.con_dbid, :snap_id, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup FROM awri$_cdb_ts$ ts, (select bkup.con_id, con_id_to_dbid(bkup.con_id) con_dbid, dfile.ts#, sum( case when bk up.status = 'ACTIVE' then 1 else 0 end ) as active_count FROM v$backup bkup, v$datafile dfile WHERE (1 = 1) AND ((bkup.con_id = dfile.con_id)) and bkup.file# = dfile.file# and dfile.status in ('ONLINE', 'SYSTEM') group by bkup.con_id, dfile.ts#) b WHERE (1 = 1) AND ((ts.con_id = b.con_id)) and ts.online$ != 3 and b.ts# = ts.ts# and bitand(ts.flags, 2048) != 2048

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	107,008	551.29	11.55
execute count	46,729	240.74	5.05
logons cumulative	1,632	8.41	0.18
opened cursors cumulative	46,683	240.51	5.04
parse count (total)	40,365	207.96	4.36
parse time elapsed	6,629	34.15	0.72
physical reads	24,204,655	124,699.41	2,613.33
physical writes	1	0.01	0.00
redo size	15,987,288	82,364.55	1,726.12
session cursor cache hits	44,517	229.35	4.81
session logical reads	24,574,188	126,603.20	2,653.23
user calls	91,684	472.34	9.90
user commits	9,262	47.72	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	1,009	5.20	0.11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
ASSM bg: segment fix monitor	0	0.00	0.00
ASSM cbk:blocks examined	283	1.46	0.03
ASSM cbk:blocks marked full	69	0.36	0.01
ASSM gsp:L1 bitmaps examined	231	1.19	0.02
ASSM gsp:L2 bitmap full	1	0.01	0.00
ASSM gsp:L2 bitmaps examined	159	0.82	0.02
ASSM gsp:Optimized reject DB	1	0.01	0.00
ASSM gsp:Search all	6	0.03	0.00
ASSM gsp:Search hint	5	0.03	0.00
ASSM gsp:Search steal	6	0.03	0.00
ASSM gsp:bump HWM	6	0.03	0.00
ASSM gsp:get free block	213	1.10	0.02
ASSM gsp:good hint	165	0.85	0.02
ASSM gsp:reject db	1	0.01	0.00
ASSM rsv:fill reserve	5	0.03	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 slow jump 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	9	0.05	0.00
CCursor + sql area evicted	262	1.35	0.03
CPU used by this session	59,319	305.60	6.40
CPU used when call started	59,358	305.81	6.41
CR blocks created	13	0.07	0.00
Cached Commit SCN referenced	24,140,993	124,371.43	2,606.46
Commit SCN cached	544	2.80	0.06
DFO trees parallelized	102	0.53	0.01
Effective IO time	1,493,323,763	7,693,420.86	161,231.24
HCC analyzer calls	0	0.00	0.00
HSC Heap Segment Block Changes	41,201	212.26	4.45
Heap Segment Array Inserts	99	0.51	0.01
Heap Segment Array Updates	4	0.02	0.00
Heatmap Blklevel Flush Task Count	0	0.00	0.00
IM populate buffer direct read time (ms)	0	0.00	0.00
IM populate checkpoint time (ms)	0	0.00	0.00
IM populate direct read time (ms)	0	0.00	0.00
IM populate segments wall clock time (ms)	0	0.00	0.00
IM populate via direct reads	0	0.00	0.00
IM prepopulate CUs	0	0.00	0.00
IM prepopulate CUs columns	0	0.00	0.00
IM prepopulate CUs memcompress for query low	0	0.00	0.00
IM prepopulate CUs requested	0	0.00	0.00
IM prepopulate accumulated time (ms)	0	0.00	0.00
IM prepopulate bytes from storage	0	0.00	0.00
IM prepopulate bytes in-memory data	0	0.00	0.00
IM prepopulate bytes uncompressed data	0	0.00	0.00
IM prepopulate rows	0	0.00	0.00
IM prepopulate segments	0	0.00	0.00
IM scan CUs columns accessed	0	0.00	0.00
IM scan CUs columns theoretical max	0	0.00	0.00
IM scan CUs current	0	0.00	0.00
IM scan CUs memcompress for query low	0	0.00	0.00
IM scan CUs no cleanout	0	0.00	0.00
IM scan CUs pcode aggregation pushdown	0	0.00	0.00
IM scan CUs pcode pred evaled	0	0.00	0.00
IM scan CUs pcode selective done	0	0.00	0.00
IM scan CUs predicates applied	0	0.00	0.00
IM scan CUs predicates received	0	0.00	0.00
IM scan CUs readlist creation accumulated time	0	0.00	0.00
IM scan CUs readlist creation number	0	0.00	0.00
IM scan CUs split pieces	0	0.00	0.00
IM scan bytes in-memory	0	0.00	0.00
IM scan bytes uncompressed	0	0.00	0.00
IM scan rows	0	0.00	0.00
IM scan rows pcode aggregated	0	0.00	0.00
IM scan rows projected	0	0.00	0.00
IM scan rows valid	0	0.00	0.00
IM scan segments disk	0	0.00	0.00
IM scan segments minmax eligible	0	0.00	0.00
IM simd compare calls	0	0.00	0.00
IM simd compare selective calls	0	0.00	0.00
IM simd decode unpack calls	0	0.00	0.00
IM simd rle burst calls	0	0.00	0.00
IM simd set membership calls	0	0.00	0.00
IM simd set membership selective calls	0	0.00	0.00
IM space CU bytes allocated	0	0.00	0.00
IM space CU creations initiated	0	0.00	0.00
IM space CU extents allocated	0	0.00	0.00
IM space SMU bytes allocated	0	0.00	0.00
IM space SMU creations initiated	0	0.00	0.00
IM space SMU extents allocated	0	0.00	0.00
IM space segments allocated	0	0.00	0.00
IMU Flushes	50	0.26	0.01
IMU Redo allocation size	78,716	405.54	8.50
IMU commits	9,211	47.45	0.99
IMU contention	50	0.26	0.01
IMU pool not allocated	0	0.00	0.00
IMU undo allocation size	21,533,088	110,935.83	2,324.89
IMU- failed to get a private strand	0	0.00	0.00
KTFB alloc req	6	0.03	0.00
KTFB alloc space (block)	393,216	2,025.80	42.45
KTFB alloc time (ms)	1,116	5.75	0.12
KTFB apply req	0	0.00	0.00
KTFB apply time (ms)	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	196,307	1,011.35	21.19
PX local messages recv'd	61,242	315.51	6.61
PX local messages sent	61,242	315.51	6.61
Parallel operations not downgraded	102	0.53	0.01
Requests to/from client	46,383	238.96	5.01
SQL*Net roundtrips to/from client	46,390	239.00	5.01
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	93	0.48	0.01
blocks cleaned out using minact	350	1.80	0.04
blocks decrypted	24,203,166	124,691.74	2,613.17
buffer is not pinned count	84,048	433.00	9.07
buffer is pinned count	59,041	304.17	6.37
bytes received via SQL*Net from client	5,730,466	29,522.66	618.71
bytes sent via SQL*Net to client	3,009,531	15,504.73	324.93
calls to get snapshot scn: kcmgss	56,232	289.70	6.07
calls to kcmgas	9,643	49.68	1.04
calls to kcmgcs	116,720	601.33	12.60
cell physical IO interconnect bytes	198,312,517,632	1,021,681,766.64	21,411,414.13
change write time	148	0.76	0.02
cleanout - number of ktugct calls	637	3.28	0.07
cleanouts and rollbacks - consistent read gets	1	0.01	0.00
cleanouts only - consistent read gets	544	2.80	0.06
cluster key scan block gets	2,487	12.81	0.27
cluster key scans	1,389	7.16	0.15
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	11	0.06	0.00
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	41,204	212.28	4.45
commit cleanouts successfully completed	41,193	212.22	4.45
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	583	3.00	0.06
consistent changes	8	0.04	0.00
consistent gets	24,405,172	125,732.45	2,634.98
consistent gets direct	24,146,347	124,399.02	2,607.03
consistent gets examination	122,902	633.18	13.27
consistent gets examination (fastpath)	122,832	632.82	13.26
consistent gets from cache	258,824	1,333.43	27.94
consistent gets pin	135,922	700.25	14.68
consistent gets pin (fastpath)	135,392	697.52	14.62
cursor authentications	31	0.16	0.00
cursor reload failures	0	0.00	0.00
data blocks consistent reads - undo records applied	8	0.04	0.00
db block changes	107,008	551.29	11.55
db block gets	168,987	870.60	18.25
db block gets direct	0	0.00	0.00
db block gets from cache	168,987	870.60	18.25
db block gets from cache (fastpath)	105,754	544.83	11.42
deferred (CURRENT) block cleanout applications	63,485	327.07	6.85
dirty buffers inspected	38	0.20	0.00
enqueue conversions	4,320	22.26	0.47
enqueue releases	27,487	141.61	2.97
enqueue requests	36,200	186.50	3.91
enqueue timeouts	8,781	45.24	0.95
enqueue waits	461	2.38	0.05
execute count	46,729	240.74	5.05
failed probes on index block reclamation	1	0.01	0.00
file io service time	57,945,208	298,526.60	6,256.23
frame signature mismatch	0	0.00	0.00
free buffer inspected	62,559	322.30	6.75
free buffer requested	62,730	323.18	6.77
heap block compress	179	0.92	0.02
hot buffers moved to head of LRU	2,930	15.10	0.32
immediate (CR) block cleanout applications	545	2.81	0.06
immediate (CURRENT) block cleanout applications	142	0.73	0.02
index fast full scans (full)	8	0.04	0.00
index fetch by key	40,127	206.73	4.33
index scans kdiixs1	5,245	27.02	0.57
key vector CUs filtered	0	0.00	0.00
key vector cas merge abort	1	0.01	0.00
key vector cas merge locking retrial	4,432,486	22,835.62	478.57
key vector cas merge operations	34	0.18	0.00
key vector dgk batch parcels	272	1.40	0.03
key vector non cas merge operations	34	0.18	0.00
key vector queries	34	0.18	0.00
key vectors created	68	0.35	0.01
key vectors created (bit wide)	68	0.35	0.01
key vectors created (offset layout)	34	0.18	0.00
key vectors created (simple layout)	34	0.18	0.00
leaf node 90-10 splits	3	0.02	0.00
leaf node splits	40	0.21	0.00
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	3,504,627,712	18,055,412.11	378,387.79
logons cumulative	1,632	8.41	0.18
messages sent	8,993	46.33	0.97
min active SCN optimization applied on CR	0	0.00	0.00
no work - consistent read gets	24,163,545	124,487.62	2,608.89
non-idle wait count	306,024	1,576.60	33.04
opened cursors cumulative	46,683	240.51	5.04
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	301	1.55	0.03
parse count (total)	40,365	207.96	4.36
parse time cpu	342	1.76	0.04
parse time elapsed	6,629	34.15	0.72
physical read IO requests	256,904	1,323.54	27.74
physical read bytes	198,284,533,760	1,021,537,597.16	21,408,392.76
physical read total IO requests	257,041	1,324.24	27.75
physical read total bytes	198,312,509,440	1,021,681,724.44	21,411,413.24
physical read total multi block requests	194,885	1,004.02	21.04
physical reads	24,204,655	124,699.41	2,613.33
physical reads cache	61,785	318.31	6.67
physical reads cache prefetch	1,188	6.12	0.13
physical reads direct	24,142,870	124,381.10	2,606.66
physical reads direct (lob)	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	1	0.01	0.00
physical write bytes	8,192	42.20	0.88
physical write total IO requests	1	0.01	0.00
physical write total bytes	8,192	42.20	0.88
physical write total multi block requests	0	0.00	0.00
physical writes	1	0.01	0.00
physical writes direct	1	0.01	0.00
physical writes direct (lob)	1	0.01	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes non checkpoint	1	0.01	0.00
pinned buffers inspected	0	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	191	0.98	0.02
queries parallelized	34	0.18	0.00
recursive calls	33,549	172.84	3.62
recursive cpu usage	57,494	296.20	6.21
redo buffer allocation retries	0	0.00	0.00
redo entries	12,951	66.72	1.40
redo log space requests	0	0.00	0.00
redo ordering marks	1	0.01	0.00
redo size	15,987,288	82,364.55	1,726.12
redo subscn max counts	81	0.42	0.01
redo synch long waits	1	0.01	0.00
redo synch time	34,888	179.74	3.77
redo synch time (usec)	348,870,290	1,797,336.94	37,666.84
redo synch time overhead (usec)	259,303,727	1,335,901.00	27,996.52
redo synch time overhead count ( 2ms)	9,197	47.38	0.99
redo synch time overhead count ( 8ms)	47	0.24	0.01
redo synch time overhead count ( 32ms)	19	0.10	0.00
redo synch time overhead count (128ms)	2	0.01	0.00
redo synch time overhead count (inf)	33	0.17	0.00
redo synch writes	9,302	47.92	1.00
redo write info find	9,298	47.90	1.00
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	7	0.04	0.00
rows fetched via callback	1,273	6.56	0.14
securefile allocation bytes	8,192	42.20	0.88
securefile allocation chunks	1	0.01	0.00
securefile bytes non-transformed	7,360	37.92	0.79
securefile direct read bytes	0	0.00	0.00
securefile direct read ops	0	0.00	0.00
securefile direct write bytes	8,192	42.20	0.88
securefile direct write ops	1	0.01	0.00
securefile number of non-transformed flushes	3	0.02	0.00
segment chunks allocation from dispenser	1	0.01	0.00
segment dispenser allocations	1	0.01	0.00
segment dispenser load tasks	0	0.00	0.00
segment prealloc bytes	0	0.00	0.00
segment prealloc ops	0	0.00	0.00
segment prealloc tasks	0	0.00	0.00
segment prealloc time (ms)	0	0.00	0.00
segment prealloc ufs2cfs bytes	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	44,517	229.35	4.81
session logical reads	24,574,188	126,603.20	2,653.23
session logical reads - IM	0	0.00	0.00
shared hash latch upgrades - no wait	228	1.17	0.02
shared hash latch upgrades - wait	0	0.00	0.00
shared io pool buffer get success	1	0.01	0.00
sorts (memory)	1,852	9.54	0.20
sorts (rows)	27,794	143.19	3.00
sql area evicted	255	1.31	0.03
sql area purged	0	0.00	0.00
switch current caused by our pin	4	0.02	0.00
switch current to new buffer	4	0.02	0.00
table fetch by rowid	7,819	40.28	0.84
table fetch continued row	209	1.08	0.02
table scan blocks gotten	24,142,770	124,380.59	2,606.65
table scan disk non-IMC rows gotten	2,822,258,123	14,539,927.68	304,713.68
table scan rows gotten	2,822,258,251	14,539,928.34	304,713.70
table scan rs2	0	0.00	0.00
table scans (IM)	0	0.00	0.00
table scans (direct read)	7,515	38.72	0.81
table scans (long tables)	9,521	49.05	1.03
table scans (rowid ranges)	9,521	49.05	1.03
table scans (short tables)	744	3.83	0.08
transaction rollbacks	0	0.00	0.00
undo change vector size	4,841,884	24,944.79	522.77
user calls	91,684	472.34	9.90
user commits	9,262	47.72	1.00
user logons cumulative	0	0.00	0.00
user logouts cumulative	2	0.01	0.00
user rollbacks	0	0.00	0.00
vector group by accumspace cardinality	287	1.48	0.03
vector group by accumspace size	9,184	47.31	0.99
vector group by used	34	0.18	0.00
workarea executions - optimal	1,009	5.20	0.11
write clones created in foreground	179	0.92	0.02

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
logons current	43	9
opened cursors current	66	30
session cursor cache count	25,070	27,069
session pga memory	181,060,408	24,092,296
session pga memory max	340,677,368	35,430,024
session uga memory	1,340,725,512	1,422,172,064
session uga memory max	15,874,938,768	20,041,991,960

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	179.2G	1288.71	945.369M	329M	212.88	1.695M	10.86ms	22.72ms
TOTAL:	179.2G	1288.71	945.369M	329M	212.88	1.695M	10.86ms	22.72ms

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

No data exists for this section of the report.

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

In-Memory Segment Statistics

In-Memory Segments by Scans
In-Memory Segments by DB Block Changes
In-Memory Segments by Populate CUs
In-Memory Segments by Repopulate CUs

In-Memory Segments by Scans

No data exists for this section of the report.

Back to In-Memory Segment Statistics
Back to Top

In-Memory Segments by DB Block Changes

No data exists for this section of the report.

Back to In-Memory Segment Statistics
Back to Top

In-Memory Segments by Populate CUs

No data exists for this section of the report.

Back to In-Memory Segment Statistics
Back to Top

In-Memory Segments by Repopulate CUs

No data exists for this section of the report.

Back to In-Memory Segment Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/ORCL/adump
audit_trail	DB
awr_pdb_autoflush_enabled	FALSE
compatible	12.2.0
control_file_record_keep_time	30
control_files	/u02/app/oracle/oradata/ORCL/control01.ctl, /u03/app/oracle/fast_recovery_area/ORCL/control02.ctl
control_management_pack_access	DIAGNOSTIC+TUNING
db_block_size	8192
db_create_file_dest	/u02/app/oracle/oradata
db_domain	XXXXXXXX.oraclecloud.internal
db_files	250
db_flashback_retention_target	1440
db_name	ORCL
db_recovery_file_dest	/u03/app/oracle/fast_recovery_area
db_recovery_file_dest_size	6442450944
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=ORCL.XXXXXXXX.oraclecloud.internalXDB)
enable_ddl_logging	FALSE
enable_pluggable_database	TRUE
encrypt_new_tablespaces	CLOUD_ONLY
fast_start_mttr_target	1
filesystemio_options	setall
inmemory_max_populate_servers	4
inmemory_size	5771362304
instance_name	ORCL
job_queue_processes	8
log_archive_dest_1	LOCATION=USE_DB_RECOVERY_FILE_DEST REOPEN=60
nls_language	AMERICAN
nls_territory	AMERICA
open_cursors	300
parallel_degree_policy	LIMITED
pga_aggregate_target	6442450944
processes	300
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan
sec_protocol_error_trace_action	LOG
service_names	ORCL.XXXXXXXX.oraclecloud.internal
sga_max_size	7130316800
sga_target	0
sql92_security	TRUE
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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)
control_files	/u02/app/oracle/oradata/ORCL/control01.ctl
control_files	/u03/app/oracle/fast_recovery_area/ORCL/control02.ctl

Back to init.ora 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

WORKLOAD REPOSITORY PDB report (PDB snapshots)

Report Summary

Main Report

Wait Events Statistics

Time Model Statistics

Foreground Wait Class

Foreground Wait Events

Service Statistics

Service Wait Class Stats

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

Instance Activity Statistics

Key Instance Activity Stats

Instance Activity Stats

Instance Activity Stats - Absolute Values

IO Stats

IOStat by Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Wait Statistics

Undo Statistics

Undo Segment Summary

Undo Segment Stats

In-Memory Segment Statistics

In-Memory Segments by Scans

In-Memory Segments by DB Block Changes

In-Memory Segments by Populate CUs

In-Memory Segments by Repopulate CUs

init.ora Parameters

init.ora Parameters

init.ora Multi-Valued Parameters

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