Rami Aubourg-Kaires wrote:

> GMI wrote:
>
>> Hi,
>>
>> I am trying to set up Oracle10g on a SLES9. Installation went OK on a
>> REISERFS partition.
>>
>> It is a bi-pro XEON, with RAID5 LSI MEGARAID controller.
>>
>> What filesystem would you suggest ?
>>
>> As I sait, currently, we are using reiserfs, but performance is
>> abismally bad: even a basic P IV pc with a IDE disk performs much
>> better...
>>
>> Kind regards,
>> Gerd
>>
>
>
> ext3
>
> You might also try to increase the following parameters:
>
> sort_area_retained_size=1048576
> sort_area_size=1048576
>
>
Won't this only be effective if his workarea_policy parameter is set to
manual?

9i defaults to using pga_aggregate_target if I am not mistaken.

Also, he can also install statspack, set it up to do periodic snapshots
and then generate reports off of that. He will get a great bulk of
information from that without needing to grok the various dynamic
views.

Statspack is a good thing to run in general.

Plus the reports themselves are very portable and easily shared.

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting