see http://arswiki.org/wiki/Oracle_Performance_Tuning#LOB_Storage
Has info on the subject and some actions that can be taken.
As for ardb.conf, I found I can greatly reduce hard parses, table
scans, and i/o on the db server on the email messages table using
this:
Form: AR System Email Messages
Clause: PARTITION BY RANGE(C18099)
(PARTITION P1 VALUES LESS THAN(1) TABLESPACE ARSYSTEM,
PARTITION P2 VALUES LESS THAN(2) TABLESPACE ARSYSTEM,
PARTITION P5 VALUES LESS THAN(5) TABLESPACE ARSYSTEM)
ENABLE ROW MOVEMENT
Index {
Id: 18099
Clause: LOCAL
}
The email engine caused a full table scan on the email messages form
every poll interval without this. This was developed against 6.0.1,
so it may or may not apply any more (I use it on 7.0.1 without any
issues). I submitted an rfe/ticket to BMC at the time I discovered
and corrected this, but my confidence that anything was done about it
is low.
Axton Grams
On Fri, Feb 29, 2008 at 12:56 PM, Garrison, Sean (Norcross)
<[EMAIL PROTECTED]> wrote:
> **
>
>
>
> Does anyone have any suggestions for improving performance in Oracle. Are
> there any general ardb.conf settings that people recommend? Our dbas are
> griping (and rightly so) about the clob fields taking up so much space in the
> db. Our db doesn't have much in it but is taking up ~40 gigs of space. Any
> suggestions on what can be done to improve this are welcome.
>
>
>
> Thanks,
>
>
>
> Sean __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
