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

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

Re: Curious DBA_DATA_FILES results

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 7 Jun 2005 00:55:50 +0100
Message-ID: <bf463805060616554c1d5865@mail.gmail.com>


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-l
Received on Mon Jun 06 2005 - 20:00:50 CDT

Original text of this message

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