RE: Query on Dual

2003-06-11 Thread Jacques Kilchoer
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

Re: Query on Dual

2003-06-11 Thread Reginald . W . Bailey
: [EMAIL PROTECTED] Subject: Re: Query on Dual ity.com

Re: Query on Dual

2003-06-11 Thread Daniel W. Fink
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 c

Re: Query on Dual

2003-06-11 Thread jmanoj
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 transcendental