Recursive SQL

From: Shivaswamy / ಶಿವಸ್ವಾಮಿ <shivaswamykr_at_gmail.com>
Date: Fri, 19 Sep 2008 14:08:05 -0400
Message-ID: <1e52ad820809191108q13e9857g83d48758c5c54b8@mail.gmail.com>


Hello.

This one recursive SQL I find, is a big one in the Top 10 SQL on ouur database, taking over a billion buffer gets. In one particular hour, I find this SQL responsible for nearly 15% of Total. It executed nearly 157K times.

select c.name, u.name from con$ c, cdef$ cd, user$ u where c.co n# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

The question I have is, how I can tie this to a User SQL? Your input appreciated.
Thanks,
Shiva

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 19 2008 - 13:08:05 CDT

Original text of this message