Tag Archives: dba

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 :: Tuning with SQLT (Series) (Part # 1)

Looking for an elegant companion for SQL Tuning ? — The answer is: SQLT. SQLT is a tool originally developed and still regularly updated, maintained by Carlos Sierra. You can visit his website for loads of information on this wonderfully crafted … Continue reading

Posted in Uncategorized | Tagged , , , , | 2 Comments