Oracle Database Discussions

Hi Gurus,

I am a developer and not very clear with the routine checks a DBA does to keep the tablespaces up to date and verify db files frequently.

However, I have come up with a requirement to check few settings on TABLESPACES.

Could anyone help, how can I look for autoextend and maxsize parameter values in a given tablespace?

I googled but was not confident enough on what I got.

What do these parameters on a tablespace indicate?

Many Thanks,