How to Find the free space in ASM Diskgroups? [ID 330414.1]
| 修改时间 28-JAN-2010 类型 HOWTO 状态 PUBLISHED | |||
In this Document
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2010***
Goal
How to Find the free space in ASM Diskgroups?Solution
The Following query can be used to find out the free space in ASM Diskgroups:
SQL:ASM>select name,total_mb,free_mb,state from v$asm_diskgroup;
In Oracle 10.2 ASMCMD> tool can be used to find the free space.
ASMCMD> du
du -Displays the total disk space occupied by ASM files in the specified ASM directory and all its subdirectories, recursively.
产品
| ||
相关的
返回页首来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/38267/viewspace-706788/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- How to recreate the SYS.ALERT_QUE [ID 430146.1]
- 11113
- How Nested Loop JOIN Works [ID 263517.1]
- How to Determine When PL/SQL Procedures Were Last Re-Compiled
- Extracting Datafile Blocks From ASM [ID 294727.1]
- How to find the highest undo segment number
- TRUNCATING A PARTITION WITH INDEXES [ID 292575.1]
- Tracing session created through dblink [ID 258754.1]
- 古董HP DL580 G3 Oracle 10G数据库故障解决
- DBA误操作 ODU救命记 （非广告）
