cyr1974的个人空间

暂无签名

  • 博客访问: 156460
  • 博文数量: 61
  • 用 户 组: 普通用户
  • 注册时间: 2009-03-16 20:36
个人简介

暂无介绍

文章分类
文章存档

2014年(1)

2011年(1)

2008年(1)

2007年(35)

2006年(19)

2005年(2)

2004年(2)

我的朋友

发布时间:2014-03-21 14:57:49

Refer to Doc in Metalink and test in on Prod.I have one physical standby database in sync with the primary database with the logs being applied in the form of real time apply. As you might be aware, for the “Real Time Apply” implementation, we need to make sure that we have created the Standby.........【阅读全文】

阅读(3205) | 评论(0) | 转发(0)

发布时间:2011-06-21 11:46:28

oracle 10g dataguard 配置,物理standby,高的log file sync等待, 没有看见 log buffer space wait event,,所以buffer尺寸不打算调整 现在初步估计是i/o问题,和高的应用提交频率引起过多的log file sync, 但是看.........【阅读全文】

阅读(740) | 评论(0) | 转发(0)

发布时间:2008-05-15 14:33:17

SQL> drop table locations_demo;Table dropped.SQL> CREATE TABLE locations_demo 2 ( location_id NUMBER(4) 3 , street_address VARCHAR2(40) 4 , postal_code VARCHAR2(12) 5 , city VARCHAR2(30) 6 , state_province VARCHAR2(25) 7 , country_id CHAR(2) 8 , CONSTRAINT loc_id_pk PRIMARY KEY (location_id));Table created.SQL> insert into locations_demo values (1,'east load','100000','beijing','beijing','86');1 row created.SQL> insert int......【阅读全文】

阅读(22982) | 评论(0) | 转发(0)

发布时间:2007-09-02 14:43:48

VKTM - The virtual keeper of time provides wall-clock time and reference time for other sessions/processes. 时间参照进程,为其他进程提供时间参照FBAR - (sadly now renamed to FBDA partway through the beta) The flashback data archiver writes old row-versions of tables with 'flashback archive' enabled into flashback data archives on commit. Anyone remember Oracle v.5 BIFs? flashback 数据存档进程,负责写提交的变化数据到归档文件。注意不是归档日志DIAG - The diagnosibility process (DIAG) runs oradebug c......【阅读全文】

阅读(1768) | 评论(0) | 转发(0)

发布时间:2007-05-18 16:18:01

1 、创建目录及授权create directory exttab as 'F:oracleproduct10.2.0oradataexttab'GRANT READ ON DIRECTORY exttab TO system; GRANT WRITE ON DIRECTORY exttab TO system; 2、准备数据文件到相关目录F:oracleproduct10.2.0oradataexttab>dir Volume in drive F has no label. Volume Serial Number is 5B8D-A9E4 Directory of F:oracleproduct10.2.0oradataexttab2007-05-18 16:09 <DIR> .2007-05-18 16:09 <DIR> ..2007-05-18 15:17 221 1.dat2007-05-18 14:49 ......【阅读全文】

阅读(3212) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册