利用Oracle RDA快速收集Oracle产品分析数据
Remote Diagnostic Agent (RDA) 是一个工程师用Perl语言编写的命令行诊断工具,RDA提供统一的诊断工具支持包和预防的解决方法。提供给Oracle支持收集的客户环境全面的...
[oradebug命令学习1]Using ORADEBUG Utility
Using ORADEBUG UtilityORADEBUG utility is a debugging tool that sends debug commands through SQL*Plus to an Oracle process. It is primarily for use by developers and Oracle Support Services p...
[oradebug命令学习3]How to Enable SQL_TRACE for Another Session Using Oradebug
How to Enable SQL_TRACE for Another Session or in MTS Using Oradebug [ID 1058210.6]修改时间:2012-6-12类型:BULLETIN状态:PUBLISHED优先级:3***Checked for relevance on 12-Jun-2012***How to Enab...
[oradebug命令学习2]How to Use Oradebug to Get Trace File Name and Location
How to Use Oradebug to Get Trace File Name and Location [ID 310830.1]修改时间:2012-7-31类型:HOWTO状态:PUBLISHED优先级:3In this DocumentGoalFixReferencesApplies to:Oracle Server - Enterprise Ed...
[oradebug命令学习4]HANGANALYZE
PURPOSE-------This article explain how to generate HANGANALYZE trace files to diagnostic database HANG issues.When a database has a severe performance response time, the cause of the probl...
Oracle常用的小工具
1.dbfsize工具:[oracle@rhel1 oradata]$ dbfsize redo01.log Database file: redo01.logDatabase file type: file systemDatabase file size: 20480 512 byte blocks#显示文件系统块或Oracle块的大小,redo01....