Autotrace on and off : autotrace « SQL Plus « Oracle PL / SQL






Autotrace on and off

   
SQL>
SQL> create table my_all_objects
  2  nologging
  3  as
  4  select * from all_objects
  5  union all
  6  select * from all_objects
  7  union all
  8  select * from all_objects
  9  /

Table created.

SQL>
SQL> insert into my_all_objects
  2  ( owner, object_name, object_type, object_id )
  3  values
  4  ( 'New Owner', 'New Name', 'New Type', 1111111 );

1 row created.

SQL>
SQL>
SQL> set autotrace traceonly
SQL> select count(*)
  2    from my_all_objects
  3   where owner = 'New Owner';


Execution Plan
----------------------------------------------------------
Plan hash value: 2942800307

-------------------------------------------------------------------------------------
| Id  | Operation          | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |                |     1 |    17 |   131   (2)| 00:00:02 |
|   1 |  SORT AGGREGATE    |                |     1 |    17 |            |          |
|*  2 |   TABLE ACCESS FULL| MY_ALL_OBJECTS |     5 |    85 |   131   (2)| 00:00:02 |
-------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter("OWNER"='New Owner')

Note
-----
   - dynamic sampling used for this statement


Statistics
----------------------------------------------------------
         50  recursive calls
          0  db block gets
        548  consistent gets
        466  physical reads
          0  redo size
        411  bytes sent via SQL*Net to client
        380  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

SQL> set autotrace off
SQL>
SQL> drop table my_all_objects;

Table dropped.

SQL>
SQL>

   
    
  








Related examples in the same category

1.autotrace command
2.Autotrace lower text function
3.Autotrace running total
4.Autotrace a query on a huge table
5.Autotrace a large table
6.Autotrace a query with group clause
7.Execution Plan
8.autotrace a nested query
9.set autotrace on explain for every single statement
10.set autotrace traceonly explain for bitmap index
11.set autotrace traceonly explain, and condition
12.set autotrace traceonly statistics
13.set autotrace traceonly statistics for 'select * from tableName'
14.set autotrace traceonly
15.AUTOTRACE exists (subquery)
16.AUTOTRACE table joining
17.AUTOTRACE table joining and aggregate function
18.autotrace ansi full outer join
19.autotrace count(*)
20.autotrace ctxsys.context index
21.autotrace merge command
22.autotrace table with/without an index