Sponsored Content
Full Discussion: vmstat question
Top Forums UNIX for Dummies Questions & Answers vmstat question Post 16152 by htsubamoto on Tuesday 26th of February 2002 08:51:37 AM
Old 02-26-2002
vmstat question

Hello all,

I have the folowing question: I have an E450 with Solaris 2.6 running in a cluster environment. The primary node runs Oracle 8.1.5. My problem is: every time the Oracle Database is shutdown, the "w"colum in vmstat command jumps to "30". In man page for vmstat command, the "w" colum means "runnable but swapped". I can't imagine what that realy means. Does anyboy have an idea of what that realy means and why that hapens? This behavior started when we had a disk crash in the boot disk e=and we replaced it.

Thanks in advance


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

vmstat question

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

Simple question about vmstat

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

Red Hat Linux question on top and vmstat outputs

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

Question on r-queue from vmstat out

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

oci_set_client_info - Sets the client information

bool oci_set_client_info (resource $connection, string $client_info) DESCRIPTION
Sets the client information for Oracle tracing. The client information is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement is executed. The client information can subsequently be queried from database administration views such as V$SESSION. The value may be retained across persistent connections. PARAMETERS
o $connection -An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3). o $client_info - User chosen string up to 64 bytes long. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 Setting the client information <?php $c = oci_connect('hr', 'welcome', 'localhost/XE'); // Record the client information oci_set_client_info($c, 'My Application Version 2'); // Code that causes a roundtrip, for example a query: $s = oci_parse($c, 'select * from dual'); oci_execute($s); oci_fetch_all($s, $res); sleep(30); ?> // While the script is running, the administrator can see the client // information: sqlplus system/welcome SQL> select client_info from v$session; NOTES
Note Oracle version requirement This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards. Tip Performance With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack- age. This is less efficient than using oci_set_client_info(3). Caution Roundtrip Gotcha Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is enabled. SEE ALSO
oci_set_module_name(3), oci_set_action(3), oci_set_client_identifier(3). PHP Documentation Group OCI_SET_CLIENT_INFO(3)

Featured Tech Videos

All times are GMT -4. The time now is 12:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy