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.
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?
How can I find out what job SMON is doing in particular.
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.
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.
Did you shutdown the db "cleanly" before dropping the RBS tablespace?
Tamil