Re: Monitoring of available PGA space

From: Vishal Gupta <vishal_at_vishalgupta.com>
Date: Thu, 02 Oct 2014 00:55:42 +0100
Message-ID: <D052523F.1A897%vishal_at_vishalgupta.com>

I use following to display the PGA usage on a single/multi instance database.

http://www.vishalgupta.com/sqlscripts/pgausage.sql

Regards,
Vishal Gupta

From: Peter Sharman <pete.sharman_at_oracle.com> Reply-To: <pete.sharman_at_oracle.com>
Date: Tuesday, 30 September 2014 19:00
To: <JBECKSTROM_at_gcrta.org>, oracle-l-freelists <oracle-l_at_freelists.org>, oracle-db-l <oracle-db-l_at_Groups.ITtoolbox.com> Subject: RE: Monitoring of available PGA space

> No time to investigate directly with OOW at the moment, but if nothing else
> you could build a metric extension off v$pgastat maybe?
>
> Pete
> Pete Sharman
> Database Architect, DBaaS
> Enterprise Manager Product Suite
> 33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
> Phone: +61262924095 <tel:+61262924095> | | Fax: +61262925183
> <fax:+61262925183> | | Mobile: +61414443449
>
>
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not, it's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA
>
>
>
>
> From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
> Sent: Tuesday, September 30, 2014 3:50 AM
> To: oracle-l-freelists; oracle-db-l
> Subject: Monitoring of available PGA space
>
> We manually control setting of the pga_aggregate_target value. We would like
> to setup monitoring of the PGA space via EM 12C to alert us when the database
> starts to steal back space due to insufficient PGA. Anybody have a script that
> does this?
>
>
>
> Jeffrey Beckstrom
> Lead Database Administrator
>
> Information Technology Department
>
> Greater Cleveland Regional Transit Authority
>
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>
> .

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 02 2014 - 01:55:42 CEST