Re: asktom.oracle.com

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1 Mar 2002 07:28:36 -0800
Message-ID: <a5o6n4016rn@drn.newsguy.com>

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

Received on Fri Mar 01 2002 - 09:28:36 CST