http://www.emigar.com/wiki/index.php?action=history&feed=atom&title=Oracle_ASM
Oracle ASM - Cronologia
2026-04-07T21:00:41Z
Cronologia della pagina su questo sito
MediaWiki 1.39.0
http://www.emigar.com/wiki/index.php?title=Oracle_ASM&diff=5111&oldid=prev
WikiSysop: Creata pagina con ' =script per controllo spazi= <pre> #!/bin/sh ORACLE_SID=+ASM ORAENV_ASK=NO export ORACLE_SID ORAENV_ASK . oraenv unset ORAENV_ASK sqlplus -s '/ as sysdba' << EOF --desc v\$asm…'
2010-12-13T19:14:22Z
<p>Creata pagina con ' =script per controllo spazi= <pre> #!/bin/sh ORACLE_SID=+ASM ORAENV_ASK=NO export ORACLE_SID ORAENV_ASK . oraenv unset ORAENV_ASK sqlplus -s '/ as sysdba' << EOF --desc v\$asm…'</p>
<p><b>Nuova pagina</b></p><div><br />
=script per controllo spazi=<br />
<pre><br />
#!/bin/sh<br />
<br />
ORACLE_SID=+ASM<br />
ORAENV_ASK=NO<br />
export ORACLE_SID ORAENV_ASK<br />
. oraenv<br />
unset ORAENV_ASK<br />
<br />
sqlplus -s '/ as sysdba' << EOF<br />
--desc v\$asm_diskgroup<br />
--desc v\$asm_disk<br />
<br />
set pagesize 200<br />
set linesize 200<br />
<br />
<br />
col PATH for a30<br />
select d.NAME NAME<br />
,d.HEADER_STATUS HEADER_STATUS<br />
,d.STATE STATE<br />
,d.TOTAL_MB TOTAL_MB<br />
,d.FREE_MB<br />
,d.PATH PATH<br />
from v\$asm_disk d<br />
where d.GROUP_NUMBER=0;<br />
<br />
select g.NAME GROUPNAME<br />
,d.NAME NAME<br />
,d.HEADER_STATUS HEADER_STATUS<br />
,d.STATE STATE<br />
,d.TOTAL_MB TOTAL_MB<br />
,d.FREE_MB<br />
,d.PATH PATH<br />
from v\$asm_disk d, v\$asm_diskgroup g<br />
where d.GROUP_NUMBER=g.GROUP_NUMBER<br />
and d.GROUP_NUMBER!=0;<br />
<br />
select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,OFFLINE_DISKS,UNBALANCED<br />
from v\$asm_diskgroup;<br />
EOF<br />
<br />
</pre></div>
WikiSysop