I have multiple oracle databases on one server. All the database are running from the same user i.e. oraent.
The process for each database can be distinguished by the ps -ef command
Eg :
The Output :
I need to find the total memory usage for each database at a given time.
I tried prstat, but there was no column which could differentiate the process per database.
Hope i was able to convey my requirement.
Any help will be welcome.
Thanks in advance..
---------- Post updated at 09:06 PM ---------- Previous update was at 09:05 PM ----------
The Operating System is SOLARIS 11
Last edited by MadeInGermany; 08-09-2017 at 02:52 PM..
Reason: Added code tags
In prstat the SIZE and RSS columns tell you how much memory a process consumes.
SIZE is wrongly described as SWAP in the man pages, but it's about the same: virtual memory including reservations.
"resident" means: resident in RAM.
The above two columns will definitely give the said information..
But i want this information for many processess.
I have in total 13000 processess.
One of the database having 8000 processess
Second having 4500 processess
And third having 500 processess.
I need the total memory used for each databases..
i.e. total of 8000 processess for database 1.
Total of 4500 processess for database 2.
Total of 500 processess for database 3.
You can use ps with the o option to get VSZ (~SIZE) and RSS per process.
Then pipe it to awk for summing up each in an array that is indexed by arg1.
At the END print the indices and their rss and vsz sums.
It' s easy to extend. For example, add the number of processes
Last edited by MadeInGermany; 08-10-2017 at 12:29 PM..
Reason: #procs
will give the usage for the user oraent.
In my case all the database are runing from the same user i.e. oraent.
will not help in my case.
i will need to perform
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)