This looks to me like a massive insert violating a unique constraint nearly 157K times. This is typically the type of query issued by Oracle to return the name of the constraint that was violated in the error message.
It hurts. HTH S Faroult Shivaswamy / ಶಿವಸ್ವಾಮಿ wrote:
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 <http://c.name>, u.name <http://u.name> from con$ c, cdef$ cd, user$ u where c.co <http://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
-- //www.freelists.org/webpage/oracle-l
