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 SUNOS
delete-http-listener
asadmin-delete-http-listener(1AS) User Commands asadmin-delete-http-listener(1AS)
NAME
asadmin-delete-http-listener, delete-http-listener - removes the HTTP listener
SYNOPSIS
delete-http-listener --user admin_user[--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
[--terse=false] [--echo=false] [--interactive=true] httplistener_ID
Removes the HTTP listeners. This command is supported in remote mode only.
OPTIONS
--user authorized domain application server administrative username.
--password password to administer the domain application server.
--host machine name where the domain application server is running.
--port port number of the domain application server listening for administration requests.
--secure if true, uses SSL/TLS to communicate with the domain application server.
--passwordfile file containing the domain application server password.
--terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
formatted data for consumption by a script. Default is false.
--echo setting to true will echo the command line statement on the standard output. Default is false.
--interactive if set to true (default), only the required password options are prompted.
OPERANDS
listener_id listener ID of the HTTP listener.
Example 1: Using delete-http-listener
asadmin> delete-http-listener --user admin1
--password adminadmin1 --host pigeon --port 5001 sampleListener
Deleted http listener with id = sampleListener
Where: sampleListener is the HTTP listener deleted.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-create-http-listener(1AS), asadmin-list-http-listeners(1AS)
J2EE 1.4 SDK March 2004 asadmin-delete-http-listener(1AS)