From Jacques.Kilchoer@quest.com Wed, 11 Jun 2003 11:30:12 -0700 From: Jacques Kilchoer Date: Wed, 11 Jun 2003 11:30:12 -0700 Subject: RE: Query on Dual Message-ID: MIME-Version: 1.0 Content-Type: text/plain http://www.ixora.com.au/scripts/cache.htm replace_dual.sql In some cases the data block for SYS.DUAL can be a hot block in cache. This script replaces the SYS.DUAL table with a view onto X$DUAL, thereby eliminating the cache access entirely. Please note: This is not a normal, supported procedure. So do not do it on a production system, unless you have discussed the matter fully with Oracle Support beforehand. -----Original Message----- Can anyone tell me the performance issues related to the excessive usage of the DUAL table in pl/sql procedures? I remember reading an article about this ( I dont remember if it was in ASKTOM site ) wherein it was told that excessive usage of DUAL comes with a cost and there was a suggestion in that to create a view on the system table X$DUAL.. If anybody has a link to that please send it to me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).