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...

表控制使用比例:select a.tablespace_name,       (sum(a.bytes) / (count(*) * 32 * 1024 * 1024 * 1024))*100  from dba_data_files a group by a.tablespace_name order by 2...

Applies to:Oracle Server - Personal Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3   [Releas...

Thomas Kyte现任甲骨文公司副总裁，是服务器技术部门的高级架构师。他是Oracle Magazine Ask Tom专栏的那个Tom，热心回答关于甲骨文数据库以及相关方面的各种问题。Thomas 是Oracle ACE，也是一位穿梭于世界各地Orac...

ORA-12545 or ORA-12537 Reported while Connecting to RAC through SCAN name [ID 970619.1]  修改时间 20-JAN-2010     类型 PROBLEM    &nbsp...

declare  VC_SQL   varchar2(200);  N_NUM NUMBER;begin  FOR I IN 1 .. 100 LOOP    for a in (select * from user_sequences) loop      VC_SQL := 'select ' || a....

1 amdu -diskstring '/dev/asm*'  生成 report.txt 可以查看磁盘组和磁盘信息具体信息如下:[grid@node1 ~]$ amdu -diskstring /dev/asm*LRM-00110: syntax error at '/dev/asm-diskb'AMDU-00101: LRM ...

1 删除无数据用分区(按照用户)declare  cnt int;  p_name varchar2(50);begin  for aa in (select t.partition_name,t.table_name               f...

1.alter tablespace tbs read only;2.alter tablespace tbs offline;3.在offline后拷贝一份原文件，并命名为新文件名4.alter tablespace tbs rename datafile 'tbs_file_old.dbf' to 'tbs_file_new.dbf';5.alter tab...

1 buffer cacheselect substr(sql_text,1,500) "SQL",sql_fulltext,                                    &nb...