Oracle PL/SQL/SQL Plus/show
show parameters block
<source lang="sql">
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>
</source>
show parameter timed_statistics
<source lang="sql">
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>
</source>
SHOW USER
<source lang="sql">
SQL> SQL> SHOW USER USER is "sqle" SQL>
</source>