How to stop a database growing in size on the disk
Any tips for stopping a database from growing.
Also a more specific question. Say I have some log table partitioned by month. The idea being I can keep pruning so that I only ever have two months of log data in the table. Say a month (one row per second) is 3 million rows. If I remove a partition with 3 million rows will that actually reduced the size the database takes up on the disk?
Subject
Written By
Posted
How to stop a database growing in size on the disk
July 30, 2013 03:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.