Database Administration (MOSC)

MOSC Banner

Tablespace Forecasting

User_2025-10-09-09-33-41-227
User_2025-10-09-09-33-41-227 Posts: 6 Newbie
edited Feb 17, 2009 1:44AM in Database Administration (MOSC) 1 comment
Tagged:

Comments

  • User_2025-09-16-20-42-32-332
    User_2025-09-16-20-42-32-332 Posts: 3 Newbie
    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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center