Hi all,
We had gotten some extra memory for our production server and I was trying
to increase our buffer cache again (I was leery of doing it all at once so I
just doubled it the first time). I got a
ORA-27123: unable to attach to shared memory segment
with my first try (it worked after I reduced the buffer cache a bit) and I'm
trying to figure out why.
Total memory on the machine is 4Gig.
shmmax=2048000000 (2000M)
4K Block size
I was able to start the database with a db_block_buffers of 350000 but not
of 400000.
Current SGA:
NAME VALUE
-------------------- ----------
Fixed Size 47296
Variable Size 248659968
Database Buffers 1433600000
Redo Buffers 1040384
This gives a total of 1605M which should leave 295M still available. An
extra 50000 blocks is only 195M. Is there something other than the total in
v$sga that counts towards the shmmax? I can't find anything in my Oracle8 &
Unix Performance Tuning book.
Thanks for any guidance!
Jay Miller
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
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).