|
-
The answer may be not that simple as you would like to see.
Maybe there are some articles on the net, so you should search for them. Some things also depends on the kind of database-use OLTP or batch-processing, large tables/ indexes
(partitioning).
There is also the machine itself. Are disks placed in stripes,
is there load-balancing on operatingsystem level.
What differences are there between logical volumes and physical volumes?
Main point is: Disk reading/ writing is a very time consuming event, it is mechanical. The less the heads should move over the disks, the faster it responds.
For instance, seperate the tables and the indexes, so it does not have to reposition all the time from index to table etc.
Create another tablespace for RBS.
I know it's not a complete answer, but at least you have some points to think over.
Regards
Ben de Boer
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
|