Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

processes statistics doubt

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users processes statistics doubt
# 1  
Old 12-24-2007
processes statistics doubt
The following is the o/p I got when i run
prstat -t
command on SunOs5.8

NPROC USERNAME SIZE RSS MEMORY TIME CPU
2 shah 3152K 2384K 0.0% 0:00.00 0.0%
8 oracle 14G 13G 100% 5:09.04 0.0%
35 root 88M 54M 0.4% 0:54.27 0.0%
1 bb 1736K 1048K 0.0% 0:00.03 0.0%
1 daemon 2680K 1880K 0.0% 0:00.00 0.0%

I am just wondering why oracle user consumed 100% of memory! is it something like totally memory has been occupied by oracle user?
Please clarify this.

Thanks.
# 2  
Old 12-27-2007
Oracle processes usually allocate a chunk of memory when they startup. So it might be possible that 100% of your memory is being used by oracle processes. It might not be noticable (or it just might be), but I suggest not setting up any more oracle instances. If you are going to, then you need to add memory to your system.
# 3  
Old 12-28-2007
Hi,

Thanks for you suggestion. But in production box oracle processes utilization of memory is just 17% ! what could be the cause of this consumption in my development box? Is it possible to segregate oracle unix users processes and find out which process under oracle user consuming more memory?

Thanks.
# 4  
Old 01-02-2008
Sorry for the delayed reply, I haven't logged in for a few days. The memory use on production box is fine, but are you sure that the two systems are exact copies of each other (same amount of memory, cpu, etc)? Are the same number of database instances running on the two boxes?

You cannot compare the two systems unless everything matches.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Text statistics

Hello every body if I want to get the following statistics from a text file 1- sorted the n frequent words 2- sorted the n frequent characters 3- sorted the n frequent diagrams (tow letter together like th OR he) 4- sorted frequent n trigrams like (the OR all etc. ) 5- any character... (10 Replies)
Discussion started by: khaled79
10 Replies

2. UNIX for Dummies Questions & Answers

Any way to get process statistics?

Hi, Can someone advise what "generic" command can I use to show statistics of a process or a running script/process? For example, I want to know how many hours/minutes it's taken to run or has been running, how much CPU it used and how much memory it used or uses. I want to be able to... (2 Replies)
Discussion started by: newbie_01
2 Replies

3. Shell Programming and Scripting

statistics using awk

Hi, I have 3 columns in a file listed below. X Y X/(X+Y) 1 1 0.5 1 1 0.5 4 1 0.8 1 1 0.5 6 1 0.857142857 1 1 0.5 23 1 0.958333333 Now I want to find confidence interval using the formula for each row. (p-2 sqrt p(1-p)/(x+y), p+2... (7 Replies)
Discussion started by: Diya123
7 Replies

4. Solaris

Identifying and grouping OS processes and APP processes

Hi Is there an easy way to identify and group currently running processes into OS processes and APP processes. Not all applications are installed as packages. Any free tools or scripts to do this? Many thanks. (2 Replies)
Discussion started by: wilsonee
2 Replies

5. UNIX for Advanced & Expert Users

Monitoring Processes - Killing hung processes

Is there a way to monitor certain processes and if they hang too long to kill them, but certain scripts which are expected to take a long time to let them go? Thank you Richard (4 Replies)
Discussion started by: ukndoit
4 Replies

6. UNIX for Advanced & Expert Users

Getting Socket statistics

Is there any way to get the file descriptor statistics of a socket file descriptor? I know that the fstat, stat system calls are for this purpose, but I want to know it there any way to get socket connection statistics for a file descriptor(like socket flags, connection type etc). Does /proc... (3 Replies)
Discussion started by: comp_wizard07
3 Replies

7. Shell Programming and Scripting

Doubt about multiple processes

Suppose that I am performing some operation on an sql database. Lets say process of Searching and then if a value is found, updating it... Now, when I have some millions of records on which the operation has to be performed... Does it help to spawn multiple processes each executing the same... (9 Replies)
Discussion started by: Legend986
9 Replies

8. Programming

Server Statistics ?

I'm trying to write a C program to view server statistics such as: - server general information - CPU usage - memory usage - running processes Cany anybody gives me hints on those system calls ?? ps: I'm using Tru64 unix (6 Replies)
Discussion started by: Agent007
6 Replies

9. Programming

system statistics

i am currently using c functions such as getprocs and statsfs to obtain process information and filesystem information on machines running aix 4.3.3.0. (soon to be running aix5.1) is there a function available to access information similar to the information provided by a vmstat command? i also... (1 Reply)
Discussion started by: briansmith40
1 Replies
Login or Register to Ask a Question