Search “Sojourn” !!
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 22.214.171.124 at my laptop. Use dbms_space.unused_space to find unused space, whose arguments are: segment_owner … Continue reading
Tuning Oracle with SQLT – Part # 2 Here’s the 2nd part to the series covering SQLT as an important tool for SQL and Oracle Tuning for Oracle DBA’s. In the last post of the series, we covered how to install this … Continue reading
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
Prologue … Oracle 12C was officially released on 25th June 2013, and is now available for downloads at OTN. The documentation cab be found here. Note: You can download it entirely from here. Here’s a brief of what I have learnt about … Continue reading