RE: Curious DBA_DATA_FILES results
- From: "Henry Poras" <henry@xxxxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Jun 2005 11:50:00 -0400
I remember seeing this a few versions back (8i?). I tracked that down to a
datafile resize (think I found the ALTER command in the alert log) on the
autoextensible file.
Henry
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jared Still
Sent: Monday, June 06, 2005 3:37 PM
To: Oracle-L Freelists
Subject: Curious DBA_DATA_FILES results
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@pr09 SQL> l
1 select file_name, bytes, maxbytes
2 from dba_data_files
3* where bytes > maxbytes
12:36:52 ORAGLDB - js001292@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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
