Bryan's Oracle Blog

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...

If you didn't know it, there is a new feature in 11.2 Grid called SCAN.  Here is a link to a little more information http://www.orafaq.c...