Anyone know columns in the DBA tables which might tell us WHEN a table extended?
I am trying to figure out what the freespace was in a particular tablespace last week as opposed to today (which I know). Thanks.
Printable View
Anyone know columns in the DBA tables which might tell us WHEN a table extended?
I am trying to figure out what the freespace was in a particular tablespace last week as opposed to today (which I know). Thanks.
The trouble with America is that there are far too many wide-open spaces surrounded by teeth.
Charles Luckman
You can monitor EXTENTS in DBA_SEGMENTS and count of EXTENTS in DBA_EXTENTS.
Sanjay
You can query dba_free_space to check the diffrence before and after the free space used.Quote:
Originally posted by pcotten
I am trying to figure out what the freespace was in a particular tablespace last week as opposed to today (which I know). Thanks.