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

Home -> Community -> Usenet -> c.d.o.misc -> Re: current size of file in v$tempfile

Re: current size of file in v$tempfile

From: sarab <sarabjeetd_at_hotmail.com>
Date: Thu, 26 Jun 2003 17:28:33 GMT
Message-ID: <53GKa.3457$5l2.1872@news.cpqcorp.net>


Thanks for the reply.

Since there is no maxbytes column in this table similar to dba_data_files, the file will autoextend as long as there is disk space. Is this assertion valid?

regards
-sarab

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:vfkuru6gavt95e_at_corp.supernews.com...
>
> "sarab" <sarabjeetd_at_hotmail.com> wrote in message
> news:D7mKa.3371$MZ1.1566_at_news.cpqcorp.net...
> > Hi,
> > How do i find out the current size of the file in the v$tempfile
view.
> > The create_bytes and bytes column in the view have the same value.
> > Another question: If the temp file is full, how does oracle handle it.
> > Oracle Version 9i
> > regards
> > -sarab
> >
> >
> >
> >
>
> 1 if bytes= create_bytes the file has never been extended and the current
> value is bytes
> 2 if the file can be autoextended it will be autoextended. Otherwise
you'll
> get an error.
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
Received on Thu Jun 26 2003 - 12:28:33 CDT

Original text of this message

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