03-08-2011
On thing that can run paging up unnecessarily is static linking of apps, something you can change for apps developed locally. All apps using libs dynamically linked are using the same pages, not copies, and since those pages are more frequently referenced, they stay in RAM.
We used to get a lot of RDBMS out of a small platform by designing batch processes to process N records at a time and then commit. We also found that over-use of updatable cursors increased processing. The way Oracle works, a long select can end up owning many pages as other processes update or delete those rows. So, it helps the whole system to do things in small batches, and even in select programs, a commit may release pages tied up by update-capable cursors. If you think of it, even processing 128 records per commit, you have 99+% of any economy of scale over one at a time. Any locks are released sooner, so interactive can get access. As batches get smaller, working set pages are in RAM or CPU cache more often, and finished pages can roll out and not soon return. Smaller batches also are more likely not to overwhelm cachng and buffering in disk subsystems, slowing I/O to media speed. Also, the system tuning does not change on more active days, just the batch run time.
Interactive row sets tend to be small, but batch can bring a lot of pages, an unpredicatable number, into play at once.
These 2 Users Gave Thanks to DGPickett For This Post:
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello ,
I just installed openssh in my system . I actually tried to man sshd but it says no entry , though there is a man directory in the installation which have the man pages for sshd .
Can anyone tell me how should i install these man pages .
DP (2 Replies)
Discussion started by: DPAI
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I've written now a man pages, but I don't knwo how to get 'man' to view them. Where have I to put this files, which directories are allowed??
THX Bensky (3 Replies)
Discussion started by: bensky
3 Replies
3. UNIX for Advanced & Expert Users
hi,
can any body tell, what are wired pages in HP_UX.
which structure contains that and plz tell the corresponding
system call to get it. (1 Reply)
Discussion started by: venkat_t
1 Replies
4. UNIX for Advanced & Expert Users
hi,
plz tell me, how can get the inactive pages in HP UX.
bye.... (1 Reply)
Discussion started by: venkat_t
1 Replies
5. UNIX for Dummies Questions & Answers
Hi folks,
I want to know all the commands for which man pages are available. How do i get it?
Cheers,
Nisha (4 Replies)
Discussion started by: Nisha
4 Replies
6. UNIX for Dummies Questions & Answers
okay.. have monitored that the page out/h max and avg have been 0 for one week. is this possible...? huge applications will have swap space being utilised ... so i am suprised that for one whole week, it has actually been zero
please advise
thanks (1 Reply)
Discussion started by: yls177
1 Replies
7. Shell Programming and Scripting
Can one string type variable changed into the date type variable. (1 Reply)
Discussion started by: rinku
1 Replies
8. Programming
Dear colleagues,
One of my friend have a problem with c code. While compiling a c program it displays a message like
"array type has incomplete element type". Any body can provide a solution for it.
Jaganadh.G (1 Reply)
Discussion started by: jaganadh
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I am new to linux. I am using more command to view the contents of a file. If the file has many pages i am using f to move forward to the next page.
But when i press f it skips to two pages instead of one page. i checked the man more.
It shows the default is 1. Please share your... (1 Reply)
Discussion started by: nokiak810
1 Replies
LEARN ABOUT ULTRIX
vmstat
vmstat(1) General Commands Manual vmstat(1)
Name
vmstat - report virtual memory statistics
Syntax
vmstat [ interval [ count ] ]
vmstat -v [ interval [ count ] ]
vmstat -fKSsz
vmstat -Kks namelist [ corefile ]
Description
The command reports statistics on processes, virtual memory, disk, trap, and cpu activity.
If is specified without arguments, this command summarizes the virtual memory activity since the system was last booted. If the interval
argument is specified, then successive lines are summaries of activity over the last interval seconds. Because many statistics are sampled
in the system every five seconds, five is a good specification for interval; other statistics vary every second. If the count argument is
provided, the statistics are repeated count times.
When you run the format fields are as follows:
Procs: information about numbers of processes in various states.
r in run queue
b blocked for resources (i/o, paging, and so on.)
w runnable or short sleeper (< 20 seconds) but swapped
faults: trap/interrupt rate averages per second over the last 5 seconds.
in (non clock) device interrupts per second
sy system calls per second
cs cpu context switch rate (switches/second)
cpu: breakdown of percentage usage of cpu time
us user time for normal and low priority processes
sy system time
id cpu idle time
Memory: information about the use of virtual and real memory. Virtual pages are considered active if they belong to processes which are
running or have run in the last 20 seconds.
avm active virtual pages
fre size of the free list
Pages are reported in units of 1024 bytes.
If the number of pages exceeds 9999, it is shown in a scaled representation. The suffix k indicates multiplication by 1000 and the suffix
m indicates multiplication by 1000000. For example, the value 12345 appears as 12k.
page: information about page faults and paging activity. These are averaged every five seconds, and given in units per second. The size
of a unit is always 1024 bytes and is independent of the actual page size on a machine.
re page reclaims (simulating reference bits)
at pages attached (found in free list not swapdev or filesystem)
pi pages paged in
po pages paged out
fr pages freed per second
de anticipated short term memory shortfall
sr pages scanned by clock algorithm, per-second
disk: s0, s1 ...sn: Paging/swapping disk sector transfers per second (this field is system dependent). Typically paging is split across
several of the available drives. This will print for each paging/swapping device configured into the kernel.
Options
-f Provides reports on the number of forks and vforks since system startup and the number of pages of virtual memory involved in each
kind of fork.
-K Displays usage statistics of the kernel memory allocator.
-k Allows a dump to be interrogated to print the contents of the sum structure when specified with a namelist and corefile. This is
the default.
-S Replaces the page reclaim (re) and pages attached (at) fields with processes swapped in (si) and processes swapped out (so).
-s Prints the contents of the sum structure, giving the total number of several kinds of paging related events that have occurred since
boot.
-v Prints an expanded form of the virtual memory statistics.
-z Zeroes out the sum structure if the UID indicates root privilege.
Examples
The following command prints what the system is doing every five seconds:
vmstat 5
To find the status after a core dump use the following:
cd /usr/adm/crash
vmstat -k vmunix.? vmcore.?
Files
Kernel memory
System namelist
vmstat(1)