Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
August | 2013 | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle 12c New Feature – Temporal Validity

  • Posted by Gavin Soorma
  • On August 21, 2013
  • 0 Comments
The Temporal Validity feature adds a time dimension to each row in the table consisting of two date-time columns to denote validity of data. Data that is older or no longer valid or not yet valid can be hidden from queries and only active data returned by queries. In case of a very large table, […]
Read More
 

Oracle 12c new feature In-Database Archiving

  • Posted by Gavin Soorma
  • On August 5, 2013
  • 0 Comments
Very often in our databases we have some very large tables which have a lot of historical and legacy data and the challenge is deciding what is old data and what is current data and even if we do identify the old data we do not need and have moved that data to tape storage, […]
Read More
 

Minimal downtime rolling database upgrade to 12c Release 1

  • Posted by Gavin Soorma
  • On August 2, 2013
  • 0 Comments
This note describes the procedure used to perform a rolling database upgrade from 11.2.0.3 to Oracle 12c Release 1 using a Data Guard physical standby database and transient logical standby database. The average time to perform a database upgrade would be in the region of one to two hours and for many organizations even that […]
Read More
 1