Re: How could I specified the memory for Oracle 8i database
From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Fri, 27 Apr 2001 06:59:42 GMT
Message-ID: <3AE919AF.39B2EE3C_at_telusplanet.net>
Date: Fri, 27 Apr 2001 06:59:42 GMT
Message-ID: <3AE919AF.39B2EE3C_at_telusplanet.net>
Suggest you get a good book on Oracle Tuning - Oracle Press Tuning Tips & Techniques, for example. The memory allocation is mainly defined by the SGA (and related) and that depends a lot on ypur init.ora parameters,
Yes, there is an algorith to calc that value - BUT it's controlled mainly by init.ora and it's very well explained in that book
TJ wrote:
> In Oracle 8i, there is an algorithm to calculate the resources (memory) for
> any oracle instances. How could I configure so that I could control the
> amoung of memory used for any instance? Is the spool size only parameter?
> Thanks.
Received on Fri Apr 27 2001 - 08:59:42 CEST