Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9i - which RAID ??
select * from v$filestat;
That gives you the physical number of read and write operations, which is your starting place.
As for what constitutes "heavy", there's no real answer. Certainly, no absolute number of writes. But you should also compare it to the number of reads, too. If the writes are a "substantial" proportion of reads, I'd call that a 'heavy writer'. Either that, or it's badly tuned.
Regards
HJR
"Wolfgang Blümlhuber" <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 Wed Jul 03 2002 - 00:58:39 CDT