RE: Extent allocation time

I made this enhancement request way back in 6.0.36 ("add a timestamp to uet$..."). It's not there, at least as of 10.2.0.1.0:    

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 20 12:57:06 2005  

Copyright (c) 1982, 2005, Oracle. All rights reserved.    

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options  

12:57:07 cvm> desc sys.uet$

 Name                                      Null?    Type

 ----------------------------------------- --------
----------------------------

 SEGFILE#                                  NOT NULL NUMBER

 SEGBLOCK#                                 NOT NULL NUMBER

 EXT#                                      NOT NULL NUMBER

 TS#                                       NOT NULL NUMBER

 FILE#                                     NOT NULL NUMBER

 BLOCK#                                    NOT NULL NUMBER

 LENGTH                                    NOT NULL NUMBER

 

 

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com <http://www.hotsos.com/> Nullius in verba

Visit www.hotsos.com <http://www.hotsos.com/> for curriculum and schedule details...  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Dick
Sent: Thursday, October 20, 2005 12:09 PM To: ora_forum_at_yahoo.com; oracle-l_at_freelists.org Subject: RE: Extent allocation time  

None that I'm aware of.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ora_forum
Sent: Thursday, October 20, 2005 1:05 PM To: oracle-l_at_freelists.org
Subject: Extent allocation time

Hi All!  

Any way I can get time when an extent was allocated for the table? One of your tbs runs out of space and I need to do some research.  

Thanks.

George.

Yahoo!
<http://pa.yahoo.com/*http:/us.rd.yahoo.com/evt=36035/*http:/music.yahoo.com /unlimited/> Music Unlimited - Access over 1 million songs. Try it free.

--
http://www.freelists.org/webpage/oracle-l