Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and (Cached?) Views

Re: Oracle and (Cached?) Views

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 23 Jul 2002 16:03:17 +1000
Message-ID: <Ad6%8.41742$Hj3.125473@newsfeeds.bigpond.com>


Hi Yong,

Thank you for reading my mind a little better than I expressed myself in the post (although I think I was a little clearer previously in the thread).

In short, yes :)

Richard
"Yong Huang" <yong321_at_yahoo.com> wrote in message news:6264db10ac75ffe3541c69106273b0d7.99975_at_mygate.mailgate.org...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:lOvW8.31132$Hj3.94303_at_newsfeeds.bigpond.com
>
> > Now that I've thought about it for a tad longer, I'm not convinced that
> > views are actually ever cached in the DD so there goes that idea !!
>
> Hi, Richard,
>
> View definition is not cached in dictionary cache. But it has to be in
> data dictionary. You're probably saying it's not cached in DC. Of
> course reading from DD and parsing a complex view takes a lot of CPU.
>
> Yong Huang
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Jul 23 2002 - 01:03:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US