... d.usedmb_kfdsk)
from
x$kfdsk d
where
g.number_kfgrp = d.grpnum_kfdsk)
from
x$kfgrp g
where
state_kfgrp ... 3, 'HIGH'), (
select
sum (d.totmb_kfdsk)
from
x$kfdsk d
where
g.number_kfgrp = d.grpnum_kfdsk),
(
select ...
... k.bytesw_kfkid -- BYTES_WRITTEN NUMBER from
x$kfdsk d,
x$kfkid k
where
d.mntsts_kfdsk != 0 and d.kfkid_kfdsk ...
... k.bytesw_kfkid -- BYTES_WRITTEN NUMBER from
x$kfdsk d,
x$kfkid k
where
d.mntsts_kfdsk != 0 and d.kfkid_kfdsk ...
http://www.dba-oracle.com/o10g_v_dollar_asm_views.htm
Similar Pages
... Table v$ View X$KFGRP V$ASM_DISKGROUP X$KFGRP_STAT V$ASM_DISKGROUP_STAT X$KFDSK V$ASM_DISK X$KFKID V$ASM_DISK ... V$ASM_DISK X$KFDSK_STAT V$ASM_DISK_STAT X$KFKID V$ASM_DISK_STAT X$KFFIL V$ASM_FILE X$KFALS V$ASM_ALIAS X$KFTMTA ... V$ASM_TEMPLATE X$KFNCL V$ASM_CLIENT X$KFGMG V$ASM_OPERATION X$KFENV V$ASM_ATTRIBUTE X$KFNSDSKIOST V$ ...
... k, 256), 256, 'QUORUM', 'REGULAR')
from
x$kfdsk d,
x$kfkid k
where
d.mntsts_kfdsk != 0 and d. ...
http://www.dba-oracle.com/t_oracle_asm_dictionary_tables.htm
Similar Pages
... Lists the diskgroups V$ASM_DISK (made from X$KFDSK and X$KFKID): Contains disk details and usage statistiocs ... from X$KFGRP): performs disk discovery and lists diskgroups V$ASM_DISKGROUP_STAT (made from X$KFGRP_STAT): ... disk discovery). V$ASM_DISK_STAT (made from X$KFDSK_STAT and X$KFKID): Contains disk details and usage ...
... View X $ KFGRP V $ ASM_DISKGROUP X $ KFGRP_STAT V $ ASM_DISKGROUP_STAT X $ KFDSK V $ ASM_DISK X $ KFKID ... ASM_DISK X $ KFDSK_STAT V $ ASM_DISK_STAT X $ KFKID V $ ASM_DISK_STAT X $ KFFIL V $ ASM_FILE X $ KFALS ... ASM_ALIAS X $ KFTMTA V $ ASM_TEMPLATE X $ KFNCL V $ ASM_CLIENT X $ KFGMG V $ ASM_OPERATION X $ KFENV V ...
http://www.routingswitching.com/vasm_diskgroup-displays-information-from-the-header-of-asm-disks/
Similar Pages
... , STATE_KFDSK, ASMNAME_KFDSK, PATH_KFDSK from x$KFDSK; Then I queried ASM_DISKGROUPS parameter : SQL> ... of V$ASM_DISKGROUP to know which X$ table stand behind it and got – X$KFGRP SQL> set autotrace on SQL> ... V$ASM_DISKGROUP view: Query X$KFGRP view: SQL> select NAME_KFGRP from X$KFGRP; NAME_KFGRP —————————— ...
http://www.juliandyke.com/Internals/FixedTables/FixedTables.html
Similar Pages
... X$KFCLLE X$KFDAT X$KFDDD X$KFDFS X$KFDPARTNER X$KFDSK X$KFDSK_STAT X$KFENV X$KFFIL X$KFFXP X$KFGBRB X$KFGMG ... X$KCBWBPD X$KCBWDS X$KCBWH X$KCCACM X$KCCAGF X$KCCAL X$KCCBF X$KCCBI X$KCCBL X$KCCBLKCOR X$KCCBP X$KCCBS X$KCCCC ... X$KCCCC X$KCCCF X$KCCCP X$KCCDC X$KCCDFHIST X$KCCDI X$KCCDI2 X$KCCDL X$KCCFC X$KCCFE X$KCCFLE X$KCCFN X$KCCIC ...
http://www.toadworld.com/platforms/oracle/b/weblog/archive/2014/01/17/v-asm-diskgroup-displays-information-from-the-header-of-asm-disks.aspx
Similar Pages
... , STATE_KFDSK, ASMNAME_KFDSK, PATH_KFDSK from x$KFDSK; Then I queried ASM_DISKGROUPS ... of V$ASM_DISKGROUP to know which X$ table stand behind it and got – X$KFGRP SQL> set autotrace on SQL> ... V$ASM_DISKGROUP view: Query X$KFGRP view: SQL> select NAME_KFGRP from X$KFGRP; NAME_KFGRP —————————— ...