How to Flush Single SQL Plan out of Shared Pool in Oracle

Todays let ‘s have look at the query which we use to resolve this issue ” How to Flush Single SQL Plan out of Shared Pool”.      Find the address and the hash value

Execute the purge procedure

Thank you for giving your valuable time to read the above information. If you […]

Read More

Progress status of index rebuild in Oracle

  The game never ends after the creation of anything. It starts when it comes to the phase of maintenance. Today we are going to have look on the query which is used to look “Progress status of index rebuild/creation or long operation”.      Let’s have look on the query.

v$session_longops will show […]

Read More

Find users with DBA privilege in Oracle

Being Oracle DBA we are aware that Oracle provides lots of views and parameters which helps DBA a lot to maintain the database. In this article, we are going to know about the user’s privilege. We may find that different users have different permissions in the database. Let’s have look at the query which we use […]

Read More

Schedule rman backup in windows

We are going to learn about the steps which we will use for schedule rman backup in windows. Most probably Organisations use Linux and Unix OS as per there requirements but sometimes as per company’s requirements, we have to use windows. Here we are going to have look at the process of schedule rman backup in windows.   Let’s have look at it. […]

Read More

HOW TO CONVERT SCN TO DATE AND DATE INTO SCN

Being DBA, we all are well aware SCN. We all known about it’s important. SCN is the most important element of Oracle Database. It helps DBA in the Recovery Database.       Database SCN number some time is very important 1) Particularly when you are doing rman recovery 2) Filling gaps of archive logs between the primary […]

Read More

How to Check/Validate That RMAN Backups Are Good

From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms.     Some of […]

Read More

How to find database growth on a Monthly wise

Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful.      

Output

Read More

High Water Mark USAGE

Before start this article we must know about “HWM” . After did lots of R&D i found the technical definition Explanation in Detail: (http://www.dba-oracle.com/t_high_water_mark.html) . The high water mark (HWM) for an Oracle table is a construct that shows the table at its greatest size.  Just as a lake has a high-water mark after a draught, an Oracle […]

Read More

Check os processid of your session from sql prompt.

To check os processid of oracle session , we can check v$process view. SPID column of v$process view shows os processid. We can use following query to check processid, status for specific user.

I have connected through sys user :

Now checking processid using above script.

check this processid 14399 from os […]

Read More

Find corrupted objects in Oracle using sql query

Find corrupted objects in Oracle using sql query : When you find block corruption in your database use validate database or validate check logical database command of RMAN, it will populate v$database_block_corruption view with corrupted blocks. Then you can check corrupted segments , its partition name and more details using following script.

   

Read More