RE: V$DATAFILE columns

From: Rahul <rahul_at_ratelindo.co.id>
Date: Fri, 9 Jun 2000 14:16:40 +0700
Message-Id: <10523.108347@fatcity.com>

you could join v$filestat and v$dba_data_files to get the tablespace name

--------------+--------------+--------------+--------------------
select	substr(file_name,1,40) file_name,
	PHYRDS PHYRD,
	PHYWRTS PHYWR,
	ROUND(PHYBLKRD/decode(PHYRDS,0,1,PHYRDS),0) PER_READ,
	ROUND(PHYBLKWRT/decode(PHYWRTS,0,1,PHYWRTS),0) PER_WRITE,
	tablespace_name
from	v$filestat, dba_data_files
where	file#= file_id

order by 3
/

--------------+--------------+--------------+--------------------

query the v$fixed_view_definition to get info on v$ views...

HTH rahul

> ----------
> From: Linda Hagedorn[SMTP:Linda_at_pets.com ]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: 09 Juni 2000 03:31
> To: Multiple recipients of list ORACLE-L
> Subject: V$DATAFILE columns
>
> Hello,
>
> I have a database in mount, and need to rename a dataset. Will someone let
> me know the column name in V$DATAFILE which holds the external dataset name,
> and the tablespace name?
>
> Is there a reference which lists all the V$ views, all the columns in the V$
> views, and if there's a V$_view_columns (of sorts) view where I can list all
> the columns for a view?
>
> Any reference to doc is sincerely appreciated.
>
> Linda
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jun 09 2000 - 02:16:40 CDT