alter system flush shared_pool : Session Variables « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. Session Variables
SQL> alter system flush shared_pool;
SQL>
SQL> alter session set optimizer_index_cost_adj=100;
SQL>
SQL> alter session set optimizer_index_caching=0;
SQL>
SQL> begin
  2     dbms_stats.import_system_stats( stattab => 'SYSTEM_STATS', statid => 'OLTP', statown => user );
  3  end;
  4  /








29.62.Session Variables
29.62.1.ALTER SESSION SET SQL_TRACE = TRUE
29.62.2.ALTER SESSION SET optimizer_dynamic_sampling
29.62.3.alter session set NLS_DATE_FORMAT='DD-MM-YYYY'
29.62.4.alter session set hash_area_size
29.62.5.alter session set sort_area_size = 102400000
29.62.6.alter session set workarea_size_policy=manual
29.62.7.alter system flush shared_pool
29.62.8.alter system quiesce restricted
29.62.9.alter system resume
29.62.10.alter system suspend