Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Show parameter timed_statistics

SQL> SQL> set echo on SQL> set serveroutput on SQL> SQL> show parameter timed_statistics; NAME                                 TYPE ------------------------------------ -------------------------------- VALUE ------------------------------ timed_statistics                     boolean TRUE SQL> SQL> alter session set sql_trace=true; Session altered. SQL> SQL> SQL> select owner, count(*)   2  from all_objects   3  group by owner; OWNER                            COUNT(*) ------------------------------ ---------- MDSYS                                 458 TSMSYS                                  2 FLOWS_020100                         1085 PUBLIC                               2766 OUTLN                                   7 RNTSOFT                                 99 CTXSYS                                338 HR                                     34 FLOWS_FILES                            11 SYSTEM                                422 DBSNMP                                 46 OWNER                            COUNT(*) ------------------------------ ---------- XDB                                   334 SYS                                  6611 13 rows selected. SQL> / OWNER                            COUNT(*) ------------------------------ ---------- MDSYS                                 458 TSMSYS                                  2 FLOWS_020100                         1085 PUBLIC                               2766 OUTLN                                   7 RNTSOFT                                 99 CTXSYS                                338 HR                                     34 FLOWS_FILES                            11 SYSTEM                                422 DBSNMP                                 46 OWNER                            COUNT(*) ------------------------------ ---------- XDB                                   334 SYS                                  6611 13 rows selected. SQL> SQL> SQL>