 | | | DWH loading : Do you use 2 types of tablespaces ? | DWH loading : Do you use 2 types of tablespaces ? 2004-06-01 - By NGUYEN Philippe (Cetelem)
Thanks for your reponses :
1. Dareell : I do 'alter move ' 2 or 3 times and it works=== > COOL !!
2. Ryan : my table is set with pctused 99 and pctfree 1 but as my ETL
(PX+Dastage) is using parallel loaders (x4) with Direct Path I suppose that
each nodes used new extents for its loading. So we waste space.
3. Dennis : is it a bests practises doing so ? (I mean using 2 type of tbs
?)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN " >
<HTML >
<HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<META NAME= "Generator " CONTENT= "MS Exchange Server version 5.5.2657.73 " >
<TITLE >RE: DWH loading : Do you use 2 types of tablespaces ? </TITLE >
</HEAD >
<BODY >
<P > <FONT SIZE=2 >Thanks for your reponses : </FONT >
</P >
<P > <FONT SIZE=2 >1. Dareell : I do 'alter move ' 2 or 3 times and it works===> COOL !! </FONT >
<BR > <FONT SIZE=2 >2. Ryan : my table is set with pctused 99 and pctfree 1 but as my ETL (PX+Dastage) is using parallel loaders (x4) with Direct Path I suppose that each nodes used new extents for its loading. So we waste space. </FONT > </P >
<P > <FONT SIZE=2 >3. Dennis : is it a bests practises doing so ? (I mean using 2 type of tbs ?) </FONT >
<BR > <FONT SIZE=2 > </FONT >
</P >
</BODY >
</HTML >
|
|
|