Re: Turn results off for a statement

first you need to create a plan_table with:

CREATE TABLE plan_table
 (

  statement_id               VARCHAR2(30),
  timestamp                  DATE,
  remarks                    VARCHAR2(80),
  operation                  VARCHAR2(30),
  options                    VARCHAR2(30),
  object_node                VARCHAR2(128),
  object_owner               VARCHAR2(30),
[Quoted]   object_name                VARCHAR2(30),
  object_instance            NUMBER,
  object_type                VARCHAR2(30),
  optimizer                  VARCHAR2(255),
  search_columns             NUMBER,
  id                         NUMBER,
  parent_id                  NUMBER,
  position                   NUMBER,
  other                      LONG

(some programs like SQL_NAVIGATOR (of quest software) can do that automatically)

then you can make the explain plan with:

EXPLAIN PLAN
SET STATEMENT_ID = [statementid]
into plan_table
FOR [select statement]

as statementid you can choose anything you like

then you can select the result from the plan_table

Joshua Goodstein wrote:

> I remember a while a go we found a way to not display the results for
> a statement for tuning purposes.. IE. I want to see how long the
> execution takes not the returning of the rows. Does anyone have docs
> or know how on how this may be done?????? I thought it was a tag like
> echo off but i don't care if the results are 1 million or 1 row I want
> performance info on the statement execution itself
>
> Joshua Goodstein
Received on Sat Jul 21 2001 - 23:57:08 CEST