Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 23, 2010 at 12:18 PM

    Hi, are you see warnings in Db13 t-code --> check database ?

    Explination of your "sizes" -->

    Size: 45,83 GB v --> the size is currently allocated in file system

    Total size: 156,25 GB the size is MAX calculeted (Your DB can grow up tothis size in file system) because the AUTOEXTEND are turned ON.

    Free Size: 9,16 GB --> really free space in DB now

    Total free size: 119,58 GB Free size --> total free autoextendable size ...

    Used: 80 % --> 45,83 DB, free 9,16 (20%) --> used 80% (36,67)

    Total used: 23 % --> Total (inc AUTOEXTEND) size are 156,25 (100%) --> used 36,67 == 23%

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.