RE: Free space puzzle

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 19 Oct 2001 11:59:48 -0700
Message-ID: <F001.003B0624.20011019121653@fatcity.com>

> -----Original Message-----
> From: O'Neill, Sean [mailto:Sean.ONeill_at_organon.ie]
>
> TS is showing 100% used in DBA Studio.  DBA_DATA_FILES is
> showing MAXBLOCKS,
> MAXBYTES values corresponding to filesize of 2000M which was
> what tablespace
> was originally created with.  Subsequently altered to 4000M with ALTER
> DATABASE DATAFILE '<filename>' AUTOEXTEND ON MAXSIZE 4000M. 
> I'm puzzled as
> to why the DBA views do not reflect the 4000M.  Can anyone
> explain what I'm
> overlooking please?

What dba_ view are you looking at? This will probably be of little consolation to you, but for me, dba_data_files immediately reflected the change in maxsize on a datafile in my test database (8.1.7 on Windows 2000).

SQL> select file_name, maxbytes
  2  from dba_data_files
  3  where file_name = 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF' ;

FILE_NAME

---

  MAXBYTES

---

D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF  115344384

SQL> alter database datafile 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF'   2  autoextend on maxsize 300 M ;

Base de données modifiée.

SQL> select file_name, maxbytes
  2  from dba_data_files
  3  where file_name = 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF' ;

FILE_NAME

---

  MAXBYTES

---

D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF  314572800 Received on Fri Oct 19 2001 - 13:59:48 CDT