16 April 2014
16 April 2014

How is data security maintained and what’s new in Oracle 12c database security – Part 1

0
1
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
0
1
26 February 2014
26 February 2014

Gaining maximum benefits from Oracle Data Guard

0
1
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
0
1
25 July 2013
25 July 2013

Oracle Database 12c New Features – Part 4

0
12
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
0
12
11 July 2013
11 July 2013

Oracle Database 12c New Features – Part 3

1
7
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
1
7
03 July 2013
03 July 2013

Oracle Database 12c New Features – Part 2

0
7
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
0
7
27 June 2013
27 June 2013

Oracle Database 12c New Features – Part I

1
28
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
1
28
15 April 2013
15 April 2013

Managing & Troubleshooting Cluster

0
0
In this webinar, Syed Jaffar Hussain (Oracle ACE Director and Oracle Magazine Editor’s choice award (2011) for ‘Technologist of the year, DBA’) explains how to manage and troubleshoot various clusterware issues. View the presentation slides Watch video You will learn: Grid Infrastructure (Clusterware) startup sequence, like how things getting started after a node reboot or cluster start-up How to understand… Read more
0
0
17 April 2012
17 April 2012

Migrating Oracle Single Instance to RAC

0
1
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
0
1
05 March 2012
05 March 2012

Upgrading to Oracle 11gR2

0
0
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
0
0
23 January 2012
23 January 2012

An Easy Way to Obtain 10053 Trace

0
0
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
0
0