KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='bmwx3' timestamp='1359400627' post='1303190917'] try TOP command and take statspack as well [/quote] top comman try cheste edi 100% cpu chupivtam ledhu bhayya nenu question tapu adigano meku ardham vera laga ayindo
Joey_Tribbiani Posted January 28, 2013 Report Posted January 28, 2013 OEM lo ki login ayyi top consumer lo em SQL chuistundi bhai
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Joey_Tribbiani' timestamp='1359401587' post='1303190989'] OEM lo ki login ayyi top consumer lo em SQL chuistundi bhai [/quote] http://www.unix.com/solaris/122757-100-memory-usage-prstat.html chusa bhayya akkada akkada malli top services,top modules,top actions,top clients,top sessions unnai bhayya top clients lo unamed 98.9% anta adi enti??
Joey_Tribbiani Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359401726' post='1303191009'] [url="http://www.unix.com/solaris/122757-100-memory-usage-prstat.html"]http://www.unix.com/...age-prstat.html[/url] chusa bhayya akkada akkada malli top services,top modules,top actions,top clients,top sessions unnai bhayya top clients lo unamed 98.9% anta adi enti?? [/quote] daani PID unte server lo ps- ef | grep -i "PID" chudu .. em process oo telustaadi
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Joey_Tribbiani' timestamp='1359402117' post='1303191052'] daani PID unte server lo ps- ef | grep -i "PID" chudu .. em process oo telustaadi [/quote] oracle chupistundi bhayya ash report run chesa andulo top session vachi rman undi? ASH report edi chudali??
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='gundugadu' timestamp='1359403048' post='1303191176'] ltt [/quote] thanks bhayya
CheGuevara Posted January 28, 2013 Report Posted January 28, 2013 actual error ento paste cheyyagalava
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='CheGuevara' timestamp='1359406777' post='1303191390'] actual error ento paste cheyyagalava [/quote] bhayya error enti ante actual error ento naku teliyadhu..users database ki connect avalekha poyaru ani email chesaru,so nenu veli processor chudam ani prstat -avm echa adi bottom lo top 5 user processor plus memory estundi so,andulo 0racle 100% undi appuddu nenu rman jobs run avuthunde oka full di adi kill chesaka.appudu vala ki issue em rale so a oracle memory 100% inka alane undi,ednuku undenaku teliyadu but e user entha cpu_usage_seconds lo sysman ekkav 90 above chupichindi so ippudu adi enduku ala ayindi ani ASH report run chesa andulo kuda top sessions rman e chupistundi(em chudale naku antha idea ledhu) top processes chudataniki top commadn prstat kakunda inka em ayinda commands unnai? prstat -avm este oracle 100% chupitundi adi normal aa enduku ala? [url="http://www.unix.com/solaris/122757-100-memory-usage-prstat.html"]http://www.unix.com/...age-prstat.html[/url]
subbayya Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359407453' post='1303191423'] bhayya error enti ante actual error ento naku teliyadhu..users database ki connect avalekha poyaru ani email chesaru,so nenu veli processor chudam ani prstat -avm echa adi bottom lo top 5 user processor plus memory estundi so,andulo 0racle 100% undi appuddu nenu rman jobs run avuthunde oka full di adi kill chesaka.appudu vala ki issue em rale so a oracle memory 100% inka alane undi,ednuku undenaku teliyadu but e user entha cpu_usage_seconds lo sysman ekkav 90 above chupichindi so ippudu adi enduku ala ayindi ani ASH report run chesa andulo kuda top sessions rman e chupistundi(em chudale naku antha idea ledhu) top processes chudataniki top commadn prstat kakunda inka em ayinda commands unnai? prstat -avm este oracle 100% chupitundi adi normal aa enduku ala? [url="http://www.unix.com/solaris/122757-100-memory-usage-prstat.html"]http://www.unix.com/...age-prstat.html[/url] [/quote] Transaction DB's meeda RMAN's night time schedule chesuko...edanna replication use chesthara..transaction to reporting or Dw ki..? or any other data load process?
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359407764' post='1303191440'] Transaction DB's meeda RMAN's night time schedule chesuko...edanna replication use chesthara..transaction to reporting or Dw ki..? or any other data load process? [/quote] data load untai kani mainframes nuchi avi kuda nite e untai,e issue second vayya ravadam cause adugtunaru ASH report em chudali enduku ayindi ante em chepali ???
subbayya Posted January 28, 2013 Report Posted January 28, 2013 neeku metalink account vunda..? Vunte ganuka... 10g use chesthunnav kabatti AWR snapshot teesuko... Issue vunna time lo oka snapshot teesuko...and issue leni time lo oka snapshot teesuko... nee metalink account tho Oracle vadi mohana oka SR padei...vade root cause mottam analyse chesi chepthdau...one day lo neeku solution dorukuthundi em jarigindi anedi... Btw, Users application ki connect ka leka pothunnaru.... and already connect ayina user application freez avuthunda..?
subbayya Posted January 28, 2013 Report Posted January 28, 2013 transaction DB kabatti business hours lo lots of SQL's run avuthuntai... so nenu previous cheppinatlu open_cursors parameter alter chei.... monitoring tool like OEM or anyother emanna vunte graphs observe chei... graph lo top SQL's objects ni buffer cache lo pin chei....inka adi kudaraka pothe development teams tho kurchoni aa sql's ni tune chei...
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359408294' post='1303191485'] neeku metalink account vunda..? Vunte ganuka... 10g use chesthunnav kabatti AWR snapshot teesuko... Issue vunna time lo oka snapshot teesuko...and issue leni time lo oka snapshot teesuko... nee metalink account tho Oracle vadi mohana oka SR padei...vade root cause mottam analyse chesi chepthdau...one day lo neeku solution dorukuthundi em jarigindi anedi... Btw, Users application ki connect ka leka pothunnaru.... and already connect ayina user application freez avuthunda..? [/quote] undi bhayya metalink account,already connect ayina valu freez plus new users kuda. a oracle 100% memory ento neku idea undha??
subbayya Posted January 28, 2013 Report Posted January 28, 2013 I/O buffer read rate more than 90% vunte ganuka chetta SQL's ni production lo pettinattu na openion prakaram... At the same time Network wait time kuda entha vundo chudu...more than 80-90% network wait time vunte issue ni Network valla meeda ki tosei...
Recommended Posts