OraFAQ Forum: Performance Tuning » Views which will help in tuning SGA and PGA

Home » RDBMS Server » Performance Tuning » Views which will help in tuning SGA and PGA

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Views which will help in tuning SGA and PGA [message #525327]

Sat, 01 October 2011 02:41

Narmada28
Messages: 13
Registered: September 2011

Junior Member

What are the views which will help in tuning SGA and PGA? which indicates memory parameters..

Report message to a moderator

Re: Views which will help in tuning SGA and PGA [message #525331 is a reply to message #525327]

Sat, 01 October 2011 02:55

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Answer depends on your Oracle version, so post it.

Regards
Michel

Report message to a moderator

Re: Views which will help in tuning SGA and PGA [message #525343 is a reply to message #525331]

Sat, 01 October 2011 04:59

Narmada28
Messages: 13
Registered: September 2011

Junior Member

Oracle Database 10g Express Edition Release 10.2.0.1.0..

Report message to a moderator

Re: Views which will help in tuning SGA and PGA [message #525360 is a reply to message #525343]

Sat, 01 October 2011 10:27

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use StatsPack reports (read spdoc.txt in %ORACLE_HOME%\rdbms\admin directory) and StatsPack papers on OTN.

Regards
Michel

[Updated on: Sat, 01 October 2011 10:28]

Report message to a moderator

Re: Views which will help in tuning SGA and PGA [message #525361 is a reply to message #525360]

Sat, 01 October 2011 10:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What are the views which will help in tuning SGA and PGA? which indicates memory parameters..
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

query
V_$PGA_TARGET_ADVICE
V_$SGA_TARGET_ADVICE

Report message to a moderator

Re: Views which will help in tuning SGA and PGA [message #525375 is a reply to message #525361]

Sat, 01 October 2011 12:05

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are they available in XE? Do you know if they are restrictions on their use (like added license)?

Regards
Michel

Report message to a moderator

Previous Topic:	optimizer ignoring USE_HASH hint in MERGE Query
Next Topic:	How to view the tables which are in the keep buffer cache????

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 03:58:16 CDT 2024