How to recreate the SYS.ALERT_QUE [ID 430146.1]
In this Document Goal Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2Information in this docum...
11113
How Nested Loop JOIN Works [ID 263517.1]
Applies ToOracle Server - Enterprise Edition - Version: 8.1.7 to 9.2.0.4Information in this document applies to any platform.GoalThis article explains how a nested loop join works.FixA nested loop joi...
How to Determine When PL/SQL Procedures Were Last Re-Compiled
ID 264242.1Applies ToOracle Server - Enterprise Edition - Version: 8.0.4.0 to 9.2.0.1This problem can occur on any platform.GoalHow to check the last recompile time of a procedure or a...
Extracting Datafile Blocks From ASM [ID 294727.1]
In this Document Purpose Scope and Application Extracting Datafile Blocks From ASM ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 10.1.0...
How to find the highest undo segment number
ID 294917.1PURPOSE-------How to find the highest undo segment that has been onlined in your database. SCOPE & APPLICATION-------------------This article is intended for database admi...
TRUNCATING A PARTITION WITH INDEXES [ID 292575.1]
Applies ToOracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.1.0.3Information in this document applies to any platform.GoalYou need to truncate a partition of a table which has a index.Will t...
Tracing session created through dblink [ID 258754.1]
PURPOSE-------To trace the session created through database link (dblink) SCOPE & APPLICATION-------------------Will help DBAs in generating traces from remote siteTRACING SESSION CREATED ...
古董HP DL580 G3 Oracle 10G数据库故障解决
环境:一个单位的HP DL580 G3 (300G*6 10Krpm RAID-5,Smart Arry 6i)Oracle 10.2.0.1 裸机RHEL 3.4 32Bit6月份刚接手的这台机器,本来想升级11G,但一直没有时间可以搞,经过持续优化Load Profile中每秒逻...
DBA误操作 ODU救命记 (非广告)
仍然是多事9月5日上午4号晚上睡的太晚,5号一来继续看那个DL580 G3 + Oracle 10.2.0.1裸奔机发现一个索引应该没太大用处,Toad下DESC 这个表调出了Table,原本想删掉那个无用索引,结果点了Toad中最右边Tr...
How To Restore Rman Backups On A Node With Different Directory Structures
ID 419137.1In this Document Goal Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and the...
oracleasm createdisk command fails: Device '/dev/emcpowera1 is not a partition
ID 469163.1SymptomsThe "oracleasm createdisk" command fails with the following error despite the device having been correctly partitioned:Marking disk "/dev/emcpowera1" as an ASM disk:...
ORA-15183 Unable to Create Database on Server using 11.2 ASM and GI
ID 1054033.1In this Document Symptoms Cause Solution Scalability RAC Community ReferencesApplies to:Oracle Server - Enterprise Edition - Vers...
How to Configure A Second Listener on a Separate Network in 11.2 GI
[ID 1063571.1修改时间:2012-7-21类型:HOWTO状态:PUBLISHED优先级:3没有任何注释注释 (0)为此文档评级通过电子邮件发送此文档的链接在新窗口中打开文档可打印页In this DocumentGoalFixReferencesApplies to...
TNS Listener Crash with Core dump [ID 549932.1]
In this Document Symptoms Cause Solution ReferencesApplies to:Oracle Net Services - Version: 10.2.0.3.0 to 11.1.0.6.0 - Release: 10.2 to 11.1Generic UNIXChecked for relevance o...
Bug 4538727 Applied column is not updated in V$ARCHIVED_LOG
This note gives a brief overview of bug 4538727. The content was last updated on: 01-APR-2008 Click here for details of each of the sections below.Affects: Product (Component)O...
CRS: Resource in UNKNOWN state and srvctl Cannot Start/Stop the Resource
ID 845709.1In this Document Goal SolutionApplies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1Information in this ...
Linux下可绕过Sendmail直接发邮件的nail/mail程式
1. 编辑/etc/mail.rc,添加如下set from=xxx@163.com smtp=smtp.163.comset smtp-auth-user=xxx@163.com smtp-auth-password=XXXXXX smtp-auth=login2. 使用mail命令发送测试邮件mail -s "test" xxx...
How to Remove a Database from OCR after Its ORACLE_HOME has been Deleted
ID 838138.1In this Document Goal Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4Information in this do...
How To Delete Archive Log Files Out Of +Asm? [ID 300472.1]
Applies to:Oracle Server - Enterprise Edition - Version: 10.1.0.3 to 11.1.0.7 - Release: 10.1 to 11.1Information in this document applies to any platform.GoalHow to delete archive log files out of +AS...