Block-Related Oracle Rac Wait Events – Part 2

An event can be anything that Oracle has to perform on behalf of a set of instructions sent by the user interface. The term “wait” is used because every time a user connects to your application, a resource is allocated to perform tasks on its behalf. The waiting comes when a session is waiting for […]

Read More

Block-Related Oracle Rac Wait Events – Part 1

The block-related wait event statistics indicate that a block was received as either the result of a 2-way or a 3-way message, that is, the block was sent from either the resource master requiring 1 message and 1 transfer, or was forwarded to a third node from which it was sent, requiring 2 messages and […]

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

Basic on Oracle RAC wait events

Analyzing and interpreting what causes sessions to wait is an important method to determine where time is spent. In Oracle RAC, the wait time is attributed to an event which reflects the exact outcome of a request. For example, when a session on an instance is looking for a block in the global cache, it […]

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

Archive log delete input and delete all input

Archive log mode :  This mode created backup of all transactions that have occurred in the database , so that you can recover your database to any point in time. These logs consumes space in respective destination. To utilize storage , we can remove archive log with RMAN command delete input or delete all input […]

Read More

check os process id of your session from sql prompt.

 Check os process id of your session from sql prompt.

My session


Read More

Create Database using DBCA silent mode

DBCA is great tool to create database using GUI , but sometimes when we don’t have access to GUI, we can still create database using DBCA silent mode creation where you need to pass silent option with dbca and some parameter values to create database. In following example we have used template General_Purpose ,   […]

Read More

RMAN maxpiecesize command

Use of RMAN maxpiecesize command To avoid large size of backupset we can set maxpiecesize of rman backup piece. I have taken following backup without setting any parameter :

By list backup command we can see all details of backup , here we can see my backup set size is 1013.84M.

now configure […]

Read More

ORA-16179 incremental changes to “log_archive_dest_10” not allowed with SPFILE

You might encounter ORA-16179 error while changing the archive destination.

There is syntax error in above command . It should be like log_archive_dest_n [n is a integer from 1 to 31]=’LOCATION=path_for_archive_log’ example :

Thank you for giving your valuable time to read the above information. If you want to be updated with all […]

Read More