|
-
Maybe your SMON is attempting to Coalence temp segments thats why it takes longer and the reason you get database isnt available is because the database isnt open. this happens if your SORT_AREA_SIZE is sized too small then SMON goes to disk and creates temporary segments which it has to release right before shuting down.
You can coalence your temp segments manually too.
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
|