Oracle Daily Tidbits March 2016

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in March 2016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… #oratidbit The awrsqrpt.sql SQL script … Read more

Oracle Daily Tidbits Feb 2016

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in February 2016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… #oratidbit Oracle XML Database … Read more

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 … Read more

RMOUG Training Days 2016

Very 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 … Read more

Oracle TidBits – December 2015

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in December 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Publish Date TidBit 1-Dec #oratidbit … Read more

Apply DB OVJM PSU + Queryable Patch Inventory Demo

Oracle started releasing OVJM component of  DB PSU in October 2014, and recommend applying OVJM PSU along with (or after) DB PSU. I will demo applying DB PSU, and OVJM PSU on 12.1.0.2 database. Use this opportunity to introduce you to Queryable Patch Inventory (DBMS_QOPATCH), where you can query OPatch information directly from the database. … Read more