-
Setting BUFFER_POOL
My oracle 8i database was running on win2000 with 1CPU and 2Go RAM.
The SGA was about 1700000000
This db_block_size = 8192
db_block_buffer = 170000
I have one table about 5 millions of rows (the Average row size 159,02) and I want to keep it in memory. What should i do to set the BUFFER_POOL_KEEP and BUFFER_POOL_RECYCLE in the parameter file with these values.
Regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|