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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, Long
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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 email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lord David
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, Long
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
