CURSOR_SHARING = {SIMILAR | EXACT | FORCE} Default value EXACT Parameter class Dynamic: ALTER SESSION, ALTER SYSTEM CURSOR_SHARING determines what kind of SQL statements can share the same cursors. CURSOR_SPACE_FOR_TIME Parameter type Boolean Default value false Parameter class ...
max_cursor_result_set_size mv_enable_aqmv_for_session navigate_super_null_on_error parse_super_null_on_error pg_federation_repeatable_read query_group search_path spectrum_enable_pseudo_columns enable_spectrum_oid spectrum_query_maxerror statement_timeout stored_proc_log_min_messages timezone use...
Alter SESSION SET EVENTS 'immediate trace name processstate level n'; 9).System State Alter SESSION SET EVENTS 'immediate trace name systemstate level n'; 10).Error State Alter SESSION SET EVENTS 'immediate trace name errorstack level n'; 0 Error stack 1 level 0 + function call stack 2 l...
2. alter session set nls_date_format = 'dd-MON-yyyy hh24:mi:ss'; 3. alter session set OPTIMIZER_MODE = RULE 4. Adjust your session time zone to -08:00, display the contents of your time table. 5. alter session set cursor_sharing = force 6. alter session set use_stored_outl...
通过:符号,可以连续设置多个事件,也可以通过连续使用alter session set events来设置多个事件。 格式说明: eventnumber指触发dump的事件号,事件号可以是Oracle错误号(出现相应错误时跟踪指定的事件)或oralce内部事件号,内部事件号在10000到10999之间,不能与immediate关键字同用。