ITPub博客

Do I Need To Disable The GoldenGate DDL Trigger Before An Oracle DB Upgrade or PSU patching? [ID 971222.1] 修改时间 15-APR-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution References Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Issue: If you are performing any Oracle database upgrades, for

MMAN (Memory Manager) is a background process that manages the dynamic resizing of SGA memory areas as the workload increases or decreases. This process was introduced in Oracle 10g. [@more@]

What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? [ID 331000.1] 修改时间 22-DEC-2009 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1Information in this document applies to any platform. New back

What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? [ID 331000.1] 修改时间 22-DEC-2009 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1Information in this document applies to any platform. New back

oracle 11690 1 0 15:52 ? 00:00:00 ora_pmon_leifsoracle 11692 1 0 15:52 ? 00:00:00 ora_psp0_leifsoracle 11694 1 0 15:52 ? 00:00:00 ora_mman_leifsoracle 11696 1 0 15:52 ? 00:00:00 ora_dbw0_leifsoracle 11698 1 0 15:52 ? 00:00:00 ora_lgwr_leifsoracle 11700 1 0 15:52 ? 00:00:00 ora_ckpt_leifsoracle 11702 1 1 15:52 ? 00:00:00 ora_smon_leifsoracle 11704 1 0 15:52 ? 00:00:00 ora_reco_leifsorac

V$TEMPSEG_USAGE This view describes temporary segment usage. Column Datatype Description USERNAME VARCHAR2(30) User who requested temporary space USER VARCHAR2(30) This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in USERNAME. SESSION_ADDR RAW(4 | 8) Address of shared SQL cursor SESSION_NUM NUMBER Serial number of session SQLADDR RAW(4 | 8) Address of SQL statement

1.表的大小select segment_name, sum(bytes)/1024/1024 MByte FROM dba_segments WHERE 1=1 AND owner ='LC0049999' GROUP BY segment_name2.表的建立时间dba_objects[@more@]

select name, state from v$asm_diskgroup此视图在asm实例和db 实例中都能查询到。在这两个视图中看到的state是不一样的。asm实例 中state 返回MOUNTED db 实例 中state 返回 CONNECTED 对此视图的解释：In an Automatic Storage Management instance, V$ASM_DISKGROUP displays one row for every disk group discovered by the Automatic Storage Management instance. In a database instance, V$ASM_DISKGROUP displays one row for every Automatic Storage Management disk group mounted by the local Automatic Storage Managemen

Oracle GoldenGate and compressed tables [ID 1266389.1] 修改时间 17-JUN-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle GoldenGate - Version: 11.1.1.0.0 and later [Release: 11.1.1 and later ]Information in this document applies to any platform. Goal Oracle GoldenGate and compressed tables Solution OGG does not support compressed tables or partitions, neith

How To Setup GoldenGate To Maintain A Heartbeat With The Database [ID 965415.1] 修改时间 31-MAY-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ] Information in this document applies to any platform. Solution PROBLEM Some user accounts in the database are setup with session timeo

Oracle GoldenGate - Heartbeat process to monitor lag and performance in GoldenGate [ID 1299679.1] 修改时间 24-MAY-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution Applies to: Oracle GoldenGate - Version: 10.4.0.0 and later [Release: 10.4.0 and later ]Oracle GoldenGate - Version: 10.4.0.0 and later [Release: 10.4.0 and later]Information in this document applies to any platform. Affected Datab

Impact Of U.S. Daylight Saving Time (DST) Change On GoldenGate [ID 970384.1] 修改时间 11-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Q: Will the Daylight Saving Time (**) change impact my GoldenGate environment? Do I have to stop the Golde

Considerations For Choosing To Use A Datapump [ID 966106.1] 修改时间 24-MAY-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Issue:Choosing Whether to Use Datapumps or NotSolution Summary:GoldenGate offers two types (among others) of Extracts to m

What Does The HANDLECOLLISIONS Parameter Do? [ID 966207.1] 修改时间 11-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution QuestionWhat does HANDLECOLLISIONS do?AnswerHANDLECOLLISIONS is a Replicat parameter that is mainly used during initial loa

ORA-15018 ORA-15003 Unable To Create/Mount Diskgroup [ID 437081.1] 修改时间 24-DEC-2009 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3Information in this document applies to any platform. ***Checked for relevance on 24-Dec-2009*** Symptoms In Non- RAC system, while trying to create the diskgroup, foll

ASM Diskgroups are not mounted with spfile on ASM on next startup with crsctl command in 11gR2. [ID 1059856.1] 修改时间 04-MAY-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform. Symptoms 1. 11gR2 Grid Infrastr

TROUBLESHOOTING - ASM disk not found/visible/discovered issues [ID 452770.1] 修改时间 28-APR-2010 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6 - Release: 10.1 to 11.1Information in this document applies to any platform. ***Check

ASM Is Unable To Detect SCSI Disks On Windows. [ID 880061.1] 修改时间 10-SEP-2009 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 Microsoft WindowsMicrosoft Windows XP (64-bit Itanium)Microsoft Windows Server 2003 (64-bit Itanium)Microsoft Windows XP (64-bit AMD64 and Intel EM6

看了老熊的帖子http://www.laoxiong.net/tns_admin_and_oem_caused_accident.html发现遵守良好的操作规范是多么的重要。David.Guo所描述的操作规范很值得遵守： David.Guo Says: 1月 23rd, 2009 at 2:03 下午 1：管理的混乱是造成这种问题的根本，首先，开发库和生产库密码相同； 2：开发环境有到生产主机的tns 3：删除用户这样的权限给到了开发使用的用户 说说这样的问题在我们这怎么管理吧： 1：开发数据库和生产数据库的用户密码完全没有联系，且生产保密； 2：非生产网段不能使用生产用户登录数据库；

RMAN> catalog adssfdfs RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, bac kup, backuppiece, controlfilecopy, clone, datafilecopy, device, db_recovery_file _dest, reco