I have an escalation that run on a time of low usage that cleans up logs, emails, email errors, etc after 30 days. Running that once a week keeps those tables from getting overly large. Which tables to 'purge' depends on your needs. Sounds like you've identified some.
For more permanent data (ie chg or inc. tickets) you need to get real clear guidelines from the business on how long that data needs to be kept before you start looking at removing those items. You can also make use of the 'archive' facility to move older data into an archive table. That way the data will still be there if folks need to search, but will not be in the basic searches folks may be running against a large number of tickets. Under form properties there is a selection for Archive which looks almost like an escalation in selecting the timing and qualification for archiving data. On Wed, 24 Nov 2010 11:47:21 -0500, patrick zandi <[email protected]> wrote: > Granted.. but the question becomes how often do you do it? > > On Wed, Nov 24, 2010 at 11:41 AM, Ramey, Anne <[email protected]> wrote: > >> ** >> >> It’s not just a matter of space. We see significant performance hits >> once >> certain tables get really big. Sometime data needs to be purged. >> >> >> >> Anne Ramey >> *********************************** >> >> *E-mail correspondence to and from this address may be subject to the >> North Carolina Public Records Law and may be disclosed to third parties >> only >> by an authorized State Official.* >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *patrick zandi >> *Sent:* Wednesday, November 24, 2010 10:18 AM >> >> *To:* [email protected] >> *Subject:* Re: Purging not releasing space >> >> >> >> ** This should be a rare occurrence and you should have enough space on >> your boxes to grow and allow the DB tables to grow dynamically. >> >> I think of no real reason not to have the space. If you (for example) >> start >> using the attachments alot space is going to grow and you are going to be >> in >> the same boat, just sooner. >> If you are bumping against Physical limits.. Just get more disk, or more >> drives. >> Remember to divide if you are using physical drives, /u01 ~ /u08 for >> example placing different pieces in different disks. >> Otherwise if you are connected SAN wise, just add more disk.. >> >> Don't play games with that.. if for some reason you miss it, vacation.. >> and >> run out of disk.. >> You are not going to like the clean up to get yourself back to where you >> were! >> >> >> >> On Tue, Nov 23, 2010 at 5:10 AM, rajat sharma <[email protected]> >> wrote: >> >> ** >> >> Thanks...Patrick for the info... >> >> Actually we are setting up a purging policy in our environmnet. If you or >> anybody in this list can help us in finding which tables should >> be purged and their frequency that would be of great help. >> >> >> >> Thanks, >> >> Rajat >> >> On Mon, Nov 22, 2010 at 8:51 PM, patrick zandi <[email protected]> >> wrote: >> >> ** you cannot reduce the size of the database (after creation) from the >> remedy side, >> >> >> you need an oracle DBA to assist you to reduce the DBF's >> >> http://www.orafaq.com/wiki/Oracle_database_FAQ -- This might help some >> ... >> >> >> The DBF's are like a jar and your data is the marbles in it.. you can >> pull >> 100 marbles from the jar, but the jar is still the same size. >> >> >> On Mon, Nov 22, 2010 at 9:20 AM, rajat sharma <[email protected]> >> wrote: >> >> ** >> >> Hi List, >> >> >> >> We are deleting recoreds from Remedy but it is not releasing space from >> Database. >> >> Please let me know if i need to check some settings. >> >> Also let me know if i need to take help from DBA. >> >> >> >> Environment: >> ARSystem: 7.5 patch002 >> Platform: AIX >> Database: Oracle 10g >> BMC Atrium CMDB: 7.5 patch004 >> BMC Drift: 7.5 >> SRM: 2.2 patch003 >> >> >> >> Thanks, >> >> Rajat >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> >> >> >> >> -- >> Patrick Zandi >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> >> >> >> >> -- >> Patrick Zandi >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
