No, looking for that for years myself.
I assume your goal is to monitor growth. You need a kind of "insert trigger"
on dba_extents.
I've seen DBA's that build scripts and procedures that queried views like
dba_extents, dba_segments, dba_free_space daily that stores results in some
tables from where you can report growth statistics.
There must be some articles published in Oracle Magazine or so that
describes the basics. (http://www.oracle.com/oramag/index.html)
----- Original Message -----
From: Zormeier, Jason <Jason.[Email Address Removed] LazyDBA.com Discussion <[Email Address Removed] Friday, June 28, 2002 9:59 PM
Subject: Extents.
| Here is an interesting question.
|
|
| Is there a way to query the database and find when (date) that an extent
was
| added for an object. Table / index?
|
| I looked in uet$ with no luck.
|
|
| Thanks,
|
|
| --------
| Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| Tell yer mates about http://www.farAwayJobs.com
| By using this list you agree to these
terms:http://www.lazydba.com/legal.html
|
|
Oracle LazyDBA home page