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