Resize bigfile tablespace
Hello,
Oracle 11.2, SE, no patches.
My bigfile TBS has about 2% of free space in TBS:
Tablespace Tbsp % Allocated Current Current File %
Name Free Filename GB Used GB Free GB Free
----------------- ------ ------------------------------------------------------------ ---------- ---------- ---------- ------
big_data 2.6 /opt/app/oracle/oradata/big_data.dbf 1,320.000 1,285.687 34.313 2.6
I want to expand it for another 100G:
alter tablespace big_data resize 1420G;
Database is quite heavily used and during resizing there will be impact as data file has to be locked. Any idea which impact can I expect ? Would be better if application will be stopped before ?
There is autoextend defined but I think it is better to have it under control and trigger in the time when db usage is not high.