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:
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.
Regards
Kesh