November 14, 2006

UKOUG 2006 Day 1

I was a bit late for Tom Kyte’s keynote. He talked about some new features of Oracle 11g, which will go product round Christmas 2007. Features interested me are
  • interval partition (e.g, interval by month). DBA does not need to manually create partitions any more.( I just spend half day to create new partitions on my several databases last week)
  • gather statistics by columns.

Oracle’s Maximum Availability Architecture

Larry Carpenter, Senior principle product manager of Oracle, talked about Oracle standby databases. He focused on physical standby.
  • Tune redo transfer. Redo transfer can be 100 times more efficient by simply spcify several parameters (SDU = 32K, ....)

Effective Oracle monitoring system

Jurijs Velikanovs made a very good presentation about monitoring Oracle. He suggests:
  • Use Nagios to monitor server availability. My group is actually using it now.
  • Use Cacti to monitor Oracle server performance. It can generated a history graph to display various information, e.g, oracle locks, session memory. This is the kind of tools I have been looking for a while.
    I take a quick look at cacti this evening and it use Apache/PHP/MySQL (Not good, I am a Apache/Java/Oracle person). We use Ganglia to monitor unix system. Both Cactic and Ganglia use RRDtool for data storage and visualization. Not sure whether I can use Ganglia to achieve same effect as produced by Cactic.

Accountability for system performance

Six sigma : 99.9997%
He also mentioned DBAs are taughted to ignore waits like “SQL*NET message from client” wait. But did not give reason why not. Hope can have a chat with him.

Others
  • I have attend conference for four years in a row. Every year I feel my English hearing is improving. Today I understood most part of the presentations.
    I also make mental note about the style of the presentation.
  • I was later to go back nursery to pick up Selina. Usually they charge £5 for each 10 minutes. I drove carefully but swiftly. Time is money now.

- One comment Not publicly viewable

  1. Chris May

    I installed Cacti on our monitoring box a while back, but took it off because it didn’t do anything that Ganglia and Nagios together couldn’t do – But I wasn’t thinking about Oracle at the time.

    I’ll re-install it for when you get back and we can take a look

    15 Nov 2006, 10:16


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXII