Script to get tablespace free space including MAXSIZE for datafiles — oracle-mosc

Database Administration (MOSC)

MOSC Banner

Script to get tablespace free space including MAXSIZE for datafiles

edited Mar 14, 2012 10:02AM in Database Administration (MOSC) 5 commentsAnswered ✓
Hi, gurus. I have scripts that query a 9i database for datafile free space and send emails listing available space per tablespace. The trouble is, these scripts do not take into account Used as % of Max. Let me elaborate. For example, the alert shows that NJ_INDEX tablespace is at 100%. It actually is. But once it reaches 100% it will extend by 100MB until it reaches MAXSIZE of 20GB. So, actually there is 18% free because datafiles will expanding until there is no space on device, or maxsize is reached. There is a discrepancy between 100% and 82% if MAXSIZE is considered.
So, the question is - where can I find scripts that actually show "Used as % of Maxsize" per tablespace?

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

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