tag:blogger.com,1999:blog-755542794415995865.post7220625849541964063..comments2023-09-23T07:13:10.004-07:00Comments on DB Optimizer: ashmasters.comKyle Haileyhttp://www.blogger.com/profile/13586511268045480856noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-755542794415995865.post-76243727577132297732009-12-17T09:17:42.215-08:002009-12-17T09:17:42.215-08:00There's not much point in registering on ashma...There's not much point in registering on ashmasters.com as I'm get to much spam until I install a spam filter in the wordpress, then I will be ignoring postings to that site.Kyle Haileyhttps://www.blogger.com/profile/13586511268045480856noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-33181100035608607832009-12-16T17:11:11.965-08:002009-12-16T17:11:11.965-08:00Hi Kyle,
I mistype my email address when I regist...Hi Kyle,<br /><br />I mistype my email address when I register as newbie01.oracle on ASH Masters. Are you able to delete that registration so I can re-register with the correct email address?<br /><br />Thanks in advance.Newbiehttps://www.blogger.com/profile/04485409328571880297noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-11621095670075587252009-11-16T09:06:47.742-08:002009-11-16T09:06:47.742-08:00Good catch. Updated the script at
http://www.perfv...Good catch. Updated the script at<br /><a href="http://www.perfvision.com/ash/aveact.sql" rel="nofollow">http://www.perfvision.com/ash/aveact.sql</a><br />The "10" decode value should have only been in there for the select off of dba_hist_active_sess_history which has 1/10 the samples as v$active_session_history.Kyle Haileyhttps://www.blogger.com/profile/13586511268045480856noreply@blogger.comtag:blogger.com,1999:blog-755542794415995865.post-26076553429725881862009-11-13T12:25:37.014-08:002009-11-13T12:25:37.014-08:00Hi Kyle,
I just found your other blog - please fi...Hi Kyle,<br /><br />I just found your other blog - please find my question from ashmasters.com <br />(Here is link to my question - hxxp:!!ashmasters.com/ash-queries/overview-queries/)<br /><br />I’m wondering if you still maintain that blog but I have a question about aveact.sql file linked above. In your script you are calculating waits using following formula (for both - online and historical)<br /><br />sum(decode(session_type,’BACKGROUND’,0,decode(session_state,’WAITING’,10,0))) waits<br /><br />but in results (linked above too) you have a strange values in wait column<br /><br />@aveact<br />TM NPTS AVEACT GRAPH CPU WAITS<br />—————- —— ——- ———————- —- —–<br />06-AUG 13:00:00 270 .33 - 2 29 59<br />06-AUG 14:00:00 1040 2.24 ——–2— 341 1984<br />06-AUG 15:00:00 623 6.67 ——2———- 438 3718<br />06-AUG 16:00:00 1088 2.59 ——–2—- 335 2486<br /><br />How is it possible that sum is 59 when we use 10s as a basic value ?<br />I assume it should be 1 for both - CPU and wait - and there is a bug inside that script.<br /><br />I’m wondering why you using 1’s for ash and 10’s for historical ash ?<br /><br />This is very useful tool - Thanks for that<br /><br />regards,<br />MarcinMarcin Przepiorowskihttps://www.blogger.com/profile/15133397892511680504noreply@blogger.com