Login or Register to Ask a Question and Join Our Community


Solaris

how to find exact memory used by oracle

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris how to find exact memory used by oracle
# 1  
Old 03-25-2010
how to find exact memory used by oracle
hi, I am using Solaris 10 and would like to know what;s the exact memory consumed by Oracle user id. I tried prstat -t and top but no luck. Am trying to monitor the the usage over a period of time. please could someone assist.
# 2  
Old 04-02-2010
You can use following command :

#prstat -a -s size -U ora_user
# 3  
Old 04-02-2010
Reboot - that won't work

prstat -a -s size -U oracle on a box with 64GB of memory:
Code:
           time  Sort by process execution time.
indca56d ng02cprd: [/local/banner/prod_envs/banner_prod/links]
appworx> prstat -a -s size -U oracle
   PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU PROCESS/NLWP
 29612 oracle     11G   10G sleep   59    0   0:00:43 0.0% oracle/11
 11081 oracle     11G   10G sleep   59    0   0:00:55 0.0% oracle/11
  2379 oracle     11G   10G sleep   59    0   0:00:11 0.0% oracle/11
  5925 oracle     11G   10G sleep   59    0   0:01:59 0.0% oracle/11
  5274 oracle     11G   10G sleep   59    0   3:00:10 0.0% oracle/258
 21599 oracle     11G   10G sleep   59    0   0:00:39 0.0% oracle/11
  5294 oracle     11G   10G sleep   59    0  24:38:00 0.0% oracle/23
 26662 oracle     10G   10G sleep   58    0   0:00:34 0.2% oracle/1
 26735 oracle     10G   10G sleep   59    0   0:00:42 0.0% oracle/1
 18869 oracle     10G   10G sleep   59    0   0:00:54 0.0% oracle/1
  5974 oracle     10G   10G sleep   59    0   0:00:31 0.0% oracle/1
 26002 oracle     10G   10G sleep   59    0   0:00:16 0.0% oracle/1
 26637 oracle     10G   10G sleep   59    0   0:00:32 0.0% oracle/1
 22860 oracle     10G   10G sleep   59    0   0:02:17 0.2% oracle/1
  4678 oracle     10G   10G sleep   59    0   0:00:14 0.0% oracle/1
 19121 oracle     10G   10G sleep   59    0   0:01:02 0.0% oracle/1
 18188 oracle     10G   10G sleep   59    0   0:00:11 0.0% oracle/1
  9292 oracle     10G   10G sleep   59    0   0:00:23 0.0% oracle/1
 19079 oracle     10G   10G sleep   59    0   0:00:32 0.0% oracle/1
 29669 oracle     10G   10G sleep   59    0   0:00:26 0.0% oracle/1
  6546 oracle     10G   10G sleep   59    0   0:00:47 0.0% oracle/1
 28970 oracle     10G   10G sleep   59    0   0:01:44 0.0% oracle/1
 18681 oracle     10G   10G sleep   59    0   0:01:18 0.0% oracle/1
  5366 oracle     10G   10G sleep   59    0   0:02:02 0.2% oracle/1
 29632 oracle     10G   10G sleep   59    0   0:00:33 0.0% oracle/1
  4662 oracle     10G   10G sleep   59    0   0:00:25 0.0% oracle/1
 25211 oracle     10G   10G sleep   59    0   0:01:44 0.2% oracle/1
  7754 oracle     10G   10G sleep   59    0   0:00:44 0.0% oracle/1
 28116 oracle     10G   10G sleep   59    0   0:01:48 0.0% oracle/1
 13614 oracle     10G   10G sleep   59    0   0:01:06 0.0% oracle/1
 NPROC USERNAME  SIZE   RSS MEMORY      TIME  CPU
   349 oracle   3359G 3345G   100%  59:46:48 3.8%

The memory reported is HUGE. This is because oracle uses large hunks of shared memory - e.g., SGA. So the same memory get reported over & over & over. A 64GB machine does not usually have 3.5TB of virtual memory, much less RAM. At least this one does not. It's a v440.
# 4  
Old 04-03-2010
This has been corrected more than 3 years ago. Use a correctly patched system.

