酷酷娱乐网

站内广告

[20190522]How to get dump or list parameters set at session level.txt

时间:2020-09-24 16:30:04   作者:酷酷娱乐网   来源:www.kukuyl.com  
内容摘要:


[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'


本文章url:https://www.kukuyl.com/new/30000920.html

相关文章

本栏最新更新

本栏推荐

阅读排行

CopyRight 2018 - 2020 http://www.kukuyl.com 酷酷娱乐网 All Rights Reserved .