SQL> set autotrace on;
SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
================================
solutions :
 SQL> grant plustrace to hr;
grant plustrace to hr
      *
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist


SQL> create role plustrace;
create role plustrace
*
ERROR at line 1:
ORA-01031: insufficient privileges

login through sys/password @database :

create role plustrace;
 grant plustrace to hr;

 grant select on v_$sesstat to plustrace;
 grant select on v_$statname to plustrace;
 grant select on v_$mystat to plustrace;
 grant plustrace to HR with admin option;

SQL> connect hr/admin



SQL> set autotrace on;
SQL> select * from employees where salary=6242.4;

EMPLOYEE_ID FIRST_NAME           LAST_NAME                 EMAIL
     PHONE_NUMBER         HIRE_DATE JOB_ID
----------- -------------------- ------------------------- ---------------------
---- -------------------- --------- ----------
    SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
---------- -------------- ---------- -------------
        104 Bruce                Ernst                     BERNST
     590.423.4568         21-MAY-07 IT_PROG
    6242.4                       103            60

        202 Pat                  Fay                       PFAY
     603.123.6666         17-AUG-05 MK_REP
    6242.4                       201            20



Execution Plan
----------------------------------------------------------
Plan hash value: 1445457117

-------------------------------------------------------------------------------
| Id  | Operation         | Name      | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |           |     2 |   142 |     3   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS FULL| EMPLOYEES |     2 |   142 |     3   (0)| 00:00:01 |
-------------------------------------------------------------------------------

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

   1 - filter("SALARY"=6242.4)


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          8  consistent gets
          0  physical reads
          0  redo size
       1414  bytes sent via SQL*Net to client
        519  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          2  rows processed

SQL>

SQL> set timining on;
SP2-0158: unknown SET option "timining"
SQL> set timing on;
SQL> select * from employees where salary=6242.4;

EMPLOYEE_ID FIRST_NAME           LAST_NAME                 EMAIL
     PHONE_NUMBER         HIRE_DATE JOB_ID
----------- -------------------- ------------------------- --------------------
---- -------------------- --------- ----------
    SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
---------- -------------- ---------- -------------
        104 Bruce                Ernst                     BERNST
     590.423.4568         21-MAY-07 IT_PROG
    6242.4                       103            60

        202 Pat                  Fay                       PFAY
     603.123.6666         17-AUG-05 MK_REP
    6242.4                       201            20


Elapsed: 00:00:00.01

Execution Plan
----------------------------------------------------------
Plan hash value: 1445457117

-------------------------------------------------------------------------------
| Id  | Operation         | Name      | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |           |     2 |   142 |     3   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS FULL| EMPLOYEES |     2 |   142 |     3   (0)| 00:00:01 |
-------------------------------------------------------------------------------

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

   1 - filter("SALARY"=6242.4)


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          8  consistent gets
          0  physical reads
          0  redo size
       1414  bytes sent via SQL*Net to client
        519  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          2  rows processed

SQL>