RE: Extent allocation time

A timestamp in uet$ wouldn't help all those people using locally managed tablespaces anyway. :)
Maybe you should change your enhancement request to "add a timestamp to x$ktfbue". Then someone will get right on it.

De : oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] De la part de Cary Millsap

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

 

 

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