使用SQL_TRACE進(jìn)行數(shù)據(jù)庫診斷

http://www.eygle.com/case/Use.sql_trace.to.Diagnose.database.htm

為企業(yè)提供成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作、網(wǎng)站優(yōu)化、成都全網(wǎng)營銷推廣、競價(jià)托管、品牌運(yùn)營等營銷獲客服務(wù)。創(chuàng)新互聯(lián)建站擁有網(wǎng)絡(luò)營銷運(yùn)營團(tuán)隊(duì)，以豐富的互聯(lián)網(wǎng)營銷經(jīng)驗(yàn)助力企業(yè)精準(zhǔn)獲客，真正落地解決中小企業(yè)營銷獲客難題，做到“讓獲客更簡單”。自創(chuàng)立至今，成功用技術(shù)實(shí)力解決了企業(yè)“網(wǎng)站建設(shè)、網(wǎng)絡(luò)品牌塑造、網(wǎng)絡(luò)營銷”三大難題，同時(shí)降低了營銷成本，提高了有效客戶轉(zhuǎn)化率，獲得了眾多企業(yè)客戶的高度認(rèn)可！

包dbms_system定義如下：
SQL> desc dbms_system
PROCEDURE ADD_PARAMETER_VALUE
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
PARNAME                        VARCHAR2                IN
VALUE                          VARCHAR2                IN
SCOPE                          VARCHAR2                IN     DEFAULT
SID                            VARCHAR2                IN     DEFAULT
POSITION                       BINARY_INTEGER          IN     DEFAULT
PROCEDURE DIST_TXN_SYNC
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INST_NUM                       NUMBER                  IN
PROCEDURE GET_ENV
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
VAR                            VARCHAR2                IN
VAL                            VARCHAR2                OUT
PROCEDURE KCFRMS
PROCEDURE KSDDDT
PROCEDURE KSDFLS
PROCEDURE KSDIND
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
LVL                            BINARY_INTEGER          IN
PROCEDURE KSDWRT
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DEST                           BINARY_INTEGER          IN
TST                            VARCHAR2                IN
PROCEDURE READ_EV
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
IEV                            BINARY_INTEGER          IN
OEV                            BINARY_INTEGER          OUT
PROCEDURE REMOVE_PARAMETER_VALUE
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
PARNAME                        VARCHAR2                IN
VALUE                          VARCHAR2                IN
SCOPE                          VARCHAR2                IN     DEFAULT
SID                            VARCHAR2                IN     DEFAULT
PROCEDURE REMOVE_PARAMETER_VALUE
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
PARNAME                        VARCHAR2                IN
POSITION                       BINARY_INTEGER          IN
SCOPE                          VARCHAR2                IN     DEFAULT
SID                            VARCHAR2                IN     DEFAULT
PROCEDURE SET_BOOL_PARAM_IN_SESSION
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SID                            NUMBER                  IN
SERIAL#                        NUMBER                  IN
PARNAM                         VARCHAR2                IN
BVAL                           BOOLEAN                 IN
PROCEDURE SET_EV
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SI                             BINARY_INTEGER          IN
SE                             BINARY_INTEGER          IN
EV                             BINARY_INTEGER          IN
LE                             BINARY_INTEGER          IN
NM                             VARCHAR2                IN
PROCEDURE SET_INT_PARAM_IN_SESSION
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SID                            NUMBER                  IN
SERIAL#                        NUMBER                  IN
PARNAM                         VARCHAR2                IN
INTVAL                         BINARY_INTEGER          IN
PROCEDURE SET_SQL_TRACE_IN_SESSION
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SID                            NUMBER                  IN
SERIAL#                        NUMBER                  IN
SQL_TRACE                      BOOLEAN                 IN
PROCEDURE WAIT_FOR_EVENT
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
EVENT                          VARCHAR2                IN
EXTENDED_ID                    BINARY_INTEGER          IN
TIMEOUT                        BINARY_INTEGER          IN

一、針對別的窗口開啟sql_trace功能，此功能可以在sql執(zhí)行前開啟，也可以在sql執(zhí)行后開啟。

--開啟sql_trace功能
exec dbms_system.set_sql_trace_in_session(42,1853,true);

--關(guān)閉sql_trace功能
exec dbms_system.set_sql_trace_in_session(42,1853,false);

--查詢trace文件位置：
select c.value || '/' || d.instance_name || '_ora_' || a.spid || '.trc' trace
FROM v$process a, v$session b, v$parameter c, v$instance d
WHERE a.addr = b.paddr
   AND b.audsid = userenv('sessionid')
   AND c.name = 'user_dump_dest';

二、針對別的窗口開啟10046事件，此功能可以在sql執(zhí)行前開啟，也可以在sql執(zhí)行后開啟。
--開啟10046事件
exec dbms_system.set_ev(42,1853,10046,12,'');

--關(guān)閉10046事件
exec dbms_system.set_ev(42,1853,10046,0,'');

--查詢trace文件位置：
select c.value || '/' || d.instance_name || '_ora_' || a.spid || '.trc' trace
FROM v$process a, v$session b, v$parameter c, v$instance d
WHERE a.addr = b.paddr
   AND b.audsid = userenv('sessionid')
   AND c.name = 'user_dump_dest';
網(wǎng)站題目：使用SQL_TRACE進(jìn)行數(shù)據(jù)庫診斷
標(biāo)題URL：http://weahome.cn/article/gsdpdp.html

真实的国产乱ⅩXXX66竹夫人,五月香六月婷婷激情综合,亚洲日本VA一区二区三区,亚洲精品一区二区三区麻豆

使用SQL_TRACE進(jìn)行數(shù)據(jù)庫診斷

http://www.eygle.com/case/Use.sql_trace.to.Diagnose.database.htm

其他資訊

網(wǎng)站制作

企業(yè)服務(wù)

網(wǎng)站建設(shè)

服務(wù)器托管