ITPub博客

查看AWR各详细使用空间描述SQL> connect / as sysdbaSQL> @?/rdbms/admin/awrinfo.sqlIn this DocumentPurposeScope and ApplicationGeneral guidelines for SYSAUX space issuesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5 to 11.1.0.6Information in this document applies to any platform.PurposeThe purpose of this document is to give general guidelines for SYSAUX tablespace space issues to control and decrease the space usage. It refers to several metalink notes for details when ne

In this Document Goal Solution 1. Stop all CRS managed resources 2. Stop all CRS services 3. Reformat ALL partitions for OCR and voting disk files 4. Set TEMP and TMP variables 5. Locate the crssetup.config.bat script 6. Execute racgons from $CRS_HOMEbin 7. Run oifcfg to configure public and cluster_interconnect 8. Run Virtual IP Configuration Assistant (VIPCA) 9. Run Cluster Verification Uitility (cluvfy) 10. Create an export copy of the

In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3Oracle Server - Standard Edition - Version: 10.2.0.1 to 10.2.0.3Sun Solaris x86 (32-bit)HP-UX ItaniumIBM AIX Based Systems (64-bit)Linux ItaniumLinux x86-64Sun Solaris SPARC (64-bit)HP-UX PA-RISC (64-bit)HP Tru64 UNIXOracle Clusterware GoalThe goal of this document is to help customers who have accidentally deleted the OCR, voting disk or the files that are required for the operation of

In this Document Goal Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7Information in this document applies to any platform.Goal MOVING ASM DATABASE FILES FROM ONE DISKGROUP TO ANOTHER: Solution The preferred way of doing the file movement amoung ASM DISKGROUPS is using RMAN. RMAN is critical to Automatic Storage Management and is responsible for tracking the ASM filenames and for deleting obsolete ASM files. Since ASM files cannot be accessed

In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1Information in this document applies to any platform.GoalThe purpose of this note is to describe the method to create transportable tablespaces(TTS) where the source and destination databases are ASM-based. This method uses standard utilities such as; DataPump and the database package dbms_file_transfer. The dbms_file_transfer package will be used to transfer the Datapump metadata and da

10.2 Data Guard Physical Standby Switchover [ID 751600.1] 修改时间 15-DEC-2009 类型 REFERENCE 状态 PUBLISHED In this Document Purpose 10.2 Data Guard Physical Standby Switchover 1.0 Prerequisites / Preparation 2.0 Pre-Switchover Checks 3.0 Switchover 4.0 Post-Switchover Steps 5.0 Create a Guaranteed Restore Point on Each Switchover Database 6. ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4Information in this document ap

OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE), including moving from RAW Devices to Block Devices. [ID 428681.1] 修改时间 16-NOV-2009 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6Information in this document applies to any platform.Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 GoalThe goal of this note is to provide steps to add, remove, replace o

参考ID 62143.11：理解Literal SQL2：Literal SQL versus Shared SQL当条件谓词是数字时，使用Literal 可以根据histogram statistics产生更精确的执行计划 ，在DDS中 parse time is small percentage of the exection time.3:Eliminating Literal SQL SELECT substr(sql_text,1,40) "SQL", count(*) , sum(executions) "TotExecs" FROM v$sqlarea WHERE executions < 5 GROUP BY substr(sql_text,1,40) HAVING count(*) > 30 ORDER BY 2；4：SESSION_CACHED_CURSORS parameter

Just about every DBA has had to deal with ora-1000 errors, "Maximum open cursors exceeded." This article will discuss initialization parameters that affect open cursors, the difference between open and cached cursors, closing cursors, and monitoring open and cached cursors.Open cursorsOpen cursors take up space in the shared pool, in the library cache. To keep a renegade session from filling up the library cache, or clogging the CPU with millions of parse requests, we set the parameter

http://jobs.zhaopin.com/P8/CC1207/8097/J902/501/CC120780976J90250113000.htm?f=ss&DYWE=1263778744153.428191.1263778744.1263778744.1http://jobs.zhaopin.com/P2/CC2652/0251/J902/500/CC265202518J90250000000.htm?f=ss&DYWE=1263778744153.428191.1263778744.1263778744.1[@more@]

Purpose: This bulletin focuses on latches. It attempts to give a clear understanding of how latches are implemented in the Oracle RDBMS and what causes latch contention. The information provided can be used in tuning the various kinds of latches discussed. Contents: 1. What is a Latch? 2. Latches vs Enqueues 3. When do we need to obtain a latch? 4. Latches request modes? 5. What c

