10g
Copying Oracle Scheduler jobs with Arguments
Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy jobs which have arguments. Need to copy jobs can arise due to following scenarios 1)Runaway jobs – When Scheduler job is running without any SID. This means OS session is not present and this will not [Read More]
11g
Using current_scn for RMAN incremental ? Think again..
I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby database which lagged by considerable time and we [Read More]
Poll on Sql Plan Management
Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM and SQL Profiles (using coe_xfr_profile.sql) to [Read More]
ORA-7445 core dump [kokscold()+849] from EM 12c
The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file [Read More]
GRID
ORA-7445 core dump [kokscold()+849] from EM 12c
The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file /u01/app/oracle/diag/rdbms/pkldb/pkldb/trace/pkldb_j035_14712.trc (incident=52961): ORA-07445: exception encountered: core dump [Read More]
Performance
Poll on Sql Plan Management
Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be [Read More]
Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins
In one of my databases, one application query suddenly started to pick Nested-Loop joins [Read More]
Plan Stability using Sql Profiles and SQL Plan Management
PLAN STABILITY How many times you have noticed a query using Index X when you wanted it [Read More]
Featured
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c (12.1.0.1.0). The Complete Upgrade process will be carried out under 3 different stages: 1. Patch existing 11g OMS to get the 12c upgrade console. 2. Deploy and [Read More]
Upgrading Grid Infrastructure 11.2.0.1 to 11.2.0.2 on RHEL4
11.2.0.2 Patchset was released few days back. I decided to upgrade a test RAC database to 11.2.0.2 yesterday and was able [Read More]
11gR2: Steps to Rename ASM Diskgroup with DB files
11gR2 introduced renamedg utility to rename diskgroups. I would discuss renaming a diskgroup on a Standalone Grid [Read More]
11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
Ever since 11gR2 has been released, it has created a lot of buzz in Oracle Blogosphere with various posts on 11g Release 2 [Read More]