Tablespace space forecasting and monitoring
muminey
Posts: 6 Newbie
Comments
-
The document needs serious editing as much of the text is duplicated making the article unreadable. The same problem exists in the included scripts.
--
HTH -- Mark D Powell --
HTH -- Mark D Powell --
0 -
The document needs serious editing as much of the text is duplicated making the article unreadable. The same problem exists in the included scripts.
Yes Mark, I know. I tired to edit and remove the repeated lines a few times but I dcouldn't manage to get rid of them for the last 2-3 days. Now I give up and I am attaching a pdf version.--
HTH -- Mark D Powell --
0 -
But won't we need to monitor the contiguous free space availablity too, along with total freespace in each tablespace? I had faced such problems were in the tablespace had many segments whose extents sizes are huge making it impossible to grow in the tablespace, though when the tablespace had a total freespace that could accomodate the extent size.
--
Regards,
Sesha
0 -
But won't we need to monitor the contiguous free space availablity too, along with total freespace in each tablespace? I had faced such problems were in the tablespace had many segments whose extents sizes are huge making it impossible to grow in the tablespace, though when the tablespace had a total freespace that could accomodate the extent size.
Sesha, if you use, as recommended by Oracle, locally managed tablespaces then contiguous free space becomes less of an issue. In fact with uniform extent tablespaces there is no such thing as free space fragmentation so who cares if the free space is contiguous or not.
--
Regards,
Sesha--
With auto-allocate free space fragmentation is still possible though the relationship of the automatically chosen extent sizes and the ability of Oracle to downsize if necessary helps avoid this issue.
--
If dictionary management is still in use someone needs to question the DBA why.
--
HTH -- Mark D Powell --
HTH -- Mark D Powell --
0 -
Why append data into a text file when you could insert the same data into a table? You could then do you analysis with SQL and wouldn't have to paste new data into a spreadsheet daily.
I have some DDL for a table and a scheduled job that does this if anyone is interested.
Also, if you have 10g and don't need long-term retention of data, you could query the dba_hist_tbspc_space_usage view for the same info.
0 -
Thanks for sharing the info.0