Posts by Alex Gorbachev

How to Dynamically Call PL/SQL Procedure in Oracle

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…

Pythian Video: Oracle RAC — Why VIPs?

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”.

Sydney Oracle Meetup #5 — Oracle 11g Adoption

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.

Oracle RAC Workload Management: A Webinar by Alex Gorbachev

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.

Alex Gorbachev — Interview on High Availability @ InSync09

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.

Sydney Oracle Meetup #3 — Focus on E-Business Suite

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.

Page 13 of 28« First...1112131415...20...Last »