Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

check if the disk is slow

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users check if the disk is slow
# 1  
Old 09-30-2011
check if the disk is slow
Hi,
we have some Oracle DBs on a AIX server.
We have the following error messages :
Code:
Warning: log write time 540ms, size 5444KB
*** 2008-05-14 10:19:02.686
Warning: log write time 1470ms, size 5533KB

Oracle in LGWR Is Generating Trace file with "Warning: Log Write Time 540ms, Size 5444kb" In 10.2.0.4 Database [ID 601316.1] metalink note says :

Code:
So probably you need to check if the disk is slow or not or for any potential OS causes. If 

everything looks fine at the hardware level or OS level then you can safely ignore these messages.

How can I check if the disk is slow or not or for any potential OS causes ?

Thank for help or any idea ?
# 2  
Old 09-30-2011
Use 'sar'. Set it up as a cron job running every 20 minutes and wait a day for results.
# 3  
Old 09-30-2011
I think you need to write something to listen on your Oracle error_log once the output include "Warning: log write time" then your script need to run some monitoring commands like :
Code:
vmstat 
iostat
sar

then save the output to the log file , this will help you to identify and resolve the problem as you collected the stats in realtime the error appeared.
# 4  
Old 09-30-2011
Did this message appear only once back in 2008 or is it still showing up from time to time?
Does your errpt show anything for the time the problem occured?
Do you use local disks or san?
# 5  
Old 10-03-2011
Hi Cero,
I have this message now. What I pasted here is from Oracle Docs.
What is errpt ?
We use san.

Thanks and regards.
# 6  
Old 10-03-2011
Run iostat for a few seconds:

Code:
iostat -sndzx 1

If possible, post the output.
# 7  
Old 10-03-2011
errpt is the command for the aix error-report you can use to check if the OS was involved in that problem. The tools the other posters suggested should give you a good overview of your disks performance.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check disk space

I am trying a script which will alert if disk space crosses some threshold, i googled it and got some scripts already, but they are not working with my server. The problem is, my filesystem names are big, so the sizes are moving to the second line. just like below any ideas? thanks in advance... (8 Replies)
Discussion started by: karthikeayan
8 Replies

2. UNIX for Dummies Questions & Answers

Fail to check disk

Hi there, I can't find any way to check the file system on a partition. The two following command fail with the same result: e2fsck /dev/sdc10 e2fsck -b 8193 /dev/sdc10Output: e2fsck 1.41.3 (12-Oct-2008) e2fsck: Bad magic number in super-block while trying to open /dev/sdc10 The... (0 Replies)
Discussion started by: chebarbudo
0 Replies

3. Solaris

How to check disk io

Hi, How to check disk io mount pointwise? I am working as Oracle DBA and want to check disk io as per mount point for adding new datafiles in tablesapce or change my redolog files to lowest disk I/O mount point. My all mount points are like /data1, /data2, /data3 ,,,,,. Can somebody tell me how... (1 Reply)
Discussion started by: rahul_switch
1 Replies

4. Solaris

Hard disk write performance very slow

Dear All, I have a hard disk in solaris on which the write performanc is too slow. The CPU , RAM memory are absolutely fine. What might be reason. Kindly explain. Rj (9 Replies)
Discussion started by: jegaraman
9 Replies

5. Filesystems, Disks and Memory

Loud Sounds can slow down disk I/O

Amazing but true... tDacjrSCeq4 More details: Unusual disk latency : Brendan Gregg Now I know why everything takes longer when I crank up the tunes. :eek: Oh well, it's nothing that a good set of headphones can't cure. (1 Reply)
Discussion started by: Perderabo
1 Replies

6. Solaris

check disk info

hi friends, - how may i check the list of disk partitions created till date specifying their physical path, size and date ? -i know only "df -k" "df -h" "du" -anyother command? -kindly advise friends..thanks alot (4 Replies)
Discussion started by: cromohawk
4 Replies

7. Solaris

How to check disk broken

Dear all, I have system that have 2 disk, and 1 off disk is broken, how can I check if the disk is broken or other problem. I'm using Solaris 10 x86. Thank you, Best Regards, Heru (4 Replies)
Discussion started by: heru_90
4 Replies

8. Shell Programming and Scripting

need help with disk check script

I wrote a script that checks particular device path directory which is full or more than 90% used, and will search older file inside and delete it. My code looks like this: #!/usr/bin/ksh ref=90 df -k | grep /cbmdata/00/gdd | tr -d '%' | \ while read a b c d e other do if (( $e >= $ref... (4 Replies)
Discussion started by: xramm
4 Replies

9. UNIX for Dummies Questions & Answers

Hard Disk Check

How can we check the number of hard disks (both internal & external) in a server, their capacity and serial number (5 Replies)
Discussion started by: muneebr
5 Replies

10. UNIX for Advanced & Expert Users

check disk

How I do to check disk not use in my server. Sun Solaris 2.8 df -k du |sort -rn But I want check disk and analyse a file system not used. Thanks for reply. (1 Reply)
Discussion started by: chris_carmo
1 Replies
Login or Register to Ask a Question