How to check the usage of the ASM disk space

Source: Internet
Author: User

We check whether the ASM disk space passes through the following routine:

Export Oracle_SID = + ASM1

By checking the v $ asm_diskgoup view, you can check the usage of the disk space as follows:
SQL> select group_number, name, total_mb, free_mb from v $ asm_diskgroup;

GROUP_NUMBER NAME TOTAL_MB FREE_MB
--------------------------------------------------------------
1 DATA 8032 2626
Today we found that through asmcmd, we can also achieve a lot of functions, a very bad one:
ASMCMD> ls
DATA/
As shown above, we can see the disk groups in the ASM instance, such as the connection usage between the database of the ASM instance disk group and the instance:

ASMCMD> lsct data
DB_Name Status Software_Version Compatible_version Instance_Name
Rac CONNECTED 10.2.0.4.0 10.2.0.1.0 rac1
After the-H parameter is added, the following information is displayed:
ASMCMD> lsct-H data
Rac CONNECTED 10.2.0.4.0 10.2.0.1.0 rac1
We can see that the-H parameter is removed from some of the above column information.
Lsdg can also be used to check the space usage of the disk groups in the ASM instance:
ASMCMD> lsdg data
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name

Mounted extern n 512 4096 1048576 8032 0 2626 0 DATA/

There are also the following methods:

ASMCMD> du data
Used_MB pai_used_mb
5312 5312
ASMCMD> ls-s
Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
512 4096 1048576 8032 2626 0 2626 0 DATA/


There are also the following common commands:
ASMCMD>?
Commands:
--------
Cd
Du
Find
Help
Ls
Lsct
Lsdg
Mkalias
Mkdir
Pwd
Rm
Rmalias
Of course, I will not list them one by one. When ORACLE 11g is reached, there are obviously many Parameter options in asmcmd:
ASMCMD>?
Commands:
--------

Md_backup, md_restore

Lsattr, setattr

Cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
Mkdir, pwd, rm, rmalias

Chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
Offline, online, rebal, remap, umount

Dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
Spmove, spset, startup

Chtmpl, lstmpl, mktmpl, rmtmpl

Chgrp, chmod, chown, groups, kgmod, lsgrp, lspwusr, lsusr
Mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr

Volcreate, voldelete, voldisable, volenable, volinfo

Volresize, volset, volstat

The rest will not be listed one by one.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12

Related Article

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.