Bryan's Oracle Blog

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

I've had a lot of discussions with some very "seasoned" professions on how to handle a high level concurrency. Most of these ...