- 博客(23)
- 资源 (6)
- 收藏
- 关注
转载 How to collect the full path name of the files in ASM diskgroups (文档 ID 888943.1)
In this Document Goal FixAPPLIES TO:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Information in this document a
2015-09-30 16:41:34 460
转载 Oracle: Network Waits
Contents1 Introduction2 SQL*Net Wait Events2.1 SQL*Net message from client2.2 SQL*Net message to client 2.3 SQL*Net more data to client 2.4 SQL*Net more data from client2.5 SQL*N
2015-09-29 16:36:45 593
转载 Execute to Parse及Soft Pars
The ratios quoted can be derived from the above as follows:Execute to Parse %: 100 * (Executes - Parses) / ExecutesSoft Parse %: 100 * (Parses - Hard Parses) / ParsesSo why not look at P
2015-09-28 11:20:27 487
转载 观察UDP buffer size 情况
UDP is a perfectly viable protocol. It is the same old case of the right tool for the right job!If you have a program that waits for UDP datagrams, and then goes off to process them before returning
2015-09-26 10:58:00 3078
转载 Know more about RAC statistics and wait event
以下列出了RAC中的主要统计信息和等待事件: 1. Statistics:1.1 V$SYSSTAT, V$SESSTAT (join to V$STATNAME)gc cr blocks servedgc cr block build timegc cr block flush timegc cr block send timegc current blocks servedgc
2015-09-22 22:18:22 1356
原创 使用onsctl ping显示ons is not running
显示如下[oracle@sdb1 ~]$ onsctl pingNumber of configuration nodes retrieved: 30: {node = sdb2.liteon.com, port = 6200}Adding remote host sdb2.liteon.com:62001: {node = sdb1.liteon.com, port = 62
2015-09-20 09:54:33 1108
原创 手工添加RAC Instance
手工添加RAC Instance1 环境准备 10.2.0.5 on Oracle Linux 5.8 ;SDB2,SDB3上已经正常配置了Instance,现在要添加SDB1到RAC;SDB1上Cluster已经正常安装,Oracle Home及ASM Home已经是RAC Enabled;ASM instance已经在SDB1上正确配置并启用以下步骤是如何手工添加SDB
2015-09-18 08:50:29 723
转载 设置 oracle sqlplus DBMS_OUTPUT.put_line
1 设置DBMS_OUTPUT.put_line输出显示 SET SERVEROUTPUT ON 2 关闭DBMS_OUTPUT.put_line输出显示 SET SERVEROUTPUT OFF 3 设置DBMS_OUTPUT缓冲区大小 SET SERVEROUTPUT ON SIZE number(1000) 4 设置只显示DBMS_OUTPUT默认的长度
2015-09-16 10:14:38 2454
转载 semi joins
2) semi joins are joins that stop when the first hit is encountered. They are used many times for "existence" checks.select * from dept where deptno in (select deptno from emp);that could use
2015-09-14 22:30:48 329
转载 Understanding Explain Plan
Benjamin Disraeli, circa 1870 wrote:Never complain and never explain.Disraeli was a lot of things, but Oracle Programmer was not amongst them. To be fair, perhaps he wasn't talking about
2015-09-11 08:58:46 376
原创 如何修改thread 为public或private
10.2.0.5 on oracle linux 5.8 oracle clusterware3 nodes: sb1, sdb2, sdb3,其中两个thread 是private的OPEN PRIVATE1 RACTEST2 SDB2OPEN PUBLIC 2 RACTEST1 SDB1OPEN PRIVATE 3 RACTEST3
2015-09-10 11:31:54 1752
转载 Convert Single Instance to RAC – Part 2: Manually Convert to RAC
In part 1 I explained how to duplicate a single instance database using RMAN. This article will focus on converting the single instance to RAC.2. Convert Single instance to RACWe have migrat
2015-09-09 20:44:24 667
转载 Initialization Parameter files: PFILEs vs. SPFILEs
Initialization Parameter files: PFILEs vs. SPFILEsSubmitted by admin on Sun, 2003-08-03 19:29RDBMS ServerWhen an Oracle Instance is started, the characteristics of the Instance are estab
2015-09-09 19:43:57 438
转载 ASMCMD fails to start on module libnnz10.so, permission denied
10.2.0.5 on oracle linux 5.8使用asmcmd出现以下错误:[oracle@sdb2 ~]$ export ORACLE_SID=+ASM1[oracle@sdb2 ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1[oracle@sdb2 ~]$ export ORACLE_HOME=/u01
2015-09-08 15:02:03 694
原创 如何查看RAC中spfile在何位置
10.2.0.5 on oracle linux 5.8使用如下命令查看:[oracle@sdb2 tmp]$ ocrdump -stdout -keyname DATABASE.DATABASES.ractest.SPFILE09/07/2015 14:24:00ocrdump -stdout -keyname DATABASE.DATABASES.ractest.SPFILE
2015-09-07 14:27:04 1779
转载 Connected to an idle instance-RAC 10.2.0.4.1
从以下文章可以得出在设定ORACLE_HOME环境变量的时候注意后面不要跟"/",如下设定是正确:ORACLE_BASE=/u01/app/oracleORA_CRS_HOME=/u01/crs/oracle/product/10.2.0/crsORA_ASM_HOME=/u01/app/oracle/product/10.2.0/asmORACLE_HOME=/u01/app
2015-09-07 10:03:17 737
原创 使用dbca添加new instance时报
10.2.0.5 on oracle linux 5.8已经有两个节点SDB1,SDB2 ,现在要使用DBCA添加第三个节点,在进行到以下步骤时出现错误。SID given in the connect descriptor could not be resolved.Connection to the database cannot be established be
2015-09-06 17:06:36 1658
原创 TNS-04612 error
10.2.0.5 on oracle linux 5.8使用dbca,在RAC添加第三个节点时报错 TNS-04612: Null RHS for "an tnsnames entry"。网上查到应该是tnsnames.ora里面对应的entry格式有问题造成的。之前该entry的格式如下:RACDB_LISTENER = (DESCRIPTION= (ADDRE
2015-09-06 10:00:29 1327
转载 How to Delete From or Add Resource to OCR in Oracle Clusterware (文档 ID 1069369.1)
How to Delete From or Add Resource to OCR in Oracle Clusterware (文档 ID 1069369.1)转到底部转到底部 In this DocumentGoalFix A. Terms/Variables used in this note B. Resource must be managed by
2015-09-06 09:54:04 1170
转载 Adding Users to Passwordfile / Using Passwordfile Authentication (Doc ID 184696.1)
Adding Users to Passwordfile / Using Passwordfile Authentication (Doc ID 184696.1)To BottomAPPLIES TO:Oracle Database - Enterprise Edition - Version
2015-09-05 22:17:38 503
转载 Correlation between MAXLOGHISTORY & CONTROL_FILE_RECORD_KEEP_TIME
Saibabu -- Thanks for the question regarding "Correlation between MAXLOGHISTORY & CONTROL_FILE_RECORD_KEEP_TIME", version 8.1.7Submitted on 5-Oct-2001 20:26 UTCTom's latest followup | Bookmark |
2015-09-01 21:38:50 778
转载 10g Manual Database Creation in Oracle (Single Instance and RAC) (文档 ID 240052.1)
10g Manual Database Creation in Oracle (Single Instance and RAC) (文档 ID 240052.1)转到底部PURPOSE-------The purpose of this bulletin is to give an example
2015-09-01 11:25:45 424
转载 How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure (文档 ID 7474
How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure (文档 ID 747457.1)转到底部In this DocumentGoal
2015-09-01 11:23:11 468
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人