How to Trim Database Size?

Asked By Liezl Gomez 0 points N/A Posted on - 12/21/2011

My problem is about reducing the size of the database which is 6.5TB. Can someone help me on how to trim my database size? My data warehouse system is growing bigger and bigger. It has reached to an average growth of 500GB every month. It takes me 19 full hours for my RMAN to back up and save my data even though I already have enabled BLOCK_CHANGE_TRACKING_FILE. My bitmap indexes is there so it is useless to rebuild my indexes. Please help me. Thanks!

• Status: Open
• Question Views: 1336
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Crag fresh 0 points N/A #106032

How to Trim Database Size?

To reduce database file size, there are lots of things that you can try to do this, These are the things that I can suggest to you:

1.       Delete temporary files on your database.

2.       Delete any files that is not important or trash files, it will help you a lot cause not all files in the database is useful or important. Try to delete those files.

3.       Save your database to a utility program like archive program. It will reduce the database file size a lot.

4.       Produce or provide a database copy without the trash files on it.

Hope this helps your problem.

About Crag fresh

Questions
1

Answers
135

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 12/22/2011
• Question Category: Database