Rebuild table sys.SOURCE$
Table sys.SOURCE$ has over 13000 extents, sized 2.4 GB.
I am thinking so many extents could have a negative impact on query performances, so I am thinking of rebuilding this into a different tablespace so to reduce its extents using the following statement:
alter table sys.SOURCE$
move
tablespace Large16Kd
storage (initial 500M next 100M);
In a TEST instance running Oracle Financials 11.5.10.2 on Oracle database 10g R2, this in fact reduced the extents to 24 from the 13000.
System is up and I am able to run things. No errors in the log.
Has any one done any thing similar to this before?