Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Database Tuning (MOSC)

Expert Opinion

Apr 25, 2014 9:06AM edited Apr 29, 2014 9:18AM in Database Tuning (MOSC) 9 comments

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

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month