Troubleshoot import(imp) very slow into table(nologging) has lob columns

  • 2020/11/28
  • ORACLE 9i-23ai
  • 288 views
  • Troubleshoot import(imp) very slow into table(nologging) has lob columns已关闭评论

一套ORACLE 11c R2 Windows环境使用import 导入一张包含blob列时速度非常的慢(平均每秒10条)，大家都知道imp里因为不能使用parallel等其它原因导入是慢一些，但这么慢不能忍,主要等待事件和时间是control file parallel write和enq: CF – contention，下面是分析一下原因。

, ,

阅读全文

Troubleshooting ORA-01578 ORA-01110 ORA-26040 NOLOGGING corrupted block

  • 2020/05/20
  • Cloud, ORACLE 9i-23ai
  • 2,474 views
  • Troubleshooting ORA-01578 ORA-01110 ORA-26040 NOLOGGING corrupted block已关闭评论

The following errors have recently occurred in our database( Oracle 19c RAC):
ORA-01578: ORACLE data block corrupted (file # xxx, block # yyyyy)
ORA-01110: data file xxx: ‘xxxxxxxxxxxxxxxxx.dbf’
ORA-26040: Data block was loaded using the NOLOGGING option

, , , ,

阅读全文