Bug ID: 4754856 *prstat* prstat -atJTZ should count shared segments only once
# 5  
Old 04-06-2010
It's a hosted box. Cannot do that. Every v9 box at the host site has that problem.
# 6  
Old 04-07-2010
Then ask your hosting provider to install kernel patch 120011-14.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep to find an exact string

Hi all, I tried searching the forum for this, and I read numerous suggestions here and even on other forums, and I cannot get this to want the way that I need it to. I tried grep -W / -f to no luck. Here is what I have. I have a list of file names- FILE1-FILE1TEST,FILE1RELATION... (7 Replies)
Discussion started by: jeffs42885
7 Replies

2. Shell Programming and Scripting

To find the exact pattern

My Input : Hi editor this is the exact pattern which we looking for the previous patternmatch My code: awk '/pattern/ { print a } { a = $0 }' Current output : exact previous (3 Replies)
Discussion started by: Roozo
3 Replies

3. AIX

How can I calculate exact memory used on AIX system?

I already checked memory on AIX with "svmon -G" and vmstat (as the figure). I see the value "inuse" nearly=97% use memory, free=3%. However, the value "pin=cache" nearly=26%. Can I calculate total free memory= free+ pin = 29% ? please help me! Thanks so much! (5 Replies)
Discussion started by: xuanthanhnk
5 Replies

4. Shell Programming and Scripting

QUESTION1: grep only exact string. QUESTION2: find and replace only exact value with sed

QUESTION1: How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed. Contents of car.txt CAR1_KEY0 CAR1_KEY1 CAR2_KEY0 CAR2_KEY1 CAR1_KEY10 CURRENT COMMAND LINE: WHERE VARIABLE CAR_NUMBER=1 AND KEY_NUMBER=1 grep... (1 Reply)
Discussion started by: thibodc
1 Replies

5. Shell Programming and Scripting

what is the find command to find exact dir from the root

I want to find a dir called STOP from the root.so what is the find command. Thanks & Regards Rajkumar (1 Reply)
Discussion started by: rajkumar_g
1 Replies

6. Solaris

How to find Total and Free Physical Memory and Logical Memory in SOLARIS 9

Hi, Im working on Solaris 9 on SPARC-32 bit running on an Ultra-80, and I have to find out the following:- 1. Total Physical Memory in the system(total RAM). 2. Available Physical Memory(i.e. RAM Usage) 3. Total (Logical) Memory in the system 4. Available (Logical) Memory. I know... (4 Replies)
Discussion started by: 0ktalmagik
4 Replies

7. Shell Programming and Scripting

Find Exact word in file

Hi ALL, I want to search one string “20 “ i.e 20 with space. But my file where I am searching this “20 “ contain some data like 120 before image file truncated 220 Reports section succeeded 20 Transaction database .prd stopped 220 Reports section completed. When I search for the... (5 Replies)
Discussion started by: Jeevan Salunke
5 Replies

8. UNIX for Dummies Questions & Answers

Find exact string

Hi Guys, File is containing data Col1 Col2 ListPrice List Price Price Average Selling Price - Actual ProjPrice Average Selling Price ProjPrice Launch Price ProjCost Cost Now i need to print col2 on the basis of col1 i.e if i Pass Price it should display only "Average... (7 Replies)
Discussion started by: Swapna173
7 Replies

9. Solaris

Find an exact string

Hii,., Can some one guide me ...how to find a exact word or string using "grep" not a part of some other string. say if i need 321 it should not give me 3210 nor 1321 it should only give me line containing string 321 Thanks and Regards, Joy (2 Replies)
Discussion started by: gr8pals
2 Replies

10. Shell Programming and Scripting

how to find the exact pattern from a file?

Hi Let say there is a file a.txt which contain number rows. My intention is to find the number of occurences of a pattern. Let say the pattern is mdbase. then it should not count the occurences of mdbase1 or mdbase2 like this. When I tried to find it like grep "/backup/surjya/mdbase"... (7 Replies)
Discussion started by: surjyap
7 Replies
Login or Register to Ask a Question