>> I don't remember the rest
Was that because of the water in Tijuana?? :-))
Sorry I missed out on that, but I got otherwise
involved in something.
RF
-----Original Message-----
Sent: Wednesday, April 24, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
please
n
One I know was "bring a coat to San Diego"
for those of you not at IOUG, San Diego, a city that is supposedly warm
was COLD and everyone was freezing there
they added a "zero" -- when you go to Tijuana, don't drink the water"
I don't remember the rest
- "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote:
> So, do you remember the other top 10 items??
>
> Robert
>
> -----Original Message-----
> Sent: Wednesday, April 24, 2002 11:39 AM
> To: Multiple recipients of list ORACLE-L
> please
> n
>
>
> it was also mentioned at the Oracle of Oracles closing session, in
> the
> "top 10 things I learned in San Diego" :)
>
>
> --- Cary Millsap <cary.millsap_at_hotsos.com> wrote:
> > Might have been Dave too, but I mentioned it in my
> "Misunderstandings
> > About Oracle Internals" talk at IOUG on Tuesday...
> >
> >
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > cary.millsap_at_hotsos.com
> > http://www.hotsos.com
> >
> >
> > -----Original Message-----
> > Sent: Monday, April 22, 2002 10:58 PM
> > To: Multiple recipients of list ORACLE-L
> > n
> >
> > I think it was Dave Ensor...
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, April 22, 2002 6:30 PM
> >
> >
> > > Hi Connor,
> > >
> > > Somebody (I think it was Cary) mentioned your little PL/SQL
> > procedure
> > that
> > > will provide any required CHR. So you are famous, even if you
> were
> > not
> > > present :)
> > >
> > > And yes, without seeming to migrate to the CHR camp, there is
> some
> > merit
> > in
> > > what you are saying. However, I would suggest that tracking
> > 'normal'
> > delta
> > > values of 'cache buffer chain' gets, misses, spins and sleeps
> from
> > > V$SYSTEM_EVENT/V$LATCH, as well as deltas of 'table scan rows
> > gotten'
> > vs
> > > 'table fetch by rowid' would be a better 'ratio' than the CHR
> which
> > will
> > > only serve to feed a myth. The former would give you some
> > indication
> > of
> > LIO
> > > (and the stress it causes on the system) and the latter will
> > indicate
> > raw
> > > requirements that were met but were the ones that drove PIO....
> As
> > for
> > me,
> > I
> > > detect changes in the following SQL and page out to an on-call
> DBA
> > when
> > some
> > > set limits are exceeded:
> > >
> > > select event, count(*) from v$session_wait
> > > group by event;
> > >
> > > This does show the 'current' bottleneck and I still remain true
> to
> > the
> > > calling of OWI!!
> > >
> > > John Kanagaraj
> > > Oracle Applications DBA
> > > DBSoft Inc
> > > (W): 408-970-7002
> > >
> > > Grace - Getting something we don't deserve
> > > Mercy - NOT getting something we deserve
> > >
> > > Click on 'http://www.needhim.org' for Grace and Mercy that is
> > freely
> > > available!
> > >
> > > ** The opinions and statements above are entirely my own and not
> > those
> > of
> > my
> > > employer or clients **
> > >
> > >
> > > > -----Original Message-----
> > > > From: Connor McDonald [mailto:hamcdc_at_yahoo.co.uk]
> > > > Sent: Monday, April 22, 2002 4:44 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RE: Anything new from IOUG? + "OWI" Born!!
> > > > (Anjo/Mogens, please
> > > > n
> > > >
> > > >
> > > > I still like to recommend the buffer cache hit ratio
> > > > because its so easy to please customers with an
> > > > improvement - A plsql routine to generate any desired
> > > > hit ratio on a running system is freely available for
> > > > download from my site... a consultants dream! :-)
> > > >
> > > > But, serious hat on temporarily, there IS still a use
> > > > for the buffer hit ratio as a "delta" measurement.
> > > > What I mean by this is that you measure it every 'n'
> > > > mins/hrs/whatever and store it. When it displays a
> > > > massive dip or a massive increase (ie something out of
> > > > the ordinary for *your* system), then whilst it
> > > > doesn't necessarily mean anything is wrong - it DOES
> > > > mean that something has changed in your system, which
> > > > is a good prompt to do some investigation..
> > > >
> > > > hth
> > > > connor
> > > >
> > > > --- John Kanagaraj <john.kanagaraj_at_hds.com> wrote: >
> > > > Mark,
> > > > >
> > > > > This is from a first-timer at IOUG, so I may be way
> > > > > off here.
> > > > >
> > > > > A lot of marketing blurb was thrown out at IOUG
> > > > > (probably a lot less than
> > > > > usual, and *much* less than Oracle OpenWorld in any
> > > > > case!). As for tools,
> > > > > many vendors were flogging the same ones, improved
> > > > > versions maybe. One which
> > > > > did make us say 'wow' was StorageXpert from Quest.
> > > > > IMHO, this is an
> > > > > excellent tool, engineered by our very own Gaja. I
> > > > > believe details are at
> > > > > the Quest site at www.quest.com. If you have EMC
> > > > > disks and are facing
> > > > > performance problems, I believe there is the best
> > > > > there is. (Or even if you
> > > > > have other storage devices, it would still give you
> > > > > the hotspots).
> > > > >
> > > > > And NO, I do NOT work for Quest, nor have Quest
> > > > > stock!
> > > > >
> > > > > And for others, I believe this was a major turning
> > > > > point and an eye-opener
> > > > > as far as the Wait Interface goes (This has
> > > > > (un)officially been renamed to
> > > > > OWI as per Kirti's slides :-). Most attendees 'saw
> > > > > the light' as far as CHR
> > > > > (Cache Hit Ratio) goes, and there were two distinct
> > > > > camps after the first
> > > > > few days - the 'CHR' and 'OWI'. No prizes for
> > > > > guessing who won the day! The
> > > > > massive number of defections and the absolute
> > > > > absense of
> > > > > CHR-based-discussions at the Performance round
> > > > > tables was clear evidence
> > > > > that OWI is here to stay! (Mr. R might still rewrite
> > > > > that book sooner than
> > > > > later!)
> > > > >
> > > > > About 20 Listers met for dinner on Sunday night (and
> > > > > again in a larger group
> > > > > at the SeaWorld bash). The meeting was characterized
> > > > > by geek-talk such as
> > > > > 'Can you fit us all in one extent?' i.e. 'can we all
> > > > > sit at one table?'),
> > > > > 'Please coalesce' - 'please move in so that more
> > > > > people can fit into the
> > > > > aisle seats'.
> > > > >
> > > > > Oh Boy, that WAS a lot of fun!
> > > > >
> > > > > John Kanagaraj
> > > > > Oracle Applications DBA
> > > > > DBSoft Inc
> > > > > (W): 408-970-7002
> > > > >
> > > > > Grace - Getting something we don't deserve
> > > > > Mercy - NOT getting something we deserve
>
=== message truncated ===
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Apr 24 2002 - 16:23:39 CDT
