Granted.. but the question becomes how often do you do it? On Wed, Nov 24, 2010 at 11:41 AM, Ramey, Anne <anne.ra...@nc.gov> 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: > arsl...@arslist.org] *On Behalf Of *patrick zandi > *Sent:* Wednesday, November 24, 2010 10:18 AM > > *To:* arslist@ARSLIST.ORG > *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 <rajatcome...@gmail.com> > 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 <remedy...@gmail.com> > 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 <rajatcome...@gmail.com> > 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"_ > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
