Oracle Database Discussions

Hi All,

I was using temp tablespace query , and was using maxbytes column to check till what size the tempfile can grow.

But MAXBYTES is showing different than expected, showed 8GB ( I was expecting it to be 32GB)

I resize one of the tempfile to 30 GB & then again checked the maxsize for same tempfile.

Yet maxbytes didnt showed me 30GB.

Note : I also checked using MAXBLOCKS*BLOCK_SIZE .. but result was not 30GB.

If Maxbytes doesnt show the range till which file can grow ,then what other views/columns are to used?

Please guide.

Thanks,

Pranay Kamble.