Oracle's simplest method of querying table space usage and remaining amount

Source: Internet
Author: User

It is much easier to write a long script than to use other views. It is said that it can be used from Oracle 7.x to 11g.

Sm $ ts_used & sm $ ts_free

Idle> select * from sm $ ts_used;

TABLESPACE_NAME BYTES
----------------------------------------
SYSAUX 256573440
UNDOTBS1 8323072
Users' 3211264
SYSTEM 506789888
Examples 71499776

Idle> select * from sm $ ts_free;

TABLESPACE_NAME BYTES
----------------------------------------
UNDOTBS1 23068672
SYSAUX 15990784
Users' 1966080
SYSTEM 6946816
Examples 33292288

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.