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