Re: dbms_stats

• Post for FREE via your newsreader at post.usenet.com ****

"Wayne March" <wmarch_at_cfl.rr.com> wrote in message news:69e9fe8c.0408191045.5c13cfb0_at_posting.google.com...
> I try to execute dbms_stats.gather_schema_stats (ownname => 'SYSADM'
> , degree => 12
> , percent_estimate => 30
> , cascade => true) ;
> and I am getting
> dbms_stats.gather_schema_stats (ownname => 'SYSADM'
> *
> ERROR at line 1:
> ORA-00900: invalid SQL statement
>
> Any ideas how do i fix this situation

Hi Wayne

The parameter name is "estimate_percent" and not "percent_estimate".

BTW:
- how many CPU has your system? Remember, with degree=12, 24 processes will be used for the processing...
- 30% is either too high or too low... in my opinion you should use 100% or a value lower than 5%, on most systems 1% is good

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=