Auto Restart Enterprise Manager Cloud Control Agent 12c

Wissem El Khlifi on 10 May 2012 with 0 comments

Introduction: Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database resources. Database instances, listeners are resources that can be automatically restarted after a hardware or software failure or whenever the server host restarts. These components can be easily added to the Oracle Restart using the crsctl add command. In this… Continue Reading →

An Introduction to 11.2 RAC Server Pools

Aman Sharma on 18 April 2012 with 7 comments

Oracle RAC is designed to cater for Oracle specific applications and also non-oracle applications. These applications, both Oracle and non-Oracle, when deployed on RAC, are termed as resources and Oracle RAC can manage both kinds of resources on the clusterware stack. Examples of both oracle and non-oracle resources are: database instance, database services, xclock, Apache etc. The traditional way to… Continue Reading →

Dynamic Sampling (II) – Controlling the Activity – Part 2

Randolf Geist on 15 March 2012 with 1 comments

In the first part of this post I’ve provided a table that summarizes the Dynamic Sampling levels on session / system level. In the “Blocks Sampled” column there were numbers in brackets for the level 3 and 4 description. In the second part of this post I’ll explain why. DYNAMIC_SAMPLING_EST_CDN In the presence of statistics Dynamic Sampling behaves differently: For… Continue Reading →

Dynamic Sampling (II) – Controlling the Activity – Part 1

Randolf Geist on 08 March 2012 with 2 comments

I’ve closed the introduction to Dynamic Sampling with an odd test case result: Although all table data was read by Dynamic Sampling the cardinality estimate of the optimizer was still way off – not quite what one might expect. The reason for this odd behaviour can be explained by the fact that Dynamic Sampling behaves differently depending on whether statistics… Continue Reading →

Security in the Database is more than Just Granting Access

Michelle Malcher on 06 March 2012 with 2 comments

Michelle Malcher (Oracle Ace Director and a representative on the Oracle Security Customer Advisor Council for the Independent Oracle User Group) presents practical ways to look at security and implementing standards and procedures around the database environment to account for the security outside of the users, including secured environments for regulations and compliance. Oracle 11g provides transparent data encryption at… Continue Reading →

Upgrading to Oracle 11gR2

Syed Jaffer Hussain on 05 March 2012 with 0 comments

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… Continue Reading →

Caching Part 2

Patrick Barel on 23 February 2012 with 5 comments

Never trust a computer you can’t throw out of a window. Steve Wozniak Deterministic Function Caching A function is considered deterministic if the outcome is the same if the input values are the same. Another thing is that the program should have no side effects. All the program changes are the return value and any out parameters. It is because… Continue Reading →

An Easy Way to Obtain 10053 Trace

Syed Jaffer Hussain on 23 January 2012 with 0 comments

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…. Continue Reading →

Oracle Essentials, 4th Edition – Oracle Database 11g

All Things Oracle on 19 December 2011 with 0 comments

Download FREE eBook Oracle Essentials, 4th Edition by Rick Greenwald, Robert Stackowiak & Jonathan Stern (O’Reilly) is a must have reference for anyone doing development or management of Oracle databases. Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the… Continue Reading →

Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2

Tim Hall on 14 November 2011 with 0 comments

This article on ORACLE-BASE describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Enterprise Linux 5 64-bit) using VMware Server 2 with no additional shared disk devices. The article is arranged in the following sections: Introduction Download Software VMware Server Installation Virtual Machine Setup Guest Operating System Installation Oracle Installation Prerequisites Install VMware Client… Continue Reading →