Session Variables « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






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