RE: SQL Power !!

  The worst I had to deal with was 6 or 7 layers of views with a total of 40+ tables (not including the views) with the same table being referenced multiple times at mutiple layers. They called me after they tried running it and it "RAN" for half hour and then errored out with an ORA-4031 ;) After rewriting it, it executed in a couple of minutes.

Quoting "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU>:

> 22 eh? Did it ever run? Was Oracle forever trying to acquire a cache
> buffer chain latch. People or query generators needlessly joining
> views to their base tables is a big headache for us. Peoplesoft
> (in-the-head) loves to do this.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_SLAC.Stanford.edu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Denny Koovakattu
  INET: groups_at_koovakattu.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).