Skip to Main Content
  • Questions
  • exact time when an extent is allocated

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Timothy.

Asked: September 04, 2007 - 10:34 am UTC

Last updated: September 06, 2007 - 3:40 pm UTC

Version: all

Viewed 1000+ times

You Asked

Under dba_objects one can see when an object (table, view, synonym, etc) was created, but how can one see when (at what time) an additional extent was allocated?

For instance, a table is created and the segment with its initial accompanying extent is allocated. That time of table creation (initial extent allocation)can be found in dba_objects. But after a while, as the table grows, an additional extent is allocated to that table to accommodate more rows. So the table now has 2 extents. But at what date (time also) was the second extent allocated? The date of first extent allocation is easy, but what of the date of the subsequent extent allocations?

Regards
Tim

and Tom said...

you cannot, we do not micro manage and track to that level.

We do not track the date of the first extent allocation either - consider the effect of TRUNCATE.

We track the object creation time (the table), but not the extents therein.

You would have to run a job that occasionally sampled the dictionary looking for new extents - you would then be able to determine that since your job last ran - N number of new extents had been allocated.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Timothy Molloy, September 07, 2007 - 3:37 am UTC

Thanks Tom, I thought that was the case but wasn't certain.