Brian Peasland wrote:
> astalavista wrote:
>> Hi,
>>
>> What are the advices to analyze SYS and SYSTEM objects ?
>> 8i, 9i, 10g ?
>>
>> Thanks in advance
>>
>>
>>
>
> In 8i...do not
> In 9i...not supported until 9iR2 (IIRC), but not a good idea in this
> version.
> In 10g..analyze the objects.
>
> HTH,
> Brian
and, in addition, use GATHER_SYSTEM_STATS to gather statistics on CPU
and disk i/o.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jan 10 2007 - 10:53:56 CST
