Re: dbms_stats - GATHER AUTO option - ORA-00933 ?

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 7 Nov 2006 04:55:12 -0800
Message-ID: <1162904112.550476.127790@i42g2000cwa.googlegroups.com>

Michel Cadot wrote:
> "Martin T." <bilbothebagginsbab5_at_freenet.de> a écrit dans le message de news:
> 1162828211.700575.176920_at_m73g2000cwd.googlegroups.com...
> | Hi all.
> | (Oracle 9.2.0.1.0)
> |
> | I'm currently trying around with gathering statistics.
> | I wanted to try with monitoring and the gather auto option, but:
> |
> | begin
> | dbms_output.put_line('Start: ' || systimestamp);
> | dbms_stats.gather_schema_stats(ownname => 'MYSCHEMA', options =>
> | 'GATHER');
> | dbms_output.put_line('Stop: ' || systimestamp);
> | end;
> | --> OK
> |
> | begin
> | dbms_output.put_line('Start: ' || systimestamp);
> | dbms_stats.gather_schema_stats(ownname => 'MYSCHEMA', options =>
> | 'GATHER AUTO');
> | dbms_output.put_line('Stop: ' || systimestamp);
> | end;
> | -->
> | ORA-00933: SQL command not properly ended
> | (snip)
> | Any ideas what I'm doing wrong?
> |
> | thanks,
> | Martin
> |

>

> Try to execute
> alter session set NLS_NUMERIC_CHARACTERS='.,';
> before you gather your statistics.
> The procedure does not work if you don't have default
> numeric characters.

>

Thanks a bunch!
It works now.

(hehe ... long time since there has been such a simple answer to anything :)

cheers,
Martin Received on Tue Nov 07 2006 - 06:55:12 CST