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
There's some new documentation on BMC's site regarding the proper placement
of Clobs. Might want to look that up.
Rick
On Fri, Feb 29, 2008 at 9:56 AM, Garrison, Sean (Norcross)
[EMAIL PROTECTED] wrote:
**
Does anyone have any suggestions for improving performance in Oracle. Are
there
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
If your on 7x (some also in 6x) these settings in ar.conf may give you
some imrovments:
Read-Only-Tran-Off:
NextID-Block-Size:
Oracle-Cursor-Sharing:
Oracle-Bulk-Fetch-Count:
Oracle-Clob-Storage-In-Row:
--
Jarl
On Fri, Feb 29, 2008 at 6:56 PM, Garrison, Sean (Norcross)
[EMAIL PROTECTED] wrote:
4 matches
Mail list logo