Hi everybody! Probably most of you knows about me and my plans, really need a hang out to think and planify the challenges that are comming in my professional life. Also It’s true I’m a little stressed out, for this reason I’ll take a break and stop blogging. Guess I’m comming back at end of August ...
Who should read this white paper? This white paper is intended to be accessible to those who are not relatively new to the Real Applications Cluster performance. Familiarity with advanced Oracle concepts and SQL language is assumed. About Technical Reviewers Pablo Albeck – Oracle Practice Manager at Oracle Corporation, with several years of experience in performance tuning complex Systems. ...
Introduction 11g Release 2 has introduced a new option to administer the cluster called “Police-based Management”, traditional physical method is still available. This is an incredible new feature that needs to be researched, clearly marks the new direction that Oracle wants to give us, BTW, it’s a smart direction/possibility where the efforts will be concentrated in the ...
Still reviewing. Thanks for your interest. I wrote a White Paper that actually is under revision. It will be distributed the first month exclusively from http://oracleracsig.org Bookmark this page and come back after Jun 21, 2010. Regards, J // ...
Finally approved the exam 1z0-050, my OCP certification is uptodate. Now preparing the Oracle Certified Master 11g. I would recommend the Robert G. Freeman book called “Oracle Database 11g New Features”, foreword by Tom Kyte. You will find this book used/new in Amazon starting from 15 bucks. Note: 1z0-050 is an upgrade exam. Certification ...
This utility was introduced in Oracle 11.1, it is an excellent tool to understand if your actual workload is overloading your disks or file systems. I/O is very important in an Oracle database so I really recommend to all DBAs the use of this great utility to know the actual capacity of your hardware. Below ...
Background Processes From 10g and over, Real Application Cluster databases has two new background processes: LMON – The Global Enqueue Service Monitor monitors the entire cluster to manage the global enqueues and the cluster resources. LMON manages instance and process failures and the associated recovery for the Global Cache Service (GCS) and Global Enqueue Service (GES). ...
Premier Support for the 10gR2 database ends in July 2010. If you haven’t already started planning your 11g database upgrade, we recommend that you start as soon as possible . // ...
The contention in blocks can be measured by using the block transfer statistic. The first step is to determine block transfer time examining the gv$sysstat view: global cache cr block receive time global cache cr blocks received. The time is determined by calculating the ratio of global cache cr block receive time to global cache cr blocks received. ...
PL/SQL can often add to program functionality and programmer efficiency, and there are certainly many cases in which a procedural language such as PL/SQL can do things that a nonprocedural language such as SQL cannot. For a number of reasons, a PL/SQL approach might offer great performance improvements over a traditional SQL approach. Why to use ...