KOTC Posted January 28, 2013 Report Posted January 28, 2013 oracle procesor 100% ayindi user complaining database ki cont avatam ledhu ani prstat -avm bottom lo oracle 100% ani chupistundi dani travtha e script use chesi [color=#000000] If you do notice the run queue exceeding the amount of CPUs, it’s a good indication that your server has a CPU bottleneck. I[size=3]nside Oracle, you can display CPU for any Oracle user session with this script:[/size][/color] [size=1]select ss.username,[/size] [size=1] se.SID,[/size] [size=1] VALUE/100 cpu_usage_seconds[/size] [size=1]from v$session ss, [/size] [size=1] v$sesstat se, [/size] [size=1] v$statname sn[/size] [size=1]where se.STATISTIC# = sn.STATISTIC#[/size] [size=1]and NAME like '%CPU used by this session%'[/size] [size=1]and se.SID = ss.SID[/size] [size=1]and ss.status='ACTIVE'[/size] [size=1]and ss.username is not null[/size] [size=1]order by VALUE desc;[/size] [color=#000000][font=arial, helvetica, sans-serif][size=1]indulo sysman 90.76--cpu-----usage--second [/size][/font][/color][color=#000000][font=arial, helvetica, sans-serif][size=1]so ippudu nenu agent restart chedam anukuntuna so that a oracle procesor koncham ayina free avtundi ani[/size][/font][/color] inka ela check cheyali a oracle processor enduku 100% running ani??
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 calling CBZ,silence please ekkada unnaru vayyas
CheGuevara Posted January 28, 2013 Report Posted January 28, 2013 check this parameter : show parameter processes adi 100 unte danni increase chey
subbayya Posted January 28, 2013 Report Posted January 28, 2013 Sessions check chei..session locks ayyi enquie emanna vachindi emo chudu....top SQL's valla..
subbayya Posted January 28, 2013 Report Posted January 28, 2013 SQL's execution time ni batti...top occupied SQL's objects ni cache lo pin chesthe...100% CPU consume avvadu... Btw, Is that a transaction database or reporting database or Warehouse?
Joey_Tribbiani Posted January 28, 2013 Report Posted January 28, 2013 OEM lo top consumers lo em Session undo chudu , if its user ran -- Cancel it .... If u r in 11.2.0.2 , there is a known issue with RMAN , Cancel it ...!
subbayya Posted January 28, 2013 Report Posted January 28, 2013 Transaction server ayithe ganaka change the following paratemer. Show parameter open_cursors; --> check chei (idi ganaka 300 vunte reset it to 500)
bmwx3 Posted January 28, 2013 Report Posted January 28, 2013 take statspack..any see what session/sql/module is consuming the cpu
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='CheGuevara' timestamp='1359399049' post='1303190774'] check this parameter : show parameter processes adi 100 unte danni increase chey [/quote] bhayya adi 2000 undi adi kadhu anukunta pblm a oracle enduku 100% memoery consuming ani
bmwx3 Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359400510' post='1303190909'] bhayya adi 2000 undi adi kadhu anukunta pblm a oracle enduku 100% memoery consuming ani [/quote] try TOP command and take statspack as well
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='subbayya' timestamp='1359399430' post='1303190812'] SQL's execution time ni batti...top occupied SQL's objects ni cache lo pin chesthe...100% CPU consume avvadu... Btw, Is that a transaction database or reporting database or Warehouse? [/quote] OLTP bhayya na ikkada confusion undi bhayya prstat -avm cheste bottom lo top 5 procesor vastai bhayya akkada CPU 100% ledhu kani e oracle memory 100% undi ?? enduku kani NPROC USERNAME SIZE RSS MEMORY TIME CPU 132 oracle 1812G 1804G 100% 15:30:20 6.6%
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Joey_Tribbiani' timestamp='1359399441' post='1303190813'] OEM lo top consumers lo em Session undo chudu , if its user ran -- Cancel it .... If u r in 11.2.0.2 , there is a known issue with RMAN , Cancel it ...! [/quote] e db 10g bhayya oem kuda 10 g e ikkada oracle 100% memory eating bhayya adi enduku ani
Recommended Posts