Database Administration (MOSC)

MOSC Banner

Tablespace Forecasting

muminey
muminey Posts: 6 Newbie
edited Feb 17, 2009 1:44AM in Database Administration (MOSC) 1 comment

Comments

  • Some comments 1) I think the inline views FA and DF can be merged, as they use the same selection and grouping criteria.
    2) I would suggest to include free_total_no_auto and percent_free_no_auto columns (I assume it is easy to guess what the names mean). Personally, I want to avoid letting the data files autoextend, in order to avoid fragmentation blahblahblah, but I would allow one file per tablespace to autoextend, in case I can't reach the database to add files for some period of time (e.g., caused by bad weather or bad health).

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center