Re: tkprof output?

From: <basilodbc_at_my-dejanews.com>
Date: Fri, 24 Jul 1998 04:04:58 GMT
Message-ID: <6p915a$f4o$1@nnrp1.dejanews.com>

Last time this happened with my tkprof output, I simply set TIMED_STATISTICS=TRUE in the init.ora file

In article <6p7gea$nul$1_at_nnrp1.dejanews.com>, ronr_at_my-dejanews.com wrote:
> In article <6p3mkq$r5o$1_at_sloth.swcp.com>,
> elufker_at_swcp.com (Ed Lufker) wrote:
> > Hi All:
> >
> > What would cause no rows to show up under this execution plan the I pulled
> > out of a tkprof output file?
> >
> > Misses in library cache during parse: 0
> > Optimizer goal: RULE
> > Parsing user id: 224 (TA087)
> >
> > Rows Execution Plan
> > ------- ---------------------------------------------------
> > 0 SELECT STATEMENT GOAL: RULE
> > 0 SORT (ORDER BY)
> > eddie lufker
>
> Did you analyze the database (dbms_utillity.analyze_schema
> ('x','COMPUTE|ESTIMATE') ?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 23 1998 - 23:04:58 CDT