statspack 的若干使用技巧
Posts from ‘February, 2009’
Oracle ASH 和Session Tracing
从Oracle10g开始引入了V$ACTIVE_SESSION_HISTORY视图，用于查询用户活动会话的历史信息。
Oracle中密码设置管理（使用自带脚本utlpwdmg.sql）
Oracle中密码设置管理（使用自带脚本utlpwdmg.sql）
oracle 使用存储过程分割字符串为数组
oracle 使用存储过程分割字符串为数组
sqlplus限制命令使用的方法
sqlplus限制命令使用的方法
ORACLE SQL PLUS 使用技巧
ORACLE SQL PLUS 使用技巧
CentOS 5连接HP EVA8000实现multipath
CentOS 5连接HP EVA8000实现multipath
exec FLUSH DATABASE MONITORING INFO;
For performance reasons, the Oracle Database does not populate these views immediately when the actual modifications occur.
Run the FLUSH_DATABASE_MONITORING_INFO procedure in the DIMS_STATS PL/SQL package to populate these views with the latest information.
Gather Statistics with DBMS_STATS by Jeff
Gather Statistics with DBMS_STATS
CREATE DATABASE Statement Fails With ORA-1501 ORA-1519 ORA-604 ORA-942 Errors
HTML clipboard .style1 { color: #FF0000; } .style2 { background-color: #C0C0C0; } 文档 ID: 434557.1 类型: PROBLEM Modified Date: 08-NOV-2007 状态: PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 10.2.0.3 This problem can occur on any platform. Symptoms CREATE DATABASE statement fails with ORA-604 [...]