Tag: Oracle

Alex Gorbachev at Oracle Open World 2008: Oracle Clusterware

If a MySQL DBA from Pythian goes to Oracle Open World, it would be a shame not to send an Oracle bloke, so there I am — presenting a 90-minute session on the first day of the OOW 08 entitled Under the Hood of Oracle Clusterware. I gave it during RAC Attack in Chicago and I’m pretty satisfied with how it went, so there should be no significant changes to the presentation. The session is in “User Group Forum,” thanks to RAC SIG and Dan Norris.

Read More >

Oracle Silent Mode, Part 7: Installing an 11.1 RAC Database

This seventh post digs into some of the silent installation commands of an 11.1 RAC. As for the Installation of a 10.2 RAC Database, this post shows how to (1) install the 11.1 clusterware, (2) install the 11.1 database, and (3) create a RAC database. It doesn’t explore any Patch Set upgrade since 11.1.0.7 is not out for now. Another interesting question, however, is how to upgrade the 10.2 clusterware to 11.1, since it has to be done in place. So let’s get into it.

Read More >

Consistent Gets not the Best Way to Look at Query Performance

This post is for those who think Consistent Gets is the only thing that matters. It’s not. That’s why Statspack and AWR provide not only the top queries sorted by Consistent Gets but also Sorted by IO, CPU, Cluster Waits, and so on. I won’t argue. Check for yourself.

Read More >

DBD::Oracle 1.22 Released

The latest release of DBD::Oracle is now ready and can be found at: CPAN DBD::Oracle. It is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles, under the auspices of The Pythian Group as open source/free software.

Read More >

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

It’s time again for another edition of the weekly review of database blogs, Log Buffer. Since it was a big week for SQL Server, let’s start there, shall we?

Read More >

RAC Attack — Day 2 by Alex Gorbachev

Last night, I left my presentation in a good state and verified the first batch of demos — all worked fine. This morning turned into a disaster as I found out that the rest of my demos stopped working. Well, I didn’t have any other choice but to add new slides with some demo results. Since I did it in a rush, there were some overlaps and I ended up with way too many slides. Good news that the first demo generated sufficiently enough interest about services automation and connection load balancing so we spent significant time there. All in all, today’s session wasn’t as good as yesterday but I managed to avoid a complete failure with the demos so I guess I shouldn’t complain.

Read More >

Oracle Import Performance: Does Import Use Single-Row Inserts?

Recently, I was involved in a discussion about import performance in this OTN forum in which the original poster raised the issue of whether or not import will resort to single-row inserts for tables with date columns. For array inserts, the buffer parameter essentially specifies the size of this array. We know, however, that if a table has lob columns, the import parameter buffer is not honored, and the import utility will use single-row inserts for those tables. But tables with date columns, so the claim goes, also must suffer single-row inserts. In this blog, I will probe this further and validate that claim.

Read More >

How Do You Edit a dump/exp/script File?

If you work with databases long enough, you run into a certain problem. You have a mysqldump file* of a table or a database, and you need to import it into your new database. However, you need to change something in the file first. Well, one simple solution is to use the sed tool to modify the file. Sed actually stands for “stream editor”. The vi editor would be considered a static editor in that it loads all of the file into memory at once. If you run out of memory, you are out of luck.

Read More >

IOUG RAC Attack! — Day 1 by Alex Gorbachev

My session was scheduled after lunch and all attendees made it back which is a good sign (thanks to good presentations from Dan Norris and Edward Whalen). I’m pretty satisfied with the results — I was able to reproduce all eviction examples I planned from the first time and I had to skip only few demos at the end (I suspected I wouldn’t get there). Anyway, I covered all the material except those last few demos (well, the audience will have labs tomorrow and I can play with it) and quick look at the few script internals and sources but that was handed over as a home work.

Read More >

Join us! Pythian Europe Launch Event in Prague on Wednesday

I’m pleased to announce that there will be the formal launch of Pythian Europe at the premises of the Canadian Embassy in Prague on Wednesday the 6th of August from 17:00 to 18:30. This historic event will be announced by Mrs. Sameena Qureshi, Trade Counsellor, Embassy of Canada; and Paul Vallee, President and Founder, The Pythian Group. Present will be various members from the press (IT and Business), as well as representatives from Oracle and Sun Microsystems, the Canadian Chamber of Commerce in Prague, and many more. We will prepare some unusual and very tasty snacks and refreshments.

Read More >
Page 101 of 143« First Page...10...99100101102103...110...Last Page »