Cache Sizes 
===================
			Begin	End		
			------	------
Buffer Cache:		87,888M	87,888M		Std Block Size:	8K
Shared Pool Size:	5,008M	5,008M		Log Buffer:	30,540K


Load Profile
===================	Per Second	Per Transaction
			-----------	---------------
Redo size:		15,793,164.54	232,404.16
Logical reads:		555,077.29	8,168.23
Block changes:		137,447.27	2,022.60
Physical reads:		9,393.32	138.23
Physical writes:	2,836.27	41.74
User calls:		1,387.39	20.42
Parses:			337.28		4.96
Hard parses:		0.38		0.01
Sorts:			682.88		10.05
Logons:			0.15		0.00
Executes:		2,485.05	36.57
Transactions:		67.96	 

% Blocks changed per Read:	24.76	Recursive Call %:	79.99
Rollback per transaction %:	0.01	Rows per Sort:	        278.57

Instance Efficiency Percentages (Target 100%) 
=============================================
Buffer Nowait %:		99.97	Redo NoWait %:	        100.00
Buffer Hit %:			98.59	In-memory Sort %:	100.00
Library Hit %:			99.97	Soft Parse %:	        99.89
Execute to Parse %:		86.43	Latch Hit %:	        98.84
Parse CPU to Parse Elapsd %:	10.31	% Non-Parse CPU:	99.95

Shared Pool Statistics 
===================
				Begin	End
				------	-----
Memory Usage %:			57.49	57.81
% SQL with executions>1:	93.13	90.90
% Memory for SQL w/exec>1:	88.26	89.86


Top 5 Timed Events 
===================
Event			  Waits		Time(s)	   Avg Wait(ms)	  % Total    Wait Class
                                                                  Call Time
-----------------------	  -----------	--------   ------------	  --------   ----------
db file sequential read	  68,407,830	685,952	   10		  72.0	     User I/O
CPU time	 	  		107,053	                   11.2	 
db file parallel write	  8,276,249	24,506	   3		   2.6	     System I/O
db file scattered read	  1,578,310	23,072	   15		   2.4	     User I/O
log file sync		  1,257,898	10,698	   9		   1.1	     Commit

Shared 	 SP 	 Est LC	  Est LC     Est LC 	 Est LC       Est LC 	Est LC 	    Est LC
Pool	 Size		 	     Time	 Time	      Load	Load	    Mem Obj
Size(M)	 Factr	 Size (M) Mem Obj    Saved (s)	 Saved Factr  Time (s)	Time Factr  Hits (K)
=======  ======= ======== =======    =========	 ==========   ========  ==========  ========
2,464	0.49	 574	  73,397     197,998,632	1     255,805	1.03	    662,198
2,976	0.59	 1,060	  139,229    198,005,209	1     249,228	1.01	    662,561
3,488	0.69	 1,570	  262,715    198,006,412	1     248,025	1	    662,622
4,000	0.8	 2,081	  382,156    198,006,805	1     247,632	1	    662,644
4,512	0.9	 2,592	  492,495    198,007,081	1     247,356	1	    662,657
5,024	1	 3,103	  590,012    198,007,268	1     247,169	1	    662,666
5,536	1.1	 3,614	  688,225    198,007,413	1     247,024	1	    662,672
6,048	1.2	 4,125	  770,369    198,007,520	1     246,917	1	    662,676
6,560	1.31	 4,636	  871,230    198,007,571	1     246,866	1	    662,679
7,072	1.41	 5,147	  968,483    198,007,630	1     246,807	1	    662,682
7,584	1.51	 5,658	  1,078,513  198,007,669	1     246,768	1	    662,684
8,096	1.61	 6,169	  1,199,038  198,007,717	1     246,720	1	    662,687
8,608	1.71	 6,680	  1,314,07   198,007,761	1     246,676	1	    662,690
9,120	1.82	 7,191	  1,430,267  198,007,786	1     246,651	1	    662,692
9,632	1.92	 7,702	  1,542,533  198,007,811	1     246,626	1	    662,694
10,144	2.02	 8,213	  1,655,355  198,007,836	1     246,601	1	    662,695

select a.sql_id, a.ratio, a.executions
from  
(
  select sql_id, buffer_gets / executions ratio, executions
  from v$sql
  where executions > 10
  order by 2 desc
) a
where rownum <= 10

For cur in (select object_name from user_objects) loop
  insert into my table values (cur.object_name);
end loop;

ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';

EXEC DBMS_MONITOR.session_trace_enable(session_id =>1234, serial_num=>1234, waits=>TRUE, binds=>FALSE);

... binds=>TRUE);