Oracle 9i 数据库性能调优技术-les03.pdfVIP

Database Configuration and I/O Issues Copyright © Oracle Corporation, 2002. All rights reserved. Objectives After completing this lesson, you should be able to do the following: • List the advantages of distributing different Oracle file types • Diagnose tablespace usage problems • List reasons for partitioning data in tablespaces • Describe how checkpoints work • Monitor and tune checkpoints • Monitor and tune redo logs 3-2 Copyright © Oracle Corporation, 2002. All rights reserved. Oracle Processes and Files Process Oracle file I/O Data files Log Archive Control CKPT Read/Write Read/Write DBWn Write LGWR Write Read/Write ARCn Read Write Read/Write SERVER Read/write Read Write Read/Write 3-3 Copyright © Oracle Corporation, 2002. All rights reserved. Performance Guidelines Basic performance rules are as follows: • Keep disk I/O to a minimum. • Spread your disk load across disk devices and controllers. • Use temporary tablespaces where appropriate. 3-4 Copyright © Oracle Corporation, 2002. All rights reserved. Distributing Files Across Devices • Separate data files and redo log files. • Stripe table data. • Reduce disk I/O unrelated to the database. 3-5 Copyright © Oracle Corporation, 2002. All rights reserved. IO Topology Support 3-6 Copyright © Oracle Corporation, 2002. All rights reserved. Tablespace Usage • Res