Re: Optimizer

From: Karl R. <kreitsch_at_zdnetonebox.com>
Date: 2000/05/19
Message-ID: <04dd98b8.26a08931@usw-ex0105-034.remarq.com>#1/1

Hello!
tkprof is one of my favorite tool's!
i have ALL session-statements ordered by specific. Here a UNIX-Shell (KSH) - Script for easier handling.

if [[ $# -ne 3 ]]; then

        print -u2 "$0 : Usage : $0 InFile OutFile User" else

	DBUSER=$3
	InFile=$1
	OutFile=$2
	tkprof $InFile $OutFile  sort=fchela explain=${DBUSER}/

${DBUSER}@PS2000 table=${DBUSER}.explain_plan fi

Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning <!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free! Received on Fri May 19 2000 - 00:00:00 CDT