RE: Extent allocation time

  • From: "Cary Millsap" <Cary.Millsap@xxxxxxxxxx>
  • To: "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Oct 2005 12:58:20 -0500

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Goulet, Dick
Sent: Thursday, October 20, 2005 12:09 PM
To: ora_forum@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Extent allocation time

 

None that I'm aware of.

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of ora_forum
Sent: Thursday, October 20, 2005 1:05 PM
To: oracle-l@xxxxxxxxxxxxx
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.

Other related posts: