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