Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Curious DBA_DATA_FILES results
Hi Dick,
I don't use OEM, and I don't use defaults on the autoextend.
Nothing serious here, just a minor inconvience in decipephering
a report that says I need to allocate space, as there are -234989823
bytes available. ( made ^ up number )
Jared
On 6/6/05, Goulet, Dick <DGoulet_at_vicr.com> wrote:
>
> 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.
>
> -----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> <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
>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 06 2005 - 20:00:50 CDT