专著oracle 技术
记录维护生产数据库的点点滴滴....
-
2008-10-13 22:40:28
/ Oracle数据库管理
安装了10.2.0.4 在hp-unix 上, 大家还需要打什么patch 吗?
查看(104)
评论(6)
-
2008-10-08 09:48:11
/ Oracle数据库管理
大家都知道默认创建的index 都是asc , b*tree index 按照所有键从小到大排序, 如果使用desc 的index 就是从大到小排序,在进行range scan 的时候性能上应该是一样的吧. 那么降序index 一般用在什么地方呢? order by index desc ? 按照我的理解order by 不论从小到大, 还是从大到小都是一样的.
查看(104)
评论(4)
-
2008-10-06 08:54:43
/ Oracle数据库管理
大家一般采用怎样的读写分离方案
查看(1117)
评论(37)
-
2008-09-01 11:32:47
/ Oracle数据库管理
os : aix 5.3 + hacmp 5.4.1db : 10.2.0. 3 racalert.logMon Sep1 03:49:17 2008Process startup failed, error stack:Mon Sep1 03:49:17 2008Errors in file /app/oracle/admin/racdb/bdump/racdb1_psp0_479298.trc:ORA-27300: OS system dependent operation:fork failed with status: 12ORA-27301: OS failure message: Not enough spaceORA-27302: failure occurred at: skgpspawn3Mon Sep1 03:49:18 2008Process PZ96 died, see its trace filetrace.logRedo thread mounted by this insta
查看(366)
评论(11)
-
2008-08-22 14:09:22
/ Oracle数据库管理
db version : oracle 10.2.0.3temp tablespace 扩展的比较大了. 我添加了一个新的临时文件, 想在删除旧的临时文件时. 错误:ORA-25152: TEMPFILE cannot be dropped at this time查找原因因为还有其它的会话在此tempfile 上有没有commit 的事务, 那么我怎么才能找出是哪个session 呢?执行步骤:1. alter tablespace temp add tempfile 'new_temp_file' size xxx2. alter database tempfile 'old_temp_file' offline;3. alter database tempfile 'old_temp_file' dropincluding datafiles;v$tempseg_usage ,
查看(159)
评论(5)
-
2008-08-21 16:22:57
/ Oracle数据库管理
windiws2003+oracle9208trace.logThe following deadlock is not an ORACLE error. It is adeadlock due to user error in the design of an applicationor from issuing incorrect ad-hoc SQL. The followinginformation may aid in determining the deadlock:Deadlock graph:---------Blocker(s)-----------------Waiter(s)---------Resource Nameprocess session holds waitsprocess session holds waitsTX-00040002-0000adef46174X46
查看(136)
评论(4)
-
2008-07-30 10:44:47
/ Oracle数据库管理
rac 环境 阻塞的一点研究.一: 单实例数据库[php]>time1 session 1usera@oradb> select * from v$mystat where rownumusera@oradb> update tab_2 set object_id=1 where object_id=59100;
查看(218)
评论(5)
-
2008-07-29 09:48:05
/ Oracle数据库管理
alert.logErrors in file /app/oracle/admin/racdb/udump/racdb2_ora_479398.trc:ORA-00600: internal error code, arguments: [4080], [1], [131], [], [], [], [], []Mon Jul 28 17:04:04 2008Following on-commit snapshots not refreshed :user_a.tab_mvError 600 trapped in 2PC on transaction 30.14.44852. Cleaning up.Error stack returned to user:ORA-00600: internal error code, arguments: [4080], [1], [131], [], [], [], [], []Mon Jul 28 17:04:04 2008Errors in file /app/oracle/admin/rac
查看(135)
评论(2)
