Unix下两种后台执行SQL脚本的方法
通常要单独在OS后台执行一个耗时的SQL脚本，采用如下两种方法： 方法一： 1、在其目录创建一个可执行脚本，如脚本名为 create_index.sh： $vi create_index.sh 2、编辑文件内容： sqlplus usern...
技术文章列表
17 篇Troubleshooting Performance Issues
 reports show I/O wait events in the "Top 5 Wait/Timed Even...
Troubleshoot Grid Infrastructure Startup Issues (Doc ID 1050908.1)
Purpose Scope Details Start up sequence: Cluster status Case 1: OHASD does not start Case 2: OHASD Agents do not start C...
Tracking Oracle initialization parameter changes
— parm_mods.sql—- Shows all parameters (including hidden) that have been modified. — Uses the lag func...
trace文件分析工具之二
如何使用trca：必须进入 trca/run 目录里面 或者把 /home/oracle/software/trca/run 放到SQL_PATH环境变量里面： ASM无法启动的问题分析(二）… ASM无法启动的问题分析(一）&...
TRACE Oracle跟踪事件
一、Oracle跟踪事件 Oracle提供了一类命令，可以将Oracle各类内部结构中所包含的信息转储(dump)到跟踪文件中，以便用户能根据文件内容来解决各种故障。设置跟踪事件有两种方法，一种是在init.ora文件中设置事件，这样ope...
Tale of a platform migration Solaris 10 SPARC 10.2.0.5 to Linux 11.2.0.2.6
Define a self-contained set of tablespaces. In other words, the tablespaces you export from the source must not contain ...
Tablespace Growth Report
Author JP Vijaykumar Date Sept 8 2013 Modified Sept 14 2013 /* The period range for this report is dependent on the snap...
Tablespace Growth History and Forecast (12c and Above)
For 10g, 11g, you can use Tablespace Growth History and Forecast (10g, 11g) and Database Growth History and Forecast (10...
Tablespace growth
SELECT TO_CHAR (sp.begin_interval_time,'DD-MM-YYYY') days > , ts.tsname> , max(round((tsu.tablespace_siz...
SYSAUX表空间的重建试验_jinhb
2012-03-13 09:34阅读：2,007[http://www.itpub.net/forum.php?mod=viewthread&tid=1477610&highlight=sysaux]()
SYSAUX表空间的重建
Syncing Standby Database Using SCN Based Backup
In Oracle dataguard environment sometime we face issues with slow network pushing us into situation where the changes ar...
Step by Step Install 11gr2 RAC in Silent Mode_1
本文实验环境以vbox虚拟机，OEL5.8 X64下完成，ASM底层采取udev管理。以下为详细实验步骤，留给以后参考。OS安装及共享设备设置略过。非明确指出，即表明所做操作为两个节点。# 1.安装前准备 1.1.关闭非必要进程 chkco...
Step by Step Install 11gr2 RAC in Silent Mode
本文实验环境以vbox虚拟机，OEL5.8 X64下完成，ASM底层采取udev管理。以下为详细实验步骤，留给以后参考。OS安装及共享设备设置略过。非明确指出，即表明所做操作为两个节点。# 1.安装前准备 1.1.关闭非必要进程 chkco...
Step By Step Golden Gate Configuration
GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as...