Bryan's Oracle Blog

Expert insights on Oracle Database, Zero Data Loss Recovery Appliance (ZDLRA), backup and recovery strategies, database security, and enterprise database solutions by Bryan Grenn.

Monday, December 27, 2010

Profiles, GTT's and how changing the underlying view can cause FTS's

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

Thursday, December 23, 2010

SQL profiles and Dynamic Sampling

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

Monday, December 6, 2010

How to view sql_profiles

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

View web version

About Me

Bryan Grenn

View my complete profile

Powered by Blogger.