Re: dbms_stats.gather_system

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 1 Oct 2003 17:28:09 +0200
Message-ID: <blerqb$rb9$1@news.fujitsu-siemens.com>

"Volker Hetzer" <volker.hetzer_at_ieee.org> schrieb im Newsbeitrag news:blbust$11o$1_at_news.fujitsu-siemens.com...
> Hi!
> I'm trying to use dbms_stats.gather_system_stats for the CBO.
> So, when I entered dbms_stats.gather_system_stats(gathering_mode=>'INTERVAL',interval=>10);
> I expected it to collect statistics for 10 minutes and then finish.
> Now, when I look at the job queue I see it scheduled for some dates I definitely hadn't in mind,
> like some time during the next 2 hours or so.
Was a problem with permissions. I let it run as sys and now it works perfectly.

Lots of Greetings!
Volker Received on Wed Oct 01 2003 - 10:28:09 CDT

Re: dbms_stats.gather_system_stats...