Clicky Web Analytics

Clicky


Feb
8
Tue
Posted By Ritesh Chhajer on Tuesday, February 08, 2011
7464 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).



Nov
17
Wed
Posted By Ritesh Chhajer on Wednesday, November 17, 2010
3696 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



Nov
8
Mon
Posted By Ritesh Chhajer on Monday, November 08, 2010
14019 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

Categories
RAC



Oct
2
Sat
Posted By Ritesh Chhajer on Saturday, October 02, 2010
6097 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.

Categories



Aug
21
Sat
Posted By Ritesh Chhajer on Saturday, August 21, 2010
18503 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.



Jul
30
Fri
Posted By Ritesh Chhajer on Friday, July 30, 2010
12780 Views | 15 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.

Categories
RAC



Latest Posts in  OraTalk  - www.ritzyblogs.com

Recommended Oracle DBA Books Minimize

     

Tag Cloud Minimize


Archive Posts Minimize
 
Monthly
    Yearly

    Disclaimer:
    This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use.

    This posting has nothing to do with my present or past employer.