Database Administration (MOSC)

MOSC Banner

Monitor Tablespace Autoextend Operations

edited Sep 8, 2016 5:01AM in Database Administration (MOSC) 4 commentsAnswered

Dear All,

on our System all tablespaces are auto extend off. Storage increase are handled manual.

Now we need to turn Auto-extend on for some datafiles in some tablespaces, and the question how to monitor this operation. is there a view where I could find info about the increase in a datafile, like the time when the extension is happened.

Why we need that, because we have to save this info and report it to mangers as a chart. "how the storage growth" "when the tbs was much increased" and so on.

And other question:

how the thresholds occur when auto-extend is on?

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