Latest Posts in OraTalk - www.ritzyblogs.com

How to use Oracle Resource Manager to control degree of parallelism with examples

Feb
8

Tue

Posted By Ritesh Chhajer on Tuesday, February 08, 2011
2615 Views

Oracle Database Resource Manager can be used to manage resources based on workload like idle time limits, CPU utilization, degree of parallelism, etc. Here we'll focus on on how to set it up and few examples pertinent to controlling degree of parallelism(DOP).

Tags degree of parallelism, dop, parallelism, resource manager

Getting started with 11.2.0.2 - New features

Nov
17

Wed

Posted By Ritesh Chhajer on Wednesday, November 17, 2010
1958 Views

This is 2nd part of getting started with 11.2.0.2 series. In the previous one we saw the upgrade process. Here, we'll see new features specific to 11.2.0.2. For general overview of 11gR2 new features, refer to Oracle 11gR2 Features and Bugs.

Tags 11.2.0.2, amm, cvu, haip, hugepages, interconnect, multicasting

Getting started with 11.2.0.2 - The Upgrade

Nov
8

Mon

Posted By Ritesh Chhajer on Monday, November 08, 2010
8729 Views | 4 Comments

With advent of Oracle 11.2.0.2, lots of bugs associated with 11gR2 database are supposed to be fixed so I've been testing the installation, upgrade and the new features pertinent to it. This post shall cover the steps to upgrade from Oracle 10.2.0.4 to 11.2.0.2 using silent installation and manual upgrade. In the next one, I'll share the new features specific to 11.2.0.2

Tags 11.2.0.2, catupgrd, multicast, ntp, xdb

EMC Powerpath and ASM

Oct
2

Sat

Posted By Ritesh Chhajer on Saturday, October 02, 2010
2421 Views | 1 Comments

EMC Powerpath basically provides multipathing and improves I/O over SAN. When dealing with CLARiiON array, database backup would be taken at LUN level using Navisphere CLI(naviseccli) snapview that would allow to create a copy of LUN using snapshots. That's why it becomes highly imperative to have mapping of LUN to physical device and ASM diskgroup. I'll be covering on the script to have that kind of mapping using powerpath management utility and also a little bit on I/O.

Tags asm, emc, naviseccli, navisphere, oracleasm, powermt, powerpath, snapview

Oracle 10g CRS troubleshooting tips and tricks

Aug
21

Sat

Posted By Ritesh Chhajer on Saturday, August 21, 2010
5323 Views | 7 Comments

It's all good to be an architect and discuss Oracle internals at length but in real time production issues, when the shit hits the fan, everyone runs for the cover. Anyways, without digressing further, I've tried to consolidate various issues pertinent to 10g CRS along with troubleshooting tips and specific examples to fix them.

Tags cluvfy, crs, crs_register, crs_stop, crs_unregister, crsctl, diagwait, ifconfig, listener, ocr

Oracle 11gR2 Features and Bugs

Jul
30

Fri

Posted By Ritesh Chhajer on Friday, July 30, 2010
6827 Views | 13 Comments

For last few months, I've been busy like hell dealing with umpteen number of Oracle 11gR2 RAC installations and upgrades and it's been a roller coaster ride discovering a new feature or bug every day. So I reckon it's high time to consolidate and put together a summarized checklist for fellow DBAs. Obviously, I won't be able to cover all the 11gR2 features but nevertheless would like to share my learnings and discoveries.

Tags asm, compatible, crs, diagnostic_dest, diskgroup, grid, hugepages, listener, rac, service