As it says on the Oracle XE overview page: Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user da. Oracle manages these files automatically when the database experience space pressure in Flash Recovery Area. In other words, when Flash recovery area gets to 85% filled, it would issue a warning, but continue to fill up FRA to %. As soon as FRA reaches %, oracle would start deleting these files from the oldest to make room for new files. Reclaiming Wasted Space. This section explains how to reclaim wasted space, and also introduces the Segment Advisor, which is the Oracle Database component that identifies segments that have space available for reclamation.



4 thoughts on “Reclaimable space oracle 11g

  1. I recommend to you to visit a site on which there is a lot of information on this question.

  2. I consider, that you are not right. I am assured. Let's discuss it. Write to me in PM, we will talk.

  3. Excuse for that I interfere … To me this situation is familiar. I invite to discussion. Write here or in PM.

Leave a Reply

Your email address will not be published. Required fields are marked *