“Seeing it once is better than hearing about it a thousand times” — I think this is the closest translation from one Russian proverb. I may add that hearing and seeing might be often better then reading so let me try to start a series of small videocasts about Oracle database technology.
One of the topics that beginners RAC DBA’s (along with network engineers supporting Oracle database infrastructure) are confused about is the Virtual IP usage in Oracle RAC starting from Oracle Clusterware 10g.
Read more...
More than a month has passed since Sydney Oracle Meetup #2. We shot some video, but it took me a while to process it and publish a few interesting pieces, but I finally got it all.
Ric Van Dyke’s presentation on tuning SQL queries using 10046 trace is available on the SOM website in the Files section (you must be a member). However, there were no material from Tanel Poder’s session — it’s title started with “Zero Slides…” and Tanel demonstrated live some of his secrets of productivity in Oracle troubleshooting. Luckily, my colleague, Andrey Goryunov, managed to shoot some of it on the video and I’m publishing here a couple fragments on the visualization of Oracle performance troubleshooting.
Make sure you are watching them in HQ on YouTube to see more details and if you like these videos, make sure you rate them.
PerfSheet is a very handy solution based on Microsoft Excel scripting and let you automate extraction and charting of any data you can extract from an Oracle database (and generally speaking, any other database). The best thing is that Tanel has put great efforts in it and made it available to everyone for free. One demo is worth many words so here we go:
Read more...
What: Sydney Oracle Meetup #5 - Oracle Database 11g adoption
When: Monday, June 1, 2009 5:30 PM. Please don’t forget to RSVP - whether it’s Yes, No or Maybe.
Where: As usual in Sydney CBD. See SOM#5 event page for the location.
This meetup is focused on Oracle 11g adoption. We will have one presentation followed by (or combined with) the discussion of Oracle Database 11g release, who is using it currently - what are positive and negative moments.
Apologies for Monday - it’s a rather unpopular day but this is when the room is available next week (except Friday again).
The presentation for this meeting is “Oracle 11g New Features Out of the Box” by Alex Gorbachev. Unlike many presentations on 11g new features, we will try to focus on a more subtle enhancements and less known new features.
Obviously, our audience will be the best source of features they liked (or not) so it should be an easy topic here.
During RSVP, please specify what are the topics and features you want to hear more about - we can make sure we include them on the agenda.
Event page to RSVP - http://www.sydneyoracle.com.au/calendar/10485645/. If you are not the member of Sydney Oracle Meetup - you need to join first.
What: Free Webinar — Oracle RAC Workload Management
When: Tomorrow! 2 separate webinars in two timezones
- Australian timezone - 21-May-09 12pm AEST (Sydney/Melbourne)
- North American timezone - 21-May-09 4pm EDT or 12PM PDT
Where: Online. Register for North American or Australian webinars.
Details:
When I posted my RAC Workload Management whitepaper, it was downloaded by many but it turned out that not everyone has half a day to go through such level of details and, frankly, not everyone is interested in how those features are implemented.
This prompted me to put together a webinar that does high level overview of available options to balance workload properly with Oracle Real Application Clusters. I think it would be especially useful for IT management and IT architects who do not necessary have full depth of Oracle knowledge but still need to know the general principles so that the optimal decision can be made and architectural solution chosen. It wouldn’t harm to be able to speak the same language with their more technical DBA’s. It should also be useful to the DBA’s having limited or no experience with RAC or who need a refresher on the features related to Oracle RAC connection management.
Having said that, this webinar does have good level of technical details so it’s not just fluffy marketing slides on how cool the technology is. The main purpose for the attendees is to learn about various features available, what are their limitations and whether these features work as advertised. Another perspective is to understand and be able to classify various requirements for workload balancing with Oracle RAC and which options work best.
Sorry, it’s a short notice — the webinar is literally tomorrow as I write this — don’t wait and register now. I hope it will fit your schedules so see your there!
Please feel free to submit the backup and recovery and DR topics you want to discuss - just mention in the comments and I’ll make sure they are on the agenda!
What: Sydney Oracle Meetup #4 - Backups, Recovery and Disasters
When: May 15, 2009 5:30 PM
Where: Our usual location in CBD see even page for details.
Meetup Description:
SOM #4 is about Oracle backup and recovery. As usual, Pizza and drinks arrive at 5:30PM and we start the presentation at 6PM. We should be out by 8:30PM with optional post-event program. It’s Friday night in the end!
Read more...
Recent Comments