Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shared Memory and Semaphores
On Apr 10, 10:17 am, sybra..._at_hccnet.nl wrote:
> On 9 Apr 2007 22:03:55 -0700, "peter" <hhh.datab..._at_gmail.com> wrote:
>
> >I have doubt in both of these.
> >Don't you think oracle is taking to much shared memory and semaphores
> >are on these server.
> >It's a test server, there so many databases are here on it.
> >Please provide any link, which can help me to find that how much
> >shared memory and semaphores are good for current databases.
>
> How about reading the friggin manual?
> You know, that book you consistently refuse to read!
> The #1 reason why you are asking RTFM questions for more than a year
> now!
> There is a formula for the # of semaphores, and IIRC, it is in the
> documentation.
> Obviously, you also shouldn't allocate all available physical RAM to
> SGA.
> But you are so lazy, you don't specify the amount of physical RAM, and
> you leave it to this group, to calculate the total amount of SGA you
> have allocated. You don't even feed the results of the ipcs command
> through awk to do this yourself. Probably because you don't know Unix
> and don't want to read about it either.
> Aren't you getting ashamed of yourself?
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Total RAM is 16G with 2 processes. It is Sun Solaris. Database is
9.2.0.3
It has 25 different-2 databases.
Please tell me any manual which can tell how much semaphore or shared
memory can be acceptable for any particular reason.
Received on Tue Apr 10 2007 - 00:30:54 CDT