ITPub博客

 [ID 332187.1]Applies to:Enterprise Manager Base Platform. - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]SUSE \ UnitedLinux x86-64SymptomsChecked for relevance on 29-JUL-2010Grid Control 1...

CentOS yum软件包安装工具可以自动解决软件包依赖关系，方便的软件包升级，但是我没在本机用虚拟机来学习Centos时，由于默认的yum是以网络源来下载安装的，在没有网络下，通过yum来安装软件就要修改掉默认网络yum源...

手工锁表：lock table tbl_t1 in row share mode nowait;                --2lock table tbl_t1 in share update mode nowait;            ...

Applies to:Oracle GoldenGate - Version 4.0.0 to 11.2.1.0.1 [Release 4.0.0 to 11.2]Information in this document applies to any platform.Tables with nologging option can cause Extract to abend with OGG-...

Applies to:Oracle GoldenGate - Version 4.0.0 and laterInformation in this document applies to any platform.FixStarting Extract you see the error:GGS ERROR 190 No minimum supplemental logging is enable...

Applies to:Oracle Server - Enterprise Edition - Version 8.0.3.0 and laterInformation in this document applies to any platform.GoalOracle Internal Events, both named event (eg: ERRORSTACK) as numeric e...

alter session set timed_statistics=true;--打开timed_statisticsalter session set SQL_TRACE= true;--打开sqltracealter session set events '10046 trace name context forever, level 12';----打开wait...

Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.1.0.7 - Release: 8.1.7 to 11.1Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.1.0.7   [Relea...

 使用imp,impdp 导入数据时统计信息经常统计失败需要重新生成一 生成统计信息的方法如下:1 基于表exec DBMS_STATS.GATHER_TABLE_STATS(ownname => 'GFOLTP',tabname => 'TJFRECORD',GRANULARITY => 'ALL',casca...

Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.1 - Release: 10.2 to 10.2Information in this document applies to any platform.SymptomsAlert log is showing errors:ORA-00600:...

1.设置归档路径方式1alter system set log_archive_dest_1='location=/u03/archivelog' scope=spfile sid='node1'alter system set log_archive_dest_1='location=/u03/archivelog' scope=spfile sid='node2'方式ASM...