| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: A Solaris question on memory usage
Thanks David. You are right, I did not notice that the private figure actually included the SGA size as well.
Regards
Long
-----Original Message-----
Sent: Thursday, 8 February 2001 7:55 PM
To: Multiple recipients of list ORACLE-L
Long
pmap seems to include portions of the SGA in the Private and Resident columns, not the Shared one. On solaris, this shows up as a line with (shmid=0x...) in the Mapped File column. To get a more sensible memory usage, I suppose that you would have to subtract these from total (the size is different for background and user processes ) and then add the size of the SGA once.
Regards
David Lord
-----Original Message-----
Sent: 08 February 2001 04:35
To: Multiple recipients of list ORACLE-L
Good day,
I am looking at how Oracle and other applications running on a Solaris 2.6 server are using memory. The server has 512 MB of RAM. I issued the "/usr/proc/bin/pmap $pid" command to display memory usage info and used the figure from the "total KB" line of the output (the last line of the output). When I add up the figures for all Oracle processes the sum of the Private areas for all Oracle processes on teh system is 1.5 GB. I do not understand this. How can this be greater than the physical RAM amount (which is 512 MB)? As I understand the Private amount is the Resident amount less the Shared amount, so the Private amount for a process would be the physical memory amount used exclusive by the process and not shared with other processes.
If you could help me to understand more about this stuff, very much appreciate.
I am trying to see if we need to up the RAM on the system.
Thanks
Long
-----Original Message-----
Sent: Thursday, 21 December 2000 3:13 AM
To: Multiple recipients of list ORACLE-L
In a query I found the total no of blocks used ,total size ,minextents,maxextents ,empty blocks of a table.
But In index i am unable to find free / Empty blocks .
but i find leaf blovks ,avg no. of leaf blocks .
Please tell me how can I found free or empty blocks of a Index.
Regards,
Saroj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj (CAP,CEF)
INET: Saroj.Dash_at_gecapital.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 13 2001 - 21:10:32 CST
 |
 |