Re: asktom.oracle.com

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 2 Mar 2002 10:16:09 -0800
Message-ID: <a5r4t901b2v@drn.newsguy.com>

In article <3C80BB63.4EA3_at_yahoo.com>, Connor says...
>
>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 :-)

well, its not 816 (thats the trouble with naming your production instances after the version -- they shouldn't have done that, I do that with all of my test instances)

flows_at_OSI816> select * from v$version;

BANNER

Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production

flows_at_OSI816>

it's really 8172, no I haven't upgraded this particular production instance to 9i as yet (haven't changed anything, no need to upgrade yet). We'll coordinate that the next time we roll out a new app (we develop on 9i -- just haven't put anything new on OSI yet)...

>
>--
>==============================
>Connor McDonald
>
>http://www.oracledba.co.uk
>
>"Some days you're the pigeon, some days you're the statue..."

--
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 Sat Mar 02 2002 - 12:16:09 CST