-
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.
-
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.