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>