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

Thread: user rollbacks

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688

    Red face

    I'v got a problem, the number of transaction in the system is increasing incredible fast, DBW and SMON takes too much memory:
    124M 6.0% ora_dbw0_WWW2
    155M 7.6% ora_smon_WWW2

    12:42:28> select value from v$sysstat where name='user rollbacks';
    VALUE = 12507118

    12:59:03> select value from v$sysstat where name='user rollbacks';
    VALUE = 12510066

    No users who makes any rollbacks!

    Is anybody knows how to deside this problem?



  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    On that case why not you move to the MTS setup. That would weel serve your purpose.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    We don't have more the 2 concurent connection in the same time.

    Originally posted by sambavan
    On that case why not you move to the MTS setup. That would weel serve your purpose.

    Sam

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