頁籤選單縮合
題 名 | Oracle資料庫效能調整技術探討=Performance Tuning for Oracle Database |
---|---|
作 者 | 陳文昌; 周維聖; | 書刊名 | 電信研究 |
卷 期 | 33:1 2003.02[民92.02] |
頁 次 | 頁43-60 |
分類號 | 312.49 |
關鍵詞 | Oracle 資料庫; 效能調整; Performance; Resource contention; SGA; System Global Area; Shared pool; |
語 文 | 中文(Chinese) |
中文摘要 | Oracle資料庫包含了多組的參數以及演算法供調教使用以適用於各種不同的環境及不同種類的應用程式,而適用於進銷貨資料庫的參數並不見得適合資料倉儲使用。因此資料庫效能調教即是如何適當的選擇及調整參數,以控制Oracle選擇合適的演算法,藉以獲得良好的反應時間。本文旨在討論各種資料庫效能的瓶頸,並提供各種調整技術與方法供資料庫管理者監控、調整Oracle資料庫的效能。 |
英文摘要 | Tuning is a powerful capability that enables you to get the most out of your existing hardware and software. The concept of tuning the Oracle instance comes from one of the basic requirements designed into Oracle - flexibility. Oracle has to work in a wide variety of environments while supporting a wide variety of applications. Obviously, setting and algorithm that work well for small transaction database are not the best for large data warehouse. Therefore, the Oracle's software actually consists of a number of different algorithm that are selected as part of the tuning process. This paper discusses various bottlenecks in the processing of database which can be tuned for maximum throughput from an Oracle database. It introduces various techniques, tools and provides sql commands for performance tuning both for application and server level. It also covers the tuning of Oracle Multi-thread Server and highlights the importance of shared SQL area and how it helps in tuning. |
本系統中英文摘要資訊取自各篇刊載內容。