-
编辑 删除
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...
-
编辑 删除
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 Convert LONG to a CLOB [ID 282464.1]
Checked for relevance on 28-OCT-2009PURPOSE-------How-To convert a LONG column to a CLOB to perform. substring operations on the data. SCOPE & APPLICATION-------------------VB, C/C++, Java,...
-
编辑 删除
How To Display The Values Of A Bind Variable In A SQL Statement [ID 1068973.6]
Checked for relevance on 17-Apr-2012 Problem Description-------------------PL/SQL is running in the database. At some point you want to dump the SQL statement along with the values that were su...
-
编辑 删除
How To Export Oracle Optimizer Statistics? [ID 903729.1]
In this Document Goal SolutionApplies to:Primavera P6 Enterprise Project Portfolio Management - Version: 5.0 and later [Release: 5.0 and later ]All Platform...
-
编辑 删除
How to check for open database cursors [ID 743605.1]
In this Document Purpose Software Requirements/Prerequisites Configuring the Script Running the Script Caution Script Scrip...
-
编辑 删除
EXPDP Fails With ORA-04031 ("streams pool", ...) [ID 457724.1]
In this Document Symptoms Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later [R...
-
编辑 删除
How to determine granule size [ID 947152.1]
修改时间 10-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution  ...
-
编辑 删除
ORA-00845 When Starting Up An 11g Instance With AMM Configured. [ID 460506.1]
修改时间 18-FEB-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause&...
-
编辑 删除
split分區踩到陷阱
[i=s] 本帖最后由 spider0283 于 2011-12-16 15:57 编辑 臨近12月31，吩咐下面兄弟檢查分區表，分區範圍不夠的要加分區結果他把一個3300萬的大表的MAX分區split了，這個MAX分區有800多筆數據這個表僅有的...
-
编辑 删除
Implementing Address Windowing Extensions (AWE) or VLM on 32-bit Windows
[ID 225349.1] 修改时间 27-APR-2011 类型 BULLETIN 状态 PUBLISHED Applies to: Oracle Server - Enterprise EditionMi...
-
编辑 删除
Howto set maximum user processes on AIX [ID 1084995.1]
修改时间 26-AUG-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal SolutionApplies...
-
编辑 删除
Fundamentals of the Large Pool [ID 62140.1]
修改时间 24-JUN-2009 类型 BULLETIN 状态 PUBLISHED Introduction~~~~~~~~~~~~ This short article describ...
-
编辑 删除
How to Enable Oracle SQLNET Tracing from Net Manager
[ID 395525.1]修改时间 30-SEP-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal &n...
-
编辑 删除
ASMM and LINUX x86-64 Hugepages Support [ID 1134002.1]
修改时间 20-JUN-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution &...
