目前分類:Oracle (8)
- Oct 23 Fri 2009 11:15
針對Oracle數據庫的優化器詳細介紹
- Oct 23 Fri 2009 11:11
優化數據庫大幅度提高Oracle的性能
幾個間單的步驟大幅提高Oracle性能--我優化數據庫的三板斧。
數據庫優化的討論可以說是壹個永恒的主題。資深的Oracle優化人員通常會要求提出性能問題的人對數據庫做壹個statspack,貼出數據庫配置等等。還有的人認為要抓出執行最慢的語句來進行優化。但實際情況是,提出疑問的人很可能根本不懂執行計劃,更不要說statspack了。而我認為,數據庫優化,應該首先從大的方面考慮:網酪、服務器硬件配置、操作系統配置、Oracle服務器配置、數據結構組織、然後才是具體的調整。實際上網酪、硬件等往往無法抉定更換,應用程序壹般也無法修改,因此應該著重從數據庫配置、數據結構上來下手,首先讓數據庫有壹個良好的配置,然後再考慮具體優化某些過慢的語句。我在給我的用護系統進行優化的過程中,總結了壹些基本的,間單易行的辦法來優化數據庫,算是我的三板斧,呵呵。不過請註意,這些不壹定普遍使用,甚至有的會有副作用,但是對OLTP系統、基於成本的數據庫往往行之有效,不妨試試。(註:附件是Burleson寫的用來報告數據庫性能等信息的腳本,本文用到)
- Aug 15 Sat 2009 11:43
1Z0-312:Oracle Application Server 10g: Administrator II
1. Which three statements correctly describe the feature of an OracleAS Cluster (Web Cache) and its
members? (Choose three.)
- Aug 15 Sat 2009 11:42
1Z0-046:Oracle Database 10g: Managing Oracle on Linux for DBAs
1. In an online transaction processing (OLTP) database instance that involves a high volume of data
manipulation language (DML) operations, you decide to increase the value of the LOG_BUFFER
- Aug 15 Sat 2009 11:04
1Z1-046:Orcale database 10g:Managing Orcale on Linux for DBAs
1. In an online transaction processing (OLTP) database instance that involves a high volume of data
manipulation language (DML) operations, you decide to increase the value of the LOG_BUFFER
- Aug 15 Sat 2009 11:02
1Z0-043:Oracle database 10g:Administration ii
1. You observe that a database performance has degraded over a period of time. While investigating the
reason, you find that the size of the database buffer cache is not large enough to cache all the needed data
- Aug 15 Sat 2009 11:02
1Z0-042:Oracle database 10g:Administration I
[電腦證照]:最新的IT資訊分享,國際認證,考古題,IT認證教程
電腦證照-認證信息分享,提供學習指南,以及考古題
- Aug 15 Sat 2009 11:00
1Z0-040:Oracle database 10g:new features for adminsitrators
1. You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows: