In the case of a container database (CDB), the actual data belongs to the underlying pluggable databases (PDB) and each pluggable database appears as a non-CDB to the client. Therefore, it makes more sense to take an export of the objects from a pluggable database. Click here to read Part 1.
Blog | Jun 7, 2017
Blog | Jun 2, 2017
Data Pump (EXPDP/IMPDP) is a utility for exporting and importing database objects in and across databases and is commonly known to most DBAs. However, with the introduction of Oracle Database 12c and particularly with the introduction of Multi-tenant architecture, there are certain changes in the methods that we use in data pump to export and import data. Click to read Part 2
Blog | Apr 12, 2017
In force full database caching mode, Oracle Database caches the entire database in memory when the size of the database is smaller than the database buffer cache size. All data files, including NOCACHE LOBs and LOBS that use SecureFiles, are loaded into the buffer cache as they are being accessed.
Blog | Apr 11, 2017
Real-Time Automatic Database Diagnostic Monitor (ADDM): Real-Time ADDM helps us to analyze and resolve problems in hung databases without having it to restart. In OEM 12c helps us to analyze and resolve problems.
Blog | Mar 8, 2017
Prior to the introduction of In-Memory Advisor, a DBA had to manually identify the tables to be placed in the In-Memory Column Store (IMCS). However, with IMA this manual task has been eliminated.
Blog | Feb 7, 2017
Oracle Database 12c has introduced new enhancements and additions to the Recovery Manager (RMAN). The new features provide both convenience and improved functionality where users don’t need to switch between RMAN and SQL* Plus prompts during Backup & Recovery, Administration etc.
Blog | Jan 17, 2017
Post new technology upgrades in an environment, it is not easy to revert the changes without proper planning and can be daunting. However, with the above methodology you can best plan to revert changes with minimal impact. Oracle provides best service levels for traditional approach for cloud applications through business-driven monitoring application management.
Blog | Dec 9, 2016
Blog | Nov 24, 2016
Prior to 12c, we had to make the standby DB sync with the primary DB by taking an incremental backup from primary DB and applying the same in standby DB. This entire process was time consuming. In 12c, we now have a new feature Recover Standby Database Using Service, which simplifies the process greatly.