Expert Opinion

Hi Experts,

Below is statspack profile of my 11.2.0.4 single instance database. Could you please provide expert opinion for tuning the DB.

Host Name

Platform

CPUs Cores Sockets   Memory (G)

~~~~ ---------------- ---------------------- ----- ----- ------- ------------

db1.prod.Linux x86 64-bit

16

8

2

31.4

Snapshot	Snap Id	Snap Time	Sessions Curs/Sess Comment
~~~~~~~~	---------- ------------------ -------- --------- ------------------
Begin Snap:	224 25-Apr-14 11:00:00	33	1.2
End Snap:	225 25-Apr-14 12:00:01	30	1.2
Elapsed:	60.02 (mins) Av Act Sess:	3.7
DB time:	222.28 (mins)	DB CPU:	20.46 (mins)

Cache Sizes	Begin	End
~~~~~~~~~~~	---------- ----------
	Buffer Cache:	3,408M	Std Block Size:	8K
	Shared Pool:	2,048M	Log Buffer:	5,600K

Load Profile

Per Second

Per Transaction

Per Exec

Per Call