Re: Oracle and (Cached?) Views

From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 23 Jul 2002 04:12:16 +0000 (UTC)
Message-ID: <6264db10ac75ffe3541c69106273b0d7.99975@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 Mon Jul 22 2002 - 23:12:16 CDT