congshi5914-优快云博客

转载 CRS Command and UNKNOW status solution

常用的crs命令如下：$ORA_CRS_HOME/bin/crs_stat –t 此命令主要用来检查crs资源状态例如[oracle@rac2 css]$ $ORA_CRS_HOME/bin/crs_stat...

2009-11-23 13:30:11 206

转载 Oracle Easy Connect Naming method

在Oracle 10g中，Oracle还提供了一种称为“Oracle Easy Connect Naming method"的连接方式。这种方法是对hostnaming method的一种改进，因为hostnaming meth...

2009-11-23 13:12:02 439

转载 9i jdbc thin drive不支持Load balance

环境是WebSphere 6.0连接10g rac的时候连接出现负载均衡的问题。原因：当前WebSphere 6.0的JDBC驱动是9i的, 而且9.2.0.8以前的jdbc thin drive是不支持rac的负载均衡JDBC...

2009-11-23 12:55:59 228

转载 Latch Free事件处理

1. Monitor the Global System event for Latch free, up to now the wait time is hung about 655 secSQL> s...

2009-11-20 16:51:57 301

转载 Oracle10g的UNDO_RETENTION自动化管理增强

在AUM模式下，我们知道UNDO_RETENTION参数用以控制事务提交以后undo信息保留的时间。该参数以秒为单位，9iR1初始值为900秒，在Oracle9iR2增加为10800秒。但是这是一个NO Guara...

2009-11-20 16:50:26 141

转载关于undo_retention

意思是commit之后在undo中需要保留的时间，以秒为单位，主要是应对long query如果query发生在修改之前，此时可能需要通过undo来构造一致性读取，如果读不到，就报ora-01555Oracle uses the...

2009-11-20 16:49:45 132

转载利用v$session_longops监控long RUN操作

一、什么情况下，操作信息会出现在V$SESSION_LONGOPS同时满足以下几个条件，操作信息才会出现在V$SESSION_LONGOPS中。1、操作是以下几种操作之一# Table scan;# Index Fast Ful...

2009-11-20 16:48:32 130

转载 ORACLE正确删除归档并回收空间的方法

一个ORACLE归档日志经常满，表现为/oraarchive 这个文件空间占用100％大家一定抱怨ORACLE为何没有归档维护工具，很多人直接删除了事，错了，ORACLE有，而且很智能，可以正确的删除归档和 FLASHBACK，...

2009-11-20 16:36:44 117

转载 oracle 10g 归档日志清除

正常情况下应该在rman下删除archivelogrman>delete archivelog all;以下为手动删除archivelog物理文件后要进行的操作1, 手工清除后，数据库中还会存有记录：select * f...

2009-11-20 16:30:53 121

转载 Oracle时间模型统计SQL

到Oracle 10g，通过查询time model statistics可以找出应用程序在哪一类数据库操作中耗费了最多的时间，通过v$sys_time_model和v$sess_time_model这两个视图来实现。下面...

2009-11-20 16:29:27 93

转载 Rescueany Tablespace except SYSTEM

The following rescue scenario is the most powerful action to resolve for example complete loss of SYSAUX tablespac...

2009-11-20 16:28:48 91

转载 Rescue UNDO Tablespace

