Amit Oracle DBA Blog

This blog is to share oracle concept and real time experience for Oracle beginner.....

Thursday, 30 April 2015

How to lock/unlock statistics on a table

In certain cases you may want to lock statistics in a table in certain cases, for example if you want a table not be analyzed by automatic ...

Tuesday, 28 April 2015

Restore the database from tape backup of the Database

Suppose the entire server is lost, we have the tape copy of the backup of the database , which includes RMAN backup pieces and control...

Friday, 24 April 2015

Perfomance Tuning Related Queries.

Listed below are some SQL queries which I find particularly useful for performance tuning. These are based on the Active Session History ...

Friday, 10 April 2015

ORA-01031: insufficient privileges while configure Enterprise Manager

Configuring OEM manually seems to be very straight forward but sometimes you may come across erors which make it difficult. Below is one...

View web version

Powered by Blogger.