RE: Extent allocation time

Right. :-)  

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: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com] Sent: Thursday, October 20, 2005 1:44 PM To: Cary Millsap; Oracle-L
Subject: 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