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 [EMAIL PROTECTED]
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 cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse5 0.00 0.00 0 0 0
0
Execute 5 0.02 0.02 0600 0
0
Fetch5 0.00 0.00 0 0 0
0
--- -- -- -- -- --
--
total 15 0.02 0.02 0600 0
0
...
select * from tablename2
where col1=:1
and col2=:2
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse5 0.00 0.00 0 0 0
0
Execute 5 0.02 0.02 0600 0
0
Fetch5 0.00 0.00 0 0 0
0
--- -- -- -- -- --
--
total 15 0.02 0.02 0600 0
0
file2.prf
select * from tablename1
where col1=:1
and col2=:2
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse5 0.00 0.00 0 0 0
0
Execute 5 0.02 0.02 0600 0
0
Fetch5 0.00 0.00 0 0 0
0
--- -- -- -- -- --
--
total 15 0.02 0.02 0600 0
0
select * from tablename3
where col1=:1
and col2=:2
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse5 0.00 0.00 0 0 0
0
Execute 5 0.02 0.02 0600 0
0
Fetch5 0.00 0.00 0 0 0
0
--- -- -- -- -- --
--
total 15 0.02 0.02 0600 0
0
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Valiveru, Siva
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).