Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Performance problem - waiting on cache
Operating Systems HP-UX Performance problem - waiting on cache Post 302489773 by keelba on Friday 21st of January 2011 02:52:55 PM
Old 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

performance problem

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

UBC cache vs. Metadata cache

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

Performance problem

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

Network performance problem

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

VPN performance problem

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

getting info on Cache Size, Data Cache etc..

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

File cache /Page cache 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

DNS Cache Problem-Urgent !!!!!!

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)

UNIX cache problem?

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

LEARN ABOUT DEBIAN

explain_lseek_or_die

explain_lseek_or_die(3) 				     Library Functions Manual					   explain_lseek_or_die(3)

NAME

       explain_lseek_or_die - reposition file offset and report errors

SYNOPSIS

       #include <libexplain/lseek.h>
       long long explain_lseek_or_die(int fildes, long long offset, int whence);

DESCRIPTION

       The  explain_lseek_or_die function is used to call the lseek(2) system call.  On failure an explanation will be printed to stderr, obtained
       from explain_lseek(3), and then the process terminates by calling exit(EXIT_FAILURE).

       This function is intended to be used in a fashion similar to the following example:
	      long long result = explain_lseek_or_die(fildes, offset, whence);

       fildes  The fildes, exactly as to be passed to the lseek(2) system call.

       offset  The offset, exactly as to be passed to the lseek(2) system call.

       whence  The whence, exactly as to be passed to the lseek(2) system call.

       Returns:
	       On successful, returns the resulting offset location as measured in bytes from the beginning of the file.  On  failure,	prints	an
	       explanation and exits.

SEE ALSO

       lseek(2)
	       reposition file offset

       explain_lseek(3)
	       explain lseek(2) errors

       exit(2) terminate the calling process

COPYRIGHT

       libexplain version 0.52
       Copyright (C) 2008 Peter Miller

															   explain_lseek_or_die(3)
All times are GMT -4. The time now is 03:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy