Re: anothere Oracle memory question

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 14 Jun 2001 11:40:33 +0100
Message-ID: <992515142.11661.0.nnrp-14.c30bdde2@news.demon.co.uk>

Out of interest, I should mention you need to have an ORACLE_SID set, and doing summem.sh S without any client connections will get you nothing.

Here's a wee figure on Solaris8/Intel, 8.1.6 for one client connection. $ summem.sh S

Total Shadow (bytes) : 888832 (so not even a meg then)

Grand Total (bytes) : 888832

$ summem.sh B

Total Private (bytes) : 5951488
Total Shared (bytes) : 58863616

Grand Total (bytes) : 64815104

SQL> show sga

Total System Global Area 30,17,5216 bytes

Fixed Size                    69,616 bytes
Variable Size              21,835,776 bytes
Database Buffers            8,192,000 bytes
Redo Buffers                  77,824 bytes

"Robert Yeh" <robert.yeh_at_qwest.com> wrote in message news:9g8e0c$cl0$1_at_bob.news.rcn.net...
> I am trying to calculate the client connection memory using pmap. The
total
> is 31272K bytes. I guess I need to deduct the shared memory (line 4,
> 12747K). Does it man this client is using 18465K (31272K-12744K) memory?
> That is a lot of memory for one client. How about line 1 and 2(16264K and
> 128K)? Are they considered shared memory also?
<snip> Received on Thu Jun 14 2001 - 05:40:33 CDT