Skip to content

Category Archives: Oracle

Oracle E-Learning Resources

There is a lot of new stuff out there nowadays, regarding products and/or functionality or others. This is also true for Oracle and in short it’s not easy to follow all those innovations and/or new products. So from time to time I have a watch on…

Posted 12 May 2012 † Marco Gralike § Uncategorized ‡ Comments Off °

Exadata

Enkitec have just announced the call for papers for their E4 conference to be held in Irving, Texas this August. (See this link for the announcement.)
I’ll be there … playing the devil’s advocate.

Posted 11 May 2012 † Jonathan Lewis § Uncategorized ‡ Comments Off °

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

They say, “April showers bring May flowers.”  They basically say that nature brings different things in different colors aimed at improving the things. That is so true for the blogging world too. This Log Buffer Edition also brings out different b…

Posted 11 May 2012 † Fahd Mirza § Uncategorized ‡ Comments Off °

Oracle’s Timeline, Copious Benchmarks And Internal Deployments Prove Exadata Is The Worlds First (Best?) OLTP Machine – Part II

There Is No Such Thing As “Pure OLTP” There is no such thing as “pure OLTP.” How true! And that’s why you are supposed to buy Exadata for your Oracle OLTP/ERP deployment—at least that’s what I’ve heard. Part I of this series on the topic of Oracle OLTP/ERP on Exadata Database Machine has brought quite [...]

Posted 11 May 2012 † kevinclosson § Uncategorized ‡ Comments Off °

Hardware Components Failures — Survey Results

When preparing for the the IOUG Collaborate 12 deep dive on deploying Oracle Databases for high Availability, I wanted to provide some feedback on what hardware components are failing most frequently and which ones are less frequently. I believe I have…

Posted 10 May 2012 † Alex Gorbachev § Uncategorized ‡ Comments Off °

Storage Replication for Oracle Database and Licensing

While doing my high availability deep dive at Collaborate 12 few weeks ago, I stated that storage replication qualifies for the cold failover licensing rules (see slide #128). During collaborate I spoke to one person at Oracle who definitely knows the …

Posted 09 May 2012 † Alex Gorbachev § Uncategorized ‡ Comments Off °

Why did that report run slow? ASH says log file sequential read

“Dump Online Redo for Buffers in Pin History” I’ve just been investigating why a certain report ran slow last night. Got to be a bit careful with ASH once it goes into the repository – DBA_HIST_ACTIVE_SESS_HISTORY – because it’s a sample of a sample. Normally, I prefer looking at the raw data to see what [...]

Posted 09 May 2012 † Dom Brooks § Uncategorized ‡ Comments Off °

Regexp hungry for CPU? Real time sql monitoring shows just how

Not exactly a snappy blog post title… First up, an execution plan showing the old problem of how the costs of a scalar subquery are not properly accounted for, even in the latest 11gR2 releases. The SQL looks something like this: The execution plan like so: There are two problems with a scalar subselect: 1. [...]

Posted 09 May 2012 † Dom Brooks § Uncategorized ‡ Comments Off °

Oradebug hanganalyze with a prelim connection and “ERROR: Can not perform hang analysis dump without a process state object and a session state object.”

Back in the (really) old days, systemstate dumps had to be used for diagnosing hangs and finding blockers of hung databases. Basically you just identified which resource your waiting sessions were waiting for and then scanned through the rest of the system state dump to see which session held that particular resource (note that over [...]

Posted 08 May 2012 † Tanel Poder § Uncategorized ‡ Comments Off °

Two Database Engines, One Table

Our flagship tool, Support Track, is steadily migrating over to use DBIx::Class to read and manipulate our databases. This is a very useful tool, for many reasons which many people explain better than I could. One of those reasons is that — thanks to …

Posted 07 May 2012 † David Perry § Uncategorized ‡ Comments Off °