- 博客(67)
- 收藏
- 关注
RSS订阅转载 英语招聘
http://jobs.zhaopin.com/P2/CC2856/3311/J902/500/CC285633119J90250000000.htm?f=sshttp://jobs.zhaopin.com/P2/CC3377/...
2010-11-29 10:24:05
166
转载 错误操作触发诊断日志
1：触发日志参数文件设置 EVENT "942 trace name ERRORSTACK level 3"当任何错误产生都会产生相应错误TRACE文件2：跟踪其他会话SQLObtain the Oracle process i...
2010-07-20 10:49:19
164
转载 [METALINK]How To Identify a Hot Block Within The Database Buffer Cache[ID 163424.1]
SUMMARY:First determine which latch id(ADDR) are interesting by examining the number of sleeps for this latch. The...
2010-07-16 10:11:38
131
转载 [转]PLSQL AND Bind variables
If you've been developing applications on Oracle for a while, you've no doubt come across the concept of «Bind Var...
2010-07-07 16:58:16
141
转载 [ASK TOM ]JAVA AND BIND VARIABLE
Trevor -- Thanks for the question regarding "Parse CPU to Parse Elapsed", version 8.1.7Submitted on 1-Jun-2003 20:...
2010-07-07 11:36:59
374
转载 [摘选]Choosing Columns and Expressions to Index
A key is a column or expression on which you can build an index. Follow theseguidelines for choosing keys to index...
2010-07-02 10:49:38
71
转载 [ASK TOM]PLSQL参数out copy and out nocopy
razvan -- Thanks for the question regarding "in and out variables - whats the difference", version 7.3.2Submitted ...
2010-06-30 11:14:03
618
转载 RAC Debug开关修改工具
Oracle RAC是一个比较复杂的东西，拥有众多进程和组件，每个进程都会写入自己的日志文件。 对于这些日志文件，有一些开关，可以控制写入信息的详细程度，这些开关，在Oracle文档光盘里面并未提供，要修改这些开关，大致有三种方...
2010-06-24 08:46:50
183
转载 RAC: Frequently Asked Questions [ID 220970.1]
修改时间 08-MAR-2010 类型 FAQ 状态 PUBLISHED Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to ...
2010-06-02 16:14:38
155
转载 ORA-1632: max # extents 4096 reached in index PERFSTAT.STATS$PARAMETER_PK
问题症状：ORA-1632: max # extents 4096 reached in index PERFSTAT.STATS$PARAMETER_PKORA-12012: error on auto execute of ...
2010-05-24 09:15:21
123
转载 How To Troubleshoot TNS: 12500 errors on Windows Platforms [ID 271072.1]
Applies to: Oracle Server - Enterprise Edition - Version: 7.3 to 9.2Microsoft Windows NT Terminal ServerMicrosoft ...
2010-05-19 16:57:44
97
转载 ORA-01031: insufficient privileges错误解决方法
问题产生：C:Documents and Settingsz9600261>sqlplus /nologSQL*Plus: Release 8.1.6.0.0 - Production on 星期三 5月 19 14:05...
2010-05-19 14:32:10
148
转载 AWR:select output from table(dbms_workload_repository.awr_report_html( :dbid, * ERROR
... of the following errors: select output from table (dbms_workload_repository.awr_report_html (: Dbid, * ERROR a...
2010-04-27 11:27:51
326
转载 "design the table", version 8.1.6
wallacel -- Thanks for the question regarding "design the table", version 8.1.6Submitted on 14-Feb-2001 19:27 Cent...
2010-04-12 10:57:51
613
转载 ORA-01555 "Snapshot too old" - Detailed Explanation [ID 40689.1]
In this Document Purpose Scope and Application ORA-01555 "Snapshot too old" - Detailed Explanation Terminol...
2010-04-08 14:36:01
100
转载 AIX: Determining Oracle memory usage on AIX [ID 123754.1]
How To Troubleshoot Memory Leaks on UNIX [ID 477522.1]PURPOSE-------To determine the amount of memory being used b...
2010-03-12 11:08:20
113
转载 Systemwide Tuning using STATSPACK Reports [ID 228913.1]
PURPOSE This article is a reference to understand the output generated by the STATSPACK utility. Since performance...
2010-03-11 10:16:36
117
转载 How does ASM work with RAID where striping and mirroring are already built-in? [ID 330398.1]
How does ASM work with RAID where striping and mirroring are already built-in? [ID 330398.1] 修改时间 24-NOV-2008 ...
2010-03-10 11:32:55
77
转载 BBED常见操作
一：安装编译#cd $ORACLE_HOME/rdbms/lib#make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed#./bbed parfile=par.bbd建立2个参数文件 a...
2010-02-24 15:39:18
93
转载 10gR2 Streams Recommended Configuration [ID 418755.1]
In this Document Purpose Overview Scope and Application 10gR2 Streams Recommended Configuration Configu...
2010-02-23 10:10:44
299
转载 General guidelines for SYSAUX space issues [ID 552880.1]
查看AWR各详细使用空间描述SQL> connect / as sysdbaSQL> @?/rdbms/admin/awrinfo.sqlIn this DocumentPurposeScope and Applic...
2010-02-08 10:19:31
82
转载 RAC on Windows: How To Reinitialize the OCR and Vote Disk (without a full reinstall of Oracle Cluste
In this Document Goal Solution 1. Stop all CRS managed resources 2. Stop all CRS services 3. Re...
2010-02-03 14:45:58
148
转载 How to recreate OCR/Voting disk accidentally deleted [ID 399482.1]
In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3Orac...
2010-02-03 14:44:42
89
转载 How to move ASM database files from one diskgroup to another ? [ID 330103.1]
In this Document Goal Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to ...
2010-02-02 10:03:53
67
转载 How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based [ID 394798.1]
In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1Info...
2010-02-02 09:56:17
94
转载 Data Guard(Data Guard Physical Standby Switchover )
10.2 Data Guard Physical Standby Switchover [ID 751600.1] 修改时间 15-DEC-2009 类型 REFERENCE 状态 PUBLISHED In t...
2010-01-27 11:22:50
545
转载 OCR / Vote disk Maintenance Operations(ICLUDING change path)
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE), including moving from RAW Devices to Block Devi...
2010-01-21 11:31:53
105
转载 shared pool 相关知识点
参考ID 62143.11：理解Literal SQL2：Literal SQL versus Shared SQL当条件谓词是数字时，使用Literal 可以根据histogram statistics产生更精确的执行计划 ...
2010-01-19 16:19:34
88
转载 Monitoring Open and Cached Cursors（转载）
Just about every DBA has had to deal with ora-1000 errors, "Maximum open cursors exceeded." This article will disc...
2010-01-18 10:26:20
81
转载 求职
http://jobs.zhaopin.com/P8/CC1207/8097/J902/501/CC120780976J90250113000.htm?f=ss&DYWE=1263778744153.428191.126...
2010-01-18 10:08:19
62
转载 What are Latches and What Causes Latch Contention [ID 22908.1]
Purpose: This bulletin focuses on latches. It attempts to give a cle...
2010-01-15 15:04:18
135
转载 应用Standby Redo Logs 减少数据的丢失 [ID 219344.1]
PURPOSE-------This document shows the usage, benefit sand limitations for an Oracle 9i/10gDataGuard Configuration ...
2010-01-14 16:05:26
122
转载 Creating a 10gr1 Data Guard Physical Standby on Linux [ID 248382.1]
PURPOSE-------This document has been created with step-by-step instructions on how to create a Data Guard Physical...
2010-01-14 15:39:30
69
转载 WAITEVENT: "buffer busy waits" Reference Note [ID 34405.1]
This is a reference note for the wait event "buffer busy waits" which includes the following subsections: Brief de...
2010-01-14 14:20:43
114
转载 ORACLE 10安装问题：多网卡IP安装 网络检查错误
ORACLE 10安装问题：多网卡IP安装 网络检查错误可能原因：1：/etc/hosts增加2个IP的地址及主机名2：检查IP地址的子网掩码是否有错[@more@]ora ...
2010-01-05 09:01:51
100
转载 ocssd.bin引起的SWAP空间不足问题
问题症状：swap使用爆炸式增长 从 2G->8G-20G，最后SWAP耗尽 数据库DOWN机分析：1: vmstat 查看内存 物理内存有剩余 CPU 磁盘正常2： 在SWAP到达8G的时候，数据库几乎没有大负荷性能SQ...
2009-12-24 10:20:35
453
转载 window+10g+rac安装问题
"You are missing local node, localhost information. Enter public node name, private node name and virtual host nam...
2009-11-16 15:54:29
81
转载 归档故障记录
据库出现归档日志无法归档，导致数据库无法访问。报警如下：Tue Nov 10 18:04:20 2009ORA-16014: log 7 sequence# 306128 not archived, no available d...
2009-11-11 14:49:06
109
转载 主题: RMAN: Tablespace Point In Time Recovery (TSPITR) Procedure.
主题:RMAN: Tablespace Point In Time Recovery (TSPITR) Procedure. 文档 ID:109979.1类型: BULLETIN ...
2009-11-03 11:37:29
49
转载 Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g
文档 ID:28814.1类型: BULLETIN Modified Date: 23-SEP-2009状态: PUBLISHEDHandling Block Corr...
2009-11-03 11:08:20
380
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人