Re: Memoryallocation in Oracle

Oracle has 2 main sections of memory, the Buffer Cache and the Shared Pool.

The Buffer Cache is specified in terms of Oracle Blocks, and is the number of Oracle Blocks that can be Cached in Oracle's Data Buffer. The parameter is db_block_buffers.

The Shared Pool is specified in terms of Bytes and is used to hold among other things, the SQL statements that have been run most recently, the Data Dictionary Cache, of the Oracle Database objects (TABLE/COLUMN/INDEX, etc.. definitions) and the Library Cache.

These are the two main parameters that make an initial impact of the database.

Initial settings for these parameters are hard to suggest without knowledge of the application, but an initial value of between 500 and 1000 block buffers and between 10,000,000 and 15,000,000 for shared pool should help. After this, you need to really tune the database, using the UTLBSTAT / UTLESTAT utility, that can be found in Oracle's tuning guide.

Hope this helps,
Andrew

Ruediger Tams wrote:

> Hi !
> We are using Remedy ARS 3.2 and have some performance
> problems with our intallation. Now we received the following advise:
>
> #
> Finally, one thing that you can do at the database level that is of
> vital
> importance is to make sure that the DB is configured to use as large a
> chunk
> of physical memory as you possibly can. The default memory configuration
> of
> most SQL database engines is almost never enough for optimum
> performance.
> Configuring more memory is probably the largest database performance
> gain
> that you can get.
> #
>
> Now my question:
> How can I configure our database (Oracle Workgroup Server 7.3.4
> on WinNT4 Server SP4) for this special way of
> "use as much memory as you want" ?
>
> Our hardware is Asus P2B-DS with Dual Intel PII 400 MHz and 1 GB RAM,
> so there is enough memory and prozessor power, I think.
>
> TFHIA ! (Thanx for hints in advance !) ;-)
>
> Regards
> Ruediger Tams
>
> KomTel GmbH
> Flensburg, Germany
> mailto:ruediger.tams_at_komtel.net
Received on Thu Apr 08 1999 - 03:12:41 CDT