RE: Query on Dual
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).
Re: Query on Dual
What attachment? Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] cs.co.in To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Query on Dual ity.com 06/11/2003 05:09 AM Please respond to ORACLE-L Find it as attachment With Regards, Manoj Kumar Jha C-56 , Phase-2 NOIDA -201305, UP(INDIA) Tata Consultancy Services Ph No: (+91-120) 4461001 ext : 1037 (Off.) Mobile No : 9810090974 A transcendentalist engaged in auspicious activities does not meet with destruction either in this world or in the spiritual world; one who does good, is never overcome by evil. "Jayaram Keshava Murthy (Cognizant)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/10/2003 11:24 PM PST Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Hi all, 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. Thanks to one and all. Regards Kesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Re: Query on Dual
Kesh, I have some information on my website (http://www.optimaldba.com/internals/oraint_dual.html). It is a pretty terse discussion of the topic. I know that Cary Millsap has tested and written a paper on this as well. IIRC, there is mention of DUAL in his paper on reducing Logical I/Os. You can find out more on his website at www.hotsos.com. -- Daniel W. Fink http://www.optimaldba.com Jayaram Keshava Murthy (Cognizant) wrote: Hi all, 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. Thanks to one and all. Regards Kesh This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com
Re: Query on Dual
Find it as attachment With Regards,Manoj Kumar JhaC-56 , Phase-2NOIDA -201305, UP(INDIA)Tata Consultancy ServicesPh No: (+91-120) 4461001 ext : 1037 (Off.)Mobile No : 9810090974A transcendentalist engaged in auspicious activities does not meet with destruction either in this world or in the spiritual world; one who does good, is never overcome by evil. "Jayaram Keshava Murthy (Cognizant)" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]06/10/2003 11:24 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: Query on Dual Hi all, 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.Thanks to one and all.RegardsKesh-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).