$BI=NN0h$N:[email protected]}K!(B

$B!!I=NN0h$N:n@.$9$k;~$N%N%&%O%&$K$D$$$F$^$H$a$F$"$j$^$9!#(B

$BI=NN0h$r:n@.!":o=|!"3HD%$9$kJ}K!(B

$BI=NN0h$r:n@.$9$kJ}K!(B

$B!!(BSVRMGR(SQL*DBA)$B$N(BSQL$B%3%^%s%I$G:n@.$7$^$9!#(B

SVRMGR# create tablespace TBS01 datafile 'tbs01.dbf' size 100M
  default storage (initial 50M next 50M minextents 1 maxextents 99 pctincrease 10) online;

$BI=NN0h$r:o=|$9$kJ}K!(B

$B!!(BSVRMGR(SQL*DBA)$B$N(BSQL$B%3%^%s%I$G:o=|8e!"(BUNIX$B$N(B rm$B%3%^%s%I$G:o=|$7$J$1$l$P$J$j$^$;$s!#(B
$B!!$3$N=g=x$r4V0c$($k$H!"%G!<%?%Y!<%9$r:F9=C[$9$k$7$+$"$j$^$;$s!#(B

SVRMGR# drop tablespace TBS01 including contents;

unix# cd ~oracle/dbs
unix# rm tbs01.dbf

$BI=NN0h$r3HD%$9$kJ}K!(B

$B!!I=NN0h$r3HD%$9$k$?$a$K$O!"(BSVRMGR(SQL*DBA)$B$N(BSQL$B%3%^%s%I$G!"%G!<%?%Y!<%9%U%!%$%k$rDI2C$7$^$9!#(B
$B!!0lEY3HD%$7$?I=NN0h$O!"=L>.$9$k$3$H$O$G$-$^$;$s!#(B
$B!!$b$7!"=L>.$9$k>l9g$O!"%(%-%9%]!<%H$7$F$+$i!"I=NN0h$r:F:n@.$9$kI,MW$,$"$j$^$9!#(B

SVRMGR# alter tablespace TBS01 add datafile 'tbs01.dbf' size 100M reuse;

$BI=NN0h$N0lMw$r;2>H$9$kJ}K!(B

$B!!I=NN0h$N0lMw$O!"0J2<$N(BSQL$BJ8$G;2>H$G$-$^$9!#(B

SVRMGR# select * from dba_tablespaces;

$B!!$^$?!"%G!<%?%Y!<%9%U%!%$%k$N0lMw$r;2>H$9$k$K$O!"0J2<$N(BSQL$BJ8$G;2>H$G$-$^$9!#(B

SVRMGR# select * from dba_data_files;

$BI=NN0h$N%5%$%:$r;2>H$9$kJ}K!(B

$B!!:n@.$7$?I=NN0h$N%5%$%:$r;2>H$9$k$K$O!"2<5-$N(BSQL$BJ8$G!"3F(Bdbf$B%U%!%$%k$N%5%$%:$rD4$Y$F9g7W$7$^$9!#(B

SVRMGR# select * from dba_data_files where tablespace_name='TBS01';

$B!!0J2<$N$h$&$K!"(BSQL$B4X?t$r;HMQ$7$F7W;;$9$k$3$H$b$G$-$^$9!#(B

SVRMGR# select sum(bytes) from dba_data_files where tablespace_name='TBS01';

$B!!$^$?!";HMQCf$N(BEXTENT$B$N%5%$%:$O!"0J2<$N(BSQL$B4X?t$r;HMQ$7$F7W;;$G$-$^$9!#(B $B$3$l$O!"(BEXTENT$B$N%5%$%:$J$N$G!"L$;HMQ%V%m%C%/$b4^$^$l$F$$$^$9!#(B

SVRMGR# select sum(bytes) from dba_extents where tablespace_name='TBS01';

$BNN0h%5%$%:$N7W;;J}K!(B

$BI=$N%5%$%:(B

$B!J#1!K%V%m%C%/%X%C%@$N%5%$%:(B

$B!!(BINITRANS=1$B$H$9$k$H%X%C%@It$N%5%$%:$O0J2<$N<0$H$J$j$^$9!#(B
$B!!(BR$B$O(B1$B%V%m%C%/Fb$N9T?t$rI=$7$^$9!#(B

$B!!(Bblock_header = block_header_a + block_header_b
$B!!(Bblock_header = 57 + 23 * INITRANS + 4 + 2R
$B!!(Bblock_header = 80 + (4 + 2R)

$B!J#2!K%G!<%?%V%m%C%/$"$?$j$KMxMQ2DG=$J%G!<%?NN0h$N%5%$%:(B

$B!!(BDB_BLOCK_SIZE=4096, PCTFREE=5$B$H$9$k$HMxMQ2DG=$JNN0h$O!"0J2<$N<0$H$J$j$^$9!#(B

$B!!(Bavailable_space = (4096-block_header) - (4096-block_header_a) * 5/100
$B!!(Bavailable_space = 3811 - 2R

$B!J#3!K%G!<%?NN0h%5%$%:!J%l%3!<%I%5%$%:!K(B

$B!!#O#R#A#C#L#E$N3F%G!<%?7?$NI,MW$J%5%$%:$r5a$a$^$9!#(B
$B!!2DJQD9$N%G!<%?$O!"BeI=CM$N%5%$%:$GBeMQ$7$^$9!#(B
$B!!Ns$N%G!<%?$,(B250$B%P%$%H$rD6$($kNs$O$[$H$s$I$J$$$b$N$H$7$^$9!#(B

$B!!(Bdata_space = $BNs(B1$B$N%5%$%:(B + $BNs(B2$B$N%5%$%:(B + ...

$B!!3FNs$N%5%$%:$O!"B0@-$K$h$C$F0J2<$NJ}K!$G5a$a$^$9!#(B

$B!!%l%3!<%I%5%$%:$r@53N$KCN$k$K$O!"N`;w$7$?%G!<%?$rEPO?$7$?%F%9%H4D6-$r:n@.$7$FD4$Y$^$9!#(B
$B!!N`;w%G!<%?$,$J$$>l9g$O!"BeI=CM$rEPO?$7$FD4$Y$k$3$H$b$G$-$^$9!#(B
$B!!%l%3!<%I%5%$%:$O0J2<$NLd$$9g$o$;$GD4$Y$k$3$H$,$G$-$^$9!#(B

$B!!!!(BSQL> SELECT AVG(NVL(VSIZE(col1),1) + AVG(NVL(VSIZE(col2),1) + ... FROM$B!!I=L>(B;

$B!J#4!K9T%5%$%:(B

$B!!(Bavg_row_size = 3 +$B!!Ns?t!!(B+ data_space

$B!J#5!K#1%V%m%C%/$"$?$j$N9T?t(B

$B!!(BR = available_space / max(avg_row_size, 9)
$B!!(BR = (3811 - 2R) / max(avg_row_size, 9)
$B!!(BR = 3811 / (max(avg_row_size, 9) + 2)

$B!J#6!K%V%m%C%/?t$H%P%$%H?t(B

$B!!%V%m%C%/?t$H%P%$%H?t$O!"0J2<$N<0$H$J$j$^$9!#(B
$B!!(Brows$B$O!"I=Fb$NA49T?t$rI=$7$^$9!#(B

$B!!(Bblocks_for_table = rows / R
$B!!(Bbytes_for_table = blocks_for_table * 4096

$B:w0z$N%5%$%:(B

$B!J#1!K%V%m%C%/%X%C%@$N%5%$%:(B

$B!!(BINITRANS=2$B$H$9$k$H%X%C%@It$N%5%$%:$O0J2<$N<0$H$J$j$^$9!#(B

$B!!(Bblock_header = 113 + 23*INITRANS
$B!!(Bblock_header = 159

$B!J#2!K%G!<%?%V%m%C%/$"$?$j$KMxMQ2DG=$J%G!<%?NN0h$N%5%$%:(B

$B!!(BDB_BLOCK_SIZE=4096, PCTFREE=5$B$H$9$k$HMxMQ2DG=$JNN0h$O!"0J2<$N<0$H$J$j$^$9!#(B

$B!!(Bavailable_space = (4096-block_header) - ((4096-block_header)*(5/100))
$B!!(Bavailable_space = 3740

$B!J#3!K%G!<%?NN0h%5%$%:!J%l%3!<%I%5%$%:!K(B

$B!!I=$N>l9g$HF1MM$K5a$a$^$9!#(B

$B!J#4!K9T%5%$%:(B

$B!!(Bavg_entry_size = 8 +$B!!Ns?t!!(B+ data_space

$B!J#5!K#1%V%m%C%/$"$?$j$N9T?t(B

$B!!(BR = available_space / avg_entry_size
$B!!(BR = 3740 / avg_entry_size

$B!J#6!K%V%m%C%/?t$H%P%$%H?t(B

$B!!%V%m%C%/?t$H%P%$%H?t$O!"0J2<$N<0$H$J$j$^$9!#(B
$B!!(Bnot_null_rows$B$O!"I=Fb$N(BNULL$B$G$J$$9T?t$rI=$7$^$9!#(B

$B!!(Bblocks_for_index = 1.05 * not_null_rows / R
$B!!(Bbytes_for_index = blocks_for_index * 4096

REDO$B%m%0%U%!%$%k$N%5%$%:(B

$B!!(BREDO$B%m%0%U%!%$%k$N%5%$%:$O!"$I$N$h$&$JCM$G$bF0:n$7$^$9$N$G!"%G%U%)%k%H$G$b==J,$G$9!#(B
$B!!(BREDO$B%m%0%U%!%$%k$N%5%$%:$r5a$a$k7W;;<0$O$"$j$^$;$s!#(B
$B!!(BREDO$B%m%0%U%!%$%k$rBg$-$/$9$k$H!"%j%+%P%j$K;~4V$,$+$+$j$^$9!#(B
$B!!(BREDO$B%m%0%U%!%$%k$r>.$5$/$9$k$H!"%A%'%C%/%]%$%s%H$,IQHK$KH/@8$7$^$9!#(B

$B%m!<%k%P%C%/%;%0%a%s%H$N%5%$%:(B

$B!!%m!<%k%P%C%/%;%0%a%s%H$N%5%$%:$O!"0lHLE*$J%H%i%s%6%/%7%g%s$N%5%$%:$K$h$C$F7h$^$j$^$9!#(B
$B!!Bg$-$J%H%i%s%6%/%7%g%s$N>l9g$O!"%m!<%k%P%C%/%;%0%a%s%H$N%5%$%:$OBg$-$$J}$,!"%Q%U%)!<%^%s%9$O8~>e$7$^$9!#(B
$B!!>.$5$J%H%i%s%6%/%7%g%s$,B??t$"$k>l9g$O!">.$5$J%m!<%k%P%C%/%;%0%a%s%H$,B??tB8:_$9$kJ}$,!"%Q%U%)!<%^%s%9$,8~>e$7$^$9!#(B

$B%F%s%]%i%j%;%0%a%s%H$N%5%$%:(B

$B!!%F%s%]%i%j%;%0%a%s%H$N%5%$%:$O!"%=!<%H$9$k%G!<%?$NJB$S$K$h$C$F0[$J$j$^$9$,!"0lHLE*$K$O!"%=!<%H$9$k%-!<9`L\$N%5%$%:$N(B1.3$BG\$N%5%$%:$,I,MW$H$J$j$^$9!#(B