Database Tuning (MOSC)

MOSC Banner

Rebuild table sys.SOURCE$

edited Dec 19, 2011 4:11AM in Database Tuning (MOSC) 12 comments
Hi,

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center