作者: Maclean Liu, post on December 17th, 2010 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
作者: Maclean Liu, post on November 26th, 2010 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
作者: Maclean Liu, post on November 18th, 2010 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
作者: Maclean Liu, post on July 7th, 2010
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 内部视图详解
作者: Maclean Liu, post on June 15th, 2010
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)
作者: Maclean Liu, post on June 9th, 2010
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
作者: Maclean Liu, post on May 22nd, 2010
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
作者: Maclean Liu, post on May 1st, 2010 大洋彼岸的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 补丁集发布
|
|
最新评论