It might be the case, that the dictionary cache cannot store any information of type LONG (which the view text is), but that requires more investigation. If somebody knows, please inform the rest of us.
But you can just turn on sql_trace and see the query against view$ for each parse. /Bj�rn. On Thursday 21 February 2002 22:23, you 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).
