Re: Oracle9i - which RAID ??

From: Binny <wonbin_choi_at_yahoo.com>
Date: Fri, 5 Jul 2002 14:45:24 +0900
Message-ID: <aqaV8.17$fk4.32@news.oracle.com>

Run Following Query in sqlplus :

column name format a20;
column tablespace_name format a20;
select tablespace_name, name, phyrds, phywrts from v$datafile df, v$filestat fs, dba_data_files where df.file# = fs.file# and df.file# = dba_data_files.file_id;

Regards
Binny

"Wolfgang Bl?lhuber" <wolfgang.bluemlhuber_at_rz.fh-regensburg.de> wrote in message news:afu354$or7$1_at_news.uni-paderborn.de...
> Hello,
>
> thanks all of you for the great response.
>
> How can I find out if there are low or heavy writes on my database.
> At the moment I use ORACLE 8.05 (want to migrate to 9i on new system).
> Is there any monitor or counter ??? Up to how many writes do you say there
> are heavy writes?
>
> Thanks.
>
> Wolfgang.
>
>
Received on Fri Jul 05 2002 - 00:45:24 CDT