Re: Updating system statistics
- From: "Don Seiler" <don@xxxxxxxxx>
- To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- Date: Tue, 12 Dec 2006 14:02:56 -0600
Alright I ran this command:
exec
dbms_stats.gather_system_stats(interval=>90,stattab=>'SYSSTATS',statid=>'DEC12');
It returned in a minute, so I assume that it runs in the background
now. I've noticed two rows in my SYSSTATS table, but the column names
are a bit unintuitive. Is there a HOWTO on interpreting that data?
Don.
On 12/12/06, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:
> So gathering system stats to the user table won't alter CBO behavior
> then? I assume I have to create that table with
> dbms_stats.create_stat_table() function.
Exactly.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
