Steve Adams has some info about this, but doesn't say how he determined this.
http://www.ixora.com.au/q+a/0104/03174106.htm "Khedr, Waleed" wrote: > > How did you determine that it's not stored in the DC? > > The DC is not a data store but it's a cache. > > Just curios. > > Thanks, > > Waleed > > -----Original Message----- > Sent: Thursday, February 21, 2002 3:48 PM > To: Multiple recipients of list ORACLE-L > > A thing about views, that nobody else seem to have mentioned is that the > view > text is not stored in the dictionary cache. Hence, each time you hard parse > > a sql statement with a view, Oracle will query view$ to get the text. > Hence, > if you are at the limit of scalability or performance due to hard parses, > views make things worse. > > /Bjørn. > > On Thursday 21 February 2002 17:18, you wrote: > > We have several applications that use views extensively. On the other > hand > > there are several apps that use no views at all. We have a new developer > > who wants to use views when writing reports in Crystal Reports. The > > application administrator is leery of using views and ask the DBA group > > what we think. I can see several reasons to use views and a few reasons > > not to use them. I was just wondering what the rest of the group thought. > > > > Ron Smith > > DBA > > Kerr-McGee Corp > > -- > Bjørn Engsig, Miracle A/S > http://MiracleAS.dk > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
