
daily log
HackersAndPainters
这个作者很懒,什么都没留下…
展开
-
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.原创 2013-04-10 16:06:54 · 2309 阅读 · 2 评论 -
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 to原创 2013-05-25 10:33:58 · 3346 阅读 · 0 评论 -
由于物化视图定义为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原创 2013-06-18 16:58:15 · 4991 阅读 · 0 评论