Ynt: SQL Trace ( Perl script help needed)

hello Siva,

You can concatenate raw SQL_TRACE files as a single file, then upload this file to itrprof.

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 19, 2001 2:30 AM

> Hello Gurus,
>
> I was trying to pull distinct sql's and their total "execute count" from a
> bunch of 250 trace output files(output from tkprof trace files). How can I
> achive this. What i need the cumulative sum of execute count from
different
> files for each sql's.
>
> As u all know sql can extend more than one line so ! I know this can be
> handled using perl script.
>
> file1.prf
> .
> select * from tablename1
> where col1=:1
> and col2=:2
>
>
> call count cpu elapsed disk query current
> rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 5 0.00 0.00 0 0 0
> 0
> Execute 5 0.02 0.02 0 600 0
> 0
> Fetch 5 0.00 0.00 0 0 0
> 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 15 0.02 0.02 0 600 0
> 0
> ...
>
> select * from tablename2
> where col1=:1
> and col2=:2
>
>
> call count cpu elapsed disk query current
> rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 5 0.00 0.00 0 0 0
> 0
> Execute 5 0.02 0.02 0 600 0
> 0
> Fetch 5 0.00 0.00 0 0 0
> 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 15 0.02 0.02 0 600 0
> 0
>
>
> file2.prf
>
>
> select * from tablename1
> where col1=:1
> and col2=:2
>
> call count cpu elapsed disk query current
> rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 5 0.00 0.00 0 0 0
> 0
> Execute 5 0.02 0.02 0 600 0
> 0
> Fetch 5 0.00 0.00 0 0 0
> 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 15 0.02 0.02 0 600 0
> 0
>
>
> select * from tablename3
> where col1=:1
> and col2=:2
>
>
> call count cpu elapsed disk query current
> rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 5 0.00 0.00 0 0 0
> 0
> Execute 5 0.02 0.02 0 600 0
> 0
> Fetch 5 0.00 0.00 0 0 0
> 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 15 0.02 0.02 0 600 0
> 0
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Valiveru, Siva
> INET: SValiveru_at_ea.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: unal-bilisim
  INET: danisment.unal_at_unal-bilisim.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).