长春平原网站建设,好网站的特点,上海建设工程网站,wordpress好还是dz好Automatic Diagnostic Repository (ADR)存放数据库诊断日志、跟踪文件的目录#xff0c;称作ADR base#xff0c;对应初始化参数diagnostic_dest。 如果设置了ORACLE_BASE环境变量#xff0c;DIAGNOSTIC_DEST等于ORACLE_BASE#xff0c;如果没有设置ORACLE_BASE#xff0c…Automatic Diagnostic Repository (ADR)存放数据库诊断日志、跟踪文件的目录称作ADR base对应初始化参数diagnostic_dest。 如果设置了ORACLE_BASE环境变量DIAGNOSTIC_DEST等于ORACLE_BASE如果没有设置ORACLE_BASE则等于ORACLE_HOME/log 。SQL show parameter diagnostic_destNAME TYPE VALUE------------------------------------ ----------- ------------------------------diagnostic_dest string /u01/productSQLdbtest$lsalert cdump hm incident incpkg ir lck metadata stage sweep trace可以通过 SQL select name,value from v$diag_info; 查看相关信息。ADRCI Command-Line Utility 命令行工具dbtest$which adrci/u01/product/oracle/bin/adrcidbtest$adrciADRCI: Release 11.2.0.1.0 - Production on Tue Aug 24 14:12:26 2010Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.ADR base /u01/producadrci备注 在adrci中命令大小写不敏感。在ADRCI中得到帮助adrci helpHELP [topic]Available Topics:CREATE REPORTECHOEXITHELPHOSTIPSPURGERUNSET BASESET BROWSERSET CONTROLSET ECHOSET EDITORSET HOMES | HOME | HOMEPATHSET TERMOUTSHOW ALERTSHOW BASESHOW CONTROLSHOW HM_RUNSHOW HOMES | HOME | HOMEPATHSHOW INCDIRSHOW INCIDENTSHOW PROBLEMSHOW REPORTSHOW TRACEFILESPOOLThere are other commands intended to be used directly by Oracle, typeHELP EXTENDED to see the listadrci