DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: select user from sys.dual running 2millions an hour

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    select user from sys.dual running 2millions an hour

    Hi, We are having a problem where there is contention for the sys.dual table. On running the statspack reports we have found that the select user from sys.dual is running 2 million times an hour. We have tracked this down to the USER function within the SYS.STANDARD packacge, but we don't know why this is being called so many times. We are using ODP.NET 11.2 for client connections from the application server. Thanks for any help. Rgds. Sheryl

  2. #2
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    We have found the issue. It was a trigger using the Oracle function IF USER <> 'ARCHIVE'. We are now sorting the problem. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width