EBS 12.x
11g
Hi ALL,
We want to gather statistics for ALL schema in EBS.
Which of the two programs is able to serve the purpose?
1.)
Exec FND_STATS.GATHER_SCHEMA_STATISTICS('ALL', 10, 8,'NOBACKUP', NULL, 'LASTRUN','GATHER AUTO', 10, 'N');
or
2.)
begin
dbms_stats.gather_schema_stats(
'SYS',
options=>'GATHER STALE',
estimate_percent =>
DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL COLUMNS SIZE AUTO',
cascade => TRUE);
end;
/
Please help....
Kind regards,
jc