Application stops working when analyzing schema

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database performance problems and tuning Oracle New Year's resolutions, part 1: Advice for navigating 2009 Solving common Oracle errors guide Oracle 11g data compression Varchar or number for better performance? Do statistics on SYS-owned objects hurt performance in 10g? Inside the Oracle 11g SQL Performance Advisor, part 1 Inside the Oracle 11g SQL Performance Advisor, part 2 Difference between driving table and driver table in Oracle Best design for E-Business Suite on hard drive Using the cost-based optimizer to improve Database 10g performance

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

The process of gathering table and index statistics is CPU and I/O intensive, and does cause a fair amount of locking, so you should schedule this process during times when the application is not active.