Posts by Alex Gorbachev
Just got an interesting note on Twitter that you can’t call a stored procedure dynamically in Oracle from a PL/SQL block like passing the procedure name in a variable. Well, yes we can! And the answer is EXECUTE IMMEDIATE — it can be used to run anonymous PL/SQL blog and not just a SQL statement. However, you will want to think many many times before doing so… if you love your data. Let’s create the test procedures…
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.
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. With this videocast, I will try to clarify those concerns once and for all. I have embedded the video here in a smaller window so you might want to go directly to YouTube for the full-size version of “Pythian Video: Oracle RAC – Why VIPs”.
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. Have a look.
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. 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.
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.
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!
Following my presentation at InSycn09 about Oracle E-Business Suite high availability, I gave an interview to a fellow Oracle tweeter here in Sydney and member of the team behind The Red Room blog — Gareth Llewellyn. I should say that my dedication to the interview was very strong and you will believe me if I tell you that during that time the party in the InSync09 exhibition hall was already in the full swing. Thanks to Gareth, the interview is now on Youtube and if you go there directly, you can watch in HD.
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.
I enjoyed InSync09 conference and the networking opportunities there — great place to meet bunch of good old friends and make some new ones. The content of the presentations and direction where Oracle is going to provided some interesting food for thoughts on Oracle’s strategy and how it’s going to make money with all those acquisitions they’ve done recently including current Oracle-Sun deal.