Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with reporting file IO activity for each tablesapce
Take the block size and multiply by the number of blocks read or written.
That gives you the number of bytes. Since Oracle always reads an entire DB
block and always writes an entire DB block you have how much data was
actually written. If you are looking for how much data was added or
changed - and not a measure of raw IO - I think the amount of redo generated
would be what you are looking for.
Jim
"Andy Trigg" <atrigg_at_optusnet.com.au> wrote in message
news:3c4a9f47$0$4019$afc38c87_at_news.optusnet.com.au...
> I am trying to design a script that will provide me with the file IO
> activity that is occuring for each table space. I have had a look at the
> utlbstat.sql/utlestat.sql script pair. These produce closely to what I
want
> except they only show the number of reads and writes that have occured and
> not the actualy number of bytes read or written. I am really after the
> activity measured in bytes.
>
> Can any body give me any idea how I can extrapolate this type of
> information? I need the solution to be OS independant. So suggesting using
> perfmon on NT is not an option. I really would like an Oracle script to
> achieve this.
> Thanks in advance.
>
> Andy
>
>
Received on Sun Jan 20 2002 - 10:33:57 CST