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
nntp-pull
NNTP-PULL(1) nntp-pull manual NNTP-PULL(1)
NAME
nntp-pull - fetch articles from the server to the mbox
SYNOPSIS
nntp-pull [options...] groupname [groupname...]
DESCRIPTION
Fetch messages from the server and save them into the mailbox (mbox format). Every argument is supposed to be a name of group, optionally
followed by a '>' character and mbox filename. If the mbox filename is omitted, it defaults to the name of the group.
Besides global options (described in sinntp(1)), nntp-pull command takes following options:
--limit=N
Pull at most N messages.
--reget
Start from the first available message.
EXAMPLES
nntp-pull --server=news.example.org --limit=50 'comp.os.linux>os-linux' Fetches at most the 50 newest articles from the newsgroup
comp.os.linux located on news.example.org server and appends them to the os-linux mailbox file.
nntp-pull --server=news.example.net --reget --limit=3 comp.os.windows Fetches at most the 3 oldest articles from the newsgroup
comp.os.windows located on news.example.net server and appends them to the comp.os.windows mailbox file.
SEE ALSO
sinntp(1)
COPYRIGHT
Copyright (C) 2009, 2010, 2011 Piotr Lewandowski, Jakub Wilk
nntp-pull 1.5 2012-04-18 NNTP-PULL(1)