Testing 123

This is is testing message. Pls ignore.

Friday, July 25, 2014 | Exadata | Read More

When to rebuild index ?

Index is one of intersting objects in database, which always attract DBAs and Developers to fine tune their queries. Because index is just like salt in food. It should be used optimized quantity. Some time index doesnt show actual expected performance. In those cases we need to chaeck whether index need to be rebuild or not. I went through certain research docs which shows certain criteria for rebuilding index: The number of deleted leaf nodes - the number of index nodes that...

Sunday, September 20, 2009 | Read More

How to dump Oracle Data Block?

Often while doing instance tuning or sql tuning, Internal structure of a Oracle Data block is important to know. Moreover when system does not show a significant direction to do troubleshooting. In this blog, I am explaining to how to extract dump of a oracle data block. dump shows following details which may be significant to find the rationale of problem of state of block: contents of the block for the given datafile number and the block number how the data is stored...

Sunday, September 13, 2009 | SQL Tuning | Read More

How to identify trace file in USER_DUMP_DIRECTORY?

ORA-600 or ORA-7445 kind of errors are always have lot of things hidden which DBA needs to determine by taking session trace of various database components. There are various way of taking these dumps like enabling session trace, using alter session command, end to end tracing, or by using oradebug utility. Once we give command to generate trace oracle saves the trace in file in directory configured in USER_DUMP_DEST parameter. Once the tracing ends, we need to find the file...

Sunday, September 13, 2009 | SQL Tuning | Read More

RMAN Backup error: What to do if some archivelog is missing or datafile is offline during RMAN backup?

I always encounters the problem while my seminars that what DBA should do if some archivelog is missing during RMAN backup. I think apart from crossing the fingers, one can at least make successful backup. backup should not be missed even if you miss some of the files. Nothing is important than successful backup. All future recovery depends upon the presence of backups. RMAN> crosscheck archivelog all; and then follwoing to delete expired archivelog. RMAN> delete expired archive...

Saturday, September 12, 2009 | RMAN | Read More

Constraints: How to resolve the duplicated primary key exceptions

After disabling the constraints, One can enter invalid values into the tables as per the constraint condition. for example, if you disable primary key constraint, it is possible to enter the duplicate value in primary key column and commit the same data in table. till this you will not have the problem. Problem will arise if you try to enable the primary key. In presence of duplicate values. If your table is small it easy to judge what rows have invalid values but this problem...

Wednesday, August 26, 2009 | Read More

Visit the Oracle Blog


Contact Us


Integrated Cloud Applications & Platform Services