OracleView

Oracle Scripts

collect full path of file in asm diskgroup

[oracle@oratest2 ~]$ sqlplus "/as sysasm" SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 2 19…

Oracle Scripts

Redo Generation Per Hour Day Wise In RAC

set lines 300  col DATE for a12 col DAY a4 select to_char(first_time,'YYYY-MON-DD') "Date",…

Oracle Scripts

Redo Log Generation Per Hour In Oracle RAC

This script will work for both RAC and standalone database. (1) First query report the   redo log switches …