Re: 10G self-managing database = sql_trace, timed_statistics, statspack turn on?

David wrote:
>
> anyone should know that 10G is self-managing database. But I don't know the
> detail of self-managing. Under my impression, the so-called self-managing
> database just like an Oracle database, with statspack installed and
> scheduled, and timed_statistics and sql_trace turn on, am I right (maybe add
> one more feature like Oracle Expert in OEM).
>
> but I am also worry that if such information is scheduled to collect, will
> it affect the overall performance of the database?
>
> (sorry about my impression since I am new to 10G.....)

I remember in San Fran some Oracle folk were saying that there was target of limiting average impact on resources of all the nice monitoring goodies to 5%.

Whether thats true or not is a wait-and-see I suppose

hth
connor

-- 
-------------------------------
Connor McDonald
http://www.oracledba.co.uk
Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"