Visit Our UNIX and Linux User Community


Oracle how many memory allocate really


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Oracle how many memory allocate really
# 1  
Old 08-06-2010
Oracle how many memory allocate really

hi... i want to find oracle allocate how many memory really..

i execute this code to list memory on unix system :
Code:
    ps -eo pmem,args | sort -k 1 -r -n

outputs ;

%mem command
12.9|ora_smon_RTX
12.9|ora_s000_RTX
12.9|ora_reco_RTX
12.9|ora_qmnc_RTX
12.9|ora_q002_RTX
12.9|ora_q000_RTX
12.9|ora_psp0_RTX
12.9|ora_pmon_RTX
12.9|ora_mmon_RTX
12.9|ora_mmnl_RTX
12.9|ora_mman_RTX
12.9|ora_lgwr_RTX
12.9|ora_dbw1_RTX
12.9|ora_dbw0_RTX
12.9|ora_d000_RTX
12.9|ora_ckpt_RTX
12.9|ora_cjq0_RTX
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|ora_smon_BSPR
6.5|ora_reco_BSPR
6.5|ora_qmnc_BSPR
6.5|ora_q001_BSPR
6.5|ora_q000_BSPR
6.5|ora_psp0_BSPR
6.5|ora_pmon_BSPR
6.5|ora_mmon_BSPR
6.5|ora_mmnl_BSPR
6.5|ora_mman_BSPR
6.5|ora_lgwr_BSPR
6.5|ora_dbw1_BSPR
6.5|ora_dbw0_BSPR
6.5|ora_ckpt_BSPR
6.5|ora_cjq0_BSPR

if i will sum all used memory ,it is greather then total memory of system...

i want to find real used memory for oracle ?
# 2  
Old 08-06-2010
The column of ps you're interested in is RSS, or "resident set size". This measures only pages that actually exist and are paged in.
# 3  
Old 08-07-2010
Let's tie this down a bit.

What Operating System and version do you have?
What version of Oracle are you using?

Because Oracle makes extensive use of Shared Memory segments and most modern versions of unix use paged memory it is remarkably difficult to find out how much memory Oracle is using. The Oracle installation manuals are very good on the subject of configuring unix and Oracle for a given memory size. It is very important to know your Oracle Database Block Size because many Oracle startup parameters are in units of Blocks.

You can find out a lot from Oracle itself.

For example to find out about the System Global Area with sqlplus:
Code:
select *  from v$sgastat;


Previous Thread | Next Thread
Test Your Knowledge in Computers #370
Difficulty: Medium
Bytecode instructions are processed by hardware and so they may be arbitrarily complex.
True or False?

10 More Discussions You Might Find Interesting

1. Programming

calloc fails: 'Cannot allocate memory'

Hi , experts. I work on Linux station (RedHat 5.7), regular user, but have root password. %> uname -a Linux ran1log06 2.6.18-238.1.1.el5 #1 SMP Tue Jan 4 13:32:19 EST 2011 x86_64 x86_64 x86_64 GNU/Linux %> cat /etc/issue Red Hat Enterprise Linux Client release 5.7 (Tikanga) Kernel \r on... (5 Replies)
Discussion started by: baruchgu
5 Replies

2. Solaris

unable to allocate enough memory

On SunOS 10 get an error when starting a large Java process with over 2Gb memory. Error occurred during initialization of VM Could not reserve enough space for object heap i have 32G memory !! , swap = 31G Please any advice !!! (3 Replies)
Discussion started by: moata_u
3 Replies

3. Programming

How to allocate memory to a string in C?

hi I want to take string as a input from user and the string is very very length. From the lengthy string i have to substring take first 16 letters, then next 8 letters,................... Please guide me how to write program to take lengthy string from user and sub string it. Thanks (4 Replies)
Discussion started by: atharalikhan
4 Replies

4. Linux

shmget failed - cannot allocate memory

Hi, In my proj, one process was running for 2 days. after 2 days its throwing an error message "shmget failed cannot allocate memory". the same problem happened every time.i.e. i can reproduce the same issue if my process is running for every 2 days for a same operation.Within this 2 days there... (1 Reply)
Discussion started by: ManoharanMani
1 Replies

5. Linux

shmget failed - cannot allocate memory

Hi, In my proj, one process was running for 2 days. after 2 days its throwing an error message "shmget failed cannot allocate memory". the same problem happened every time.i.e. i can reproduce the same issue if my process is running for every 2 days for a same operation.Within this 2 days there... (1 Reply)
Discussion started by: ManoharanMani
1 Replies

6. SuSE

shmget failed - cannot allocate memory

Hi, In my proj, one process was running for 2 days. after 2 days its throwing an error message "shmget failed cannot allocate memory". the same problem happened every time.i.e. i can reproduce the same issue if my process is running for every 2 days for a same operation.Within this 2 days there... (1 Reply)
Discussion started by: ManoharanMani
1 Replies

7. UNIX for Advanced & Expert Users

How to allocate memory

Hi, I have 2 systems with same hardware and software. One system is giving me error "Error occurred during initialization of VM Could not reserve enough space for object " when I tried to increase JBoss App's heap size to 2GB while the other system is running fine without any issue. Is there... (5 Replies)
Discussion started by: ravi3553
5 Replies

8. UNIX for Advanced & Expert Users

unable to allocate enough memory

On SunOS 5.8 I get an error when starting a large Java process with over 2Gb memory. Error occurred during initialization of VM Could not reserve enough space for object heap When stopping several other Java processes we can start this process. This seems to indicate that we don't have... (11 Replies)
Discussion started by: rein
11 Replies

9. Programming

how allocate virtual memory

Hi Folks can any body suggest how to allocate virtual memory any function for that (2 Replies)
Discussion started by: munnu
2 Replies

10. UNIX for Dummies Questions & Answers

Unix Help - allocate more memory to /tmp

Hi Guys I using Solaris 8 and I need to change the size of my /tmp file. Was wondering does anyone know how to do this. Thanks Carson (1 Reply)
Discussion started by: cmackin
1 Replies

Featured Tech Videos