Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB02 showing 80% full data where as full file system is empty

hi all,

In DB02 transaction of my BW production server i'm getting following entry on Database tab:

Name DEFAULT

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?

kindly help.

Regards,

Priya

Former Member
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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question