|
|
|
|
| Re: Database Buffer size [message #147701 is a reply to message #147698] |
Sat, 19 November 2005 10:44  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Please check out the below written things.....
Logical Structure Of Database
=============================
Database is made of number of tablespaces , which is made up of segments , segments having number of extents and extents are having number of blocks.
Types Of Segments
=================
Table
Index
Rollback
Temporary segment
When creating any table the extents are allocated in data file , the number of extents starts from 0 and on …
This extents are collection of blocks when you create any segment oracle allocate extents
u can know the size of block by parameter DB_BLOCK_SIZE = ___ bytes
once db is created you cant change the size of this parameter, if you change it database gets corrupted
Block size should equal to O/S (i.e. operating system) block size or multiple of it
Example
=======
For oracle 9i & 10g on Xp
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16
==============================================================
This are the other parameter which can be used in buffer pool.
Default Pool db_cache_size = 33554432
Keep Pool db_keep_cache_size = 5242880
Recycle Pool db_recycke_cache_size = 5242880
I Hope above information will be usefull to you
Regards
Always Friend sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
