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.
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.
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)
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)
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)