Home » RDBMS Server » Server Administration » PGA utilization (10.2/aix)
PGA utilization [message #537445] Wed, 28 December 2011 06:50 Go to next message
Garryhere
Messages: 1
Registered: December 2011
Location: Switzerland
Junior Member
Hello Everybody,

I have a requirement to monitor the PGA utilization with time to time.
can anyone provide a good script which will effectively show the pga utilization.


thank you
Garry
Re: PGA utilization [message #537447 is a reply to message #537445] Wed, 28 December 2011 07:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum - I hope you will both learn and contribute (as I try to do, with varying degrees of success). Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

About PGA, I would think your best technique would be to use the alert system. Configure an alert (with dbms_server_alert) on metric 5003, "PGA Memory (Session)". If you have Enterprise Edition licences, you can report it automatically whenever your threshold is crossed, otherwise you'll have to write your own alert handler.
Re: PGA utilization [message #537454 is a reply to message #537445] Wed, 28 December 2011 07:42 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
V$PGASTAT and, if you bought it, DBA_HIST_PGASTAT

Regards
Michel
Previous Topic: archive mode in oracle database
Next Topic: alter database datafile file_id offline
Goto Forum:
  


Current Time: Thu Mar 28 05:43:28 CDT 2024