Amit Oracle DBA Blog

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

Tuesday, 26 November 2019

SQL Query is really hanged or not

Monitoring Progress of a SQL Execution Plan / sql query is really hanged or not How to see the progress a query is making from ...

Wednesday, 14 August 2019

Check the last incarnation restore time of oracle database

Check the last incarnation restore time when the database is started with resetlogs command with following command. Incarnation is th...

Monday, 19 June 2017

Script to Drop a user's objects.

This script will produce the alter/drop commands that we can use to drop all the user objects from a database. REM Script to dro...

Tuesday, 16 May 2017

Creating sql baseline to fix query with better execution plan

Hello everyone, hope you all doing good. It’s been too long I haven’t updated new post on my blog due to my busy schedule. S...

View web version

Powered by Blogger.