Monthly Archives: December 2012

Real-Time library cache monitoring

Again the same story : Oracle provides a useful view to check librarycache statistics (v$librarycache), but this view is a cumulative one. So how to check what’s is going on my database right now with cumulative values ? Right : … Continue reading

Posted in Perl Scripts, ToolKit | Tagged , | Leave a comment

Rac One Node : Create preferred node

In my previous Rac One Node post I gave a way to “stick” one Rac One Node database to a particular node of your cluster so that : It should re-start automatically on the “stick” node in case of database … Continue reading

Posted in Rac | Tagged | 7 Comments

Rac One Node : Avoid automatic database relocation

Imagine you need to ensure that one of your many RAC One Node database: Should re-start automatically on the current node in case of database or node crash. Does not relocate automatically on other nodes. So, you need somehow to “stick” this particular RAC … Continue reading

Posted in Rac | Tagged | 2 Comments

Real-Time enqueue statistics

Again the same story : Oracle provides a useful view to check enqueue statistics (v$enqueue_statistics), but this view is a cumulative one. So how to check what’s is going on my database right now with cumulative values ? You have … Continue reading

Posted in Perl Scripts, ToolKit | Tagged , | Leave a comment

Real-Time SGA component monitoring

From the V$SGA_RESIZE_OPS view, you observed that your database is doing frequent resize. You want to know what’s going on and you decided to query the v$sgastat view at regular interval to understand which component of the sga is growing. … Continue reading

Posted in Perl Scripts, ToolKit | Tagged , | Leave a comment

Real-Time segments statistics

The v$segment_statistics and v$segstat views are a goldmine to extract statistics that are associated with the Oracle segments. You can see how useful it could be in those posts : Kevin Closson’s post Jonathan Lewis’s post or this one Arup Nanda’s … Continue reading

Posted in Exadata, Perl Scripts, ToolKit | Tagged , , | 2 Comments

Real-Time Wait Events and Statistics related to Exadata

Into my first post related to Exadata I provided a perl script to extract real-time metrics from the cells based on their cumulative metrics (see here). In this post I focus on the information available from the database: Cumulative “cell” Statistics and … Continue reading

Posted in Exadata, Perl Scripts, ToolKit | Tagged , , | 2 Comments