Home » RDBMS Server » Server Administration » Oracle9i: DB_CACHE_SIZE [Newbie ?]
Oracle9i: DB_CACHE_SIZE [Newbie ?] [message #49848] Wed, 13 February 2002 09:45 Go to next message
Stephen Jones
Messages: 3
Registered: February 2002
Junior Member
? about DB_CACHE_SIZE, DB_2K_CACHE_SIZE, DB_4K_CACHE_SIZE, . . .as I configure my database SGA.

Do I need to size my DB_CACHE_SIZE with the understanding that my DB_nK_CACHE_SIZE(s), are part of the sum set in the INIT.ORA?

Or are they separate--e.g., SGA = DB_CACHE_SIZE, DB_CACHE_nK_SIZE, SHARED_POOL_SIZE, LOG_BUFFER, and LARGE_POOL_SIZE.

Stupid question, I know, but getting confused.

--Stephen

Report message to a moderator

Re: Oracle9i: DB_CACHE_SIZE [Newbie ?] [message #49849 is a reply to message #49848] Wed, 13 February 2002 09:51 Go to previous message
Stephen Jones
Messages: 3
Registered: February 2002
Junior Member
Addendum: If I also configure DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE, I am assuming I will also need to add these sizes to my SGA formula mentioned previously as well. Right?

Report message to a moderator

Previous Topic: Extremely Large Databases - Indexes?
Next Topic: Re: CAN U PLZ TELL ME FULL FORM OF ORACLE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 11:23:57 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.