|
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
JAVA2S 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
JAVA2S 99
CTXSYS 338
HR 34
FLOWS_FILES 11
SYSTEM 422
DBSNMP 46
OWNER COUNT(*)
------------------------------ ----------
XDB 334
SYS 6611
13 rows selected.
SQL>
SQL>
SQL>
|