本文共 2092 字,大约阅读时间需要 6 分钟。
确实不行。使用oradebug可以发现:
SYS@book> oradebug setospid 12507
Oracle pid: 25, Unix process pid: 12507, image: oracle@gxqyydg4 (TNS V1-V3)
SYS@book> oradebug dump modified_parameters 1
Statement processed.
SYS@book> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/book/book/trace/book_ora_12507.trc
--//检查转储:
*** 2020-04-20 11:17:05.571
Received ORADEBUG command (#2) 'dump modified_parameters 1' from process 'Unix process pid: 12516, image: '
DYNAMICALLY MODIFIED PARAMETERS:
nls_language = AMERICAN
nls_territory = AMERICA
nls_sort = BINARY
nls_date_language = AMERICAN
nls_date_format = YYYY-MM-DD HH24:MI:SS
nls_currency = $
nls_numeric_characters = .,
nls_iso_currency = AMERICA
nls_calendar = GREGORIAN
nls_time_format = HH.MI.SSXFF AM
nls_timestamp_format = YYYY-MM-DD HH24:MI:SS.FF
nls_time_tz_format = HH.MI.SSXFF AM TZR
nls_timestamp_tz_format = YYYY-MM-DD HH24:MI:SS.FF TZH:TZM
nls_dual_currency = $
nls_comp = BINARY
_add_col_optim_enabled = FALSE
--//好像就是隐含参数不行,不是隐含的还是可以发现的。
--//session 1:
SCOTT@book> alter session set optimizer_index_cost_adj=10;
Session altered.
--//session 2:
SYS@book> select * from v$ses_optimizer_env where sid=15 and lower(name) like '%optimizer_index_cost_adj%';
SID ID NAME SQL_FEATURE ISD VALUE
--- -- ------------------------ ----------- --- -----
15 66 optimizer_index_cost_adj QKSFM_CBO NO 10
SYS@book> oradebug dump modified_parameters 1
Statement processed.
--//检查转储:
*** 2020-04-20 11:22:11.711
Received ORADEBUG command (#4) 'dump modified_parameters 1' from process 'Unix process pid: 12516, image: '
DYNAMICALLY MODIFIED PARAMETERS:
nls_language = AMERICAN
nls_territory = AMERICA
nls_sort = BINARY
nls_date_language = AMERICAN
nls_date_format = YYYY-MM-DD HH24:MI:SS
nls_currency = $
nls_numeric_characters = .,
nls_iso_currency = AMERICA
nls_calendar = GREGORIAN
nls_time_format = HH.MI.SSXFF AM
nls_timestamp_format = YYYY-MM-DD HH24:MI:SS.FF
nls_time_tz_format = HH.MI.SSXFF AM TZR
nls_timestamp_tz_format = YYYY-MM-DD HH24:MI:SS.FF TZH:TZM
nls_dual_currency = $
nls_comp = BINARY
optimizer_index_cost_adj = 10
_add_col_optim_enabled = FALSE
转载地址:https://blog.csdn.net/weixin_33458486/article/details/116365764 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!