No db_cache_size is the actual value of you database buffer , it is not
calculated by multiplying the db_block_size value,also do not set any value
for parameter db_block_buffers

-----Original Message-----
From: Kulkarni Deepak
[mailto:oracledba-ezmlmshield-x3025592.[Email address protected]
Sent: Monday, July 31, 2006 9:44 AM
To: LazyDBA Discussion
Subject: db_cache_size , db_block_buffers & db_block_size


We have upgraded a database from 8.1.7 to 9.2.

We still have following parameter set for db cache.

db_block_buffers integer 39321
db_block_checking boolean FALSE
db_block_checksum boolean TRUE
db_block_size integer 8192
db_cache_advice string OFF
db_cache_size unknown 0

I am assuming that since we don't have db_cache_size set to a valid value
it'll be calculated as db_block_buffers * db_block_size as it was earlier.

Am i correct.Can you please advise.

Deepak


This message contains information that may be privileged or confidential and
is the property of the Capgemini Group. It is intended only for the person
to whom it is addressed. If you are not the intended recipient, you are not
authorized to read, print, retain, copy, disseminate, distribute, or use
this message or any part thereof. If you receive this message in error,
please notify the sender immediately and delete all copies of this message.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

This electronic mail message contains information that (a) is or may be
CONFIDENTIAL, PROPRIETARY IN NATURE, OR OTHERWISE PROTECTED BY LAW
FROM DISCLOSURE, and (b) is intended only for the use of the addressee
(s) named herein. If you are not an intended recipient, please
contact the sender immediately and take the steps necessary to delete
the message completely from your computer system.

Not Intended as a Substitute for a Writing: Notwithstanding the Uniform
Electronic Transaction Act or any other law of similar effect, absent
an express statement to the contrary, this e-mail message, its
contents, and any attachments hereto are not intended to represent an
offer or acceptance to enter into a contract and are not otherwise
intended to bind this sender, barnesandnoble.com llc,
barnesandnoble.com inc. or any other person or entity.

Oracle LazyDBA home page