Oracle question about tablespaces

I want to know if it's possible to know the memory space reserved and used

from a tablespace of Oracle.

I'm working with a UNIX server. I access the database via sqlplus and I want

to know if there's ant system table with information about the memory reserved

for a tablespace.



Thanks.



Nauj


Comments

  • select sum(bytes/1048576)

    from dba_extents;

    give s u r table space size









    : I want to know if it's possible to know the memory space reserved and used

    : from a tablespace of Oracle.

    : I'm working with a UNIX server. I access the database via sqlplus and I want

    : to know if there's ant system table with information about the memory reserved

    : for a tablespace.

    :

    : Thanks.

    :

    : Nauj

    :












Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories