01-21-2011
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 131 0x00000000 --rw-r----- oracle dba 2202075136
m 132 0x00000000 --rw-r----- oracle dba 2197815296
m 133 0x00000000 --rw-r----- oracle dba 1411452928
m 134 0x97604490 --rw-r----- oracle dba 16384
We just got through rebooting the server and ran another process and it is exhibiting the same behavior.
I can look into increasing the DBC but that may be difficult to get through and take some time with our change management.
What's strange is that this very process has been running fine for years. Then, within the past week, it has all of a sudden been acting strangely. I am trying to figure out what has changed but so far it appears nothing has.
Someone recommended I run truss against the process. I've never run truss before so I do not know what to expect from it but it's worth a shot.
Also, I am not certain that what I am seeing in Glance is a problem. I think it is abnormal to see a process waiting on cache but this may be absolutely normal and running the way it should based on the query. The problem could be somewhere else but I have no idea where else to look. The issue we're trying to solve is "a certain query is all of a sudden taking a long time to run".
Thanks everyone for the help so far.
---------- Post updated at 01:52 PM ---------- Previous update was at 01:41 PM ----------
Quick update: I ran the truss (HP's tusc command) and all I see is line after line of:
read *****************
lseek *****************
read *****************
lseek *****************
read *****************
lseek *****************
read *****************
lseek *****************
read *****************
lseek *****************
and on and on and on. I'm inclined to believe now that there is not anything wrong with the server but getting our DBAs to delve deeper can be quite an issue. My job is to prove that nothing is wrong with the server or else find the problem and fix it.
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello,
I have a mail server (sendmail) with SUNOS 5.5.1. Just recently it began to respond very slowly.
I used vmstat to check the performance data. Only interupt, system call and CPU context swiching are relatively high. Other statistics are normal, especially CPU utilization are very... (5 Replies)
Discussion started by: caoai
5 Replies
2. UNIX for Advanced & Expert Users
hi,
What is the difference between UBC cache and Metadata cache ? where can i find UBC cache Hits and Metadata cache Hits in hp-ux?
Advanced thanx for the help. (2 Replies)
Discussion started by: sushaga
2 Replies
3. Solaris
Hi All,
There is a virtual user "ecoouk" which logs on to the server and runs some scripts. I want to know how much server performance can I gain if I put off all the scripts run by this user.
Please tell me how to analyse how much resources a specific user is using.
Regards,
Abhishek (3 Replies)
Discussion started by: max29583
3 Replies
4. UNIX for Dummies Questions & Answers
I have a Teradata Machine, using MP-RAS Unix, with a 1000 Intel Ethernet card and a Cisco switch.
If I configure the ethernet card and the switch to auto, so they negotiate to 1000, or configure the ethernet card and switch manually to 1000Full or 100Full, the velocity is very very low.
Only... (2 Replies)
Discussion started by: cuatrodos
2 Replies
5. Emergency UNIX and Linux Support
This is a weird problem I've been butting my head against for days now...
I have two OpenVPN servers set up with identical configurations except for the keys. One of them is hosted in a datacenter with a large backbone, the other is hosted on my home server's limited residential internet. One... (9 Replies)
Discussion started by: Corona688
9 Replies
6. Linux
Hi all
I saw in Microsoft web site www.SysInternals.com a tool called CoreInfo from able to print out on screen the size of the Data and Instruction caches of your processor, the Locigal to Physical Processor mapping, the number of the CPU sockets. etc..
Do you know if in Linux is available a... (2 Replies)
Discussion started by: manustone
2 Replies
7. Linux
Hi All,
could any one point out any open source test-suites for "File cache" testing and as well as performance test suites for the same. Currently my system is up with Linux/ext4.
Regards
Manish (0 Replies)
Discussion started by: hmanish
0 Replies
8. Solaris
I have DNS Server running in solaris 10 .
There is website called exaple.com ,whcih was hosted in this dns server with IP 1.2.3.4 ,now we deleted the DNS entry of that website from our DNS Server (db.exmaple.com is deleted from named.conf ) and it is hosted with some other name server with IP... (1 Reply)
Discussion started by: sandeep.tk
1 Replies
9. OS X (Apple)
So I worked out a script for Mac OSX from an existing script. This script checks the versionnumber of a plugin and a package. If the plugin version is different from the package it has to update the plugin. The script works fine but the final check fails.
Here is my script:
#compare version... (6 Replies)
Discussion started by: mattiasvdm
6 Replies
NFSSTAT(1) BSD General Commands Manual NFSSTAT(1)
NAME
nfsstat -- display NFS statistics
SYNOPSIS
nfsstat [-cseuv] [-w wait] [-n net|user] [-m [mountpath]]
DESCRIPTION
nfsstat displays statistics kept about NFS client and server activity, active user activity, exported directories, and mount information. In
the absence of any options, nfsstat displays NFS client and server statistics.
The options are as follows:
-c Show NFS client statistics.
-e Show NFS server exported directory statistics.
-m [mountpath]
Show NFS mount information.
-s Show NFS server statistics.
-u Show NFS server active user statistics.
-w wait
Display a shorter summary at wait second intervals.
-n net|user
Show network addresses as numbers, or show users as uid numbers. This option can appear multiple times.
-v Show additional information (if available).
OUTPUT
The data fields that nfsstat displays for each set of statistics are:
Client Information:
Statistics for NFS file system mounts.
RPC Counts
Counts of the RPC calls made to each of the NFS protocol procedures.
RPC Info
Statistics for NFS RPC calls:
TimedOut
RPC calls that timed out, perhaps to a slow or dead server.
Invalid
Invalid RPC replies.
X Replies
RPC replies received that did not have calls pending.
Retries
RPC calls that were retried.
Requests
Total number of RPC calls made.
Cache Info
Statistics on NFS client-side cache performance:
Attr Hits/Misses
Performance of the NFS file attribute cache.
Lkup Hits/Misses
Performance of the directory name lookup cache.
BioR Hits/Misses
Performance of block cache for reads.
BioW Hits/Misses
Performance of block cache for writes.
BioRL Hits/Misses
Performance of symbolic link cache.
BioD Hits/Misses
Performance of directory cache.
DirE Hits/Misses
Performance of directory offset cache.
Server Information:
Statistics for the NFS server.
RPC Counts
Counts of RPC calls on each of the NFS server's procedures are recorded here.
Server Ret-Failed
RPC errors returned by the server.
Server Faults
Errors in the NFS server.
Server Cache Stats
Statistics from the NFS server's RPC duplicate request cache:
Inprog
Calls already in progress.
Idem
Cache hits for idempotent procedures.
Non-idem
Cache hits for non-idempotent procedures.
Misses
Cache Misses.
Server Write Gathering
These statistics describe the efficiency of the NFS server's write gathering feature.
WriteOps
Write operations to disk.
WriteRPC
Write operations received by the server.
Opsaved
Write operations that were gathered (WriteRPC - WriteOps)
NFS Server Exported Directory Information:
Statistics for each exported directory on the NFS server.
NFS Requests
Count of NFS requests processed by an exported directory.
Bytes Read
Count of bytes read from an exported directory.
Bytes Written
Count of bytes written to an exported directory.
NFS Server Active User Information:
List of active NFS users and statistics on the NFS server.
NFS Requests
Count of NFS requests received from an active user.
Bytes Read
Count of bytes read by an active user.
Bytes Written
Count of bytes written by an active user.
Idle
Amount of time an active user has been idle.
User
Name (or uid if -n user was given) of active user.
IP Address
Host name (or network address if -n net was given) of client machine.
NFS Mount Information:
Information about the given NFS mount (or all NFS mounts).
The path mounted on and the server:/path that is mounted.
Mount arguments originally passed in to the mount.
Current mount parameter values and status information.
SEE ALSO
netstat(1), iostat(8), mount_nfs(8), nfsd(8)
HISTORY
The nfsstat command appears in 4.4BSD.
4.4BSD January 11, 2011 4.4BSD