[20190522]How to get dump or list parameters set at session level.txt
[20190522]How to get dump or list parameters set at session level.txt
1.环境:
SCOTT@book> @ ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SCOTT@book> @ spid
SID SERIAL# PROCESS SERVER SPID PID P_SERIAL# C50
---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------
30 535 42553 DEDICATED 42554 26 245 alter system kill session '30,535' immediate;
alter session set sql_trace=true;
alter session set optimizer_mode=first_rows;
2.测试:
SYS@book> oradebug setospid 42554
Oracle pid: 26, Unix process pid: 42554, 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_42554.trc
--//检查/u01/app/oracle/diag/rdbms/book/book/trace/book_ora_42554.trc.
*** 2019-05-22 09:50:30.330
Received ORADEBUG command (#1) 'dump modified_parameters 1' from process 'Unix process pid: 43053, image: <none>'
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
sql_trace = TRUE
optimizer_mode = FIRST_ROWS
*** 2019-05-22 09:50:30.330
Finished processing ORADEBUG command (#1) 'dump modified_parameters 1'
*** 2019-05-22 09:50:38.410
Received ORADEBUG command (#2) 'tracefile_name' from process 'Unix process pid: 43053, image: <none>'
*** 2019-05-22 09:50:38.410
Finished processing ORADEBUG command (#2) 'tracefile_name'
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· PostgreSQL 和 SQL Server 在统计信息维护中的关键差异
· C++代码改造为UTF-8编码问题的总结
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库