Bryan's Oracle Blog

I am getting ready to do a presentation on "real world Experiences" with the exadata, and I am still in process of getting the Exa...

I was working on copying an RMAN backup from an NFS mount into ASM to do a restore of a database.. I figured.. A great opportunity to use DB...

We are using a GTT, multiple times, in a view.. 1) Just the query --------------------------------------------------------------------...

I've been playing some more with profiles, and I came up with a reproduciple test case. 1) Start with the OE schema in the database ...

I am using profiles for some very stubborn queries. I wanted to know what the profile really looks like. It looks like Oracle has significa...

I have been spending a lot of time with SQL_PROFILES, and figuring out how my profile went stale (and subsequently the performance went from...

I discovered an interesting little by product of running Oracle on ASM.. Our SGA was sized a little small on a non-production box.  All of a...