Database Administration (MOSC)

MOSC Banner

set autoextend threshold so that tablespace autoextends automatically after predefined limit

edited May 22, 2011 11:20PM in Database Administration (MOSC) 4 commentsAnswered
 created a bigfile tablespace using
CREATE BIGFILE DWSG_TBS
LOGGING DATAFILE '+DWSDG_DB1' SIZE 66680M
AUTOEXTEND ON NEXT 41200M
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

I have some UNLIMITED tablespace and some tablespace with MAXSIZE limit.
I have a monitoring script to monitor the size of tablespaces and ASM diskgroups.
For tablespace, the used=sum(bytes) in dba_data_files and free=sum(bytes) in dba_free_spaces.
This script generates alarm if the used is more than 75% of (used+free),
but at about 85% or so, oracle auto extends. Is there a fixed threshold when oracle decides to auto extend?

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