Sponsored Content
Operating Systems Solaris Find memory usage for a process Post 303001782 by yashreads on Friday 11th of August 2017 05:45:10 AM
Old 08-11-2017
Running ipcs -m gave me
Code:
oraent@DBSRV1 $
oraent@DBSRV1 $ ipcs -m
IPC status from <running system> as of Friday, August 11, 2017 03:07:22 PM IST
T         ID      KEY        MODE        OWNER    GROUP
Shared Memory:
m         15   0x3f81fc70 --rw-r-----   oraent oinstall
m         14   0x0        --rw-r-----   oraent oinstall
m         13   0x0        --rw-r-----   oraent oinstall
m          7   0xeb0a8b74 --rw-r-----   oraent oinstall
m          6   0x0        --rw-r-----   oraent oinstall
m          5   0x0        --rw-r-----   oraent oinstall
m          3   0xf6b11ac0 --rw-r-----   oraent oinstall
m          2   0x0        --rw-r-----   oraent oinstall
m          1   0x0        --rw-r-----   oraent oinstall
You have new mail in /var/mail/oraent
oraent@DBSRV1 $
oraent@DBSRV1 $

The oracle database allocates memory equivalent to the SGA parameter.
Thsi is needed to only start the database and to keep it running.
But as new user connect to the database and perform theis tasks. Each user has its own process on the server. This process consumes memory.

So, such connections per database differs.
In my case i have three database opn the server.
Out of the three, one database consumes apporx 80% of the CPU and memory. This is just an estimate depending on the number of connections see at the database level.
Thats why i need to find the memory usage per database.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to restrict memory usage by a process

we are running red hat ES4 and i would like to know if there is anyway of restrcting the maximum amount of memory that a process can get? I have a single preocess that is taking >13GB. Thanks, Frank (4 Replies)
Discussion started by: frankkahle
4 Replies

2. Solaris

RAM Physical Memory usage by each Process.

Hi All, I am trying to find the physical memory usage by each process/users. Can you please let me know how to get the memory usage?. Thanks, bsraj. (12 Replies)
Discussion started by: bsrajirs
12 Replies

3. Shell Programming and Scripting

Memory usage of a process

hi all, i want to write a script that checks the memory usage of processes and send a mail with the name of the process witch is using more then 300mb RAM. dose anybody have a sample script or an idea how i can make it ? PROCCESSES="snmpd sendmail" for myVar in $PROCCESSES do ... (7 Replies)
Discussion started by: tafil
7 Replies

4. HP-UX

how can I find cpu usage memory usage swap usage and logical volume usage

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

5. HP-UX

how could I get a process Memory Usage

I use pstat API to get Process Infomation I would like to get a process 1.process owner 2.how many physical memory and virtual memory and total memory used(KB) and usage(%) 3.a process excution file create time 4.a process excution file access time I do't know which attribute it i need ... (3 Replies)
Discussion started by: alert0919
3 Replies

6. UNIX for Advanced & Expert Users

How to find out memory & cpu usage of a process

Hi, By using time command we can determine the execution time of a process or command. bash-2.04$ time ls -l total 0 -rw-r--r-- 1 admin tac 0 Oct 6 04:46 file1 -rw-r--r-- 1 admin tac 0 Oct 6 04:46 file2 real 0m0.002s user 0m0.000s sys 0m0.001s... (5 Replies)
Discussion started by: learn more
5 Replies

7. UNIX for Advanced & Expert Users

collecting memory usage by a process

Hi Guys, I work on a AIX environment and I'm trying to write a script where I can collect all the memory used by a process. Basically I'm executing the command 'ps -fu userid' to get all the process ids and then executing the 'ps v PID' to get all the memory allocated by PPID. My question is... (2 Replies)
Discussion started by: arizah
2 Replies

8. HP-UX

Virtual Memory Usage a Process

Hi all, Is there any command which shows the virtual memory usage of a particular process in HP-UX machine. I have tried with ps, top but could not get what I want. Kindly provide me a solution. Thanks in Advance ARD (4 Replies)
Discussion started by: ard
4 Replies

9. Solaris

Process memory usage

hi all gurus: I want to find out Solaris process memory usage, but got a bit confused, see if any one can provide me some guidance. i tend to use prstat -a to get total memory consumption by user (I know prstat likely have a bug that simply sum up the memory, regardless if the memory being... (5 Replies)
Discussion started by: oakville
5 Replies

10. UNIX for Beginners Questions & Answers

How can I check actual memory usage each Process?

I can't check actual memory usage in the Redhat 5.5... The used memory is 14214 Mb of Total 15919 by Free -m command. I sum the RSS value on PS aux command result and the value is 5428.66Mb. Yes It's quite different actual usage memory and RSS value. So I added Shared memory value... (5 Replies)
Discussion started by: tom8254
5 Replies
Jifty::Handle(3pm)					User Contributed Perl Documentation					Jifty::Handle(3pm)

NAME
Jifty::Handle -- A database handle class for Jifty DESCRIPTION
A wrapper around Jifty::DBI::Handle which is aware of versions in the database METHODS
new PARAMHASH This class method instantiates a new Jifty::Handle object. This object deals with database handles for the system. After it is created, it will be a subclass of Jifty::DBI::Handle. canonical_database_name Returns the canonical name of the application's database (the actual name that will be given to the database driver). This name is a lower-case version of the "Database" argument in the "Database" section of the framework config. For SQLite databases (where the database name is actually a filename), this also converts a relative path into an absolute path based at the application root. connect ARGS Like Jifty::DBI's connect method but pulls the name of the database from the current Jifty::Config. check_schema_version [pretend => 0|1] Make sure that we have a recent enough database schema. If we don't, then error out. If "pretend =" 1> is passed, then any auto-upgrade action this might take is dry-run only. create_database MODE "MODE" is either "print" or "execute". This method either prints the commands necessary to create the database or actually creates it, depending on the value of MODE. Returns undef on failure. drop_database MODE "MODE" is either "print" or "execute". This method either prints the commands necessary to drop the database or actually drops it, depending on the value of MODE. Returns undef on failure. AUTHOR
Various folks at BestPractical Solutions, LLC. perl v5.14.2 2011-01-24 Jifty::Handle(3pm)
All times are GMT -4. The time now is 01:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy