OraFAQ Forum: Server Administration » For those unsing 9i/10g and having more then 10GB of PGA

Home » RDBMS Server » Server Administration » For those unsing 9i/10g and having more then 10GB of PGA

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

For those unsing 9i/10g and having more then 10GB of PGA [message #63504]

Mon, 11 October 2004 12:58

Mike
Messages: 417
Registered: September 1998

Senior Member

I would like to get a general overview of the PGA utilisation on�larger database.

I'm specialy interessted in DB using� workarea_size_policy=auto� and having more then 10GB of PGA.

I would like to know which values you got in the following 3�rows of�� v$pgastat:

aggregate PGA target parameter�
maximum PGA used for auto workareas�
cache hit percentage

Could please also specify if it is an DWH or an OLTP system

Thanks for any feedback

Mike

Report message to a moderator

Previous Topic:	Error In udump/Tracefile
Next Topic:	Oracle 9i: calculating EXTENT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 06 10:32:47 CDT 2026