02-26-2002
Well, gosh...runnable means runnable...able to be run. If a process is not runnable it must be waiting for something to occur, like a signal or an i/o operation.
Swapped means that the entire process is sitting on disk in the swap area. If it wasn't swapped, it would be in memory.
Having processes swapped out is not good, it means you really need more memory.
If you really get exactly 30 such processes each time that you shutdown your database, I would guess that they are database processes of some kind that were sleeping, then got swapped, and finally awoken by the shutdown process. But I don't have much to go on here and that is just a guess.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have MATLAB INSTALLED IN MY SUN MACHINE >>
WHENEVER I USE IT THE CPU USAGE SHOWS ABT 90%
Seeing the vmstat shows that system calls and context switch counters reach a very high value .
What are these counters ( Man pages do not give much info on that) ....
The only thing i can make out that... (1 Reply)
Discussion started by: DPAI
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
In the unix command, "vmstat" we get information on Page memory.
what does the "mf" - "minor fault" is?
Regards,
Anent (3 Replies)
Discussion started by: anent
3 Replies
3. UNIX for Dummies Questions & Answers
When I exeute vmstat (e.g. vmstat 30 2),
in some machines I get some wierd result as the first line.
like: -117% or 208% for CPU idle percentage.
But the second line is alright.
Could someone explain this please.
Thanks !
Chaadana (4 Replies)
Discussion started by: chaandana
4 Replies
4. UNIX for Advanced & Expert Users
Hi,
what does mean the free colomne in out put of vmstat ? is it free espace of physical memory or of swap space on hard disk ?
Thank you (4 Replies)
Discussion started by: big123456
4 Replies
5. UNIX for Dummies Questions & Answers
Hi
I wanted to collect data by using vmstat -I 60 >xxxx.txt & using my own account
It was stopped by it self after 2 hours try again same result
We want to collect day date by succession how to collect data using vmstat for day
Thank you (2 Replies)
Discussion started by: Syed_45
2 Replies
6. HP-UX
if I have a two CPU
when I run vmstat command to check cpu usage
it only one row
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
1 ... (1 Reply)
Discussion started by: alert0919
1 Replies
7. Shell Programming and Scripting
Hi
I need to write a script to display VMSTAT every 5 seconds and I just need the memory columns - swap free re and just the numbers and the headers arent required.
For example
bash-3.00$ vmstat 5| awk '{print $4" "$5" "$6}'
disk faults cpu ------ This header isnt required
swap... (3 Replies)
Discussion started by: kapilk
3 Replies
8. Solaris
Hi friends,
I have confusion about VMSTAT command.
1. When I execute "vmstat" command without any interval then I got something like following output.
vmstat
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr m1 m1 m1... (13 Replies)
Discussion started by: rahul_switch
13 Replies
9. UNIX for Dummies Questions & Answers
RHEL 5.4
Our Linux machine seemed to be running slow. So, I ran the top and vmstat commands.
Question1.
I can see the process 11517 consuming 100% CPU . But that just means that this process totally utilizes one of the cores in a mult-core CPU. Right ? This machine apparently has two... (2 Replies)
Discussion started by: kraljic
2 Replies
10. AIX
On our prod system we found sometime runqueue goes back to 0 as below.
Whereas on test server even with very very less work the r-queue never dropped to 0. Under what conditions r-queue drops to 0? Does it mean something unusual?
EG:
kthr memory page faults ... (1 Reply)
Discussion started by: aixusrsys
1 Replies
LEARN ABOUT DEBIAN
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm)
NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
database_version
Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.
insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
build_dsn PARAMHASH
Takes a bunch of parameters:
Required: Driver, Database or Host/SID, Optional: Port and RequireSSL
Builds a dsn suitable for an Oracle DBI connection
blob_params column_NAME column_type
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
distinct_query STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle
perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)