-
编辑 删除
ORACLE数据库Dataguard dg broker
ORACLE数据库Dataguard dg broker
-
编辑 删除
ORA-3136 错误解决 .
参考metalink的文档：Doc ID: Note:3136.1 and 465043.1WARNING: inbound connection timed out (ORA-3136)1.参数含义：SQLNET.INBOUND_CONNECT_TIMEOUT is set to a value in seconds and determines how long a client has toprovide the necessary authentication information to a database.INBO...
-
编辑 删除
ORA-27102:out of memory Linux-X86_64 .
1.startup Linux下oracle报以下错 ORA-27102:out of memory Linux-X86_64 Error: 28: No space left on device 2.检查alter日志报:Checkpoint not complete Current log# 3 seq# 514388 mem# 0: /opt/oracle/product/10.2.0/oradata/orcl/redo03.logThread 1 advanc...
-
编辑 删除
由于物化视图定义为on commit导致update更新基表慢的解决方案
由于物化视图定义为on commit导致update更新基表慢的解决方案以下是模拟和解决测试过程：(模拟update慢的过程)1、首先基于基表创建物化视图日志:create materialized view log on scott.emp with rowid;2、首先基于scott用户下emp创建物化视图：create materialized view mv_empREFRESH FAST on commitas...
