The Pythian Blog

Error Installing Oracle VM: File “/usr/lib/anaconda/network.py”, line …

Yury Velikanov — Sun, 27 May 2012 17:07:09 +0000

I just installed 3.1.1 Oracle VM server for training purposes on my sandbox and faced the same issue I faced installing 3.0.3 and 3.0.1 versions before. I quickly found a workaround that worked for me. But as follow up I decided to search though Google and MOS in order to see if there has been any good [...]

Happy Geek Pride Day!

Maryanne Birksted — Fri, 25 May 2012 18:15:09 +0000

(or: 4861707079204765656b205072696465204461791!) Geeks, freakazoids, nerds, dweebs, it’s that time of the year again: May 25th i.e., International Geek Pride Day!! Today also shares the same date as two other similar nerd “holidays”: Towel Day, for fans of The Hitchhiker’s Guide to the Galaxy (Paul Vallée brought his towel to the office today) and the Glorious 25 May for [...]

Log Buffer #273, A Carnival of the Vanities for DBAs

Fahd Mirza — Fri, 25 May 2012 09:30:38 +0000

Glamour from across the world is sparkling in the South of France, but even that has failed to eclipsed the vivid aura of the database blogs from the realms of Oracle, MySQL and SQL Server. This Log Buffer Edition in Log Buffer #273 covers this glamorous gala of innovation. Oracle: Jonathan Lewis blogs about subquery [...]

My Failure, Success and How to never give up …

Yury Velikanov — Fri, 25 May 2012 03:40:51 +0000

The purpose of this blog isn’t to show off the results of my presentation at Collaborate conference, but to inspire you (and maybe myself in the future) and give you additional motivation to never give up on reaching your dreams if you truly believe in them. Some of you know that I had a pretty [...]

My SLOB IO testing index

Yury Velikanov — Mon, 21 May 2012 01:36:25 +0000

Martin Berger suggested to create this page to keep track of blog posts related SLOB IO testing. Here it is Martin ;) If you are seriously interested to get a good understanding of your IO subsystem performance characteristics then one of the tools that you may consider for putting your system IO on stress is SLOB. See Introducing [...]

My First Experience Running SLOB – Don’t repeat my errors (AWR)

Yury Velikanov — Sat, 19 May 2012 15:36:52 +0000

If you are wondering what I am busy with then this post explains it. As you may noticed I am still testing one of the Oracle systems using the SLOB framework and learning on my way. I ran several tests with the same parameters (Readers 24) and I noticed that for one reason or another awr.txt reports [...]

OEM12c Discovery of Exadata Cluster

Fahd Mirza — Sat, 19 May 2012 07:00:11 +0000

dbm_configurator.xls is needed to generate databasemachine.xml file which is needed by OEM 12c to discover an exadata cluster. Following is a step by step process as how to generate databasemachine.xml file to be used with OEM 12c: 1) Get the dbm_configurator70.xls file from /opt/oracle.SupportTools/onecommand directory from the first compute node of Exadata cluster. 2) Also [...]

Insider’s Guide to ODA Performance

Gwen Shapira — Fri, 18 May 2012 18:23:20 +0000

I have a confession to make: I hate webinars. I find it difficult to concentrate on a disembodies voice. I typically get distracted and find myself checking email and blogs even during the best webinars. Watching a webinar is a bit like watching DVD of a live show – not as fun as live show, [...]

Debugging IN vs OR performance in MySQL

Danil Zburivsky — Fri, 18 May 2012 15:06:14 +0000

I was recently puzzled by the question, “Which query will be faster?”: SELECT * FROM table WHERE pk = x OR pk = x1 OR pk = x2 ... Or SELECT * FROM table WHERE pk IN (x1, x2,...); There are 50k values in both IN and OR clauses and lookup is done via primary [...]

Test-driving Reflex

Yanick Champoux — Fri, 18 May 2012 13:53:52 +0000

At $work we have a need for a little job daemon that would poll jobs and process them. If there was only one kind of job involved, the solution could be nothing more complicated than while ( my @jobs = poll_jobs() ) { process( $_ ) for @jobs; sleep $a_wee_bit; } But there are more [...]