Hi, The normal problem when the Oracle database grows out of proportion, it has to do with if CLOB-data is defined to be stored outside row (default) instead of inside row.
You can check your ar.cfg/conf for Oracle-Clob-Storage-In-Row:T. If not found, you have the default ouside row that creates an enormous data overhead. Here is a BMC document describing the differences and SQL-code to convert existing tables to In-Row: http://documents.bmc.com/supportu/documents/96/63/89663/89663.pdf Best Regards - Misi, RRR AB, http://rrr.se > My DBA is doing a refresh of the Production DB to my Test Server. He said it > is 180GB. > > It has only been live since 5/2013. Is this the "normal" size for something > like the setup I have? > > ITSM 7.6.04 SP4 (CMDB, Change Management, Work Orders, Incidents) > ARS 7.6.04 SP4 > Oracle 11.2.0.3.0 - 64bit Production > Win 2008 Server > > > Thank you! > Claire > > 5/12/2014 <4:33pm> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
