Tag: Oracle

Log Buffer #149: A Carnival of the Vanities for DBAs

This is the 149th edition of Log Buffer, the weekly review of database blogs.

Read More >

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…

Read More >

Sydney Oracle Meetup #5 Report: Oracle 11g New Features

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.

Read More >

Webinar for EMEA, June 4: Migrating to an Open Source DB Platform

Paul Vallée, Pythian’s founder and Executive Chairman really opened our eyes. Paul talks about Oracle’s 11G features with the same enthusiasm he has for MySQL’s federated architecture, or for SQL Server’s peer-to-peer replication technology. You could hardly find anybody who presents his visionary views of the new technology trends like cloud computing, virtualization, or server consolidation with such a deep understanding of the topics. Here is your opportunity to confer with Paul Vallée on Thursday, June 4, 2009 12:00 PM–1:00 PM CEST (11AM–12:00 PM GMT) in a free webinar, Database Platform Migration.

Read More >

Log Buffer #148: A Carnival of the Vanities for DBAs

This is the 148th edition of Log Buffer, the weekly review of database blogs. Welcome.

Read More >

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

Read More >

Sydney Oracle Meetup #2 Report – Visualizing Oracle Performance

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.

Read More >

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.

Read More >

Log Buffer #147: A Carnival of the Vanities for DBAs

Welcome to the 147th edition of Log Buffer, the weekly review of database blogs.

Read More >

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.

Read More >
Page 92 of 147« First Page...10...9091929394...100...Last Page »