Securing enterprise business-critical data is as important for DBAs as database tuning and data protection. Oracle provides comprehensive and powerful security controls/solutions to ensure data privacy and data security which will help with meeting regulatory compliance. Oracle supports the following security controls: Data Masking Advance Security (TDE, Data Redaction) Label security Virtual Private Database (VPD) Fine Grained Auditing (FGA) Data… Read more
When Oracle initially introduced the standby database concepts, the solo intention was to deliver the solutions to protect enterprise critical business data from any sort of natural and unnatural disasters. Since its innovation, Oracle has incorporated huge amount of new functionality/features and made several enhancements to ensure the standby database deliver and meet various user demands. This article is not… Read more
Parts 1,2 & 3 focusssed more on the most useful improvements and enhancements of Database administration: Performance Tuning, RMAN, Data Guard, ASM and Clusterware. This part of the series will mainly focus on some of the new features that are useful to developers. Read Oracle Database 12c New Features – Part 1 Read Oracle Database 12c New Features – Part… Read more
During this Oracle Database 12c new features article series; I shall be extensively exploring some of the miscellaneous, yet very useful, new additions and enhancements introduced in the areas of Clusterware, ASM and RAC database. Read Oracle Database 12c New Features – Part 1 Read Oracle Database 12c New Features – Part 2 Part 3 covers: Additions/Enhancements in ASM Additions/Enhancements… Read more
During this Oracle Database 12c new features series, I shall be extensively exploring some of the miscellaneous, yet very useful, new additions and enhancements introduced in the areas of Database Administration, RMAN, Data Guard and Performance Tuning. Read Oracle Database 12c New Features – Part 1 Part 2 covers: Table partition maintenance enhancements Database upgrade improvements Restore/Recover data file over… Read more
During this Oracle Database 12c new features article series, I shall be extensively exploring some of the very important new additions and enhancements introduced in the area of Database Administration, RMAN, High Availability and Performance Tuning. Part I covers: Online migration of an active data file Online table partition or sub-partition migration Invisible column Multiple indexes on the same column… Read more
This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have to cope with numerous challenges when migrating an existing non-cluster environment to a cluster environment. One of the most significant challenges a DBA faces is to migrate/convert an existing single instance to RAC. Oracle provides several easy methods to carry… Read more
It has been a common practice and relatively a tough task for almost every individual Oracle DBA to decide whether to proceed or not with the upgrade whenever Oracle releases new version. The core objective of this presentation is to share my experience of upgrading 4 Cluster environments with nearly 200 databases to Oracle 11gR2. The presentation is best suited… Read more
I have just learnt a couple of new methods to obtain an Optimizer (10053) trace for any sql statement that is already in the cache, without actually executing it and also enabling ‘events infrastructure’. With 11gR2 onwards, you can either use the DBMS_SQLDIAG.DUMP_TRACE package procedure or use new diagnostic events infrastructure to obtain the 10053 trace for a given sql_id… Read more