Re: Components of Logical database

hafeez_splendid_at_yahoo.co.in wrote:

> Can anyone list all the parameters of Logical part of database which
> are to be consider while creating a database for getting better
> performance.
>
> I got to know some of them,such as,
>
> 1.Connection Pool size
> 2.Index Pool size
> 3.Connection threads etc.,
>
> I dont have much idea about this. Please throw some light over this .

Well, I would hate to spoonfeed you and deny you the joys of gaining some real insight and knowledge by reading the Oracle Concepts and Oracle Performance Tuning guides.. so I won't.

Here are the URLs to these manuals:

OracleŽ Database Concepts
10g Release 1 (10.1)
Part Number B10743-01
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/toc.htm

OracleŽ Database Performance Tuning Guide 10g Release 1 (10.1)
Part Number B10752-01
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/toc.htm

--
Billy