Oracle PL/SQL/SQL Plus/show

show parameters block

 
SQL>
SQL> show parameters block
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers                     integer     0
db_block_checking                    string      FALSE
db_block_checksum                    string      TRUE
db_block_size                        integer     8192
db_file_multiblock_read_count        integer     128
SQL>

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

SHOW USER

 
SQL>
SQL> SHOW USER
USER is "sqle"
SQL>