Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
|
Oracle
»
DDL
»
DBA
»
Performance
Analyze and Gather Statistics
Oracle 8, 9, and 10g
-- for entire schema
exec dbms_stats.gather_schema_stats ( OWNNAME => 'PEOPLESOFT',
METHOD_OPT => 'FOR ALL INDEXED COLUMNS SIZE 1',
ESTIMATE_PERCENT => 25,
CASCADE => TRUE,
GRANULARITY => 'ALL' );
-- for single table
exec dbms_stats.gather_table_stats(
METHOD_OPT => 'FOR ALL INDEXED COLUMNS SIZE 1',
TABNAME => 'accounts',
estimate_percent=>15,
degree=>1 );
|
|
|
Get the latest Rocket99 news and tech tips via
|