PURPOSE-------This document shows the usage, benefit sand limitations for an Oracle 9i/10gDataGuard Configuration with Standby Redo Logs.SCOPE & APPLICATION-------------------All DBA's and Interested persons who wish to implement DataGuard inOracle 9i/10g (9.x-10.x).1. Standby Redo Logs - what are they and when to use them ??-------------------------------------------------------------Starting Oracle 9i you have to opportunity to add Standby Rodo Log Groups toyour Online Redo Log Groups. The

PURPOSE-------This document has been created with step-by-step instructions on how to create a Data Guard Physical Standby environment, derived from the 10G documentation. Although, this setup was tested with Linux, the procedure would be the same for any flavor of Unix.Note: For 10gr2 please refer:Note 343424.1 Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply Creating a Physical Data Guard scenario in 10G on Linux.=========================================

This is a reference note for the wait event "buffer busy waits" which includes the following subsections: Brief definition Individual wait details (eg: For waits seen in <<View:V$SESSION_WAIT>>) Systemwide wait details (eg: For waits seen in <<View:V$SYSTEM_EVENT>>) Reducing waits / wait times See Note:61998.1 for an introduction to Wait Events.Definition:Versions:7.0 - 10.2 Documentation: This wait happens when a session wants to access a database block in the

ORACLE 10安装问题：多网卡IP安装 网络检查错误可能原因：1：/etc/hosts增加2个IP的地址及主机名2：检查IP地址的子网掩码是否有错[@more@]ora

问题症状：swap使用爆炸式增长 从 2G->8G-20G，最后SWAP耗尽 数据库DOWN机分析：1: vmstat 查看内存 物理内存有剩余 CPU 磁盘正常2： 在SWAP到达8G的时候，数据库几乎没有大负荷性能SQL 数据库运行良好3：每次SWAP耗尽后 重启过2次服务器 每次都是运行几小时就出现同样问题问题最后解决：prstat -as size 发现 SIZE列进程ocssd.bin占用了39G496 oracle 39G 15M sleep 59 0 0:00.00 0.0% ocssd.bin/11ocssd.bin 进程介绍：Oracle 集群同步服务 (OCSSD) 是 Oracle 集群就绪服务 (CRS) 的一个组件，用于 RAC 和使用 ASM 的单个实例数据库。

"You are missing local node, localhost information. Enter public node name, private node name and virtual host name for all the nodes in“解决方案：设置网卡的绑定识别顺序打开网络连接-》菜单栏的高级-》高级设置 选择pub网卡为第一顺序/etc/host的配置内容：127.0.0.1 localhost# Public192.168.2.101 rac1.localdomain rac1192.168.2.102 rac2.localdomain rac2#Private192.168.0.101 rac1-priv.localdomain rac1-priv192.168.0.102 rac2-priv.localdomain rac2-priv#Virtual192.168.2.111

主题: RMAN: Tablespace Point In Time Recovery (TSPITR) Procedure. 文档 ID: 109979.1 类型: BULLETIN Modified Date: 28-JUN-2009 状态: PUBLISHED "Checked for relevance on 28-Jun-2009"Below describes TSPITR procedure using manual auxiliary intance. If you are running 10g or above, you may want to check below note that describes automaticTSPITR procedure:Note 335851.1 Automatic TSPITR in 10G RMAN -A walk ThroughTablespace point in time recovery (TSPITR) wi

文档 ID: 28814.1 类型: BULLETIN Modified Date: 23-SEP-2009 状态: PUBLISHED Handling Block Corruptions in Oracle7 / 8 / 8i / 9i / 10g / 11g Contents Introduction Overview of Steps to handle a Corruption Corruption due to NOLOGGING or UNRECOVERABLE (1) Determine the Extent of the Corruption Problem (2) Replace or Move Away from Suspect Hardware (3) Which Objects are Affected ? Options for various Segment Types: CACHE CLUSTER INDEX PARTITION INDEX LOBIND

调用：c:delete_log.bat=============contentcscript c:delete_log.vbs====================delete_log.vbs '需要自定义3个常量 Delete_Log_Dir Delete_Long Delete_His_Record' Option Explicit Dim m_lngFileCount Dim m_objFSO Const Delete_Log_Dir="E:HH" '定义被删文件所在目录' Command1_Click Private Sub DelFolder(strPath) Const ForReading = 1, ForAppending = 8 Const Delete_Long=2 '定义需要删除多少天前的日志' Const Delete_His_Record="c:kxt_errlo