Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and (Cached?) Views
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