Snap Id		Snap Time		Sessions	Cursors/Session

Begin Snap:	22630		07-Jul-22 10:27:50	100		80.8

End Snap:	22631		07-Jul-22 11:28:07	107		72.4

Elapsed:	 		60.28 (mins)	 	 

DB Time:	 		380.96 (mins)	 	 

Load Profile



				Per Second	Per Transaction	Per Exec	Per Call

DB Time(s):			6.3		4.5		0.00	0.00

DB CPU(s):			5.9		4.2		0.00	0.00

Background CPU(s):		0.0		0.0		0.00	0.00

Redo size (bytes):		35,974.7	25,648.1	 	 

Logical read (blocks):		276,808.6	197,350.1	 	 

Block changes:			246.4		175.7	 	 

Physical read (blocks):		4,203.0		2,996.5	 	 

Physical write (blocks):	73.7		52.6	 	 

Read IO requests:		1,390.7		991.5	 	 

Write IO requests:		2.5		1.8	 	 

Read IO (MB):			32.8		23.4	 	 

Write IO (MB):			0.6		0.4	 	 

IM scan rows:			0.0		0.0	 	 

Session Logical Read IM:	0.0		0.0	 	 

User calls:			4,589.4		3,272.0	 	 

Parses (SQL):			70.2		50.1	 	 

Hard parses (SQL):		3.4		2.4	 	 

SQL Work Area (MB):		9.8		7.0	 	 

Logons:				1.7		1.2	 	 

User logons:			0.1		0.1	 	 

Executes (SQL):			3,067.6		2,187.0	 	 

Rollbacks:			0.0		0.0	 	 

Transactions:			1.4	 	 	            

Top 10 Foreground Events by Total Wait Time



Event				Waits		Total Wait Time (sec)	Avg Wait	% DB time	Wait Class

DB CPU	 					21.4K	 		93.5	 

db file sequential read		4,582,827	1302.5			284.22us	5.7		User I/O

SQL*Net more data to client	1,990,298	156.9			78.82us		.7		Network

PGA memory operation		3,386,157	124.6			36.79us		.5		Other

direct path read		35,914		114.7			3.19ms		.5		User I/O

read by other session		375,667		80.9			215.25us	.4		User I/O

db file scattered read		35,692		52			1.46ms		.2		User I/O

db file parallel read		57,499		46			799.93us	.2		User I/O

SQL*Net message to client	16,480,229	29.5			1.79us		.1		Network

latch: shared pool		2,327		18.3			7.87ms		.1		Concurrency

Time Model Statistics



Statistic Name					Time (s)	% of DB Time	% of Total CPU Time

DB CPU						21,374.63	93.51		100.08

sql execute elapsed time			20,614.32	90.19	 

parse time elapsed				1,261.07	5.52	 

hard parse elapsed time				493.44		2.16	 

hard parse (sharing criteria) elapsed time	193.49		0.85	 

connection management call elapsed time		129.21		0.57	 

PL/SQL execution elapsed time			12.88		0.06	 

repeated bind elapsed time			3.86		0.02	 

PL/SQL compilation elapsed time			0.29		0.00	 

DB time						22,857.36	 	 

total CPU time					21,357.96