When I increase storage for Oracle database

[#1]

Hi, Gurus

We start and golive SAP one year ago, Now

my oracle databes usage is 68% like below from ST04.

Size: 308.09 GB Total size: 400.39 GB <br>

Free Size: 97.27 GB Total free size: 189.57 GB <br>

Used: 68 % Total used: 53 % <br>

This storage usage at UNIX level <br>

/dev/vx/dsk/eccprd-dg/sapdata1 100G 72G 26G 74% /oracle/PRD/sapdata1 <br>

/dev/vx/dsk/eccprd-dg/sapdata3 100G 80G 19G 82% /oracle/PRD/sapdata3 <br>

/dev/vx/dsk/eccprd-dg/sapdata4 100G 68G 30G 70% /oracle/PRD/sapdata4 <br>

/dev/vx/dsk/eccprd-dg/sapdata2 100G 89G 10G 90% /oracle/PRD/sapdata2 <br>

When I must increase storage size because it to much usage 90% ?

Or wait 90++ % all drive.

Thank for all comment.

[Former Member]

Based on database growth you may want to decide the strategy like fill level, size of the data file etc. If you are monitoring regularly then you can decide to add datafile once tablespace reaches to say 90%. You will get database growth trend also in your early watch reports.

Finally autoextend on saves the day though I would not suggest to wait until last minute. But make sure you have enough hard disk space (this is not a major worry recently as hardware is very cheap).