Login or Register to Ask a Question and Join Our Community


Solaris

High I/O on Sun server running Oracle.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris High I/O on Sun server running Oracle.
# 1  
Old 12-23-2008
High I/O on Sun server running Oracle.
Hi,

Currently we have a Sun Fire 480R running Solaris 9 and Oracle 9.2.0.8. The server is fibre attached to a NetApp FAS3070. Two separate 100GB LUNs are presented to the server.

The two LUNs are mounted as the file systems data and logs for the Oracle database. We are seeing high I/O on both these 'disks' during database queries. We have a comparable setup at another site which does not have the same problems. Below is the output of iostat -xPnce

It may be difficult to make out but the kr/s is high along with asvc_t. The %b is averaging about 80% all the time. I have read somewhere that anything over 5% is bad.

Code:
   extended device statistics       ---- errors ---
    r/s    w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b s/w h/w trn tot device
   29.4    1.2  337.6   13.0  0.0  1.0    0.0   34.0   0  72   0   0   0   0 c2t2d1s2
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c2t2d1s7
   32.8    0.8 5993.2    6.4  0.0  1.4    0.0   41.9   0  86   0   0   0   0 c2t2d2s2
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c2t2d2s7
   25.2    0.4  289.6    3.2  0.0  0.9    0.0   36.9   0  67   0   0   0   0 c3t2d1s2
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c3t2d1s7
   30.0    1.0 6707.6    9.8  0.0  1.4    0.1   46.0   0  80   0   0   0   0 c3t2d2s2
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c3t2d2s7
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t0d0s0
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t0d0s1
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t0d0s2
    0.0    0.6    0.0   14.6  0.0  0.0    0.0   10.7   0   0   0   0   0   0 c1t0d0s3
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t0d0s4
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t0d0s7
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t1d0s0
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t1d0s1
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t1d0s2
    0.0    0.6    0.0   14.6  0.0  0.0    0.0   14.3   0   1   0   0   0   0 c1t1d0s3
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t1d0s4
    0.0    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0   0   0   0   0 c1t1d0s5

I need to know what I can check or change on the server (Unix or Oracle) or the filer to try to improve performance? Thanks for your help.
# 2  
Old 12-23-2008
i can't see any high i/o... there are 32 reads per second and this is nothing. please post the output of "iostat -xnc -Td 2" and let this command run for a minute. after that put the output in a file and post this file here.
Login or Register to Ask a Question

Previous Thread | Next Thread

3 More Discussions You Might Find Interesting

1. Solaris

Test program running taking much more time on high end server T5440 than low end server T5220

Hi all, I have written the following program and run on both T5440 and T5220 on same OS version. I found that T5540 server takes more time than T5220. Please find below the details. test1.cpp #include <iostream> #include <pthread.h> using namespace std; #define NUM_OF_THREADS 20... (17 Replies)
Discussion started by: sanjay_singh85
17 Replies

2. UNIX and Linux Applications

High CPU activity running Oracle

I'm running Oracle 10g on a V880 using Solaris 8 connected to a NetApps SAN and recently I've been getting cpu activity that normally is 2 -3 % now running from 14% ass a low up to 90% peak against oracle PIDs. No recent changes have been to Oracle or the OS. THere has been some firmware updates to... (4 Replies)
Discussion started by: stocksj
4 Replies

3. UNIX for Advanced & Expert Users

Sun: High kernel usage & very high load averages

Hi, I am seeing very high kernel usage and very high load averages on my system (Although we are not loading much data to our database). Here is the output of top...does anyone know what i should be looking at? Thanks, Lorraine last pid: 13144; load averages: 22.32, 19.81, 16.78 ... (4 Replies)
Discussion started by: lorrainenineill
4 Replies
Login or Register to Ask a Question