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] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] ss.username,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] se.SID,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] VALUE/100 cpu_usage_seconds[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] v$session ss,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] v$sesstat se,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] v$statname sn[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] se.STATISTIC# = sn.STATISTIC#[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] NAME like '%CPU used by this session%'[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] se.SID = ss.SID[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] ss.status='ACTIVE'[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] ss.username is not null[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]order by VALUE desc;[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]e command em chestundi e user ekkav processor use chestundi cheptundi kadha???[/background][/size][/font][/color]
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Silence..Please' timestamp='1359410325' post='1303191700'] mari inkem.. adhe root-cause [/quote] kani same issue oka 2 days back vachindi appudu nenu deal cheyaledhu vere team memeber chesadu? neku ASH report PM chesta zara chusi chepu enduku ayindi adii
Gachibowli_Diwakar Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359410385' post='1303191707'] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] ss.username,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] se.SID,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] VALUE/100 cpu_usage_seconds[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] v$session ss,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] v$sesstat se,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] v$statname sn[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] se.STATISTIC# = sn.STATISTIC#[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] NAME like '%CPU used by this session%'[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] se.SID = ss.SID[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] ss.status='ACTIVE'[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] ss.username is not null[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]order by VALUE desc;[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]e command em chestundi e user ekkav processor use chestundi cheptundi kadha???[/background][/size][/font][/color] [/quote] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]CPU used by this session [/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]nuvu run chesina query lo ne undhi ga em chesthundi ani[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]kani , in a situation like this, direct ga db lo chuudaru .. u shud start from OS level .. then associate that process id with database sid . [/background][/size][/font][/color]
Gachibowli_Diwakar Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359410487' post='1303191723'] kani same issue oka 2 days back vachindi appudu nenu deal cheyaledhu vere team memeber chesadu? neku ASH report PM chesta zara chusi chepu enduku ayindi adii [/quote] oori ni yenkamma.. RMAN backup kill cheyagane system usual aindhi ani nuvve chepthunnav .. so, that is the culprit .. inkem chuudaali nuvu . kavalante AWR report generate chesi chudu aah time-period lo naku PM's ravu .. inbox full
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Silence..Please' timestamp='1359410575' post='1303191742'] oori ni yenkamma.. RMAN backup kill cheyagane system usual aindhi ani nuvve chepthunnav .. so, that is the culprit .. inkem chuudaali nuvu . kavalante AWR report generate chesi chudu aah time-period lo naku PM's ravu .. inbox full [/quote] yeah problem solve ayindi bhayya,so first OS level chusi then DB level ki velali antav OS level lo top,prstat -avm inka em ayina commands unte chepu zara bhayya processors entha % chudataniki
Gachibowli_Diwakar Posted January 28, 2013 Report Posted January 28, 2013 [quote name='KOTC' timestamp='1359410751' post='1303191764'] yeah problem solve ayindi bhayya,so first OS level chusi then DB level ki velali antav OS level lo top,prstat -avm inka em ayina commands unte chepu zara bhayya processors entha % chudataniki [/quote] top shud give some sort of an idea to start with
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Silence..Please' timestamp='1359410971' post='1303191794'] top shud give some sort of an idea to start with [/quote] Thanks bhayya
Joey_Tribbiani Posted January 28, 2013 Report Posted January 28, 2013 [list] [*] [size=4][background=transparent] prstat -s rss[/background][/size] [size=4][background=transparent] '-s' sorts prstat output by rss column (see man page for other columns). Also try '-a' option for a per user accumulation.[/background][/size] [*] [size=4][background=transparent] ps -eo pid,pmem,vsz,rss,comm | sort -rnk2 | head[/background][/size] [size=4][background=transparent] Top 10 RAM consumers. '-o pmem' displays percentage of resident memory i.e. RAM used by process.[/background][/size] [*] [size=4][background=transparent] ls -lh /proc/{pid}/as[/background][/size] [size=4][background=transparent] Easy way to show total address space (vsz) of a process. Useful in combination with pgrep to accumulate by user, pattern, ... e.g.:[/background][/size] for pid in `pgrep -U webserver`; do ls -lh /proc/$pid/as; done [/list]
KOTC Posted January 28, 2013 Author Report Posted January 28, 2013 [quote name='Joey_Tribbiani' timestamp='1359411860' post='1303191884'][list] [*] [size=4][background=transparent]prstat -s rss[/background][/size] [size=4][background=transparent]'-s' sorts prstat output by rss column (see man page for other columns). Also try '-a' option for a per user accumulation.[/background][/size] [*] [size=4][background=transparent]ps -eo pid,pmem,vsz,rss,comm | sort -rnk2 | head[/background][/size] [size=4][background=transparent]Top 10 RAM consumers. '-o pmem' displays percentage of resident memory i.e. RAM used by process.[/background][/size] [*] [size=4][background=transparent]ls -lh /proc/{pid}/as[/background][/size] [size=4][background=transparent]Easy way to show total address space (vsz) of a process. Useful in combination with pgrep to accumulate by user, pattern, ... e.g.:[/background][/size] for pid in `pgrep -U webserver`; do ls -lh /proc/$pid/as; done [/list] [/quote] Thanks bhayya
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 os level lo em ayina avtundi chudali ante varadm kakunda em ayina commands unnai OS:solaris
Recommended Posts