window.onerror=function(){return true;};INPUT,TEXTAREA,SELECT,.FCK__Anchor,.FCK__PageBreak,.FCK__InputHidden { beh...

2009-11-20 16:28:23 106

转载用ORACLE8i修复数据库坏块的三种方法

用ORACLE8i修复数据库坏块的三种方法在进行SUN CLUSTER双机切换、意外断电或其它情况下，有时会发生共享盘MOUNT不上的情况，需要使用FSCK对共享盘进行修复。修复完成后，在数据库启动过程中，却又出现"数据块损坏...

2009-11-20 16:24:21 93

转载用dbv和RMAN检查数据文件中的坏块

本文主要介绍了使用dbv和RMAN检查数据文件坏块的两个具体示例，详细内容请大家参考下文：1：用dbv检查D:\oradata\oralandba>dbv file=ORALANDBA.DBF block...

2009-11-20 16:20:18 189

转载 ORACLE数据库坏块的处理 (一次坏快处理过程)

今天处理了一个数据库坏块的问题，这种问题碰到很多次了，特此把处理过程纪录如下：1.根据报错的信息，用dbv确认一下，是否真的文件有坏块了，如果有，那继续，用下面的SQL查询出坏块为index还是数据，如果是索引，删除重建即可，如...

2009-11-20 16:18:21 351

转载 ORACLE数据库坏块的处理 (处理无对象坏快的方法)

数据库坏块的情况有很多，这里主要介绍如何处理不属于任何数据对象的数据文件坏块情况。有两种解决办法方法1：可以将发生坏块的数据文件，其所属表空间里的所有数据对象移动到别的表空间。然后将现有的数据文件删除并重建。该方法的缺点是很明显...

2009-11-20 16:17:06 263

转载 ORACLE数据库坏块的处理 (通过re-create table方法)

当Oracle数据库出现坏块时，Oracle会在警告日志文件(alert_SID.log)中记录坏块的信息:ORA-01578: ORACLE data block corrupted (file # 7, block # )O...

2009-11-20 16:15:21 367

转载 exp导出一张表的部分内容

其实很简单，我们所要利用的就是query这个选项，下面是个例子：exp scott/tiger tables=(emp) query=\"where job=\'Oracle DBA\' and sal<1600\" fi...

2009-11-20 16:14:51 337

转载 Oracle 9i exp/imp的回忆录

2009-11-20 16:13:44 95

转载 Oracle DBA在新环境下必须了解的事情

面对一个全新的环境,作为一个Oracle DBA,首先应该了解什么?在这里,不谈那些大的方面,比如了解整个IT环境整体情况,假设你已经知道了这些,接下来需要面对的就是这些一个个活生生的database了.这里总结了...

2009-11-20 16:12:38 95

转载 CM 8.4.2 Listener configuration in RAC env

SID_LIST_LISTENER_CMSUN17 =(SID_LIST = (SID_DESC = (SID_NAME = ICMLSExtProc) (ORACLE_HOME = /orac...

2009-10-18 17:35:46 103

转载 Quick steps to rebuild the CRS

Root user to perform. the following scripton node1------------cd $ORA_CRS_HOME/install./rootdelete.shon node2...

2009-10-18 17:25:09 75

转载 How to Change Interconnect/Public Interface IP or Subnet in Oracle Clusterware

Metalink 283684.1Purpose:----------------The purpose of this note is to describe how to change or update the clust...

2009-10-16 14:37:14 102

转载 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node

Metalink 276434.1Purpose--------------The purpose of this note is to illustrate the changing of a Virtual IP Addre...

2009-10-16 13:52:21 92

转载 10.2.0.3 VIP 漂移问题

问题描述： 3节点的Oracle 10.2.0.3版本RAC Oracle Patch merge6平台上主机P570，操作系统AIX 5***没有压力状态下，拔掉节点node1的2根public网线，发现VIP重启累计用时如...

2009-10-15 21:54:14 122

转载 Change AUTO_START in ASM Resource Oracle Clusterware

When a node stops and restarts, Oracle Clusterware starts the instance as soon as the node starts. This ...

2009-10-15 12:47:45 200

转载 Oracle RAC active-passive mode

ACTIVE_INSTANCE_COUNT enables you to designate one instance in a two-instance cluster as the primary instance and ...

2009-10-14 15:22:22 234

转载 How to Clean Up After a Failed Oracle Clusterware (CRS) Installation

PURPOSE-------The purpose of this document is to help DBA's and support analysts understand howto clean up a faile...

2009-08-25 10:39:11 67

转载 OCR和VOTING DISK的MIRROR DISK的添加和删除及备份

一、添加OCR1) 停止crs，分别在所有节点执行# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crsStopping resources.Succ...

2009-06-05 15:17:01 99

转载 Keeping the Library Cache Reload Ratio at 0 and the Hit Ratio Above 95 Percent

For optimal performance, you’ll want to keep the library cache reload ratio [sum(reloads) /sum(pins)] at zero and ...

2009-05-15 11:30:49 110

转载 Keeping the Data Dictionary Cache Hit Ratio at or above 95 Percent

The data dictionary cache is a key area to tune because the dictionary is accessed so frequently, especially by th...

2009-05-15 11:23:40 116

转载 Query the duration of log switch

Here is a query that will show you the time between log switches. It can be handy in determining if you have a pro...

2009-05-07 14:26:02 71

转载 Automatic Segment Space Management

Use ASSM instead of FREELISTS, FREELIST GROUPS, and PCTUSED.In version 9i of the database, Oracle introduced Autom...

2009-05-07 13:46:54 126

转载 Using the Correct Extent Size and Eliminating Fragmentation

It is recommended that you regularly monitor your database to find segments that are growing to extreme numbe...

2009-05-07 13:37:04 71

转载 Listing Chained Rows of Tables and Clusters

You can look at the chained and migrated rows of a table or cluster using the ANALYZE statement with the LIST...

2009-05-07 13:04:41 141

转载 Getting More Information about Partitions

We can retrieve the information regarding partitions by accessing user_tables, dba_part_tables,and user_segments....

2009-05-07 13:01:49 156

转载 Metalink bug dowload hints

9.2.0.4 = 30952779.2.0.5 = 35019559.2.0.6 = 39484809.2.0.7 = 41634459.2.0.8 = 454780910.1.0.3 = 376184310.1.0.4 = ...

2009-04-23 12:48:57 83

转载 Oracle LOB issue

For lob data we should pay attention for two options:store as (CHUNK NK disable storage in row/enable storage in r...

2009-04-01 15:05:21 68

转载 Use the statspack to generate the accurate explain plan

Get the snapshot with level=>6-------------------------------------------exec statspack.snap(i_snap_level =>...

2009-02-11 11:05:59 67

转载 How to enable the flashback database:

How to enable the flashback database:--------------------------------------[root@plinuxt19 ~]# su - oracle[oracle@...

2009-02-10 11:18:53 54

空空如也

空空如也