Category Archives: database

INSERT and Error Logging

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

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

IMP with RESUMABLE option

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

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

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

Tuning Oracle with SQLT – Part # 2

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

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

Oracle :: 12C … The new horizon!

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

Posted in Computers, database, experience, Oracle, Oracle DBA, technology | 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

Unreliable Oracle Metalink post !!

Usually all the Knowledge docs I’ve encountered in Oracle Metalink so far are quite able to provide the right in time solution for the Oracle database (and other products) related issues, but here’s one exception — an unreliable Oracle Metalink article … Continue reading

Posted in Computers, database, education, experience, IT, Oracle, Oracle DBA | Tagged , , , , , , , , , | Leave a comment