Tag Archives: performance

How to Find High Water Mark in Oracle

Here’s an interesting find on how to find the high watermark in Oracle. It works fine in both the 10.2.0.1 and 11.2.0.1 at my laptop. Use dbms_space.unused_space to find unused space, whose arguments are:    segment_owner         … Continue reading

Posted in database, Oracle, Oracle DBA | Tagged , , , , , , | Leave a comment

Oracle :: AWR Data Extract

Firstly a small note of Thanks !! Before even starting off this post, I would like to convey my heartiest thanks to Brian Diehl for sharing such a useful piece of information on the Oracle Blog. Introduction The Oracle RDBMS has … Continue reading

Posted in Computers, database, experience, Oracle, Oracle DBA, Oracle Performance Tuning | Tagged , , , , , | Leave a comment