-
编辑 删除
How to create an Oracle 8i standby database
CREATING A STANDBY DATABASE:[@more@]Doc ID: Note:70233.1 Type: REFERENCE Last Revision Date: 04-MAY-2004 Status: PUBLISHED This document will provide the reader with basic step-by-step instructions on how to create a Standby Database on Oracle 8i (8.1.x). If you are using Windows,please also perform appropriate step also shown in this Note. For additional explanation or information on any of these steps, please see the referenceslisted at the end of the document.CREATING A STANDBY DATABASE:=====
-
编辑 删除
windows下自动备份oracle的脚本
AUTOEXP.BAT[@more@]:: ------------------------------------------------------------------:: Batchfile : NewDate.bat:: Purpose : A routine to parse the current date. Supports formats::: MM-DD-YYYY DD-MM-YYYY DD.MM.YYYY DD/MM/YYYY:: OS : Windows 95+, Windows NT4+:: Created : Tom Lavedas <lavedas@pressroom.com>, 20000717:: Adopted : Frank-Peter Schultze <fpschultze@bigfoot.de>, 20000719:: Revised : Frank-Peter Schultze <fpschultze@bigfoot.de>, 20050918:: ---------------------------
-
编辑 删除
分析schema的存储过程
CREATE OR REPLACE PROCEDURE SYSTEM.Analyze_Schema(owner_name varchar2,inc_idx_flag boolean) IS--tmpVar NUMBER;[@more@]CREATE OR REPLACE PROCEDURE SYSTEM.Analyze_Schema(owner_name varchar2,inc_idx_flag boolean) IS--tmpVar NUMBER;/******************************************************************************NAME: Analyze_SchemaPURPOSE: Analyze schema,If inc_idx_flag is true,then analyze all tables & indexes of the owner,else analyze all tables only.Automatically available Auto Replace Keywords
-
编辑 删除
Linux的load average的含义
$ uptime11:12:26 up 3:44, 4 users, load average: 0.38, 0.31, 0.19上面的输出，load average后面分别是1分钟、5分钟、15分钟的负载情况。数据是每隔5秒钟检查一次活跃的进程数，然后根据这个数值算出来的。如果这个数除以CPU的数目，结果高于5的时候就表明系统在超负荷运转了。其算法(摘自Linux 2.4的内核代码)如下：[@more@]$ uptime11:12:26 up 3:44, 4 users, load average: 0.38, 0.31, 0.19上面的输出，load average后面分别是1分钟、5分钟、15分钟的负载情况。数据是每隔5秒钟检查一次活跃的进程数，然后根据这个数值算出来的。如
-
编辑 删除
史上最强的FQA for ORACLE(备份与恢复部分)
Q]如何开启/关闭归档[@more@]Q]如何开启/关闭归档[A]如果开启归档，请保证log_archive_start=true开启自动归档，否则只能手工归档，如果是关闭了归档，则设置该参数为false注意：如果是OPS/RAC环境，需要先把parallel_server = true注释掉，然后执行如下步骤，最后用这个参数重新启动1、开启归档a. 关闭数据库shutdown immediateb. startup mountc. alter database archivelogd. alter database opne2、禁止归档a. 关闭数据库shutdown immediateb. startup mountc. alter database noarchivelogd. alter database open归档信息可以通过如下
