Search “Sojourn” !!
I have come up to this feature of Oracle lately, when I was working on a certain script to insert and merge data from various tables into one, and was looking out for an effective way to record the errors … Continue reading
There are cases when we would need to use the RESUMABLE option with IMPORT. Example: One such case I faced recently where my datafiles were not in the AUTOEXTEND ON mode, because of obvious reasons – so as to give … Continue reading
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 220.127.116.11 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
Firstly, a big thanks to Suzanne, an MVP, for providing this easy resolution to a (however) a small issue on which she had replied on the Microsoft Tech Forums. I would provide more details on her work and valuable information … 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