Depends on the table and the use of the system. For example, our notifier log gets about 1 million entries every month. It needs cleaning every 6 months or so. Asset Audit log is similar, it tends to need cleaning yearly. Etc.
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 11:47 AM To: [email protected] Subject: Re: Purging not releasing space ** Granted.. but the question becomes how often do you do it? On Wed, Nov 24, 2010 at 11:41 AM, Ramey, Anne <[email protected]<mailto:[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]<mailto:[email protected]>] On Behalf Of patrick zandi Sent: Wednesday, November 24, 2010 10:18 AM To: [email protected]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ -- Patrick Zandi _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ -- Patrick Zandi _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ -- Patrick Zandi _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"
