ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [笔记]关于调整的一些建议

[笔记]关于调整的一些建议

原创 Linux操作系统 作者:husthxd 时间:2004-11-09 00:00:00 0 删除 编辑

some advice from oracle support.


1. Use more database buffers to reduce the need for Disk I/O. 
2. Organize objects that are heavily accesses such that they are  
   on separate disks.  
3. Separate indexes from tables place into different tablespaces and split these tablespaces onto different disks.  
4. Stripe heavily accessed objects over multiple disks.  
5. Separate redo logs onto a lightly loaded disk drive.  
   Note: Raid 5 based disks are NOT a good location for redo logs 
6. Place rollback segments into to separate tablespaces and then  
   by the listing order in the init.ora interleaf the access  
   between the two tablespaces.  
7. Use multiple database writers up to the number of disk spindles  
   that are being accessed.  
8. Use the Explain plan utility to check the most common SQL

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/6906/viewspace-21625/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 推荐好书:
请登录后发表评论 登录
全部评论
ITPUB数据库版块资深版主,对Oracle、PostgreSQL有深入研究。

注册时间:2007-12-28

  • 博文量
    1422
  • 访问量
    3858420