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!

Monitoring memory performance for oracle database on windows

MSandicoMar 21 2013 — edited Mar 27 2013

Hi All,

I'm new to Oracle database admin and am looking at a dedicated Oracle db server running on Windows with 12GB of RAM. I noticed that available mem is 10GB and when checking SGA size in EM, it says max size is 1000MB! We've looked at how to increase the size (we are going to increase to 8000MB) but what i'd like to know is how to monitor memory performance from an Oracle perspective (i am familiar with windows OS counters but am looking for Oracle db-specific counters). I see one about buffer cache hit ratio but is that the only one? In SQL server, there are several SQL-specific counters to look at in terms of SQL memory usage, hoping to get the same for ORacle..

thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2013

Added on Mar 21 2013

#general-database-discussions

10 comments

825 views