Monthly Archives: July 2008

Automatic killing of dead lock sessions

If you are experiencing frequent dead lock problem in your database and want to kill automatically causing sessions. You can accomplished this task with Oracle Resource Manager. It will kill the sessions those are waiting /hanging more than 20 minutes … Continue reading

Posted in Uncategorized | Leave a comment

Backup of control file (text format) of your database

Here is script that will create backup of control file (text format) of your database 1. It will identified trace file 2. Edit trace file to make neat and clean script to create control file 3. Copy to identify folder. … Continue reading

Posted in Shell Script | Tagged | Leave a comment

Inspiration

I got inspiration to start my blog from my friend buddy Vish Vangapally.

Posted in Uncategorized | Leave a comment