SAP Knowledge Base Article - Preview

3560767 - Best Practices for Gathering Statistics in an Oracle Production System

Symptom

To ensure optimal performance of the system, it is essential to gather statistics in the production environment. This can be done either through an online statistics gathering process, where statistics are collected while the system remains fully operational and accessible to users, or through an offline statistics gathering process, where the system is temporarily taken offline to gather statistics without the interference of active transactions and processes. 


Read more...

Environment

Oracle

Product

SAP NetWeaver all versions

Keywords

C11, Oracle, Gather statistics  , KBA , BC-DB-ORA , Oracle , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.