Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Autoextend - how many times has a datafile extended

RE: Autoextend - how many times has a datafile extended

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 01 Oct 2001 09:39:59 -0700
Message-ID: <F001.0039D8B8.20011001093027@fatcity.com> 









> -----Original Message-----

> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]

> 

> it doesn't store the number of times it extended but it's easily

> derived

> 

> # extensions= 

> (v$datafile.bytes - v$datafile.create_bytes)/sys.filext$.inc






What if the autoextend is changed with an alter tablespace command? The current autoextend value might not be the same as the original value.
Received on Mon Oct 01 2001 - 11:39:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US