-
Archives
- April 2019
- March 2019
- September 2018
- August 2016
- July 2016
- May 2015
- April 2015
- December 2014
- November 2014
- August 2014
- February 2014
- January 2014
- November 2013
- July 2013
- June 2013
- March 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
-
Meta
Category Archives: Oracle in general
Happy Easter: Oracle 11g Release 2 for Windows released
As of April 5th Oracle released Oracle 11g Release 2 for Windows 32-bit and 64-bit. The software can be donwloaded from OTN. Update: I just noticed neither Clusterware (aka “RAC”) nor ASM are available for 32-bit Windows.
Posted in Oracle in general
Leave a comment
MEMORY_TARGET (SGA_TARGET) or HugePages – which to choose?
Oracle 10g introduced the SGA_TARGET and SGA_MAX_SIZE parameter which dynamically resized many SGA components on demand. With 11g Oracle developed this feature further to include the PGA as well – the feature is now called “Automatic Memory Management” (AMM) which … Continue reading
Posted in Oracle 11g Release 2, Oracle in general
20 Comments
Integrate EM Console Startup/Shutdown into Clusterware Control
When installing a RAC clusterware is responsible for starting and stopping required resources automatically and in required order. Under normal circumstances every resource is integrated with one exception: EM Control. So this is a short guide on how to integrate … Continue reading
Posted in Oracle in general
5 Comments
Creating a Oracle 10g Release 2 or 11g Release 1 database on a 11g Release 2 Cluster
Today i installed a Oracle 11g Release 2 cluster on Solaris SPARC. Installation went smooth – except installation was not able to set up SSH equivalency automatically so i had to configure it myself. After installing Oracle 11g R2 grid … Continue reading
Posted in Oracle in general
6 Comments
How to trace DBCA (>= 10g)
Tracing DBCA can be useful. Starting with 10g onwards this can be achieved by: 1. Copy dbca to dbca_debug cp dbca dbca_debug 2. Edit dbca_debug file, fine the last line and add “-DDEBUG” before the “-classpath” argument. The edited line … Continue reading
Posted in Oracle in general
3 Comments
Creating database clones with ZFS really FAST
While working on my most recent project i tested an interesting ZFS feature: writeable snapshots aka “clones”. While testing i came to the conclusion that with the help of clones oracle databases (and, of course – other databases as well) … Continue reading
Posted in Oracle in general
3 Comments
I am Oracle Certified Trainer now
Just a short note from myself: Last week i successfully completed all requirements to become an Oracle Certified Trainer Preparing for the course took all my time so there was little time left to write in my blog. Beside preparing … Continue reading
Posted in Oracle in general
6 Comments
Oracle 11g R2 for UP-UX (Itanium) and AIX (PPC64) released
When checking OTN today i noticed the release of Oracle 11g Release 2 (11.2.0.1.0) for HP-UX (Itanium) and AIX (PPC64) I am surprised 11g R2 for Itanium was released prior 11g Release 2 for Windows…..
Posted in Oracle in general
Leave a comment
OOW 2009 catch-up
Perhaps a little bit late but this post is a catch-up of interesting speeches held at the recent Oracle open world 2009: Database Consolidation Tips by Husnu Sensoy: you can get his presentation in his blog or here as local … Continue reading
Posted in Oracle in general
Leave a comment
How much memory is being used per program (not process)
Sometimes administrators want to know how much memory is being used by a program (and not per process). This is especially useful to calculate the memory consumption for an oracle instance. Today i found a nice script for doing so … Continue reading
Posted in Oracle in general
3 Comments