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: > ** > > > > 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"