Configuration
- Use SET Command to change the configuration for the current session
- Modify parameter group settings for the cluster
-- Displays current configuration s
SQL>show all;
datestyle - display format of date/time
extra_float_digits - digits displayed for floating point numbers. If it is set -ve, it supresses unwanted digits.
query_group - user-defined label to a group of queries that are run during the same session. Not available in parameter group settings. you can set only using SET. This label is captured in the query logs and system tables/views like STL_QUERY, STV_INFLIGHT, SVL_QLO.
search_path - A comma-separated list of existing schema names. If '$user' is present, then the schema having the same name as SESSION_USER is substituted
statement_timeout - Aborts any statement that takes over the specified number of milliseconds
max_cursor_result_set_size - Defines the maximum size of data returned by per cursor result set of larger query.(Specified in MB). It affects the number of concurrent queries.
wlm_query_slot_count - Sets the number of query slots a query will use.1 to 50 (cannot exceed number of available slots (concurrency level) for the service class). if concurrency level is set to 5, then the service class has 5 slots).WLM
allocates the available memory for a service class equally to each slot.
Comments