----- Original Message -----
From: <[EMAIL PROTECTED]>
>
> I want to know how to how to use dbms_stats. package and get the statistics
>
> I want to know how to how to use dbms_stats. package and get the statistics
>
short answer:
begin
dbms_stats.gather_schema_stats(ownname => 'XXXX',cascade=>true);
end;
for a detailed explanation take a look at
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "