05-23-2013
For Paging Space related impacts, only the output of svmon is relevant, as -=Xray=- stated.
RSS is not related to what is being paged out and what not. ps is not useful to analyse this - stick to svmon.
Interessting are those entries, that have lots of pages being paged out and if they grow, ie. page out even more. Use of Paging Space should be avoided as it usually thrashes a system and makes it rather slow up to unusable. As Paging Space is usually being located in the rootvg on the same disks/volumes where the rest of the operating system resides, it slows down general performance since disks are way much slower than RAM.
Anyway it seems there has been allocated a bigger amount of memory for Oracle (SGA?) than you have real memory available.
That might be the reason so much pages are allocated by Oracle.
In your vmstat output you sometimes see counts in the pi and po columns which indicate that some pages are written to Paging Space or written to there, which is something you want to avoid.
High values there are usually the real problematic impact, where you and your users might "feel" the slowness of the system and it's applications on-top ie. being dependent on this Oracle DB running there.
I recommend checking your memory settings of the Oracle DB (SGA?) and adjust it so, that it uses not more than about 80% of your ~57GB RAM. Don't count the Paging Space in for that.
It could be that at day time there is not that much pi/po traffic, but it seems the space has been allocated at some time which could be as well night time.
Maybe some RMAN backups or whatever. Best is to set up some longterm monitoring with nmon for example to check out what causes this.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all,
Is there a paging utility in UNIX, when we can page some one for some condition
Best Regards
Omran (1 Reply)
Discussion started by: omran
1 Replies
2. AIX
This is my first post, and I am new to the UNIX world. Hopefully this question won't be too lame.
I know that I can use topas to see the paging space used by some processes. I would like to script something that can add up the paging space used by process owned by or associated with an... (1 Reply)
Discussion started by: alntht
1 Replies
3. Shell Programming and Scripting
I need a script which sends a mail when paging is happening and which process is causing paging? (5 Replies)
Discussion started by: jayaramanit
5 Replies
4. AIX
Hi,
I have paging size 2048M showed from topas and 10240M showed from "lsps -a", can anyone tell what is the difference? and how to change the PAGING SIZE (showed in topas) to 8192M?
Can you please tell in detail step?
Thanks!
Victor
#topas
Topas Monitor for host: egsprc01dev ... (10 Replies)
Discussion started by: victorcheung
10 Replies
5. Shell Programming and Scripting
how to get output of a file which is large screen by screen (1 Reply)
Discussion started by: mayur_verma
1 Replies
6. AIX
Hi ,
I have 8Gb memory in my JS21 server. When I run svmon it shows 3655Mb memory is utilized and 4344Mb free. I have configured 8Gb paging space and 14% is utilized which is 1Gb. I dont have memory issues but just want to know Why 1gb paging is utilized when my almost 4Gb real memory is free?... (6 Replies)
Discussion started by: vjm
6 Replies
7. AIX
I do have a friend who have this script already but lost it. Can you please help to give me a script that can capture the closed_wait on the stack and identify which process using it. I am thinking of using netstat and rmsock. (2 Replies)
Discussion started by: depam
2 Replies
8. BSD
Hi Experts,
I am facing one problem here which is one process always stuck in running state which causes the other similar process to sleep state . This causes my system in hanged state.
On doing cat /proc/<pid>wchan showing the "__init_begin" in the output.
Can you please help me here... (0 Replies)
Discussion started by: naveeng
0 Replies
9. UNIX for Advanced & Expert Users
Hi Experts,
I am facing one problem here which is one process always stuck in running state which causes the other similar process to sleep state . This causes my system in hanged state.
On doing cat /proc/<pid>wchan showing the "__init_begin" in the output.
Can you please help me here... (1 Reply)
Discussion started by: naveeng
1 Replies
10. UNIX for Advanced & Expert Users
Hi Experts,
I am facing one problem here which is one process always stuck in running state which causes the other similar process to sleep state . This causes my system in hanged state.
On doing cat /proc/<pid>wchan showing the "__init_begin" in the output.
Can you please help me here... (6 Replies)
Discussion started by: naveeng
6 Replies
LEARN ABOUT DEBIAN
apache::session::store::oracle
Apache::Session::Store::Oracle(3pm) User Contributed Perl Documentation Apache::Session::Store::Oracle(3pm)
NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.10.1 2010-10-18 Apache::Session::Store::Oracle(3pm)