Oracle PL/SQL/SQL Plus/show

Материал из SQL эксперт
Перейти к: навигация, поиск

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>