Zafar Ali Invisible Columns In Oracle Database 12C In Oracle Database 12c, you can set a column in table as invisible either during CREATE TABLE or modifying existing table via ALTER TABLE command.... 12 December 2016 5 min read
Anju Garg Oracle Database 12.1.0.2c: Hot Cloning Of Pluggable Databases Cloning of a Pluggable Database (PDB) in Oracle Multitenant is a great feature and is very useful. Oracle Database 12c Release 1 has introduced various enhancements to the... 20 September 2016 8 min read
Anju Garg Oracle Database 12.1.0.2c: Automatic Big Table Cache Serial direct path reads were first introduced in Oracle 11g to prevent wiping out a large number of buffers from the buffer cache by a... 11 March 2016 18 min read
Anju Garg ASM Proxy: New Instance Type in Oracle 12c Prior to Oracle Database 12c, an ASM instance ran on every node in the cluster and ASM Cluster File System (ACFS) Service on a node... 15 February 2016 11 min read
Houri 12c Histogram: TOP-Frequency As of Oracle version 12.1, if a number of buckets N in a histogram is less than the number of distinct values in the data... 19 January 2016 13 min read
Jonathan Lewis Basics of the Cost Based Optimizer – part 6 In part 5 of this series I started working through a list of queries designed to demonstrate ways in which the optimizer can produce bad... 04 November 2015 14 min read
Anju Garg TSPITR Using ACFS Snapshots Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database files (database version 11.2.0.4 and... 10 August 2015 16 min read
Ravi Kumar Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c Introduction For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and opens it with NORESET LOGS... 03 July 2015 12 min read
Anju Garg 12c: Database Backups Using ACFS Snapshots Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment ) supports database files (database version 11.2.0.4... 29 June 2015 11 min read
