Rajat, Your DBA can give you a list of the largest tables in your environment; however, we have seen these tables grow ginormously in ours: T587 NTE:Notifier Log T2013 EIE:Log T24 AR System Searches Preference T69 Email Error Logs T586 NTE:Notifier T590 NTE:SYS Individual NT Control T1084 HPD:Help Desk T1067 HPD:Help Desk AuditLog
Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM & ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 [email protected]<mailto:[email protected]> http://its.state.nc.us<http://its.state.nc.us/> 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 rajat sharma Sent: Tuesday, November 23, 2010 5:10 AM To: [email protected] Subject: Re: Purging not releasing space ** 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 ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
