-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: import_chunk100
包含OLAP组件SCHEMA使用imp导入碰到严重性能问题
客户一个十几个G的用户尝试使用IMP导入到数据库中,执行时间超过了2天。 数据库版本为10.2.0.5 FOR LINUX X86-64,而导入的dmp文件是在10.2.0.3 FOR LINUX X86平台上导出的,这个用户包含了OLAP组件。 整个导入过程异常缓慢,一共不到20G的数据量,导入的时间超过了两天。虽然imp导入效率不高,但是也没有理由慢到如此地步,通过10046跟踪imp进程: *** 2012-08-07 17:25:03.099 *** ACTION NAME:() 2012-08-07 17:25:03.051 *** MODULE NAME:(imp@db (TNS V1-V3)) 2012-08-07 17:25:03.051 *** SERVICE NAME:(SYS$USERS) 2012-08-07 17:25:03.051 *** SESSION ID:(880.53796) 2012-08-07 17:25:03.051 ===================== PARSING IN CURSOR #61 len=6 … Continue reading
ORA-600(kghstack_underflow_internal_2)错误
数据库10.2.0.3 for Linux 32环境出现ORA-600(kghstack_underflow_internal_2)错误。 详细错误信息为: Tue Aug 7 08:36:43 2012 Errors IN file /ora/app/oracle/admin/ORC/udump/orcl_ora_29455.trc: ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2], [0xB72101E8], [], [], [], [], [], [] ORA-01013: USER requested cancel OF CURRENT operation ORA-01013: USER requested cancel OF CURRENT … Continue reading
Posted in BUG
Tagged dbms_aw_exp, imp, import_chunk100, kghstack_underflow_internal_2, olap, ora-1031, ORA-600
Leave a comment