ITPub博客

ORA-01591错误故障处理 摘要： 在访问某些表的特定行时报ORA-01591错误 select * from BF_INCOME_EXPENSES_T where account_id = 36816153 and user_id = 39964213 and city_code = '185' ORA-01591: 锁定已被有问题的分配事务处理72.0.1608712挂起 SQL> select count(*) from UNITELE.BI_MQSYNC_SOURCE_CONTROL_T1; ORA-01591: 锁定已被有问题的分配事务处理72.0.1608712挂起 由于该表是业务关键表，部分前台业务受到影响。 关键词：ORA-01591 DBA_2PC_PENDING 分布式事务 1.故障分析 首先，

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

在oracle10g数据库上经常看到一些ora_pz进程From Oracle 10g onwards you will find on every node slave processes like pz99. This are the processes that query the gv$ viewsselect * from gv$px_process; INST_ID SERV STATUS PID SPID SID SERIAL#---------- ---- --------- ---------- ------------ ---------- ---------- 2 PZ99 IN USE 35 24994 2562 53336 2 PZ98 AVAILABLE 109 3905 2 PZ97 AVAILABLE 1229 4260

运行oracle自己的工具就可以查询锁的信息You can also use the utllockt.sql script to display lock wait-for in a hierarchy. The script prints the sessions that are waiting for locks and the sessions that are blocking. You must run the catblock.sql script (found in $ORACLE_HOME/rdbms/admin folder) as a sysdba user before using utllockt.sql. The catblock.sql script creates the dba_locksand dba_blockers views along with others that will be used by utllockt.sql[@more@]

10g推出了回滚段自动调整的新特性，但是在实际工作中经常出现回滚表空间100%的情况。建议关闭自动调整功能 Alter system set "_undo_autotune" = false; Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow

/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} From a SQL*Net perspective, the only thing

最近在虚拟机器上安装了下oracle 11g rac，总体安装流程跟oracle 10g rac安装区别不大[@more@]

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;

了解下oracle11g在physical standby模式下可以在standby数据库打开状态下进行数据恢复，考虑这种方式可以实现使用standby数据库进行数据查询。自己做个测试，了解下 v:* {behavior:url(#default#VML);} o:* {behavior:url(#default#VML);} w:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* St