Skip to content

Category Archives: Oracle

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

With the weather taking extremes turns, technology is providing the much-needed warmth through the blogs. This Log Buffer Edition is sizzling with few of the hand-picked blog posts in Log Buffer #259. Oracle: Love Day has passed but love is still in th…

Posted 17 February 2012 † Fahd Mirza § Uncategorized ‡ Comments Off °

Subquery Factoring

When I wrote a note last week about the fixes to the subquery factoring optimizer code in 11.2.0.3, I finished with a comment about having more to say on the test case if I materialized the subquery. Today’s the day to talk about it. As a reminder, here’s the query, but with the /*+ materialize [...]

Posted 16 February 2012 † Jonathan Lewis § Uncategorized ‡ Comments Off °

Introducing the Hardline According to Tim Hall…

I’ve made quite a big decision today. I’ve decided that I will no longer waste my time answering crap questions on my forum. I don’t mean I will not answer any questions. Just that I will not answer questions where the poster has put little to no effort into the question. The sort of things [...]

Posted 14 February 2012 † Tim... § Uncategorized ‡ Comments Off °

Subquery Factoring

Here’s an interesting little conundrum about subquery factoring that hasn’t changed in the recent (11.2.0.3) patch for subquery factoring. It came to me from Jared Still (a fellow member of Oak Table Network) shortly after I’d made some comments about the patch. It’s an example based on the scott/tiger schema – which I’ve extracted from [...]

Posted 14 February 2012 † Jonathan Lewis § Uncategorized ‡ Comments Off °

How Many Non-Exadata RAC Licenses Do You Need To Match Exadata Performance?

This post is about exaggeration. The Oracle Database running in the Database Grid of an Exadata Database Machine is the same as what you can run on any Linux x64 server. Depending on the workload (OLTP/ERP/DW.BI.Analytics) there is the variable of storage offload processing freeing up some cycles on the RAC grid when running Exadata. [...]

Posted 13 February 2012 † kevinclosson § Uncategorized ‡ Comments Off °

Dbvisit Replicate…

Last months I wrote a post Dbvisit Standby and said I planned on taking a look at their replication product at some point. I had actually already started writing an article on it, but got a bit side tracked before putting it live. I went back to it today and noticed a new version of [...]

Posted 11 February 2012 † Tim... § Uncategorized ‡ Comments Off °

SQL Developer 3.1 : Scheduler Support…

I had a play around with the scheduler support in SQL Developer 3.1 today. I’m late to the party because most of it has been there since 3.0, but what the hell. SQL Developer 3.1 Scheduler (DBMS_SCHEDULER) Support It’s more of an opinion piece, so it started as a blog post, but it got too [...]

Posted 10 February 2012 † Tim... § Uncategorized ‡ Comments Off °

Create Bigfile Tablespace – Oracle Managed Files (OMF)

Working with Exadata a lot (almost exclusively) I create almost all my tablespaces as bigfile using OMF. For some reason I can never find the right syntax for this when I need it. So, that’s the main reason for this post. On a related note, wow I…

Posted 10 February 2012 † Tyler Muth § Uncategorized ‡ Comments Off °

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

Database blogging is more than about announcing that your last night’s backup was successful. While that’s extremely important to keep track of, the database world across Oracle, MySQL, and SQL Server technologies has grown way beyond. This…

Posted 10 February 2012 † Fahd Mirza § Uncategorized ‡ Comments Off °

11.2 New views

It looks like Laimutis Nedzinskas has spent some time producing  a list of new views, and changes to existing views, for trouble-shooting specialists. The lists cover the dynamic performance views and the AWR history views, and the differences between 10.2 and 11.2. The lists include, where relevant, convenient hyperlinks to the view definitions in the [...]

Posted 10 February 2012 † Jonathan Lewis § Uncategorized ‡ Comments Off °