OCOUG 2005 Monitoring Oracle 10g for success

1
OCOUG 2005Monitoring Oracle 10g for success

• Presenter Joe Leslie, Product Manager
• Quest Software
• Wednesday August 24, 2005
• Irvine Hilton

2
Key areas to monitor

• Activity and TOPs
• Users, programs, machines, ERP module, SQL
• Throughput
• CPU, IO, memory, network resources
• Contention
• Blocking Locks and DB Latching
• SQL
• When?
• Real Time
• Diagnostics
• Root-cause-analysis

• Historical
• Trending
• Analysis
• Predictive Modeling

3
Key techniques to deploy

• Real-time Diagnostics
• The need to debug and troubleshoot to solve
  problems fast!
• Comparison
• Detail comparison of instance or job performance
  from one run to the next
• Change Tracking
• Know how change relates to performance
• Produce ROI reports for planned change events
• It was working well yesterday?!.... What changed?
• Historical Analysis
• Trending
• Advanced reporting to isolate workload elements
• SQL Tuning Workbench style
• TuneTestRewriteTestOptimizeTestIndex
  AnalysisBenchmarkChoose!
• Outline Management

4
The QCO Advantage the details !

• Advanced SQL Tuning
• Rewrites SQL quickly utilizing the industrys
  best SQL Tuning engine (LECCO) optimization
• Simulates index usage, and impact to applications
• SQL Tuning lab environment
• Outline Manager provides automated management of
  Query plans
• Query Plan Analyzer compares SQL plans between
  jobs or different instances.
• Real-time Diagnostics (Spotlight and PA)
• Unique live-time graphical interface is easy to
  understand and pinpoints areas of performance
  concern
• Xpert knowledge base helps diagnose and resolve
  problems quickly
• Application details retained for one hour prior
  to historical rollup to enhance diagnostic
  research
• Comprehensive database advisories help DBAs
  ensure the health of their DB system with easy to
  follow action plans

5
The QCO Advantage the details !

• Historical Analysis
• Easily drilldown to root-cause using visual zoom
  and OLAP dimensions
• Which SQL, program, and/or users are consuming
  the most CPU, IO, and/or memory
• Diagnose and resolve blocking locks in real-time
  or after-the-fact.
• Powerful Comparison Utility enables DBAs to
  compare instance nodes and job performance
• Change Tracking enables DBAs to automate Change
  reporting and easily correlate changes and
  performance. Provide management ROI and cost
  justification reports.
• Comprehensive performance Reports
• Automatically customize, schedule and distribute
  reports in a variety of formats (pdf, html,
  Excel)
• Customer Specific Features
• Support for ERP - oraApps / PeopleSoft, EMC
  storage performance, and RAC

6
The QCO Advantage the details !

• Integrated Testing with Benchmark Factory
• Only tuning and testing methodology for RAC
  implementations and Oracle 10g Deployments
• Only tool to assist to determine right number of
  RAC nodes
• Scalability testing
• Replay production workload
• Only tool that optimizes SQL for scalability and
  performance

7
The QCO Advantage the details !

• Space Management
• Proactive database maintenance
• Reorg report helps identify objects needing
  reorganization
• Capacity reports help predict out-of-space
  conditions and future space requirements
• Zero application down time for live
  reorganizations
• Users can remain online throughout entire
  reorganizationusers are unaffected
• Live reorg switch control
• Automatic, manual or in a time window
• Flexible scripting options
• Parallelism used for speed
• Sorted reorganizations allows index selection
• Exceptional feedback
• Job Monitor to manage and monitor all scheduled
  scripts
• Live Reorg Detail window lists all tables in the
  reorg and displays transaction and operation
  statistics for each table as it is
  reorganizedallows user to estimate when switch
  will occur (new in 5.6)
• Provides script visibility and space checks
• SQL Editor to review execution script and script
  logs (for troubleshooting)
• Space checks prior to reorg
• Automated script restart-ability

Also proven to scale and perform on terabyte
tables
8
Thank you!

• Please visit Quest Software at
• www.quest.com
• for more information