09-01-2012
It is obvious that Oracle takes most of the memory available. When Oracle starts the DB it takes a configurable amount of memory, the SGA (system global area). It does its own sort-of file caching in there (DB block buffers, ...) as well as memory-intensive operations (indexing, ....). The SGA is so-called "pinned memory", that means it is not swapped out under any circumstance.
Apart from that Oracle has separate processes by which it communicates with the outside world: the "listeners". In your "top" output these are the processes with "(LOCAL=NO)" at the end. Every listener needs some memory too and this might add up to something. How many instances of a listener process are started depends on the load on the database (if there are less DB connections there will be less listener processes), but is also configurable somewhere in the DB startup files.
I have only some cursory knowledge about these things (I am a Sysadmin, not a DBA, after all), but your DBA can probably off the top of his head explain these things in detail to you. I suggest you set together with him/her and discuss these issues.
I hope this helps.
bakunin
/P.S.: Now that Jim mentions it, i believe he is right: the heap looks definitely fragmented and, yes, this can cause problems.
10 More Discussions You Might Find Interesting
1. Linux
Hi All,
Kindly help me in optimizing the server as it displays a great amount of CPU & MEM being utilised when the mysql process executes.
Below are the stats ---
--------------------------------------------------------------------------
# top
15:51:57 up 23:22, 5 users, load average:... (1 Reply)
Discussion started by: gautamatul82
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I want to check the CPU and Memory Utilisation in the whole machine (not for a single process). Can someone send me a ready made script which captures all information in a log every 5min??
Thanks,
Ajith (0 Replies)
Discussion started by: Ajith Praveen
0 Replies
3. Red Hat
We have a VM running RedHat that seems to have very high system (kernel) utilisation compared to our physical servers running the same OS and workload that show normal system time utilisation.
Any ideas?
Thanks in advance. (2 Replies)
Discussion started by: azurty
2 Replies
4. Shell Programming and Scripting
Hi all,
I am a newbie to whole shell scripting thing. I deal with computational studies and a lot of softwares which run on linux. At times, I have to schedule my jobs after some process has started. In these case, I have to use at command to schedule my job.
However, I would like to know if... (0 Replies)
Discussion started by: johnsmithgr8
0 Replies
5. IP Networking
hi,
we have one unix server which sends multicast packets in the network, recently we have implemented firewall in between unix server and clients.After implementing firewall we found our lease line utilisation has been increased dramatically.
Is this because of firewall or else...please... (2 Replies)
Discussion started by: ajaysahoo
2 Replies
6. AIX
Hi,
We need to monitor one process over time to see at which exact point it starts to consume to much memory and CPU (to correlate this with some other events).
I am a newbie in AIX, so please could you tell me which command will give a snapshot of the current state of a process so that I... (1 Reply)
Discussion started by: yallow
1 Replies
7. Red Hat
Hi All,
I have a RHEL 5.4 server which runs an Apache web server(2.2.23 compiled with prefork MPM).I want to find out the memory utilised by the web server.
# ps -ylC httpd | wc -l
245
# ps -ylC httpd | more
S UID PID PPID C PRI NI RSS SZ WCHAN TTY TIME CMD
S ... (0 Replies)
Discussion started by: Hari_Ganesh
0 Replies
8. Red Hat
Hello All,
We have a jave server running on both linux and Solaris environments.
On solaris,it consumes only 600-700MB whereas it goes upto 21G in Linux.
I am monitoring the memory consumption through top command.
Is this high memory consumption expected in Linux? (1 Reply)
Discussion started by: prasperl
1 Replies
9. Shell Programming and Scripting
Hi,
I need to find the memory utilisation of a server as mentioned below. Memory should be divided into TOTAL, UZDM, BUFFER, CACHE, AVAILABLE. Can anyone help me to get this? (10 Replies)
Discussion started by: Arasu
10 Replies
10. Red Hat
Hi ,
There is one following alert .
Message : cdm:Average (2 samples) swap memory usage is now 91%, which is above the warning threshold (90%)
Here is my findings.
Output of TOP command in Linux server.
top - 14:21:44 up 6 days, 4:48, 1 user, load average: 2.55, 2.06,... (3 Replies)
Discussion started by: Maddy123
3 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)