Re: Query Execution Time "alone"

From: Donatello Settembrino <donatello.settembrino_at_gmail.com>
Date: Wed, 16 Mar 2011 03:28:10 -0700 (PDT)
Message-ID: <92331580-c145-4b7c-8d0e-6d804c0bdb47_at_t19g2000prd.googlegroups.com>

On Mar 15, 8:48 pm, raja <dextersu..._at_gmail.com> wrote:
> so, set autotrace traceonly statistics, will execute the query and
> just gives the elapsed time of the query and not the data ???

as Jonathan says,
get the elapsed time and the statistics captured during the execution of the query

Here's an example of

SQL> create table t as
  2 select rownum as c from dual connect by level <= 10000;

Tabella creata.

SQL> select count(*) from t;

  COUNT(*)

---

     10000

SQL> set timing on;
SQL> set arraysize 1000
SQL> set autotrace traceonly statistics
SQL> select * from t;

Selezionate 10000 righe.

Passati: 00:00:00.28

Statistiche

---

          8  recursive calls
          0  db block gets
         36  consistent gets
          0  physical reads
          0  redo size
      90442  bytes sent via SQL*Net to client
        323  bytes received via SQL*Net from client
         11  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      10000  rows processed

Received on Wed Mar 16 2011 - 05:28:10 CDT