Re: Recursive SQL

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: shivaswamykr@xxxxxxxxx
  • Date: Fri, 19 Sep 2008 20:07:44 +0100

With difficulty, it's looking up constraint information. You could of course
trace user sessions to see where this is recursively called
(inserts/updates/deletes most likely) but before you do any of that I'd
suggest that you investigate the elapsed time figure, to consider whether
you actually care.

On Fri, Sep 19, 2008 at 7:08 PM, Shivaswamy / ಶಿವಸ್ವಾಮಿ <
shivaswamykr@xxxxxxxxx> 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, from con$ c, cdef$ cd, user$ u  where
> 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

Niall Litchfield
Oracle DBA
  • References:

Other related posts: