ITPub博客

本文转自：http://blog.xb668.com/?action=show&id=24 感谢原作者。请以root用户权限执行： 1) # snap -r 回答Y（如果以前未做过snap,系统会报错说明没有可清理的内容,显示“nothing to clean up”）， 完成后继续 2) 2) # snap -gbc 完成后,通过ftp (用binary方式,在命令行下执行:bin) 取得/tmp/ibmsupt/snap.pax.* 文件 (snap.pax.Z 或者snap.tar.Z) 然后执行 #errpt -a > /tmp/errpt.txt[@more@]

linux --sysreport ，还有一个dmidecode，不过dmidecode输出的信息都是些硬件的信息。aix--prtconf 或者snapwindows --msinfo32.exe 其实就是系统信息窗口。里边"文件"-"导出" 可以导出为txt文本格式hpux 有啥？[@more@]

检查定时任务的脚本发现：export ORACLE_SID= orcl注意，orcl前面多了个空格，把空格去掉即可。export ORACLE_SID=orcl[@more@]

Selects Against ALL_SYNONYMS Perform Badly on 10g Release 10.2 [ID 377037.1] 修改时间 01-DEC-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2Information in this document applies to any platform. Symptoms In some cases queries against the ALL_SYNONYMS vi

DBA_LOGSTDBY_NOT_UNIQUE displays all tables that have no primary and no non-null unique indexes. Most of the tables displayed by this view are supported because their columns contain enough information to be maintained in a logical standby database. Some tables, however, cannot be supported because their columns do not contain the necessary information. Unsupported tables usually contain a column defined using an unsupported datatype.Column Datatype NULL Description OWNER

关于oracle在linux系统下安装后，如何在系统重启的情况下让服务自动启动起来，网上有很多的教程和现成的脚本，这里只是个人工作中的一点经验。 以redhat as4和oracle 10g为例。单机在安装过程依照oracle官方的文档一步步下来，只要设置好参数、安装好必要的包，一般不会出什么问题。安装好了以后系统重 启，oracle重启服务，网上很多人建议自己写脚本（其实脚本也很简单），这里讲的是用oracle本身的脚本实现，当然不可避免最后还要写一点点的。 1、配置dbstart和dbshut 在$ORACLE_HOME/bin中，有dbstart和dbshut这两个脚本，

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