Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AWR SGA+ PGA usage

divNov 18 2010 — edited Nov 23 2010

Hi
We're doing some performance testing on our database. The SGA is set to 1.5GB and PGA set to 0.5GB. At some point we are runnning out of memory as we ramp up the number of users and transactions .
What I'm looking for is to graph the PGA and SGA usage seperately regular intervals (a line graph) showing their increaase as users ramp up.

Anyone any ideas on how I can get this information whether through AWR or manually.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2010

Added on Nov 18 2010

#general-database-discussions

6 comments

962 views