Re: asktom.oracle.com

Thomas Kyte wrote:
>
> 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

Man, thats the last time I try for a little light humour on the newsgroup... I didn't mean to create a storm for you Tom :-)

But 8.1.7.2 ?

Dear oh dear... That's obsolete - 8.1.7.3 is out :-)

hee hee hee

Cheers
Connor

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

http://www.oracledba.co.uk

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