02-28-2003
How much memory does the system have? How much swap space? Has the /etc/system file been updated with the required parameters for Oracle? How long has the problem been occuring? (and what changed when it started - more users, more databases, new searches being launched daily...)
This isn't something one of us can just say "Yea, you need more memory" You have to work with your Oracle DBA and IT team to find out what was happening and what is happening, know/investigate any changes happening on the system be it OS or Oracle.
Give more details of what you have found and possibly a 'best guess' can be given back.
Post output from any of the monitoring tools showing your problem. If you haven't been watching your servers or at least have sar running and collecting information, turn it on to have some clue of what the server is doing at what times. Check for new cron jobs, increase in users utilizing the database, changes in your volume management (if you are using Vertias or any other volume manager, losing a disk drive and having it 'automatically' place databases on different disks that had the space (but really could not handle the increased load of hits) could cause problems (if you didn't have hot spares).
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi folks,
Lately my RS 6000 server is giving some problems.
Needs a reboot from time to time (4-8 days):mad:
Specs:
IBM/RS6000
Unix 4.3
3 gigabyte memory
I keep getting messages like :
" The fork function failed "
I have raised the paging space from 1 gigabyte to 3 gigabyte,... (2 Replies)
Discussion started by: Erik Rooijmans
2 Replies
2. Filesystems, Disks and Memory
Hi Guys: Would like to know how to check system swapping and paging and some theory on how they function. I am an oracle dba and my environment is 8171 on AIX 433. We have a 1GB of RAM on the box and I am educating myself to see how much more SGA can be accommodated on the box and what are the... (2 Replies)
Discussion started by: ST2000
2 Replies
3. UNIX for Dummies Questions & Answers
i have a server constantly have high iowait, but i am not able to tell which process generate the most of io. none commands, such as iostat, sar, top will give me this kind of information.
hope there is some command can help me to spot the process generate the most of io
let to know input... (1 Reply)
Discussion started by: giantpanda77
1 Replies
4. AIX
Gurus,
What does excessive Page Ins indicate for the memory status on the machine.
Or, in another form, Reardless the OS, does excessive Page INs reflects memory shortage ? (6 Replies)
Discussion started by: Negm
6 Replies
5. UNIX for Advanced & Expert Users
can anybody explain me the concepts
virtual memory mangement, swapping and paging?
although i roughly know what they are , i need
more solid distinction between them, and also i want to figure out
the relations between them?
do you have any well-defined definitons for this concepts? (2 Replies)
Discussion started by: gfhgfnhhn
2 Replies
6. AIX
Hi
I have found a problem on my AIX 5.1 server. day by day the paging size is increasing,what is the reason behind it and if percentage is at 100 what will happen. Oracle 9i is running on my server.
PAGING SPACE
size,mb 5632
% used 14.6
% free 85.3
How can i decrease the using... (6 Replies)
Discussion started by: dearsumon
6 Replies
7. AIX
Has anyone seen this error before? On the IBM website they suggest updating to AIX 6.1.0.0 TL2, but we are already at that level. Any help or suggestions are appreciated! Thanks!
/>errpt -a
---------------------------------------------------------------------------
LABEL: ... (2 Replies)
Discussion started by: troym72
2 Replies
8. UNIX for Dummies Questions & Answers
AIX & DB2 paging issues
Hello I needs some help on AIX & DB2 paging issues. Recently a db2 query caused paging issues which then lead to memory problems and a server restart. Is there anyway of finding out what db2 queries were causing the problem..
Thanks in advance (2 Replies)
Discussion started by: nedkao
2 Replies
9. Solaris
Hello all, new to this forum (member of many others). Hopefully I can find help here.
SERVER:
Brand new server Oracle Enterprise SPARC T4-1
Loaded Solaris SPARC 10 u10, patched to 147440-27
Loaded OpenLDAP v2.4.30
Loaded Berkley DB 4.7.25.NC Loaded OpenSSL 1.0.1c
Note: All packages are... (2 Replies)
Discussion started by: Wraith_G2IC
2 Replies
10. Solaris
Hi all,
This might sound silly but i am trying to determine if i have sufficient memory or not.
My definition of sufficient memory = no swapping + no paging to physical swap file.
I know i can use vmstat to monitor swapping and paging and using the SR column as well.
But wouldn't it be... (28 Replies)
Discussion started by: javanoob
28 Replies
LEARN ABOUT LINUX
mysql_waitpid
MYSQL_WAITPID(1) MySQL Database System MYSQL_WAITPID(1)
NAME
mysql_waitpid - kill process and wait for its termination
SYNOPSIS
mysql_waitpid [options] pid wait_time
DESCRIPTION
mysql_waitpid signals a process to terminate and waits for the process to exit. It uses the kill() system call and Unix signals, so it runs
on Unix and Unix-like systems.
Invoke mysql_waitpid like this:
shell> mysql_waitpid [options] pid wait_time
mysql_waitpid sends signal 0 to the process identified by pid and waits up to wait_time seconds for the process to terminate. pid and
wait_time must be positive integers.
If process termination occurs within the wait time or the process does not exist, mysql_waitpid returns 0. Otherwise, it returns 1.
If the kill() system call cannot handle signal 0, mysql_waitpid() uses signal 1 instead.
mysql_waitpid supports the following options:
o --help, -?, -I
Display a help message and exit.
o --verbose, -v
Verbose mode. Display a warning if signal 0 could not be used and signal 1 is used instead.
o --version, -V
Display version information and exit.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_WAITPID(1)