Home › Discussions › Questions & Answers › Monitoring Database Object Usage in SGA Buffer Cache

Monitoring Database Object Usage in SGA Buffer Cache

Avatar photoCustomer Questions & Answers 5 replies

We need to identify which database objects (tables/indexes) are heavily utilizing the SGA buffer cache and potentially forcing other necessary objects out. Which report shows this usage by object?

5 replies

  • Support Enginatics

    Run the DBA SGA Buffer Cache Object Usage report. This report shows SGA buffer cache space usage broken down by object names in megabytes.

  • Avatar photoCustomer

    What is the key metric in that report that tells me if an object is entirely or mostly cached?

  • Support Enginatics

    Look at the ‘Object Percentage’ column. A value of 100% indicates that the object is completely resident in the buffer cache. This helps identify ‘hot’ objects and potential objects that should be pinned.

  • Avatar photoCustomer

    If I notice an imbalance between our Shared Pool and Buffer Cache, where can I find the current split?

  • Support Enginatics

    The DBA SGA Memory Allocation report provides the current SGA memory usage in gigabytes, specifically showing the split between the buffer cache and the shared pool.

  • You must be logged in to reply to this post.