User login

  • Create new account
  • Request new password

Search

[ Advanced ] [ Help ]

Site navigation

  • About
  • Articles / Blogs
  • Blog Aggregator
  • Books
  • Directories
  • Events
  • FAQ's
  • Forums
  • Mailing Lists
  • Papers
  • Scripts
  • Tools
  • USENET News
  • Wiki
  • XML Feeds

Featured book

cover of Oracle Database 11g DBA Handbook
Oracle Database 11g DBA Handbook

Similar entries

  • High Performance Oracle Database Applications: Performance and Tuning Techniques for Getting the Most from Your Oracle Database
  • Oracle Performance Tuning for 10gR2, Second Edition
  • Oracle Database Performance Tuning Interview Questions, Answers and Explanations: Oracle Performance Tuning Certification Review
  • Oracle High Performance Tuning for 9i and 10g
  • Oracle High-Performance SQL Tuning
Home » Oracle FAQ Knowledge Base » RDBMS Server

Performance Tuning

Submitted by admin on Wed, 2005-10-19 09:25.

Database Performance Tuning

  • What database aspects should be monitored?

  • Why and when should one tune?

  • Where should the tuning effort be directed?

  • What tools/utilities does Oracle provide to assist with performance tuning?

  • What is STATSPACK and how does one use it?

  • When is cost based optimization triggered?

  • How can one optimize %XYZ% queries?

  • Where can one find I/O statistics per table?

  • My query was fine last week and now it is slow. Why?

  • Is my index being used or nor?

  • Why is Oracle not using the damn index?

  • When should one rebuild an index?

  • How does one tune Oracle Wait events?

  • What is the difference between DBFile Sequential and Scattered Reads?

  • Where can one get more info about Oracle Tuning?

  • How does one tune the Redo Log Buffer?

‹ Where to find more general info about an Oracle lock?upWhat database aspects should be monitored? ›
»
  • Login to post comments
.:: Site Home :: Wiki Home :: Forum Home :: Privacy :: Contact ::.