V$BACKUP_NONLOGGED and V$CON_SYSSTAT in 12c

V$BACKUP_NONLOGGED is new view in 12c, displays information about nonlogged block ranges in data file backups recorded in the control file. A related view is V$NONLOGGED_BLOCK. It displays ranges of nonlogged datafile blocks recorded in the control file. In version 12c and forward RMAN validate no longer populates view V$DATABASE_BLOCK_CORRUPTION, instead V$NONLOGGED_BLOCK is updated. V$COPY_NONLOGGED displays information about nonlogged block ranges in data file copy blocks recorded in the control file.

V$CON_SYSSTAT is similar to V$SYSSTAT view, but is new in 12c and useful for container database (CDB) architecture. May be from 12c onwards, you might want to start using V$CON_SYSSTAT instead of V$SYSSTAT, so the scripts can be used on both CDB and non-CDB.  One nice thing about V$CON_SYSSTAT is that it includes NAME and CLASS columns as well, no need to join with V$STATNAME view. Usually we join V$SYSSTAT with V$STATNAME to get a meaningful query result.

RMOUG Training Days 2016

rmoug16speakerVery happy and excited to be part of RMOUG Training Days 2016 Conference in Denver. This year I am presenting two sessions.

Feb 9 2:30 PM – Quick Tips

Using VirtualBox and Free Online Resources to Learn Oracle Database 12c and EBS R12
Topic: Database Tools of the Trade

Feb 11 11:15 AM – Conference Session

Configuring E-Business Suite for RAC and PCP
Topic: Oracle Apps

I am excited to be part of a great line of speakers, many from the Oracle ACE community.

Check out the schedule and topics here…

Look forward to see you and to say Hello!