Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: redo logs and IO please advise
Thanks.
The filestat table doesnt really hold information pertaining to the redo logs but the waitstate table gave me some useful information.
Thanks again.
On Thu, 29 Mar 2001 07:00:26 -0600, David Busby <dbusby3_at_slb.com> wrote:
>Try v$filestat and v$waitstat.
>
>
>
>"Kev.-" wrote:
>
>> Hello All,
>>
>> Now that I know the right question to ask here it goes. What table
>> can you query to get the IO (physical reads and writes) that they are
>> producing?
>>
>> For example when I query v$filestat I am able to get reads and writes
>> that the file has produced since the oracle server was booted as the
>> values keep incrementing until re-booted/ shutdown-re-started, etc...
>>
>> How can I get these same values for the redo logs. I have looked the
>> the v$log, v$logfile but there is nothing there.
>>
>> Thanks,
>>
>> Kev.-
>
Received on Mon Apr 02 2001 - 17:45:23 CDT