Tag Archives: parallel

12c新增并行索引扫描

Posted on 2018/12/24 by yangtingkun

Oracle在12c之前对于索引范围扫描是没有办法并行执行的，从12.1开始，Oracle可以并行的执行索引扫描。 首先创建测试环境： SQL> create table t_para_ind (id number, name varchar2(30), created date);   Table created.   SQL> insert into t_para_ind select id, object_name, created from t_big;   6735106 rows created.   SQL> commit;   Commit complete.   SQL> create index … Continue reading →

Posted in ORACLE | Tagged , | Leave a comment

ORA-7445(kxfrSortGranuleInstance)错误

Posted on 2012/06/05 by yangtingkun

10.2.0.4 RAC for HP-UX上出现了这个错误。 错误信息为： Sat DEC 31 14:48:42 2011 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl1_ora_26183.trc: ORA-07445: exception encountered: core dump [kxfrSortGranuleInstance()+1248] [SIGBUS] [Invalid address alignment] [0x9FFFFFFFBDF45674] [] [] Sat DEC 31 14:49:26 2011 Thread 1 advanced TO log SEQUENCE 68840 CURRENT … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-600(ksnpost:ksnigb)错误

Posted on 2012/05/12 by yangtingkun

客户10.2.0.5 RAC for HP-UX ia64出现ORA-600(ksnpost:ksnigb)的错误。 错误信息如下： Wed Apr 25 16:32:21 UTC 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc: ORA-00600: Message 600 NOT found; No message file FOR product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb] Wed Apr 25 16:32:55 UTC 2012 Trace dumping IS performing id=[cdmp_20120425163255] … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

ORA-600(15214)错误

Posted on 2012/02/19 by yangtingkun

告警日志中包含ORA-600[15214]错误。 错误信息为： Fri Feb 03 01:21:47 EAT 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_p155_29897.trc: ORA-00600: internal error code, arguments: [15214], [0], [2], [], [], [], [], [] Fri Feb 03 01:21:49 EAT 2012 Trace dumping IS performing id=[cdmp_20120203012149]Fri Feb 03 01:21:47 EAT … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

数据泵导出出现ORA-31617错误

Posted on 2012/01/11 by yangtingkun

客户的Oracle10204 RAC FOR Hp数据库执行EXPDP并行导出时出现了这个错误信息。 导出报错如下： Export: Release 10.2.0.4.0 – 64bit Production ON Thursday, 12 January, 2012 6:10:00 Copyright (c) 2003, 2007, Oracle. ALL rights reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production WITH the Partitioning, … Continue reading →

Posted in ORACLE | Tagged , , , , | 1 Comment

ORA-7445(qerixGetKey)错误

Posted on 2011/12/06 by yangtingkun

执行并行查询时碰到的问题。 错误信息如下： Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p001_8093.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [21] [] [] [] Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p000_8091.trc: ORA-07445: exception encountered: core dump … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-600(krd_check_slaves_1)错误

Posted on 2011/10/16 by yangtingkun

物理STANDBY环境在进行恢复时碰到这个错误。 详细错误信息为： <pre lang=’SQL’>Sun Sep 11 06:59:47 2011 alter database recover datafile list clear Sun Sep 11 06:59:47 2011 Completed: alter database recover datafile list clear Sun Sep 11 06:59:47 2011 alter database recover datafile list 1 , 2 , … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment