Improved features to Deploy PeopleSoft on Oracle Grid

PeopleSoft new Features on the Grid Support for PeopleSoft Application Continuity Transparent Application Failover Fast Application Notification Active Data Guard support Workload Tagging Module, Action, Client and Service Information PeopleSoft Consumer Groups Support for Advanced Compression & Partitioning Oracle Grid new features RAC One Node & Instance Caging Single Instance RAC Database Cold Failover Limit . . . → Read More: Improved features to Deploy PeopleSoft on Oracle Grid

Best Practices for Automatic Failover Using Oracle Data Guard 10g Release 2

Agenda Fast-Start Failover Overview Fast-Start Failover, Details & Best Practices Failover Processing Flow Failover Events and Monitoring Best Practices Test Results Automatic Client Failover Questions? Failover Requirements Faster is better Downtime is bad If manual intervention is required, the time it takes to notify administrative staff can be lengthy Reliability is a must-have Correct procedure . . . → Read More: Best Practices for Automatic Failover Using Oracle Data Guard 10g Release 2

Make Money with Active Data Guard

Active Data Guard with Oracle Database 11g creates entirely new opportunities for I.T organizations that extend far beyond disaster recovery.

This presentation discusses how Active Data Guard, a new database option available with Oracle Database 11g will help I.T. organizations meet the challenge of enhancing the Quality of Service offered to their customers while at . . . → Read More: Make Money with Active Data Guard

x$ksusecst 内部视图详解

9i 中v$session_wait 是Oracle wait interface的一个主要用户接口,而该动态视图的内容来源于x$ksusecst内部视图:

SQL> select view_definition from v$fixed_view_definition where view_name=’GV$SESSION_WAIT’; VIEW_DEFINITION ——————————————————————————– select s.inst_id,s.indx,s.ksussseq,e.kslednam, e.ksledp1,s.ksussp1,s.ksussp1r,e. ksledp2, s.ksussp2,s.ksussp2r,e.ksledp3,s.ksussp3,s.ksussp3r, decode(s.ksusstim, 0,0,-1,-1,-2,-2, decode(round(s.ksusstim/10000),0,-1,round(s.ksusstim/10000))) , s.ksusewtm, decode(s.ksusstim, 0, ‘WAITING’, -2, ‘WAITED UNKNOWN TIME’, -1, ‘ WAITED SHORT TIME’, ‘WAITED KNOWN TIME’) from x$ksusecst s, x$ksled e where bit and(s.ksspaflg,1)!=0 and bitand(s.ksuseflg,1)!=0 and s.ksussseq!=0 and s.ksussop c=e.indx SQL> . . . → Read More: x$ksusecst 内部视图详解

9iRAC Tuning Best Practices (INTERNAL ONLY)

3.1 Buffer Cache and Shared Pool 3.1.1 Buffer Cache Sizing

The database buffer cache is used to keep database blocks in memory, so that we do not have to perform a disk read when we want to access the same database block again. Therefore we also get a lower latency to access a database block . . . → Read More: 9iRAC Tuning Best Practices (INTERNAL ONLY)

Patch set update 11.2.0.1.1 Readme quote

Patch set update 11.2.0.1.1 Readme quote:

Patch 9352237 – 11.2.0.1.1 Patch Set Update

Released: April 13, 2010

This document is accurate at the time of release. For any changes and additional information regarding PSU 11.2.0.1.1, see these related documents that are available at My Oracle Support (http://support.oracle.com/):

Note 854428.1 Patch Set Updates for Oracle Products Note 1061294.1 . . . → Read More: Patch set update 11.2.0.1.1 Readme quote

famous summary stack trace from Oracle Version 8.1.7.4.0 Bug Note

as this bug note claimed that:

PROBLEM: ——– Customer frequently receives the following errors while rollback of a transcation using Portal application:

ORA-603: ORACLE server session terminated by fatal error ORA-600: internal error code, arguments: [6856], [0], [0], [], [], [], [], []

ORA-600: internal error code, arguments: [25012], [3], [15], [], [], [], [], . . . → Read More: famous summary stack trace from Oracle Version 8.1.7.4.0 Bug Note

10.2.0.5 补丁集发布

大洋彼岸的4月30日早晨,期盼已久的10.2.0.5补丁终于发布了(等了大约有1年时间吧);直接接受的一些在10.2.0.4上的问题,oracle都宣布将在这个版本中解决;实际上我一度认为10.2.0.5不会发布了,因为作为一个奇数版本会给人一丝不够稳定的感觉,同时该版本之后不太可能会有后续的补丁集了,如果以一个奇数版本为10g的最终版本似乎不是最理想的方案,当然这番推断还有待验证。

新补丁的大小为1.2g,十分符合以往的惯例,附patch set note:

Oracle® Database Patch Set Notes 10g Release 2 (10.2.0.5) Patch Set 4 for Linux x86-64 Part Number E15229-01

Oracle® Database

Patch Set Notes

10g Release 2 (10.2.0.5) Patch Set 4 for Linux x86-64

E15229-01

April 2010

These patch set notes accompany the Oracle Database release 10.2.0.5 patch set. This document . . . → Read More: 10.2.0.5 补丁集发布