| Executing gather schema statistics at backend |
| Monday, June 16, 2008 |
exec dbms_stats.gather_schema_stats
('GL', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE);
exec dbms_stats.gather_schema_stats
('AP', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE);
exec dbms_stats.gather_schema_stats
('AR', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE);
exec dbms_stats.gather_schema_stats
('PA', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE);
exec dbms_stats.gather_schema_stats
('FA', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE);
exec dbms_stats.gather_schema_stats
('APPS', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE);
exec dbms_stats.gather_schema_stats
('APPLSYS', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE);
exec dbms_stats.gather_schema_stats
('CE', options=>'GATHER', estimate_percent=>
DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>
'FOR ALL COLUMNS SIZE AUTO', cascade=>TRUE); |
posted by Senthil Kumaran @ 11:44 PM   |
|
|
|
