05-07-2008
Memory tuning for Oracle
Normally running Oracle on AIX 5.3, you need to do some memory tuning so that you don't "double up" in buffering files. General rule is to reduce AIX amount of mem used to buffer IO and put this into Oracle's file buffers (in the SGA). This is because Oracle knows better what to cache, as it is its own data.
I don't recommend changin the following parameter by itself but it is (IMHO) the most important new parameter for an ERP/OLTP server (Introduced in AIX 5.3 ML1 and AIX 5.2 ML4).
vmo –p –o lru_file_repage=0
This means that program memory requests (e.g. Oracle file buffers) get priority over AIX's own file buffers. This is the behaviour you'd want.
Of course there are a whole heap of other parameters you'd want to check so please DO NOT just run this command without understanding what the other settings are.
And the previous post was right, just looking at "free memory" in AIX doesn't tell you much at all as AIX will try to use all memory all the time.
I hope you are using DIO or CIO access from Oracle if using JFS2 to hold your data (and DIO if using JFS). Also Asynch I/O.
Last edited by indulis; 05-07-2008 at 08:30 AM..
Reason: correction
10 More Discussions You Might Find Interesting
1. AIX
Hi,
how can I find out how many memory (physical and virtual) a thread uses at the moment? I know how to find out the Thread-ID, but not how to monitor it...
We use AIX 4.3.3 at th emoment.
Please help, I am stuck :confused: !! (0 Replies)
Discussion started by: Fong
0 Replies
2. HP-UX
I want to check the memory usuage on the HP-UX box.
print_manifest : gave me the information of the system configuration
and came to know that we have 8GB of ram.
But on runtime I want to know what is the memory left.
Iam new to HP-UX and I would appreciate if some one can assist me on... (2 Replies)
Discussion started by: siebeladmin
2 Replies
3. Solaris
hi
pmap, prstat and ps gives the RSS which is shared memory.
I need to know the consumption of real memory. how to do that?
thx (4 Replies)
Discussion started by: melanie_pfefer
4 Replies
4. Programming
Hi,
my C++ program does some memory consuming tasks and runs several minutes.
During execution time, I want to print information on the current memory consumption and peak memory consumption of my program into a logfile.
How can I retrieve this information, i.e. which functions are available... (0 Replies)
Discussion started by: DarthVader77
0 Replies
5. AIX
Hi,
monitor memory usage on AIX machine on any day of the week from 3:00 PM ET to 5:00 PM ET -
Povide min and max memory consumption.
Determine if all of the available memory is visible to the operating system. If it is not, determine the amount of memory which may be allocated to the... (3 Replies)
Discussion started by: Rookie_newbie
3 Replies
6. UNIX Desktop Questions & Answers
Hi All
I am new to UNIX ,can any one please help in finding MEMORY CONSUMPTION of VLC when i use it as Streaming Server.
I need to log the memory consumption for atleast 10 hours.
Can any one help me in finding this Please (1 Reply)
Discussion started by: ravikanth17
1 Replies
7. UNIX for Advanced & Expert Users
Hello,
we are using AIX 6.1
On our AIX 6.1 server there are two instance of Oracle, a Websphear, a Java application and informatica are running. Can I find out how much memory each of these are consuming?
Thanks, (1 Reply)
Discussion started by: AIX_DBA
1 Replies
8. HP-UX
Hi,
Can some one please tell me how do I generate a report of the Memory Consumption over a time period:
HP-UX B.11.31 U ia64 0440531406 unlimited-user license
I normally use glance to monitor memory in run time.
Note: I do not have root privileges.
Thanks
Danish
... (5 Replies)
Discussion started by: danish0909
5 Replies
9. HP-UX
Dear All,
I want to find out top 15 memory consumption processes in HP UX. Can anyone give me any idea about it?
Kauser (2 Replies)
Discussion started by: makauser
2 Replies
10. HP-UX
I want to obtain memory consumption history on a HPUX machine.
I know I can access data from the last week with sar
sar -f /var/adm/sa/sa14
I do not know how to get memory usage with sar.
Are there any other ways?
thank you (3 Replies)
Discussion started by: black_fender
3 Replies
LEARN ABOUT SUSE
apache::session::store::oracle
Session::Store::Oracle(3) User Contributed Perl Documentation Session::Store::Oracle(3)
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.12.1 2007-09-28 Session::Store::Oracle(3)