oracle常用的动态视图
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.
Wait Event Enhancements in Oracle 10g(zt)
http://www.dbspecialists.com/files/presentations/wait_events_10g.html Integrigy Corporation Oracle, Database, audit, security, Session, v$session, sys_context, fine grained auditing, fga 11.9999 Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-nam
Common Oracle Wait Event Descriptions(zt)
http://www.softcov.com/database/common--oracle-wait-event-descriptions-1.html【REVIEW】 Oracle wait events is an important measure of operating conditions based on Oracle and indicators. The concept of waiting for the event introduced in Oracle7.0.1.2, roughly 100 to wait for the event. In this paper, Oracle common wait events in detail.Oracle wait events is an important measure of operating conditions based on Oracle and indicators. The concept of waiting for the event introduced in
fast parse,soft parse,hard parse的区别
http://www.itpub.net/thread-877110-1-5.htmlSubject: SQL Parsing Flow Diagram Doc ID: Note:32895.1 Type: REFERENCE Last Revision Date: 20-OCT-2005 Status: PUBLISHED PURPOSE ~~~~~~~ The document gives a overview of Parsing. SCOPE & APPLICATION ~~~~~~~~~~~~~~~~~~~ For users requiring a general overview of how parsing works. Introduction ============ This article show the parsing mechanism as a f
Monitoring Open and Cached Cursors(zt)
ust about every DBA has had to deal with ora-1000 errors, "Maximum open cursors exceeded." This article will discuss initialization parameters that affect open cursors, the difference between open and cached cursors, closing cursors, and monitoring open and cached cursors. Open cursors Open cursors take up space in the shared pool, in the library cache. To keep a renegade session from filling up the library cache, or clogging the CPU with millions of parse requests, w
commit_write,commit_logging,commit_wait参数和oracle redo行为
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
Oracle的异步commit设置
In Oracle 10gR2, you can now choose to break this fourth property. Oracle's new asynchronous commit feature essentially allows you to trade durability for speed on a transaction-by-transaction basis. You can choose to break ACID compliance in this way by default, at the instance level; or you can choose to break it at the individual transaction level. Asynchronous Commit By default, Oracle's commits are durable. Oracle writes your changes to disk and doesn't return control of t
重新 create oracle Repository
emca -deconfig dbcontrol db -repos recreate[@more@]
set autotrace in SQL*Plus
set autotrace offset autotrace onset autotrace traceonlyset autotrace on explainset autotrace on statisticsset autotrace on explain statisticsset autotrace traceonly explainset autotrace traceonly statisticsset autotrace traceonly explain statisticsset autotrace off explainset autotrace off statisticsset autotrace off explain statisticsSetting autotrace allows to display some statistics and/or an query execution plan for DML statements.set autotrace on: Shows the execution plan as well as sta
oracle中 Wait Events 和可能原因(oracle doc)
wait events to possible causes and gives an overview of the Oracle data that could be most useful to review next. Table 10-1 Wait Events and Potential Causes Wait Event General Area Possible Causes Look for / Examine buffer busy waits Buffer cache, DBWR Depends on buffer type. For example, waits for an index block may be caused by a primary key that is based on an ascending sequence. Examine V$SESSION while the problem is occurring to determine the ty
查询oracle历史最大连接[会话]数
select * from v$license;V$LICENSE This view contains information about license limits. Column Datatype Description SESSIONS_MAX NUMBER Maximum number of concurrent user sessions allowed for the instance SESSIONS_WARNING NUMBER Warning limit for concurrent user sessions for the instance SESSIONS_CURRENT NUMBER Current number of concurrent user sessions SESSIONS_HIGHWATER NUMBER Highest number of concurrent user sessions since the instance
Java Monitoring, Management and Troubleshooting Tools
Monitoring and Management Tools You can use the following tools to monitor JVM performance and resource consumption. The tools described in this section are unsupported and experimental, and should be used with that in mind. They may not be available in future JDK versions. Platform support: jconsole: all platforms.jps, jstat, and jstatd: all platforms except Windows 98 and Windows ME. For more information, see Monitoring and Management for the Java Platform. java.lan
Window平台下的系统监视器以及“性能日志和警报“使用
Logman.exe loadTOCNode(2, 'moreinformation'); 您可以使用 Logman.exe 工具来完成以下操作: 通过指定远程计算机名称来从一个中央位置远程启动和停止日志文件数据收集。在一台计算机上配置数据收集,然后 从一个中央位置将该配置复制到多台计算机上。查询当前运行的日志和跟踪。示 例 loadTOCNode(3, 'moreinformation'); 如果 Sample_Log 是本地计算机上的一个现有性能日志的名称,logman start Sample_Log 命令将启动该日志。Relog.exe loadTOCNode(
enable run glance utility in windows CMD
Question:hi friends, why the error?. thanks # glance -m Welcome to GlancePlus ===================== GlancePlus Fatal Error Version: User : root(/dev/pts/ta) Date: Tue Jun 24 10:40:49 File : /crm/gp/source/glance/terminal.c Line: 180 System : saturno B.11.11 9000/800 Unable to initialize terminal. ansi is not a supported terminal.Answer:Do "echo $TERM" to determine your terminal type. Valid terminal types for glance are "vt100", "vt220", &q
netsh的强大功能
netsh netsh命令介绍方案 ( 这个blog系统自动把windows的路径分隔符号右斜线自动屏蔽了,我只好用/代替。阅读时候请注意) netsh 是windows系统本身提供的功能强大的网络配置命令行工具。导出配置脚本: netsh -c interface ip dump > c:/interface.txt 导入配置脚本: netsh -f c:/interface.txt 进入netsh环境后,在根级目录用exec命令也可以加载一个配置脚本。还有对wins、route、ras等网络服务的配置也可以通过Netsh的内置命令操作。下面是配置示例: C:/Documents and Settings/Administrator>netsh /?用法: net
RMI 各参数意义sun.rmi Properties
sun.rmi PropertiesWARNING: The properties described here are not supported, can change at any time, and only exist in certain implementations of RMI from Sun MicrosystemsTM. These properties are not part of the RMI public API. To see a list of the properties that are part of the RMI public API, please refer to the page, java.rmi Properties. Please Note: Unless otherwise stated, any output from these properties is sent to System.err. Each of the properties that have names ending in ".logLeve
IBM - Java Diagnostics Guide
http://publib.boulder.ibm.com/infocenter/javasdk/v5r0/index.jsphttp://publib.boulder.ibm.com/infocenter/javasdk/v1r4m2/index.jsp[@more@]Java Diagnostics Guide
JAVA线程dump的分析
http://developers.sun.com.cn/export/sites/default/ISVs/docs/docs/thead.htmlJAVA线程dump的分析http://www.ibm.com/developerworks/cn/websphere/library/techarticles/0903_suipf_javadump/利用 Java dump 进行 JVM 故障诊断 [@more@]java dump jvm
Thread Dump 和Java应用诊断
来源:http://gflei.javaeye.com/blog/492152Thread Dump 和Java应用诊断 Thread Dump是非常有用的诊断Java应用问题的工具,每一个Java虚拟机都有及时生成显示所有线程在某一点状态的thread-dump的能力。虽然 各个Java虚拟机thread dump打印输出格式上略微有一些不同,但是Thread dumps出来的信息包含线程;线程的运行状态、标识和调用的堆栈;调用的堆栈包含完整的类名,所执行的方法,如果可能的话还有源代码的行数。Thread Dump特点:能在各种操作系统下使用能在各种Java应用服务器下使用可以在生产环境下使用而不影响系统的性能可以将
ORB 相关的次代码
该文档说明了 WebSphere Application Server 高级版 Java ORB 中使用的次错误码。这些次代码不符合 CORBA 标准。符合 CORBA 的次代码通常以 OMG 指定的标识码开头,后面紧随供应商标识符及标识次代码的数字。然而,Java ORB 次代码中不包含供应商标识符。 次代码与 CORBA 异常相关联,并对可能发生的错误提供了更为详细的信息。异常名称与次代码不是一对一的映射。相反,一个次代码可以与几个异常名称相关联。根据所报告的异常,次代码消息可有不同的意思。 系统异常的次代码范围限制在 0 到 4095 之间。对于每个系统异常范围内的次代