space usage WITH autoextend

[jonnyd]

Hi Tim,

Can you recommend an oracle approved script that can detail tablespace usage WITH autoextend taken into account?

Also, do you know if the tablespace usage part of grid control takes autoextend into account? I dont think it does.. Any ideas?

Best regards,

Jd

[Tim...]

Hi.

You can use one of these:

http://www.oracle-base.com/dba/script.p ... _space.sql
http://www.oracle-base.com/dba/script.p ... s_full.sql
http://www.oracle-base.com/dba/script.p ... _space.sql
http://www.oracle-base.com/dba/script.p ... _space.sql

They all take into account autoextend and max sizes, which I think it what you need.

Cheers

Tim...