Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Curious DBA_DATA_FILES results
Sure have. If you're a user of OEM and set the autoextend parameter on
it defaults to KBYTES. Now if the datafile is > than whatever in KBYTES
then Oracle won't complain, but won't do anything either. Have done
that several times. Rather embarrassing, especially in the middle of
the day.=20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_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
-------------------------------------------------- ----------------=20
2 rows selected.
--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 06 2005 - 15:46:45 CDT