升级专题研究看在升级前后的系统性能(英文).ppt

An Oracle 10g Upgrade Case Study: Looking at System Performance Before and After the Upgrade Todays Session The view from 30,000 feet: Our Oracle environment, upgrade strategy Impressions: upgrade process and compatibility Impressions: Oracle 10g in general In greater detail: Sizing the shared pool and SGA Optimizer statistics collection and accuracy Query optimization SQL Tuning Advisor Overhead Today’s Session Goal: Help you plan for your own Oracle 10g upgrade. We will: Look at one company’s experience upgrading to 10g Discuss real-life experiences Provide data so you can draw your own conclusions We will not: Walk through the actual upgrade steps Make any judgments about Oracle 10g Always Remember Each Oracle system is unique and will have its own challenges. Never take somebody else’s word on anything when it comes to Oracle technology. In this session we are only relaying one company’s experiences. The only way for you to know how your specific system will fare on Oracle 10g is to try it—in a test environment—and see. White Paper Contains additional topics and examples we wont have time to discuss today Contains additional “supporting evidence” for conclusions reached in todays session that we wont have time to discuss or that won’t fit legibly on a PowerPoint slide TKPROF reports, execution plans, AWR reports Download: /presentations The View From 30,000 Feet Our Oracle environment Our upgrade strategy Impressions: upgrade process and compatibility Impressions: Oracle 10g in general Our Oracle Environment Platform details: Oracle 8.1.7 Standard Edition 32 bit Sun Solaris 8 64 bit One production and one dev database Production database 15 Gb in size Our Oracle Environment Application: Customer database monitoring tool Backend daemons process inbound agent files from our customers’ database servers in the field Web-based user interface for report generation, system configuration Almost all code is PL/SQL (roughly 50,000 lines) Leverages Oracle 8i fea