10-21-2005
Memory Usage in AIX
Hi All,
I have a question, can you guys please help me by giving your valuable suggestons:
I am using AIX 5L, running oracle 7 version. I need to increase the oracle memory to 40 MB more. Currently Oracle occupies 260M. I wanted to know whether I can increase the memory without any problem. It is a production server.
The result of the svmon -G is as follows:
# svmon -G
size inuse free pin virtual
memory 262133 261991 142 11851 128713
pg space 524288 90425
work pers clnt
pin 11851 0 0
in use 93992 167999 0
So, is it advisable to increase the Oracle memory by 40MB? Please help me
Regards
Santhosh
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi All,
I have a question, can you guys please help me by giving your valuable suggestons:
I am using AIX 5L, running oracle 7 version. I need to increase the oracle memory to 40 MB more. Currently Oracle occupies 260M. I wanted to know whether I can increase the memory without any problem.... (1 Reply)
Discussion started by: kollam68
1 Replies
2. Shell Programming and Scripting
I have written a script that will calculate CPU usage and Memory usage of a particular process on AIX Unix. I know the PID and I am using the command --
# for CPU Usage
MSG_CPU_USG=`ps uax | grep ${PID} | awk {'print $3'}`
#for Memory Usage
MSG_MEM_USG=`ps uax | grep ${PID} | awk {'print... (0 Replies)
Discussion started by: asutoshch
0 Replies
3. AIX
Hi,
We have AIX 5.1 machine of RAM 8 GB and paging space is 8GB. we are getting high memory usage of almost 99%.Can anybody please help in this ?
Partial vmstat o/p
kthr memory
----- -----------
r b avm fre
2 1 278727 1143
There is no paging issue.Becoz in... (5 Replies)
Discussion started by: jayakumarrt
5 Replies
4. AIX
How to check the memory usage on AIX by various processes? (1 Reply)
Discussion started by: aajmani
1 Replies
5. HP-UX
how can I find cpu usage memory usage swap usage and
I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times
my final destination is monitor process
logical volume usage above X % and number of Logical voluage above
can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies
6. AIX
How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies
7. AIX
Hi,
I have AIX 5.3TL8 two node cluster using HACMP and have 10g database using RAW devices. I am seeing gradual increase in comp% memory everyday and it reaches 100% and evicts the node, we had 4 evictions in 40days.
I am pasting vmstat and vmo output, anyone seen this issue?
... (5 Replies)
Discussion started by: navin7386
5 Replies
8. AIX
hi,
I want to ask , my AIX 6.1 is always used about 97% memory.
Is this normal ?
or any command can free up memory like Linux ?
thanks. (1 Reply)
Discussion started by: virusxx
1 Replies
9. AIX
Hi All,
I have some questions regarding the performance, MEMORY/ Virtual Memory (paging /swap space)
Please see the nmon-MEMORY stats from my AIX LPAR.
24 GB --> RAM
3456 MB --> Paging Space
│ Memory ───────────────────────────────────────────────────────────────────────
│... (8 Replies)
Discussion started by: System Admin 77
8 Replies
10. AIX
Hi, i have 2 identical web servers using AIX. I use nmon analyser to check their performance.
The server A exceeds 20% memory usage for system, 5% for cache and the rest 75% for processes. While, it uses 4% of Paging Space.
The server B exceeds 20% for system, 45% for cache and 35% for processes.... (24 Replies)
Discussion started by: dim
24 Replies
LEARN ABOUT SUSE
apache::session::oracle
Session::Oracle(3) User Contributed Perl Documentation Session::Oracle(3)
NAME
Apache::Session::Oracle - An implementation of Apache::Session
SYNOPSIS
use Apache::Session::Oracle;
#if you want Apache::Session to open new DB handles:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:sessions',
UserName => $db_user,
Password => $db_pass,
Commit => 1
};
#or, if your handles are already opened:
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh,
Commit => 1
};
DESCRIPTION
This module is an implementation of Apache::Session. It uses the Oracle backing store and no locking. See the example, and the
documentation for Apache::Session::Store::Oracle for more details.
USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to
either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have
adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order
to make you think about this problem.
This module also respects the LongReadLen argument, which specifies the maximum size of the session object. If not specified, the default
maximum is 8 KB.
AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>.
SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session
perl v5.12.1 2007-09-28 Session::Oracle(3)