KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359408470' post='1303191498'] 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... [/quote] open cursors 5000 bhayya,sql valla kuda kadhu anukunta bhayya a oracle 100% memeory enduku ayindi, select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like '%CPU used by this session%' and se.SID = ss.SID and ss.status='ACTIVE' and ss.username is not null order by VALUE desc; syman---cpu---usage---seconds ----90enduku undii
subbayya Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359408514' post='1303191502'] undi bhayya metalink account,already connect ayina valu freez plus new users kuda. a oracle 100% memory ento neku idea undha?? [/quote] transaction servers meeda that is more common dude... etu production lo vunna objects ni gelakaleru antha easy ga so extra memory add chesukomanu... money pette atlu ayithe. But...nee meeda koncham best impression vundali ante ganuka....app users issue report chese munde nuvvu database monitor chesi oka alert e-mail kottu... like database is abnormal... may face some issues ani...
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359408647' post='1303191512'] 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... [/quote] a network wait time ela chustaru bhayya???
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359408854' post='1303191536'] transaction servers meeda that is more common dude... etu production lo vunna objects ni gelakaleru antha easy ga so extra memory add chesukomanu... money pette atlu ayithe. But...nee meeda koncham best impression vundali ante ganuka....app users issue report chese munde nuvvu database monitor chesi oka alert e-mail kottu... like database is abnormal... may face some issues ani... [/quote] money petaru bhayya,so 100% abnormal antav em ayina command telusa bhayya os level o processor entha % ani top prstat kakunda
subbayya Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359408852' post='1303191533'] open cursors 5000 bhayya,sql valla kuda kadhu anukunta bhayya a oracle 100% memeory enduku ayindi, select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like '%CPU used by this session%' and se.SID = ss.SID and ss.status='ACTIVE' and ss.username is not null order by VALUE desc; syman---cpu---usage---seconds ----90enduku undii [/quote] edanna process run ayithe ne kada dude memory occupy ayyedi... aa process ento monitoring tool use chesi dig chei...
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359409045' post='1303191557'] edanna process run ayithe ne kada dude memory occupy ayyedi... aa process ento monitoring tool use chesi dig chei... [/quote] chesina bhayya adi kuda a syman sql kinda paste chesa chudu na guess adi OEM di anukunta? [font=arial, sans-serif][size=3]select username,osuser,sql_id from v$session where type!='BACKGROUND'AND STATUS='ACTIVE';[/size][/font] [font=arial, sans-serif][size=3]elect SQL_TEXT FROM v$SQL where SQL_ID='2b064ybzkwf1y';[/size][/font] [font=arial, sans-serif][size=3] SQL_TEXT[/size][/font][font=arial, sans-serif][size=3] ------------------------------------------------------------------------------------------------------------------------[/size][/font][font=arial, sans-serif][size=3] BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;[/size][/font]
juvenile Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359409169' post='1303191573'] chesina bhayya adi kuda a syman sql kinda paste chesa chudu na guess adi OEM di anukunta? [font=arial, sans-serif][size=3]select username,osuser,sql_id from v$session where type!='BACKGROUND'AND STATUS='ACTIVE';[/size][/font] [font=arial, sans-serif][size=3]elect SQL_TEXT FROM v$SQL where SQL_ID='2b064ybzkwf1y';[/size][/font] [font=arial, sans-serif][size=3]SQL_TEXT[/size][/font] [font=arial, sans-serif][size=3]------------------------------------------------------------------------------------------------------------------------[/size][/font] [font=arial, sans-serif][size=3]BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;[/size][/font] [/quote] Agent restart chesi chudu bhayya !!
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359409104' post='1303191565'] ODA and OS enti..? [/quote] sun solaris ,oracle 10g database s ODA ante enti bhayya oracle database appliance ani telusu but more detail??
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='juvenile' timestamp='1359409557' post='1303191619'] Agent restart chesi chudu bhayya !! [/quote] ade anukuna bhayya kani issue fix ayindi annaru apatiki so cheyaledhu..chusta next time vaste ade chesta
Gachibowli_Diwakar Posted January 28, 2013 Report Posted January 28, 2013 backup run aithe .. e time lo enduku schedule chesaru .. after hour's run avvaali asalu aah process either rman / oracle background process aah.. lekapothe application process aah ..
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Silence..Please' timestamp='1359409755' post='1303191643'] backup run aithe .. e time lo enduku schedule chesaru .. after hour's run avvaali asalu aah process either rman / oracle background process aah.. lekapothe application process aah .. [/quote] adi ela chudaloo idea ledhu bhayya,zara chepa radhu ade teliyadhu bhayya ASH report run chesa top sessions ani aithe RMAN showing
Gachibowli_Diwakar Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359409927' post='1303191659'] adi ela chudaloo idea ledhu bhayya,zara chepa radhu ade teliyadhu bhayya ASH report run chesa top sessions ani aithe RMAN showing [/quote] rman ani chuupisthondi ante.. backup run authondi ani .. see if it is database backup (most probably it will be db backup) or archive log backup (this should not consume hell a lot of cpu) .. mi team vaalla ni adugu kill cheyocha dhaanni ani sar -d 5 5 run that command, it will show how disk utilization u r seeing
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Silence..Please' timestamp='1359410096' post='1303191672'] rman ani chuupisthondi ante.. backup run authondi ani .. see if it is database backup (most probably it will be db backup) or archive log backup (this should not consume hell a lot of cpu) .. mi team vaalla ni adugu kill cheyocha dhaanni ani sar -d 5 5 run that command, it will show how disk utilization u r seeing [/quote] kill chesa e issue morning vachindi forst rman job kill chesi denga travtha normal ayindi system
Gachibowli_Diwakar Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359410215' post='1303191687'] kill chesa e issue morning vachindi forst rman job kill chesi denga travtha normal ayindi system [/quote] mari inkem.. adhe root-cause
Recommended Posts