Showing posts from May, 2014

Database opening with RESETLOGS

Whenever we perform incomplete recovery or recovery with a backup control file, you must…

Read more

Granting select access to v$ Tables

To provide grant select access on v$ tables (like v$session,V$ASM_DISK etc) error will e…

Read more

Oracle Grid Home Clone Guide

Oracle GRID home cloning can be done using  below steps Steps: 1.Copy source GRID Ho…

Read more

Finding session using UNDO tablespace

The below query can be used to find the session which is consuming more UNDO tablespace.…

Read more