oracle安装目录满了trace,Oracle 11g 定位trace文件

最新推荐文章于 2023-05-23 11:54:30 发布

weixin_39520204

最新推荐文章于 2023-05-23 11:54:30 发布

阅读量150

点赞数

文章标签： oracle安装目录满了trace

--查询数据库版本SQL>select*fromv$version;

BANNER--------------------------------------------------------------------------------OracleDatabase11g Enterprise Edition Release11.2.0.1.0-64bitProduction

PL/SQL Release11.2.0.1.0-Production

CORE11.2.0.1.0Production

TNSfor64-bitWindows: Version11.2.0.1.0-Production

NLSRTL Version11.2.0.1.0-Production--查询视图 v$diag_infoSQL>select*fromv$diag_info;

INST_ID NAME VALUE---------- -------------------- --------------------------------------------------1Diag Enabled TRUE1ADR Base d:\app\administrator1ADR Home d:\app\administrator\diag\rdbms\orcl\orcl1Diag Trace d:\app\administrator\diag\rdbms\orcl\orcl\trace1Diag Alert d:\app\administrator\diag\rdbms\orcl\orcl\alert1Diag Incident d:\app\administrator\diag\rdbms\orcl\orcl\incident1Diag Cdump d:\app\administrator\diag\rdbms\orcl\orcl\cdump1Health Monitor d:\app\administrator\diag\rdbms\orcl\orcl\hm1DefaultTraceFiled:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5744.trc

INST_ID NAME VALUE---------- -------------------- --------------------------------------------------1Active ProblemCount01Active Incident Coun0t--条件查询视图 v$diag_info where name = ‘ v$diag_info’SELECTvalueFROMv$diag_infoWHEREname='Default Trace File';--改变系统 sql_trace = trueSQL>altersystemsetsql_trace=true;

系统已更改。--sql查询SQL>select*fromdual;

DU--X--改变系统 sql_trace = falseSQL>altersystemsetsql_trace=false;

系统已更改。--查看trc文件，得到相关sql查询信息=====================PARSINGINCURSOR#16len=18dep=0uid=0oct=3lid=0tim=6209383360hv=942515969ad='7ff73f205f8'sqlid='a5ks9fhw2v9s1'select*fromdualENDOFSTMT

PARSE #16:c=15600,e=34241,p=0,cr=3,cu=0,mis=1,r=0,dep=0,og=1,plh=272002086,tim=6209383358EXEC#16:c=0,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=272002086,tim=6209383572FETCH#16:c=0,e=7916,p=2,cr=3,cu=0,mis=0,r=1,dep=0,og=1,plh=272002086,tim=6209391595STAT #16id=1cnt=1pid=0pos=1obj=116op='TABLE ACCESS FULL DUAL (cr=3 pr=2 pw=0 time=0 us cost=2 size=2 card=1)'FETCH#16:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=272002086,tim=6209392413***2012-10-1522:17:48.640CLOSE#16:c=0,e=49,dep=0,type=0,tim=6218121671=====================