Re: anothere Oracle memory question

Because I have PMON, LGWR, DBWR and such all running. These are all background processes. Remember, it's a SUMMARY of background processes I'm running. Likewise, if I had had a dozen client connections, then I'd have expected to see 888832*12 (give or take etc).

Like I said before however, I can't vouch for this scripts accuracy, but as it was provided by Oracle I have to have some faith in it. Tom's response gives more details - so if you had time on your hands, you could compare the two and see if they're near.

"Robert Yeh" <robert.yeh_at_qwest.com> wrote in message news:9gaaja$7ks$1_at_bob.news.rcn.net...
> Why do you have 64M background process total but only 30M SGA?
>
> andrew_webby at hotmail wrote in message
> <992515142.11661.0.nnrp-14.c30bdde2_at_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 Fri Jun 15 2001 - 04:56:56 CDT