Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Creating Oracle Database Objects >

Collecting Optimizer Statistics for Oracle 9i

Collect statistics for the tables, indexes, and histograms for the columns where the data shape is skewed. For details on how to collect these statistics, see Oracle administration manuals.