Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TKPROF usage

Re: TKPROF usage

From: <michael_bialik_at_my-deja.com>
Date: Fri, 15 Oct 1999 20:54:30 GMT
Message-ID: <7u84a0$5do$1@nnrp1.deja.com>


Hi.

 Try using :

 TKPROF80 ... <user_id>/<password>@<service_name>

 E.G. scott/tiger_at_orcl

  HTH. Michael.

In article <7u7voa$1u0$1_at_nnrp1.deja.com>,   Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote:
> Subject: TKPROF usage
>
> I have a question/problem in using TKPROF, which I have just begun to
> explore. Turning on the statistics and genning a trace file is
working
> fine. However, when I run TKPROF80 with the EXPLAIN option, the
> resulting report shows an 0RA-12203: Unable to connect. After
looking
> everything over, I can’t find any mechanism whereby TKPROF can know
> which database it is supposed to connect to in order to perform the
> EXPLAIN PLAN. The connect string doesn’t appear in the .TRC file and
I
> don’t see any TKPROF command line parameters to supply it – though
> there is the parameter to supply the userid/password.
>
> This is on an NT desktop client going against an O8.0.5 database on an
> NT server.
>
> What simple thing am I missing?
>
> TIA,
>
> Ed Stevens
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 15 1999 - 15:54:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US