摘要：Objectivesshared pool tune（shared pool 调优）After completing this lesson,you should be able to do the following:Determine the size of an object and pin it in the shared poolTune the shared pool reserved spaceDescribe the user global area (UGA) and session memory considerationsMeasure the library cache 阅读全文

摘要：Oracle Database 11g includes three standard storage options:File systemNetwork attached storage(NAS)Storage area network(SAN)Direct attached storageRaw Partitions(原始分区,此种方式将逐渐被淘汰)Automatic Storage Management(AMS)Oracle Processes and FilesProcessOracle File I/OData filesOracle File I/ORedo LogOracle 阅读全文

摘要：Operating System Tuning1、首先对内存进行调优（理论上讲，内存足够大的话，就不存在IO读写） 查看一些系统快慢的时候，首先要查看系统的内存占用率. linux下查看内存使用情况命令vmstat(virtual memory)、vmstat 3（3秒钟变化一次）、top2、对I/O进行调优 linux下查看IO使用情况命令iostat3、CPU进行调优 正常情况下，CPU的利用率，应当控制在70%以下.top命令查看cpu使用情况------------------------------------------------------------------------- 阅读全文

摘要：1、Statspack(强大的分析和性能调优工具)Installation of Statspack using the spcreate.sql scriptCollection of statistics execute statspack.snapAutomatic collection of statistics using the spauto.sql scriptProduce a report using the spreport.sql scriptTo collect timing information,set TIMED_STATISTICS = True2、搭建stat 阅读全文

摘要：1、What Does the DBA Tune?Performance tuning areasApplication:(Shared with developers)SQL statement performanceChange managementInstance tuning:MermoryDatabase structureInstance configurationOperating system interactions:(Shared with SA)I/OSwapParameters2、Tuning QuestionsWho tunes?Application designe 阅读全文