Blog

  • 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!