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.