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 -> current size of file in v$tempfile

current size of file in v$tempfile

From: sarab <sarabjeetd_at_hotmail.com>
Date: Wed, 25 Jun 2003 18:48:03 GMT
Message-ID: <D7mKa.3371$MZ1.1566@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
Received on Wed Jun 25 2003 - 13:48:03 CDT












Original text of this message













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