Re: asktom.oracle.com

Thomas Kyte wrote:
>
> In article <lEzf8.4568$zU2.716670_at_news1.news.adelphia.net>, "Scott says...
> >
> >Is there something going on to make it so very slow right now?
> >
> >
>
> You seem to have posted at 8:49 am GMT on friday (3:49 am EST for me)...
>
> Over the last 24 hours (from 9:50am EST thurs - 9:50am EST fri) my stats for
> page generation were:
>
> Pages Genererated 18,149
> Avg Elap seconds/page 0.37
> Slowest/Fastest Page 4.45/0.12 seconds (some of my report pages take a bit)
>
> I did not see any unusual spike or decline in pages generated:
>
> CASEWH CNT_LAST_24HRS CNT_PRIOR_24HRS CNT_DIFF
> ------ -------------- --------------- ----------
> Fri 02 465 578 -113
> Fri 03 709 763 -54
> Fri 04 753 725 28
> Fri 05 578 475 103
>
> the traffic was about the same as the same period 24 hours ago....
>
> 1 select to_char(time_stamp,'hh24'), min(elap), max(elap), avg(elap), count(*)
> 2 from wwv_flow_activity_log1$
> 3 where time_stamp between to_date( '01-mar-2002 2am', 'dd-mon-yyyy hham' )
> 4 and to_date( '01-mar-2002 5am', 'dd-mon-yyyy hham' )
> 5* group by to_char(time_stamp,'hh24' )
> flows_at_OSI816> /
>
> TO MIN(ELAP) MAX(ELAP) AVG(ELAP) COUNT(*)
> -- ---------- ---------- ---------- ----------
> 02 .14 2.42 .380516129 465
> 03 .14 2.15 .354654443 709
> 04 .14 2.32 .364196547 753
>
> flows_at_OSI816>
>
> the pages/hour for that period looked OK as well.
>
> I'll have someone look at the network later but I don't see any problems on this
> end.
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp

OSI816 ?!?! Surely you're not using 8.1.6 - the people at Oracle marketing told me that this was obsolete and that everyone in the world was upgrading to, or already on, 9i

I can't believe they would be be lying to me :-)

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."