OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » DB CACHE (Oracle 10g 10.2.0.1.0,Windows 2003 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB CACHE [message #281558]

Sun, 18 November 2007 05:11

foreigndba
Messages: 7
Registered: November 2007
Location: Dhaka

Junior Member

Hellow

In Oracle 10g 10.2.0.1.0 db_cache_size is not defined.
In Oracle 10g 10.1.0.2.0 db_cache_size is defined may be 25MB(depend on SAG).

1.I want to know what is the relation between database buffer cache,db_cache_size,db_file_multiblock_read_count=16 (in Oracle 10g 10.2.0.1.0).

2.When I initilize db_2k_cache_size,db_4k_cache_size,db_16k_cache_size,db_32k_cache_size

3.I know db block size by default db_block_size=8192. When I used in my database db_block_size=8192 and another db_block_size=16KB, what is the size of db_cache_size? when we used different block size.

Plz Help me

Report message to a moderator

Previous Topic:	Urgent RMAN related answers needed
Next Topic:	Create trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 20:10:23 CST 2025