DBAToolZ

Lightweight Oracle DBA Tools

 

Archive for June, 2009

Notes from the 11g Upgrade & Best Practices hosted by Tom Kyte

I finally got out of the dungeon and made it to an Oracle hosted event titled “Oracle Technology Day – 11g Upgrade & Best Practices” which was hosted by Tom Kyte and Oracle Center of Excellence (COE) folks in Los Angeles on June 16 ‘09. And it was definitely worth it. I got [...]

Oracle RAC’s share everything vs share nothing …

Google’s share nothing approach to application development has lead to the #1 search engine solution both in performance and functionality. Notice that I said “application development” because for the share nothing approach to work it needs to be built into the application from day one not as an afterthought.
On the other end of the [...]

What the heck is “snapshot standby”?

I was just reviewing Note:565535.1 Flashback Database Best Practices & Performance and came across the following paragraph under the title of “Measuring Impact of turning Flashback Database ON / Analyzing the Performance Impact“:
If you’re on RDBMS release 11g and have a physical standby, then you can enable flashback database on your physical standby and then [...]

09′ IOUG Collaborate – notes for Oracle DBAs

I just reviewed Tom Kyte’s presentation from the 09′ IOUG Collaborate event and made a list of things that are specifically interesting to an Oracle DBA with the links for further research into each feature.
I. Those managing PHP/Oracle shops will be happy to learn that there’s a new Database Resident Connection Pool [DRCP] that performs [...]


My name is Vitaliy Mogilevskiy -- I started working with ORACLE Products in 1996 (Oracle v7, 7.3.4 was pretty good).

What you will find here is what works for me day in day out - 24x7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database -- sqlplus and KSH.

Do you have DBA questions? Head over to Ask DBA.

RSS DBA Forums


Recent Comments

  • Hans Forbrich: Douglas – your comment about ASM after Clusterware was true for 11gR1 and older. With 11g...
  • gurpreet: thanks…..
  • MVE: According to the 11gR2 documentation — “OCR and voting disk files can be placed either on ASM, or on...
  • Douglas: Dude, You can’t put the OCR and vote/quorum devices in ASM… Clusterware must be up before ASM,...
  • Craig: Easy to understand -as an Oracle newbie it was very usefull.Thx I followed your tutorial and I’m...

Categories

Blogroll


Archives