smon very busy, Rollback tablespace replaced by larger tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: smon very busy, Rollback tablespace replaced by larger tablespace

  1. #1
    Join Date
    Nov 2001
    Posts
    110

    smon very busy, Rollback tablespace replaced by larger tablespace

    A rollbacktablespace was removed from a production box and a larger tablespace was replaced and put on-line. On startup the PMON process has been very busy and a lot of group-by, order-by, distinct key word queries are running very slowly. What can be the problem.
    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. you're hitting a bug
    2. your cpu is very busy
    3. your network is very busy
    4. your disk is very busy
    5. your machine is swapping
    6. your SQL is bad
    7. your database is not tuned properly

    shall I add more of what "might" be wrong?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2001
    Posts
    110
    How can I find out what job SMON is doing in particular.

  4. #4
    Join Date
    Oct 2003
    Posts
    65
    Hello,

    Why are you so keen abt SMON busy while your application is slow?Can you relate anything.There could be someother reason for the application slow performance.

  5. #5
    Join Date
    Nov 2001
    Posts
    110
    SMON Process is taking 20% of the CPU and this application has been running properly for a long period of time. I donot believe it is the application. It is just that after this rollback scenario this performance problem has arisen. Just want to know if there is any way to find if SMON is tryning to do some recovery after dropping the tablespace.

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Did you shutdown the db "cleanly" before dropping the RBS tablespace?

    Tamil

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