Rick - The space usage is probably related to storing CLOB's out of row. There's a defect (somewhere) regarding your exact situation with Disco/CMDB.
We found that when loading 120k+ people, our db grew out of control. There is auditing functionality on ctm:people, and storing clob's (zero length fields) out of row will eat at least your db block size (8k usually) for each row. I've made it a point to switch on clob-in-row as soon as finishing the ars install (prior to itsm7) and manually moving clobs out of row via ardbc.conf as needed. If you use a utility such as TOAD you can browse objects (on the tablespace tab) and sort by size. Our offender was the CTM:AuditLogSystem form which had grown to about 1GB Here's a snippet of some of my email on the subject: "So I did some math (always a scary thing) ... Column C536870935 data is basically: "1178756214AR_ESCALATORLocation has been set with Site : 01018 - Covington - Wa Region has been set with : Department Store Default Notify Mechanism has been set to : E-mail Client Type has been set to : Office-Based Employee Received Person ID : PTG000000008352 PTG000000008352 has Asset Viewer Permissions now People Entry has been successfully added User Information has been successfully added User Form Information for Company Kohl's has been successfully modified." That data is 468 characters. We're non-unicode for the ARServer so that should be bytes. Bump it up to 500. Multiply by 120000. 60000000 bytes. Convert that to megabytes = 57 which is getting stored in the database as 994MB. Even if I got screwed up on my bit/byte stuff and math, 457MB is nowhere close to 994. " hth, tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Rick Cook <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 06/20/2007 09:58 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Anybody running ARS 7 on Oracle 10g XE (XE is free) ** Ours, even after all the configuration data was in (including LDAP and a truncated DSL), fit in about 1 GB (on Oracle 9), until we started importing asset records from Discovery, at which time it ballooned to about 10 GB. So even with Oracle 10, I would think 4 GB should hold plain ITSM 7 without FD/TD. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 20, 2007 7:30 AM To: arslist@ARSLIST.ORG Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free) ** great, thanks Jarl. BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample data (excluding the product dictionary) From: Jarl Grøneng Sent: Wed 06/20/07 12:23 AM To: arslist@ARSLIST.ORG Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free) Yes, using it on my laptop with 7.x But only for small development tasks... -- Jarl On 6/20/07, Guillaume Rheault <[EMAIL PROTECTED]> wrote: > ** > > Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)? > Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), but > maybe somebody has given it a shot... > > XE is free since 02/2006, according to this Oracle press release: > > http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html > > "The software can be downloaded for free from the Oracle Technology Network > at: http://www.oracle.com/technology/xe. Oracle Database XE > is available for download, usage and distribution at no charge." > > Any feedback is appreciated > > thx, Guillaume > > > > > > __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
