Friday, January 27, 2012
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
Latest Topics
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 [Read More]
Cluster SSH tool Utility
Many times you come across scenario’s when you wish to open multiple ssh windows and execute same commands.e.g [Read More]
11g: Multiple failed login attempt can block New Application connections
In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple [Read More]
Subscribe To Feed
10g
10gR2 Silent Install with 11gr2 CRS fails
I was trying to perform a 10.2 silent install with 11gR2 CRS. While doing pre-checks installer failed with following error Check complete: Failed <<<< Problem: The 'active' version of Oracle Clusterware is not 10g Release 2 (10.2). Recommendation: You must upgrade all nodes of the cluster to Oracle Clusterware 10g Release 2. If you have [Read More]
11g
11g: Multiple failed login attempt can block New Application connections
In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple sessions hitting database with wrong password. As per [Read More]
Oracle Critical Patch Update January 2012
I guess most of us having My Oracle Support have got email from Oracle mentioning that Critical Patch Update January 2012 has been released. Main reason behind this is [Read More]
User Sessions stuck on resmgr:cpu quantum wait event
We were experiencing lot of session getting stuck on resmgr:cpu quantum in our database. In fact at a time we had 70 sessions which were stuck on this wait event and our [Read More]
GRID
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 Configure 12c agents. 3. Upgrade 11g OMS to 12c. The approach used [Read More]
Performance
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]
V$SQL_SHARED_CURSOR in 11.2.0.2
Oracle 11.2.0.2 has introduced new column “REASON” to V$SQL_SHARED_CURSORS. I [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]
Recent Comments
{ @Ganesh: The global stats were up-to-date for both the databases, though I did not check the col stats. But the automated gather_stats_job ran next day... } – Jan 21, 8:40 AM
{ Verify DBA_TAB_COL_STATISTICS in both database for those tables to get information on histograms. select owner,job_name,schedule_name,enabled,state,last_start_date from DBA_SCHEDULER_JOBS } – Jan 20, 10:17 AM
{ Thanks Suvv and Anand for your comments... } – Jan 20, 9:00 AM
{ I am curious if you find anything. Having almost identical issues, CBO chose MJ vs HJ. } – Jan 20, 5:37 AM
- Older »