DB02 showing 80% full data where as full file system is empty
In DB02 transaction of my BW production server i'm getting following entry on Database tab:
DB system: ORA
Size: 45,83 GB Total size: 156,25 GB
Free Size: 9,16 GB Total free size: 119,58 GB
Used: 80 % Total used: 23 %
where as in file system i have hardly any space filled.
Now what does this 80% used signifies?
Where does my data goes while data loading? Does it goes in this module? if so then during next dataload my database will be full?
Sergo Beradze replied
I'm starting to tire) ...
DB02 --tablspaces --> overwiev --> shows for your PSAPSR3 (TOTAL SIZE) = 40 GB i'm right ? Allocated are 24460 -->
Sum of all fre fragments --> 15353 this size are currently free with the approach.
Per your history you will use your PSAPSR3 last month rather actively, your DB grow from
06.02.2010 = 18940
06.21.2010 = 23480
Somewhere about 7Gb per month ...
This means with the approach your Remaining 15GB enough for 2 months, but you can add more datafiles In order to not think about it. Regards.