Re: tkprof explain=user/password password exposed?

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 7 Feb 2006 13:48:43 -0800
Message-ID: <1139348923.436155.232910@g44g2000cwa.googlegroups.com>

Rich,

Do you even need to use the explain option? The trace file should have the STAT lines, which will be sufficient.

This example is 9.2 on HP-UX (the same works on AIX). (Yes, some of the names have been changed to protect the innocent)

tkprof mydb_ora_29951_ORDERS_QUERY.trc ORDERS_QUERY.tkp waits=yes sys=no sort=fchela,exeela,prsela

The output in the tkp file includes

Rows Row Source Operation

-------  ---------------------------------------------------

1455078 FILTER (cr=35253920 r=914766 w=0 time=2945488279 us) 42320274 NESTED LOOPS OUTER (cr=35253920 r=914766 w=0 time=2707510696 us)
8490108 TABLE ACCESS FULL t1 (cr=155298 r=154998 w=0 time=138319618 us)
42318883 TABLE ACCESS BY INDEX ROWID t2 (cr=35098622 r=759768 w=0 time=2488967324 us)
42318883 INDEX RANGE SCAN ix1 (cr=25636426 r=203318 w=0 time=901305041 us)(object id 7435)

As long as the STAT lines are in the trace file, tkprof *should* be using them instead of an explain plan call into the database.

Regards,
Dan Fink Received on Tue Feb 07 2006 - 15:48:43 CST