-
Hi,
I found out there are around 60 pieces fragments in my SYSTEM tablespace, and it seems to grow. I use 'alter tablespace SYSTEM coalesce', but no use. Do you have any ideas to solve this problem? I don't think I can use exp/imp to defragment it.
Thank you!
-
Only the way is rebuild the whol Database with right storage parameters for the system.
Thanks
Kishore Kumar
-
What are the issues in defining extent size for "SYSTEM" tablespaces ??? Usually Oracle suggests not to change system tablespace extent sizes/ change very carefully with support.
Per Pando post, sql.bsq has to be modified to do this and to be with Oracle support/ whatever.
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
|