Recursive SQL
- From: "Shivaswamy / ಶಿವಸ್ವಾಮಿ" <shivaswamykr@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Sep 2008 14:08:05 -0400
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
Other related posts:
