ࡱ> n("3n珸W8309cfFNn믇btLvG2֒D'] S%ڃbȆR1잶,O%2wSxU{TTšDyxo. Je>Dxxeѫ}>z$\ j?ػ4T&66G7nN:'4~m-ҶaqyKge`LM3ZVǫ96:g2<wƵ_=WmFz\lC} D~ݍz'`~ }wdr sh8\6ۿT&iqURQd1 %Ƀe=ߦܯ NFp88vM{]>cﱁE_,~ l'lM^WH6D. m{B?L/CLO ëC;£VAGz0-߸혶TL5nmX'eF^2ǖ#}ʚd`$:+z 7Ia-'t6t~qL^|6d/5۲OMc泟LNaGUp#F.:ޏxwLjweCItxL##,˯\Q)JW>z` l'z(Grn\ G0,KX5ďjS"pNOx :=k(TnFU#̭yk/-a6(5R?X XRkCcI#ݞktZ1_]]dN¦A;]FAMmܼ1g>;E':H'<&.}tye齛t`C[:DIrh^0P@z=njjZۦڑ zz?*{ 8L{dӆ@ ^†Ƀ30t؅yq6}NAa q} c:ڑ =+hg`GvUtt41 *L0j贱,wʤzo`Z5qG-nKhﯨc iSрz:=;zuN[%=O<ˆ-j[trݸ n:ƺmŧ<8<>=TX.yѥmXb548֛ߏF< FaS îFSd.fwrNJMK[S{H\!((EV9m#E/FCAܳv3DMllp=Y͊q9κEK]ĸ\n$X˼. pFQdOM@@p'zEt vsNdV|:Z >sGQM/d'>Ϲb4++[L 3 q\{&]aqK:ai貌&d2DW<1ILNLԛyj9Lj >J|b=ZHFB[,CLA7Lգy04l04&@, ,9- u 1,=ZwglSw}Z?lbuϛS`^.h9j0,afLЌ : 4+oWEnؙ+g'D/:qƾ 6xi`9kj&kX9Иjj&9];C94-caqE\ȫ%֦)(7``I!*"ؾ6(~W7*s E:*0}k߳ouxԘ{fC @nYtNXW'(*ÍhCճ`H1_f,nN{lx^e:QmOuW@S]Q= js=|Q(lA{\͂ʓJz&Rh=@=`z0Eo+4vާ*pUR{y|cr COca`L0M5}"Wek`2x4բIe|$s,$;xiLQ0A:m*5: ;hQ_\Ҁ4*?_f€8 #ا pN93Ӕ&)ׇŋqtiV631PkH[đ:D=}KODaq}#HA,ߍn,ۼB]TI"Br%ɴ slR|]ЊL~B$.έJWjU$U9Y t#[\s"K?.f:-n\YMyp]Fʄf=8MوQFt͇ԟ%KU]Ӣu>a*҆ԝGXzl4բ# PU >mb:'W[~_ Vz~ "6*syaqѐmVD9*wm+Q͈UЧ9j0Y޸]-55|_;(4 ᴞS;E@{ZjbQT:6MT|lCĪ'T-W'+b% wt0\Uh/)f/ yfE7,V/sPkH(1Ao_t+% /"R=F*' P.DL.t%臞"' fN>Tv" mn¶0xNU_)`.rVUҡ82DXljv2f&] ?M=I`_T7m*g@"GcA`r>Q8=Ԭ-9yMTAbXn" *{vqft,B D t!끕yc`᭼un^K.UF+#R—x>6{w7re j*h/Jm~Y2#}SI mQj [l1zʅ`V!:>"[=WV2P7*߱7ӲINkajk& c@<nE `|fka]dj<:CGr7U(ŖQ`hoUmUȶ[k*}@h,kř#B1Gұͩ 1?_G0ɍKE&@A=Ibw }Zf":ՇTNϦj4g]4k[.`Uғ9UTb;Fn{F `l{}{CuJ&!̴ \ ~_YT DLjdj}{Wbl@=-1,7޲Jݪ-sRPlwQ0y Pj^࿱(3yzrpV%IPѕS~"Ӑ2&yz+ƍa.ˈQpEvo|T7"hSpvpcdA#MS?xQpKRtX ?FL[*F?|tzޡ[]b* ߡs[;NxdE2LJ"wZ'd\Hm^~۪mbR~p^F]>,h[S\9Z87Q<;;0:\tQ ђ{=9V˺Κ,Y"bqKth.ZU_Ц,Ofk*ogNi}utF|DeN[Rtꦯ:cIuv$l]ʐOh AuUf9S^\TdMr74quUp]ϲC^@D!]{ѡwz_GG1nƚ*N㍱qh`jZ!,<ڪ.k q]zsK+X}r}]t'.AGh}QTl&.䗵NR=v|M!*aNC֧r/:NnmQ"*pZEG9PR~4@mBTsM̆DS9\lUԀTQlKR y0ixbg¨rUőW3M>5TbNڴYh5GЛ3x{0L>2SS8I djf@m0o[P:woU 6524?OmC_7 |d4UUQͨR<@'= Ƶtz,ҍ#M&~wuJnיo4=.^&i7}7 L'F6e XQb *oއb{Rl Jܾ9]KzޡwߍI-܃QUb9T6[la AI1N/^,Ӝ`E;MB`LDl<f992㱃I.6<ȖGA9ZQ8a]O!)`z%2f)r @2*r|g !Ip4ӅϥKt5m ַNly-UȤ-*>/{rN=~ng3)K P?IỉZlf'UNN˕Á{xpvyRj&@&l ~"+܃@MogC;G7D=tZGa#DZ)e&Uz2t64mU68#7TQt^!I0# `BB"o{BU0 tx%~6ak0Fs_09\ZUh1 ˕P.C=w*qIüf/%8F15v*g{v )y Oз='09ظ 2!lG;嗁$&>Y*&'{jrf ](_YYJ[eo(Cr`?dbsXe >c{5er}6p=>)^IDAT[э2{}c!8prtvfHm9 ?B3Rn>C04;qLUӐuo(f Z773yeRv{wc̛R8]7ӊx.ڝqM՞kpz\oyqSB~ҝ&;C?&C;C<n#IENDB`FXA%<4RaJFIFKKMSO Palette ȜͣЫӱЦӫ԰ֱ׶ٸԨױ׭ٶ۷ٰܼڷ۶ݸݼ޾߾޶“ȠʦƘ̥ͪϭʜˣΪϩѰȘЪЬҰΣѯӰԴ˙͝ϧЩҬҰ԰ΣϢЩѫҫҮ԰Դֶ͜ФШѩҧҬӰԭԯձմֱֳִ׵׸ѤөӬԯײПӨӫԨլհְֲֵ֬֯ׯײ׵سضظٶڷڻҠԪׯ׳״رٲٶڷں۹ۼܻԦիְ֭ذضٯٲٴٵٸڶܸܽݻݾ֦ת׭װرٲڱڵڶ۴۷۹ܹܻݸݹ޼߼٭ڱڴ۸ܷܹܻܵݷݻ޼޿߽٬ڱ۳۵ݷݸݺݻ޸޼޿߼۰ݴݷݹ޻߹߼߾ݱ޶޸߼C    ' .)10.)-,3:J>36F7,-@WAFLNRSR2>ZaZP`JQROC&&O5-5OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO"+!1AaQ"q2BbA ??5UkJRpHKRځI-3ʱy,o[e嶡x(^%+Ľ~`/$;wʀm74$]G}FgCDIo#dF='{c{:b mtIyƷ*o!ʪa.uN\Y\ʘ^Eݛh+&rD=OK},Oh}eUH?E𰯥-I0`s@ydTVKZN*{ DXsQʊv&V9_,بY;5O|e4K7đG{7ǙRa[X.!G2嶿0*ZHT!zrjDT+q6e>n<-h=WIpA-:uMz; r/\_i_w=?D1j״Qx>&Yd+ Y4śأqLd^PW} GP4z8zx8B<ʉO ZyEr[t+wN7O%Ѩ9% ,^$1&Pu.E{2OO;a7@LM1c >+T[bʉm7B^d/Urw [JnwUK:%cפ!o!bq);qq @[4ɻ*ӖO[by`ܛ9$ץiZcJkR1 P9PZWwzfn]-Rqc}T}r-*PT%n8w{)Q8y츖Th$-GB2@{gyĐ,55yt?Wsame sized extents (as in rollback segment)%$SEGMENT Types 8DATA segment INDEX segment ROLLBACK segment TEMP segment&% TablespaceLargest logical storage unit Has one or more datafile(s) where data is actually stored DBA can CREATE/ALTER/DROP Associated with one or more user(s) Each user MUST have one DEFAULT & one TEMPORARY tablespace'&TABLESPACE (Cont.)Size of a tablespace = sum of the datafiles To increase ADD datafile ONLY way to remove DATAFILE ----> DROP USER ...; Can take ONLINE/OFFLINE (except SYSTEM) Create separate for each segment type ('DatafileOne datafile is associated with ONE & ONLY ONE tablespace SIZE can be ALTERED after creation CANNOT be DROPPED on the fly For big database AUTOEXTEND ON MAX no/size of datafile is restricted by OS)(Syntax : Create TablespaceRCREATE TABLESPACE test DATAFILE  /data/oracle/test1.dbf SIZE 100M REUSE DEFAULT STORAGE (INITIAL 500K NEXT 1024K MINEXTENTS 2 MAXEXTENTS 50 PCTINCREASE 10) <TEMPORARY>;(( (((((((( (( (( (((4r*) Add DatafileALTER TABLESPACE  RBS ADD DATAFILE  /data/oracle/rbs4.dbf SIZE 100M;^G(((((((7 ,*Resize DatafileALTER DATABASE DATAFILE  /oracle/datafile/test.dbf RESIZE 100m;<F /  -+Autoextend DatafileAlter database datafile  /Data/oracle/test.dbf Autoextend on Next 100k <Maxsize 10m> <Unlimited>;Pz/ A.,To See Size of Datafile Select file_name  name , Sum(bytes)/1024/1024  size From sys.dba_data_files Group by file_name;xxQ$/-Tablespace SizeSelect sum(bytes)/1024/1024  size , Tablespace_name From sys.dba_data_files Group by tablespace_name;ssD,2/Estimate Table Size - Method 1 R Row/Data size from Table Structure(DDL) Table emp (name varchar2(30), salary number (8,2), join_date date); Step 1 : each row size ->20B + 6B + 7B = 43B Step 2 : estimated rows -> 10000 Step 3 : table size -> 43 * 10000B = 0.5 MB Step 4 : yearly growth rate -> 43 * 2000 = 100 KB Moral : Always be conservative P'K3'&, $3$3 ,/+30Estimate Table Size - Method 2: From Avg Row Size of existing Data Step 1 :Initial 40,Next 50,Extents 4,PctIncrease 50 Step 2 :Size : (90 + 50*1.5 + 50*1.5*1.5)= 287.5 Step 3 :Size with MaxExtents (121 for 2K DB Block) : It s a G.P. Series. S = Sum of N terms = [A(RN -1)/(R-1)] where A = NEXT; R = (100+PctIncrease)/100; N= (MAXEXTENTS - 1) => Total Size = ( S + INITIAL) Moral : Set PctIncrease Judiciously! $.+YzW zW zWOzW3<< $3$$3$3 t@ G  ^ ] 41Estimate Table Size - Method 3^Row/Data size from Analyzed table Info Step 1 :ANALYZE TABLE EMP ESTIMATE[COMPUTE] STATISTICS; Step 2 :SELECT (NUM_ROWS*AVG_ROW_LEN) FROM USER_TABLES WHERE TABLE_NAME =  EMP ;B&2K0.To Check Extent GrowthSelect substr(owner ||  . || segment_name,1,25)  object , Maxextents From sys.Dba_extents Where maxextents -extents <= 5 Order by extents; Will give you the segment which is approaching MAXEXTENTS:/15689:;<NQRSTUV W!X"Y#Z$[%\&]'^(PCustom Show 1b6.Custom Show 1]  ` @ ff3Ιd332z` @ ff3Ιd332z` 999MMM` fffPP3f>?" dd@,?4Zd@  d " @ ` n?" dd@   @@``@n?" dd@  @@``PV    @ ` `p>>K0 y (  F   `  0PPn  S >A A:\minispir.GIFlB  <g   H= 1Ȝ? p  T Click to edit Master title style! !   c $; p  RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S  c $T9 p    C* 2   c $; p    E*(2   c $U    E*(2Z  B޽h))?? @ ff3Ιd332z NotebookJ  ` `(   TF       XA StationeryPPn   S >A A:\minispir.GIF  < ?^~  T Click to edit Master title style! !  c $ 3    W#Click to edit Master subtitle style$ $  c $D ^#  C* 2f  c $ ^~#   E*(2f  c $ ~#  E*(2fZ  B޽h))?? @ ff3Ιd332zn 0 .&@X(  0&ؔ X X 0$ P    =*  X 0D     ?* d X c $ ?   X 0  @  RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S X 6d `P   =*  X 6 `   ?* H X 0޽h ? ̙33 04( x   0d P    =*   0     ?*   6 `P   =*   6$ `   ?* H  0޽h ? ̙33 G?P( F7,-@WAF x  c $ pp@  4  0pv  This presentation is supposed to give a simple and brief overview for storage calculations. THREE simple methods have been discussed for TABLE size calculation.(2   0q 0 %~ Nilendu Misra nilendu@innocent.com&&(2  zWB  s *޽h ? @ ff3Ιd332z  p$(  x  c $@`   l  C p  H  0޽h ? @ ff3Ιd332z*   $R(  $ $ C xxaxa1 ? p    $ C xxaxa1 ?p<$ 0  d $ <1?pd $ <1? d $ <1?xp $ ZTxaxa1?0@vN  Header Data $ ZRxaxa1? pM.  Row  $ ZOxaxa1?p   Free SpaceH $ 0޽h ? i(3e  $(  x  c $TQ p   l  C tRp  H  0޽h ? @ ff3Ιd332z  $(  x  c $D p   l  C Mp  H  0޽h ? @ ff3Ιd332z   $(   x  c $tL p   l  C Up  H  0޽h ? @ ff3Ιd332z  tl(    C x$xaxa1 ? p     C xxaxa1 ?p<$zW 0  H  0޽h ? i(3e  H@0(    C x$xaxa1 ? p     C x"xaxa1 ?p  H  0޽h ? i(3e  H@P( pI   C xD xaxa1 ? p     C xxaxa1 ?p  H  0޽h ? i(3e  $( #(p!  x  c $t p   l  C Ԇp  H  0޽h ? @ ff3Ιd332z  $(  x  c $ p   l  C Tp  H  0޽h ? @ ff3Ιd332z  $(  x  c $ԉ p   l  C 4p  H  0޽h ? @ ff3Ιd332z  $(  x  c $ p   l  C p  H  0޽h ? @ ff3Ιd332z   $(  x  c $ p   l  C p  H  0޽h ? @ ff3Ιd332z ! $(  x  c $4 p   l  C p  H  0޽h ? @ ff3Ιd332z "  $( s>T x  c $ p   l  C p  H  0޽h ? @ ff3Ιd332z # 0$( x x  c $t p   l  C ԏp  H  0޽h ? @ ff3Ιd332z $ @$(  x  c $4 p   l  C p  H  0޽h ? @ ff3Ιd332z % P$(  x  c $ p   l  C Tp  H  0޽h ? @ ff3Ιd332z & `$(  x  c $ p   l  C p  H  0޽h ? @ ff3Ιd332z ' p$(  x  c $ p   l  C p  H  0޽h ? @ ff3Ιd332z ( D( i@ l  C T p     C <$0  H  0޽h ? @ ff3Ιd332z(  P( h r  S `     S  <$0  H  0޽h ? @ ff3Ιd332z(  P(  r  S t p     S <$0  H  0޽h ? @ ff3Ιd332z   B(     B$XX? p   l  C p  H  0޽h ? @ ff3Ιd332z*  0   z ( w R  3 X     C X @   An extent is the allocation that is dedicated to any table, cluster, index, or rollback segment whenever (1) a segment is created or (2) a segment is required to grow because an insertion cannot be allocated into the existing allocation of space. A segment is a collection of extents that make up a single table,cluster, index, temporary segment, or rollback segment. Storage Parameters for a Segment : initial  the size of the segment s first extent. next  the size of the segment s next extent that will be allocated; the value of next is reset to the present value of next times (1+pctincrease/100) each time the segment gains a new extent. pctincrease  the percentage by which the (k+1)th extent s size exceeds that of the k th extent. minextents  the number of extents allocated to the segment at creation. maxextents  the maximum number of extents that can be allocated to the segment.o *M! 0 ( > FtK 0 $$ ? GH  0޽h ? ̙33 0 OG(  R  3 X   M  C $X @   In this session we are going to discuss the different storage structure, both physical(datafile etc) and logical (tablespace etc). Then we will discuss the storage parameters & how to manage them in Oracle. Finally we will see how to estimate space for a data segment. We will discuss three easy and practical methods to calculate table sizes. Oracle prescribed method (as in Oracle Server Administrator Guide Appendix) will not be followed because of its complexity. The implications for following the default while creating an object must be discussed elaborately. All discussion on Rollback Segment, including its sizing, will be discussed in the following session on Rollback Segment Management. During this session the instructor is supposed to show the storage parameters & structures through Enterprise Manager or Server Manager. This session will be followed by a quiz and a lab session which will take place simultaneously. ,W  )H  0޽h ? ̙33E 0 ( $@ R  3 X     C d!X @   An Oracle database block is the physical unit of storage in which all Oracle database data are stored in the database files. The Oracle database block size is determined by the setting of the instance parameter called db_block_size when the database is created. Because the block size of an Oracle database is a formatting definition, it cannot be changed simply by altering the value of db_block_size in the instance parameter file. If an Oracle Server administrator does make the decision to change the block size of a database, the only way to do so is to preserve the data(exp), rebuild the database (by issuing the create database), and then repopulate the database (imp).(">bH  0޽h ? ̙33 0 x ( h  R   3 X   ~   C !X @    H   0޽h ? ̙33 0 x( h R  3 X   ~  C "X @    H  0޽h ? ̙33 0 x ( 7 R  3 X   ~  C #X @    H  0޽h ? ̙33 0 x@( 7 R  3 X   ~  C  X @    H  0޽h ? ̙33 0 x`( |@|@ R  3 X   ~  C !X @    H  0޽h ? ̙330 0 xd( 7 dR d 3 X   ~ d C X @    H d 0޽h ? ̙33 0 xp( h pR p 3 X   ~ p C tX @    H p 0޽h ? ̙33" 0 xt( |@|@ tR t 3 X   ~ t C uX @    H t 0޽h ? ̙33# 0 xx( 7 xR x 3 X   ~ x C uX @    H x 0޽h ? ̙33$ 0 x|( 7 |R | 3 X   ~ | C TvX @    H | 0޽h ? ̙33% 0 x( 7 R  3 X   ~  C vX @    H  0޽h ? ̙33& 0 x( 7 R  3 X   ~  C wX @    H  0޽h ? ̙33' 0 x (  R  3 X   ~  C twX @    H  0޽h ? ̙33( 0 x0(  R  3 X   ~  C 4uX @    H  0޽h ? ̙33) 0 x@( pTH R  3 X   ~  C xX @    H  0޽h ? ̙33* 0 xP( |@|@ R  3 X   ~  C xX @    H  0޽h ? ̙33+ 0 x`(  R  3 X   ~  C TyX @    H  0޽h ? ̙33, 0 xp( |@|@ R  3 X   ~  C yX @    H  0޽h ? ̙33- 0 x( |@|@ R  3 X   ~  C zX @    H  0޽h ? ̙33/ 0 x( |@|@ R  3 X   ~  C tzX @    H  0޽h ? ̙33rT7A]QUJ]N_Ra HW0Vc:fh#@kmoqsuwyM{}ց^ڃ.I8P^&N~QF֯f.N޿n0 6^bOh+'0DR px (4 T ` l xStructure & Storage AnalysistNilendu MisraorNC:\Program Files\Microsoft Office\Templates\Presentation Designs\NOTEBOOK.POT\Nilendu Misraes32eMicrosoft PowerPointoso@4C@`L@ HYg@XI`xGPoM  P('& &&#TNPP0D & TNPP &&TNPP     'A x(xʦ """)))UUUMMMBBB999|PP3f3333f333ff3fffff3f3f̙f3333f3333333333f3333333f3f33ff3f3f3f3333f3333333f3̙33333f333ff3ffffff3f33f3ff3f3f3ffff3fffffffff3fffffff3f̙ffff3ff333f3ff33fff33f3ff̙3f3f3333f333ff3fffff̙̙3̙f̙̙̙3f̙3f3f3333f333ff3fffff3f3f̙3ffffffffff!___wwwKnnsJsKsnmKnsKnnKnnnrKnnnmnJsnrKmsmsnJKnnnJsKsnnKnnnKnKnnnmQnnnmnKsnÒsϼQnnnrKnPnsϠϼϽϙϼϠϚϚϙϽϙϽϙnJnQnnnnnÙÙϚϼϙϠϽϽϽϙϙϙϙϚϼϚϠϽϚϽϙϙϽϚϚϠϽÙnsnngJsmnšÚÙٚϚϙϼϼϙϼϽϙϽϙϙšÚÙٚnJnImJnnss３mJsÚÙ½ÙÚÙ½ÙϠÚϽÙ½ÙÚÙ½ÙÚÙ½ÙnsKmJDCCJÙJDCýÙýÚÙýÙýϽÚÙϽÙýÚÙýÙýÚÙýÙýÚÙnmnnJsKsnsÙCÚýÚýÚýÚýÚýKsKsnnnmK½ÙÚÚýý½ÙÚÚýý½ÙÚÚýý½ÙÚÚýý½ÙÚÚýýnmnJnPnnsýššÙÚýÙýššÙÚýÙýššÙÚýÙýššÙÚýÙýššÙÚýÙýšsKnsnnnnKÙàÙàÙàÙàÙànmKmDJmms½ÚÙ½ýÚÚÙ½ýÚÚÙ½ýÚÚÙ½ýÚÚÙ½ýKsnJJgJmnmJmýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ýüÚÙÙýýÚnmKnmJJJJsDCýüýÚÙýüýÚÙýüýÚÙýüýÚÙýüýÚQnsnJnnnnmJÚÙÙýüÚÙÙý"""""""""""""""""""""""ýüÚÙÙýünmKmsnPnns½ýÚښýÚÚ½ýÚښý"""½"ý""""""""""Ú""""ý"""""šýÚÚ½ýÚښýÚÚ½KnsnKnnmKýÚýýÚÙÚÙýÚýýÚÙÚÙý"""""""""""""""""""""""""""ÚÙÚÙýÚýýÚÙÚÙýnmKnrnKnnýÚýýüÚýýÚýýüÚý""ý"ýü"Úý""ÚýýüÚýýÚýýüÚýýKsnJDDmrnsýüüÙ½ýüüÙ"½""üüÙ"""½ýüüÙ½ýüüÙnnJmJDJDJsgInýýý½ýýýý½ýýýý½ýýýý½ýýýý½JnsmsnnmKÙsJCýښÙÙÙýښÙÙÙýښÙÙÙýښÙÙÙýښÙÙnnKnKmQnssýmmÚýýýýÚýýýýÚýýýýÚýýýýÚýýýKrnmsnnmnsÙÚÙÙÚÙÙÚÙÙÚÙÙÚÙnKnQnJsKnÙüÚýÙüÚýÙüÚýÙüÚýÙüÚýnsnmnnnnnsÙ½ýÙ½ýÙ½ýÙ½ýÙ½ýnJnJDImns""""""""""""""""""""""""""Ù"""""""""""""""""""""""""Ù""""""""""""""""""""""""""""""""""nsnJmDDJmsJCJ"""š""""""""""""""""""""Ú"""""""ý""""š""""""""""""""""nJnmnPnJnšsCm""""""""""""""""""""""""""""""""""š"""""Ú""""""""Ú"""""""""""""""""""""""""""""""""ښnsKsKnnsnssÚ"ý"Ú""Ú""""""Úý"½"ý½nnmnnrKnn½""½""""""""""""""""""½"½JnKrKnnJnsnsnnnsnnssÙÙÙ""ÙÙnKmJCCInssÚÙٚÚÙٚÚÙÙ""ÚÙٚÚÙٚnrnJnJnmK켙nCJÚ""""""""""""""""""""""""""""½"Ù""""""""""""Ù"""""""""""""Ú"""""""""""""""""""""""""""""ÙnKnKsmnQnsüsICmý"""""""""""""""""""""""""""ý"""""""""ý"""""""""""""""""""ÚÙnrnnnKsmnýns"""""""""""""""""""""""""""""""""""Ú"""""""""""""""""""""""""""""""""""""""""""""""ýnKnJsmKnns½ÙÚ"Úý"½ÙÚ"ý"""""½"ÙÚÚýý"½ÙÚ"ýý""½ÙÚÚýýnrnnnKsmKýššÙ"ýÙ"ýššÙÚý"""""""""""""""""""ÚýÙýš"ÙÚý"Ùý"šÙ"ÚýÙýšKnnKsmnnnÙàÙàÙàÙàÙànrKCDJrm½smÚÙ½ýÚÚÙ½ýÚÚÙ½ýÚÚÙ½ýÚÚÙ½ýKnnmQmnnnssmCCýüÚÙÙýý""½ýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ý"ÚÙÙýýÚnrKnnnQmnýsDIýüý""ÙýüýÚÙýüýÚÙýüýÚÙ""üýÚnKnnsJnnnsÚÙÙ"""""""""""Ú"""""""""""ý""""""""Ù"""""""""""""Ù""""""""""""""""""Ù""ýünrnQmnsJnÚ½ýÚښ"""""""""Ú"""""""""½"""Ú""""""""""ý"""Ú""""ý""""""""""ښýÚÚ½nKnnnKnnKýÚýýÚ""""""""""""""""""""""""Ú"""""""""ý""""""""""Ú""""""""""ý"""""Ù""""""""""""""""ÚÙÚÙýnsmJmnmJnÚýýüÚýý"ýýü""ýÚ"ýüÚýýÚý"ýüÚýýÚýýüÚýýmKnDJJmJmýüüÙ"ýüüÙ""½""üüÙ½ý""Ù½ýüüÙnnrnKsnrKsÙrJCJýýý½ýýýý½ýýýý½ýýýý½ýýýý½PnKrnmnKnDCýښÙÙ""ښÙÙÙýښ""""ÙýښÙ"ÙÙýښÙÙnnnKnQnmnsýýÚýýý""ÚýýýýÚý""""ýÚý""ýÚýýýnQmsnmnQnÙÚ"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""Ù""""""ÚÙnmKnKnnnnÙü""""""""""""""""""""""""Ú"""""""""""""Ú"""""""""""ÚýKnnmmmJCDýÙ"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""½ýnrKJDImrsJCsÙ""ÙÙÚÙÙÚÙ"ÙÚÙÙÚnKnsnsKnnsmCښ"""""ýښýښýÚ"ýښnrnJnmsnKšsCJÚÙښÚÚÙښÚÚÙښÚÚÙښÚÚÙښKnKnsnKmn½Úý½Úý½Úý½Úý½Úý½nrnnJnsnKs½½½½½½KnnnsnKmnnsJJDDDJÙÙÙÙÙmKnmJJmssCCÚÙٚÚÙٚÚÙٚÚÙٚÚÙٚnsKmnnsmQnJCnÚÙ½ÙÚÙ½ÙÚÙ½ÙÚÙ½ÙÚÙ½ÙKmnnQmKnnÙCIýÙýÚÙýÙýÚÙýÙýÚÙýÙýÚÙýÙýÚÙnsKnmnsJnýÚýÚýÚýÚýÚýJnmnsKnnný½ÙÚÚýý½ÙÚÚýý½ÙÚÚýý½ÙÚÚýý½ÙÚÚýýnsKnmnJnJýššÙÚýÙýššÙÚýÙýššÙÚýÙýššÙÚýÙýššÙÚýÙýšKnmJCDJmJÙàÙàÙàÙàÙànsJnJmmssnC"ÚÙ½ýÚÚÙ½ýÚÚÙ½ýÚÚÙ½ýÚÚÙ½ýJnnnsKnKnnICmýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ýüÚÙÙýýÚ½ýüÚÙÙýýÚnsJnmnsmnýDmÙýüýÚÙýüýÚÙýüýÚÙýüýÚÙýüýÚJnnnQmKnQüÚÙÙýüÚÙÙýüÚÙÙýüÚÙÙýüÚÙÙýünsJnnnsnn½ýÚښýÚÚ½ýÚښýÚÚ½ýÚښýÚÚ½ýÚښýÚÚ½ýÚښýÚÚ½KnnnmJCCCýÚýýÚÙÚÙýÚýýÚÙÚÙýÚýýÚÙÚÙýÚýýÚÙÚÙýÚýýÚÙÚÙýnmJJCDnsnÚýýüÚýýÚýýüÚýýÚýýüÚýýÚýýüÚýýÚýýüÚýýQnsnKmJrnsCýüüÙ½ýüüÙ½ýüüÙ½ýüüÙ½ýüüÙnmKmsnmnsÙmfIsýýý½ýýýý½ýýýý½ýýýý½ýýýý½nKsnnnQnKÙJnýښÙÙÙýښÙÙKKKښÙÙÙýÚKKÙÙÙýښÙÙnmnJsJnnnýýýÚýýýýÚýýýKKÚýýýýÚKýýýÚýýýsnQnnnmmJÙÚÙÙKKÚKÙÚÙnJnmDJDJÙüÚýÙKKKKKKKKKKKKKKKKKKKKKKKKýKKKKKKKKKKKKKKKKKKKKKKKKKüÚýnnnJJmsns뚼Ù½ýKÙKKKKKKKKÙKKKKKKKKKKKKKKKKÙ½ýnPnrnJnmsnC"ÙÚÙKKKKKKKKKKÙKKKKKKKKKKKKKKÙÙÚnnnKnnKsKsCCښýKÚKKKKKKKKKKKKKšKKKKKKKKKKKKKKKKKýښnPnrnJsmnšmsÚÙښÚKKÚKKKÚKKKKKKKKKKKKKKKKKKKKKKKÚÙښnnnKnnnnKÚý½ÚKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK½KKKÚý½nPnnJmDIC½½KK½KK½K½½nnnmmKmnnKKKKKnKmJJCsnJnÙKKKKÙKÙKKKÙrnQmKsJmnsC켚ÚÙٚÚÙٚÚÙٚÚÙٚÚÙٚnnnnnnnnQmCCÚÙ½ÙÚÙ½ÙÚÙ½ÙÚÙ½ÙÚÙ½ÙKmQmQmQnmÙnýÙýÚÙýÙýÚÙýÙýÚÙýÙýÚÙýÙýÚÙnnnnnnnJnýÚýÚýÚýÚýÚýnQmnJCJCJý½ÙÚýýÙÚýÚÚýýnmnJmnnnmýššÙÚKKKKKKKKKKKKKKKKKKKKKýKKKKKKKKKKKKKKKKKšKKKKKKKKKKKKKKKKKšKKKKKKÚýÙýšnsKmJImsnsmJÙKàKKKKKKKKàKKKKÙKKKàKKKKKKKKKKKKKKànJnnnKnsnnCCÚKÙ½KÚKKKKKK½KÚKKKÚKKKýKKKKKKKKÚKKKÚÙ½ýnnnQnrnJnJCýüÚÙÙKKKKKKKKKKýKK½KKKÙKýKýKKKKKKKKKKKK½KKKÙÙýýÚnPnmnKnnnýÙýüKKKKKKKKKKKKKKKKKKýKKKKKKKKKKKKKKKKKKKÚÙKKKüýÚnnnKnnmJDｽüÚÙÙKKKKKKKKKKÙKKKKKKKKKKKKÙKKKKKKKKKKKKKKKKKKKKKKKKKKüÚKKKKýünPnmJJJmJÚ½ýÚښýKÚK½ýÚښýÚÚ½ýÚÚKKÚ½ýÚKšýÚÚ½ýKKښýÚÚ½nnnJmnnKnýÚýýÚÙKKýýýÚÙÚÙýÚýýKKKÙýÚýýKÚÙÚÙýÚKKÚÙÚÙýnPnJJJmnJmÚýýüKKKKKýKýýüÚýýÚýýKKKKýýÚýýüÚýýÚýKKKýüÚýýnnnnnnrnsmC"ýüüÙ½ýüüÙ½ýüüÙ½ýüüÙ½ýüüÙnPnrKnKnnÙnCCýýý½ýýýý½ýýýý½ýýýý½ýýýý½nnKnnmmDJÒýښÙÙÙýښÙÙÙýښÙÙÙýښÙÙÙýښÙÙnrnJDJJnmýýýÚýýýýÚýýýýÚýýýýÚýýýýÚýýýKnmnsnmsKÙÚÙÙÚÙÙÚÙÙÚÙÙÚÙnnKIgJnnnÙüÚýÙüÚýÙüÚýÙüÚýÙüÚýrKrnKmnsrýDIÙ½ýÙ½ýÙ½ýÙ½ýÙ½ýnnnKrKsnnJCCÙÚÙÙÚÙÙÚÙÙÚÙÙÚnKrnnnmsJrDmýښýښýښýښýښnnKnPnKnnšÚÙښÚÚÙښÚÚÙښÚÚÙښÚÚÙښPnrnnnnPnÚý½Úý½Úý½Úý½Úý½nnKnPnnnn½½½½½½nKrnnrKnPnnrnnPnKrnnnnKnnnnnKnKnnnnnKnKrKrnrKrKrnrnPnPnrnnnnnKnnnnnKnnnnnKnn "--&TNPP &՜.+,D՜.+,    3On-screen ShowTCS  !Times New RomanMonotype Sorts Times-Roman;Times-Italic;Times-Times-Roman;Times-BoldTimes-Roman;Times-Italic Symbol;Times-Bold;Times-Roman;T Notebook'Primer on Structure & Storage Analysis Data Block Oracle BlockExtent & Segment Free Space Management : PCTFREEPctusedWhy Consider these Parameters?CONT.Designing ParametersRow Chaining EXTENT Calculation SEGMENT Types TablespaceTABLESPACE (Cont.) DatafileSyntax : Create Tablespace Add DatafileResize DatafileAutoextend DatafileTo See Size of Datafile Tablespace Size Estimate Table Size - Method 1 Estimate Table Size - Method 2Estimate Table Size - Method 3To Check Extent GrowthCustom Show 1  Fonts UsedDesign Template Slide Titles Custom Shows 6> _PID_GUIDAN{4AF1EE40-CCAE-11D1-AB41-0060973A30AD}%_* bNilendu Misra  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxy{|}~Root Entry2 dO)U lKdPicturesddU lAddd d*dCurrent User2   SummaryInformationd(ddztRPowerPoint Document2(NDocumentSummaryInformationd8dddddddddd