The problem about this is, that spool doesn't work, while in Oracle 10 a similar script worked well. ]]>Rumak182013-01-29T16:10:05-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/575935/#msg_575935
I.E.

]]>LNossov2013-01-30T15:54:37-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576175/#msg_576175
Here are the results:
The only thing that was created is :
'GATHER')
and this file is empty.
Nothing more happened. ]]>Rumak182013-02-01T09:31:48-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576178/#msg_576178
LNossov2013-02-01T09:50:41-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576183/#msg_576183
Rumak18 wrote on Fri, 01 February 2013 10:31

Hello LNossov:

Here are the results:
The only thing that was created is :
'GATHER')
and this file is empty.
Nothing more happened.

you MUST copy and paste what you did and got otherwise we can't help you.
And post it FORMATTED that is:
Read How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel

]]>Michel Cadot2013-02-01T10:10:49-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576206/#msg_576206
I was writing my message speaking German with my colleague and did't realized, that my message is a mix of German and English.

]]>Rumak182013-02-01T15:53:07-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576231/#msg_576231
So either:
1) you have a really weird oracle bug and you need to be talking to oracle support about it, not us.
2) That file was generated by you or someone else making a mistake when typing/copying and pasting.

My money is on option 2.

That said, I still don't understand:
1) why you are using spool. What do you expect the file to say? I'd expect to see "PL/SQL procedure successfully completed.", which seems rather pointless.
2) Why you don't just leave oracle to do it for you. It's routinely generating stats anyway, unless you explicitly stopped it.

EDIT: typo]]>cookiemonster2013-02-01T16:03:08-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576232/#msg_576232
We have NO idea of what you did.

Regards
Michel
]]>Michel Cadot2013-02-01T16:03:21-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576960/#msg_576960
Now...@cookiemonster:
To tell the truth...i'm just the second DB administrator and try to reach the knowledge of my colleague who successfully tries to stop my development in oracle knowledge. Also he was the one who introduced this script for statistics. Now, where can i see the "default" statistics process in oracle? Perhapts it is still configured.]]>Rumak182013-02-11T12:45:03-00:00Re: Oracle Statisticshttp://www.orafaq.com/forum/./mv/msg/185981/576962/#msg_576962
Quote:

Now, where can i see the "default" statistics process in oracle? Perhapts it is still configured.

Look at the view DBA_AUTOTASK_CLIENT, and related views and packages. Read up on the autotask system.

Quote:

i'm just the second DB administrator and try to reach the knowledge of my colleague who successfully tries to stop my development in oracle knowledge