Basic IOPS

I was asked about IOPS, so that a new server could be sized, this could help. Your results might look something like: Remember that statistics contained in the GV$ views are cumulative and therefore should be sampled. You then subtract your first statistics from the last statistics to give you the throughput. It is now easy to calculate the IOPS for small and large I/O and also MBPS. The following calculations will assist in determining the workload for the current database system. Small Read IOPS =(333474-106883)/(10*60) = 377 IOPS Small Write IOPS =(500211-205903)/(10*60) = 490 IOPS Total Small IOPS =(226591+294308)/(10*60) = 868 IOPS I/O Percentage of Reads to Writes = 44:56 Large Read IOPS =(8010-2791) /(10*60) = 8 IOPS Large Write IOPS =(142981-40298)/(10*60) = 171 IOPS Total Large IOPS =(5219+102683) /(10*60) = 179 IOPS I/O Percentage of Reads to Writes = 4:96 Total MBPS Read =((5586081648-2009381888) /(10*60))/1048576= 5 MBPS Total MBPS Written =((22232604961-4188587008)/(10*60))/1048576= 28 MBPS Total MBPS =((3576699760+18044017953)/(10*60))/1048576= 34 MBPS We could conclude from these figures that this is more of a OLTP as there is more writes occurring.

How to recreate database dbconsole

Steps to recreate database dbconsole 1) emca -deconfig dbcontrol db -repos drop 2) Normally you would run emca -reconfig all db -repos recreate but we want to specify a listener home This will recreate the dbconsole.