Database Administration (MOSC)

MOSC Banner

Resize bigfile tablespace

edited Jul 20, 2020 3:09PM in Database Administration (MOSC) 5 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center