-
Trying to shutdown a database which takes about 10 mins sometimes to shutdown. According to my research I found out that smon creates temporary segments which it tries to colensce (release) and that takes time. I believe Oracle was saying that by increasing the sort area size this might help. My question is how do i know on which tablespace has these temporary segments been created?
What about increasing hash area size?
any suggestions?
sun solaris 2.6
thanks
Jigar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|