Thanks Kirti and everyone who responded.
This forum is really great.
- Original Message -----
Date: Thursday, January 22, 2004 12:14 pm
> Why not process the trace file with 9i tkprof?
> It will nicely summarize the wait times for those events.
> After seeing those unique wait events, your boss may ask for the
> wait times next!! Be proactive
> :)
>
> - Kirti
>
>
>
> --- "Simpson, Ken" <Ken_Simpson_at_troweprice.com> wrote:
> > > -----Original Message-----
> > > From: ml-errors_at_fatcity.com [ml-errors_at_fatcity.com] On
> > > Behalf Of jaysingh1_at_optonline.net
> > > Sent: Thursday, January 22, 2004 11:09 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: How to get unique value using AWK?
> > >
> > >
> > > Hi All,
> > >
> > > My manager wants to get all the unique wait events from the
> > > trace file.
> > > I tried the below but how do i get DISTICT wait event name?
> > >
> > > Any help would be really appreciated.
> > >
> > > $ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 "
> > > " $5 " "$6}'|more
> > > nam='SQL*Net message to client'
> > > nam='SQL*Net message from client'
> > > nam='library cache lock' ela=
> > > nam='SQL*Net message to client'
> > > nam='SQL*Net message from client'
> > > nam='SQL*Net message to client'
> > > nam='SQL*Net message from client'
> > > nam='SQL*Net message to client'
> > > nam='SQL*Net message from client'
> > > nam='SQL*Net message to client'
> > > nam='SQL*Net message from client'
> > > nam='SQL*Net message to client'
> > > nam='SQL*Net message from client'
> > > nam='SQL*Net message to client'
> > >
> > >
> > > Thanks
> > > Jay
> > >
> >
> > How about piping it through uniq?
> >
> > $ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 " "
> $5 "
> > "$6}'| uniq
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Simpson, Ken
> > INET: Ken_Simpson_at_troweprice.com
> >
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
> http://webhosting.yahoo.com/ps/sb/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kirtikumar Deshpande
> INET: kirtikumar_deshpande_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> -------------------------------------------------------------------
> --
> 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.net
--
Author:
INET: jaysingh1_at_optonline.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu Jan 22 2004 - 12:19:26 CST
