Filesystem space with autoextend on

[Former Member]

Hi,

Is there a view of used space when all datafiles with autoextend on reach maximum size?

Like in RZ20, the MTE <instance> - OperatingSystem - Filesystems, but with datafiles full.

For example the monitor Oracle - <SID> - Space management - Tablespaces - <TS> - Used space, shows that "virtual" used space. Or like DB02 that shows both "Used" and "Total used".

To add new datafiles this information is very welcome, because you don't know which filesystem will have more free space...

Thanks!

Aitor

[paul_power]

Hi Aitor,

I am not sure I understand your question exactly but if you go to transaction DBACOCKPIT -> space -> overview

does this show you the information about how much space is used that you are looking for?

It should show percentage used for each tablespace and you can see a breakdown of each datafile.

Hope this helps,

Paul

[Former Member]

Thanks Paul, but I'm looking for used space at filesystem level, but using the MAXSIZE of each datafile if autoextensible or else file size.