I am running the following script to give me information about the size and growth of objects..
All data is pulled from the data_dictionary except check_date which is sysdate..
WHERE EXTENTS >= 50
This script worked great until it was ran against the table on a different day and it was inserted,
This means for instance if the data was inserted into the table on 27-FEB-01 and the script was run on 01-MAR-01 there is no output.
I am looking for help in adapting this scrip so that it works no matter what day it's ran..
I was thinking of something using
but I can't get it to work
Any help would be a life saver.
Where did you find APRODBSEC table?
APRODBSEC is a table I created to hold space information extracted from the data dictionary, I use the following script to insert this information
insert into APRODBSEC
( TS ,
from DBA_SEGMENTS@APRODBSEC.world D
where Owner = UPPER('schema_owner')
DBA_SEGMENTS@APRODBSEC.WORLD is a database link I have set up to another database on another server (this all works fine)