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

Home -> Community -> Mailing Lists -> Oracle-L -> Curious DBA_DATA_FILES results

Curious DBA_DATA_FILES results

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 6 Jun 2005 12:37:02 -0700
Message-ID: <bf463805060612379947299@mail.gmail.com>


Oracle 9.2.0.6 <http://9.2.0.6> on Windows 2003. Interesting results from a query for which I would expect to see '0 rows returned'.

There are 2 datafiles for which the autoallocate value of MAXBYTES is less than the actual size of the file, possibly via a resize I imagine.

Anyone else seen this?

A bug perhaps?

12:36:33 ORAGLDB - js001292_at_pr09 SQL> l
1 select file_name, bytes, maxbytes
2 from dba_data_files
3* where bytes > maxbytes
12:36:52 ORAGLDB - js001292_at_pr09 SQL> /
MAX
BYTES BYTES
FILE_NAME MEG MEG
-------------------------------------------------- ----------------



D:\ORACLE\ORADATA\ORCL\USERS01ORCL.ORA 2,506,096,640 104,857,600 D:\ORACLE\ORADATA\ORCL\INDX01ORCL.ORA 524,288,000 104,857,600

sum 3,030,384,640

2 rows selected.

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 06 2005 - 15:42:00 CDT

Original text of this message

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