Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003

    Unanswered: Date extent was allocated

    Is there some hidden table in Oracle that shows the DATE an extent
    was allocated?

    I want to write a table-growth script based on when extents were allocated.
    However, I can't find a DBA view or table that shows this information.
    I think it would be handy to know that on 12/23/2003 an extent of 10M was
    allocated to TABLE_Y.

    - The_Duck
    you can lead someone to something but they will never learn anything ...

  2. #2
    Join Date
    Apr 2004
    nothing that I know of - the underlying table is EXT$, which has no date columns, and EXT# (part of its pk) doesn't exist in any other sys table.
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  3. #3
    Join Date
    Mar 2002
    Reading, UK
    As shoblock says there is now table or view which has the date an extent was allocated. What I've done in the past is to have a regular oracle job to summarise dba_extents into my own table which thus has a history of extent allocation for all tables and indexes.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts