|
-
To find out OS block size, login as sys and run the following query:
select max(lebsz) from sys.x$kccle;
If Veritas is used and block size is 8k, then it is advisable to set your DB_BLOCK_SIZE to 8K. The reason is simple: no extra IO.
When they are NOT equal then OS has to do reconstruct the data block in the memory. This will impair performance.
Tamil
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
|
Click Here to Expand Forum to Full Width
|
Reply With Quote