| script for tablespace growth [message #50152] |
Mon, 04 March 2002 05:04  |
Kishore
Messages: 45
Registered: September 2000
|
Member |
|
|
Hi,
Can anybody please send me a script for monitoring tablespace growth on daily and/or weekly and/or monthly basis? Thanks in advance!
Kishore
|
|
|
|
| Re: script for tablespace growth [message #50153 is a reply to message #50152] |
Mon, 04 March 2002 05:11  |
saleem
Messages: 65
Registered: January 2002
|
Member |
|
|
I don't have a script written,
but what you would want to do is :
1 analyze the table (estimate is a good guess but if you need specifics then you need to compute stats).
2 select a count(*) from dba_extents to get a count of how many extents there are and how many bytes they are taking up (you can extent info from user_Tables as well, but that's just sizing, not really a measure of growth).
3 you can also check user_tables for chaining and freelists
4 as a supplemental, also check the size of the tablespace and the data files to make sure you are not approaching any limits.
that should give you alll the information you should need with regards to any one table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
