High I/O on Sun server running Oracle.


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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  
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 Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Test program running taking much more time on high end server T5440 than low end server T5220
sanjay_singh85
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...... Solaris
17
Solaris
High CPU activity running Oracle
stocksj
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...... UNIX and Linux Applications
4
UNIX and Linux Applications
UNIX and Linux

Unix (trademarked as the UNIX certification mark) is a very mature family of multitasking, multiuser computer operating systems that evolved from the original AT&T Unix. Unix development starting in the 1970s by legendary Bell Labs programmers Ken Thompson, Dennis Ritchie, and others. Unix was first targeted for the Bell System and AT&T licensed Unix to outside parties. In the 1970s time period, this lead to a variety of for-profit as well as not-for-profit Unix variants.
In the early days, this included the University of California, Berkeley (BSD), Microsoft (Xenix), IBM (AIX), and Sun Microsystems (Solaris). In the early 1990s, AT&T sold their Unix rights to Novell. In 1995 Novell sold their Unix business to the Santa Cruz Operation (SCO). The UNIX trademark was passed to The Open Group, a "neutral" industry consortium. The Open Group promoted the use of the UNIX trademark for certified operating systems that comply with the Single UNIX Specification (SUS). In 2014 Apple's macOS became the Unix version with the largest global install base and macOS remains the largest Unix-user base today.
Linux is a family of open source Unix-like operating systems based on the Linux kernel. The Linux kernel is an operating system kernel first released by Linus Torvalds on 17 September 1991. Linux distributions include the Linux kernel, system software and libraries. Popular free open source Linux distributions include Debian, Fedora, and Ubuntu. Commercial Linux distributions include Red Hat Enterprise Linux and SUSE Linux Enterprise Server. Linux may be freely modified and redistributed. Anyone on the planet may create a Linux distribution for any purpose.
Please enjoy and help our forum community by "showing your work" and posting your code, even when your code is not working as expected. To help others help you, please wrap your code blocks, sample input, sample output, error messages, and other data in CODE tags and wrap your short commands and short data objects in ICODE tags. We were all beginners in the beginning. If you have any questions about how to register or how to post, please contact us in Live Chat. Thank you and enjoy this "forever free" technical support community for UNIX, Linux and computer information technology in general.