Re: Optimizer Mode

From: Gert Rijs <nospampleasegem_at_wirehub.nl>
Date: 1997/08/17
Message-ID: <01bcaaf7$a8b8d220$0100007f@gertrijs>#1/1

An easy way to collect statistics is with the dbms_utility package: exec dbms_utility.analyze_schema('SCOTT', 'COMPUTE')

this will analyze all Scott's tables (using the compute method).

hth,
gert

-- 
reply address is altered to keep the spam down
remove the nospamplease part to reply...

Ivan Boesing <boesing_at_geocities.com> wrote in article
<01bca8c6$d9bc0460$46013396_at_Ivan>...


> Hi Oracle gurus,

> 

>      I recently changed the optimizer mode of my database. I collect

> statistics with the analyze command for some tables (about 10). The

> optimizer works fine with this tables and statistics. 

>      Howewer, I have some doubts. Do I collect statistics for each table

 in


> database?? If so, how can I do it automatically (or I have do it

 manually,


> table per table). I should do this by a midnight script, but for every

 new


> table I would need to update the script.....        By other hand, if

> statistics are necessary just for the most used tables I can collect it

> manually, but if the table change in size so frequently how the optimizer

> will work?

>      Sumarizing, how can I proceed with statistics and cost based

> optimization method?

Received on Sun Aug 17 1997 - 00:00:00 CDT