Power Star Posted January 21, 2013 Report Posted January 21, 2013 impdp struck ayyindi ippudu question enti ante e procees kill chesi table_exists_action=append petti start chesthe workout avutada ?? already vunna data corrupt avvakunda leni data insert chestundaaa ??
Joey_Tribbiani Posted January 21, 2013 Report Posted January 21, 2013 malli table drop chesi impp start chei bhayya , better and clean way
Power Star Posted January 21, 2013 Author Report Posted January 21, 2013 [quote name='Joey_Tribbiani' timestamp='1358794168' post='1303146503'] malli table drop chesi impp start chei bhayya , better and clean way [/quote] time ledu bhayya schema import chestuna 140 GB size already 32 hours ayyindi
Gachibowli_Diwakar Posted January 21, 2013 Report Posted January 21, 2013 stuck aindhi ani ela chepthunnav ? dba privileges unte .. v$session view lo chudu status also, keep doing count(*) from table .. count increase aithe it is doing the job ani moreover, when you load data using impdp .. better use exclude=statistics .. import aipoyaka.. statistics gather cheyi for that table ..
Joey_Tribbiani Posted January 21, 2013 Report Posted January 21, 2013 [quote name='BOY' timestamp='1358794254' post='1303146517'] time ledu bhayya schema import chestuna 140 GB size already 32 hours ayyindi [/quote] PArallel threads increase chei bhayya , PARALLEL=10 ala add chei bhayya ..
Gachibowli_Diwakar Posted January 21, 2013 Report Posted January 21, 2013 impdp tho u can attach the job .. for example nuvu initial ga parallel em use cheyakapothe .. job attach chesi parallelism increase cheyi google it for further instructions about how to add parallelism to existing job
Power Star Posted January 21, 2013 Author Report Posted January 21, 2013 [quote name='Silence..Please' timestamp='1358794334' post='1303146530'] stuck aindhi ani ela chepthunnav ? dba privileges unte .. v$session view lo chudu status also, keep doing count(*) from table .. count increase aithe it is doing the job ani moreover, when you load data using impdp .. better use exclude=statistics .. import aipoyaka.. statistics gather cheyi for that table .. [/quote] [quote name='Joey_Tribbiani' timestamp='1358794387' post='1303146540'] PArallel threads increase chei bhayya , PARALLEL=10 ala add chei bhayya .. [/quote] [quote name='Silence..Please' timestamp='1358794411' post='1303146542'] impdp tho u can attach the job .. for example nuvu initial ga parallel em use cheyakapothe .. job attach chesi parallelism increase cheyi google it for further instructions about how to add parallelism to existing job [/quote] already parallel =16 vundi daani valla emmana problem a partition and lob data vundi dmp loo
Power Star Posted January 21, 2013 Author Report Posted January 21, 2013 [quote name='Silence..Please' timestamp='1358794334' post='1303146530'] stuck aindhi ani ela chepthunnav ? dba privileges unte .. v$session view lo chudu status also, keep doing count(*) from table .. count increase aithe it is doing the job ani moreover, when you load data using impdp .. better use exclude=statistics .. import aipoyaka.. statistics gather cheyi for that table .. [/quote] konni locks and blocking sessions vunay impdp jobs lo vaatini clear chedam ante impdp kill avutadi ani waiting
Gachibowli_Diwakar Posted January 21, 2013 Report Posted January 21, 2013 [quote name='BOY' timestamp='1358794522' post='1303146559'] already parallel =16 vundi daani valla emmana problem a partition and lob data vundi dmp loo [/quote] lob data will take time .. count check chesthunava ? num of rows increase authondha table dhi from time to time ?
Power Star Posted January 21, 2013 Author Report Posted January 21, 2013 [quote name='Silence..Please' timestamp='1358794605' post='1303146573'] lob data will take time .. count check chesthunava ? num of rows increase authondha table dhi from time to time ? [/quote] avvatam ledu last 7 hours nunchi not moving hour ki 100 MB ala load avutundi anthe
Gachibowli_Diwakar Posted January 21, 2013 Report Posted January 21, 2013 [quote name='BOY' timestamp='1358794682' post='1303146589'] [b]avvatam ledu last 7 hours nunchi[/b] not moving [b]hour ki 100 MB ala load avutundi anthe[/b] [/quote] rendu points contradictory ga unnaay
Power Star Posted January 21, 2013 Author Report Posted January 21, 2013 [quote name='Silence..Please' timestamp='1358794714' post='1303146596'] rendu points contradictory ga unnaay [/quote] ante pedda improvement em ledu ani bhayya imp log file lo noo movement from last 7 hours TS lo chustunte lite ga increment vundi datafile size loo antunaa
Power Star Posted January 21, 2013 Author Report Posted January 21, 2013 Thanks all man oracle vaaddu parallel=1 ki reduce cheyyamandu will test that edo bug antaa e oracle gadini
Recommended Posts