Posted by André Araujo on Nov 6, 2009
Last Friday in the Sydney Oracle Meetup I talked about Oracle Flashback technology and how it helps to reduce downtime. The session generated great interest among the attendees, which led to interesting discussions and many questions about the subject.
Some of the questions couldn’t be answered during the meeting so I’ve followed up on them and I’m posting the answers here since they may be of interest for many others.
Q: Is there a separate background process for writing flashback logs?
A: Yes. Read the rest of this entry . . .
Posted by Alex Gorbachev on Jul 14, 2009
What: Sydney Oracle Meetup #8 — Exadata Extravaganza
When: Friday, July 17, 2009 5:30 PM (please, make sure to RSVP yes/no/maybe)
Where: Sydney CBD Join meetup for the detailed location.
The topic for this meetup is quite exciting – Oracle Exadata and everything about it. David Centellas, Senior Database Consultant from Oracle will do technical presentation on Exadata and, after the break, we will have a open forum discussion where two Oracle’s Enterprise Architects, Tim Rubin and Chris Jones, will answer our questions and share thir real-world experience.
Schedule:
- 5:30pm – 6:00pm — Networking with food and refreshments
- 6:00pm – 7:00pm — Presentation on Exadata by David Centellas
- 7:00pm – 7:30pm — Break and informal networking
- 7:30pm – 8:30pm — Open Forum based on real-world Exadata experience with David Centellas, Tim Rubin and Chris Jones
- post even — optional gathering in the nearby pub – it’s Friday night in the end!
Read the rest of this entry . . .
Posted by Alex Gorbachev on Jun 10, 2009
What: Sydney Oracle Meetup #6 — storage for Oracle databases
When: June 17, 2009 5:30 PM. Please RSVP Yes/No/Maybe.
Where: Our usual location at Sydney CBD. Level 3 this time!
Details:
We will start at 5:30PM with pizza and drinks and roll on from there as usual.
Note that we are meeting at the level 3 this time!
This meetup will be focused on storage technologies for Oracle database. It looks like a short presentation on Oracle Automatic Storage Management is in order – quite a few people are missing the concepts of the Oracle flagman storage storage solution and it’s useful to understand the approach whether you use it now or not.
So the presentation is – Oracle ASM 11g – the Evolution by Alex Gorbachev:
Read the rest of this entry . . .
Posted by Alex Gorbachev on Jun 1, 2009
I think it was the smallest group so far which is not surprising considering that Monday has been the least popular day in our internal poll. We had a tad less than 20 people but very good size for the informal discussion of Oracle 11g adoption that took place at the second half of the meetup.
Turned out that there are very few people running 11g in production. Besides us at Pythian with number of clients on 11g, we’ve had only couple people I think including Carl Young from Metcash. Carl shared their experience of running a multi-terabyte data-warehouse on Oracle 11g and how the migration happened. Thanks a lot Carl for your insights!
If you haven’t seen the case study from Oracle about this migration — see what benefits Metcash had with 11g migration. I myself took note of few areas — Query Cache helped a lot on dimension tables lookups and some popular reports, Materialized Views invalidation problems reduced, CBO becomes smarter.
Some of the things to pay attention to in 11g — Oracle Warehouse Builder 11g (11.1.0.6) has actually less features than the latest OWB 10g release. If you look at 11.1.0.7’s list of bugs fixed (Metalink Note 601739.1), you would see a few dozen bugs on “Wrong Results” Read the rest of this entry . . .
Posted by Alex Gorbachev on May 26, 2009
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 the rest of this entry . . .
Posted by Alex Gorbachev on May 25, 2009
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. Read the rest of this entry . . .
Posted by Alex Gorbachev on May 13, 2009
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 the rest of this entry . . .
Posted by Alex Gorbachev on Apr 22, 2009
What: Sydney Oracle Meetup #3 – Focus on E-Business Suite + Oracle/Sun deal
When: April 28, 2009 5:30 PM
Where: As usual – Sydney Mechanics School of Art
How: just register at the SOM website.
We have to limit the number of people to 40 this time so make sure you RSVP timely!
We are gathering at 5:30pm and technical goodies are starting at 6pm so use this time to catch up with other members. We should finish by 8:30pm including a beaks and some post follow up. The presentation schedule is a bit floating this time.
As usual, we should have some pizza and beverages facilitating seamless peer networking. ;-)
In addition to the main topic, we plan to have some overview of Oracle / Sun deal and share what everyone thinks about it + report from the InSync09 conference. We will talk a bit about MySQL as it becomes Oracle technology now.
Read the rest of this entry . . .
Posted by Alex Gorbachev on Apr 1, 2009
Before I get to the announcement of the next Sydney Oracle Meetup, let me share the experience from the the Very First SOM that took place yesterday. I think I can sum it up as one word — awesome!
My schedule was a bit crazy recently and I was afraid I could forget something important under time pressure (it always happens to me). In the end, I did forget few things (like napkins and power adapter for my MacBook) but it was all resolved.
Thanks to Andre Araujo for helping me to carry some of the required “ingredients”. One of the attendees was there a bit early so we’d got additional help preparing the room (thanks Jack). As we just cracked the first beers and pizzas, people started arriving and we had nice 30 minutes of warm up.
Read the rest of this entry . . .
Posted by Alex Gorbachev on Mar 19, 2009
Gday everyone. This information would be most useful for the Oracle professionals in Sydney, Australia. I’m very excited to announce the Sydney Oracle Meetup (SOM).
Read the rest of this entry . . .
