Re: TYT Oracle 8i Bible Question: Effect of Large_Pool_Size o...

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 14 Nov 2000 13:53:22 GMT
Message-Id: <10680.121989@fatcity.com>

Hannah,

Not quite....

>Ok, here's my question: There are a few paramters that greatly impact the
>overall size of the SGA:
>
>A: db_block_size
>B: db_block_buffers
>C: log_buffer
>D: shared_pool_size
>E: large_pool_size
>
>In order to calculate the overall size of the SGA , would you: A * (B + C +
>D + E) ?
>

C, D and E are expressed in exact size in bytes, not Oracle blocks so the calculation should be:

(A * B) + C + D + E

>what is the calculation used by SQL Plus when you use the SHOW command with
>the
>SGA clause? (BTW, I did not see that the
>SGA clause was available in 7.3.4, looks like its only supported in 8i).
>

I believe it's the above calculation that's used, but I am sure that someone here will correct me if I am wrong

show sga is available in 7.3.4 but not through SQL*Plus, only through svrmgrl -- just tried it on my 7.3.4 db. Same for 8.0 It's only with 8i that you can use sqlplus to start/stop the database so it makes sense that the command is not available in sqlplus until then.

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Tue Nov 14 2000 - 07:53:22 CST