ITPub博客

1：触发日志参数文件设置 EVENT "942 trace name ERRORSTACK level 3"当任何错误产生都会产生相应错误TRACE文件2：跟踪其他会话SQLObtain the Oracle process identifier or the Operating System process identifier (SPID) from v$process in an MTS environment: sqlplus /nolog SQL> connect / as sysdba SQL> select pid, spid from v$process p, v$shared_server s 2 where p.addr = s.paddr; PID SPID---------- ------------ 14 6976 2. Attach to t

SUMMARY:First determine which latch id(ADDR) are interesting by examining the number of sleeps for this latch. The higher the sleep count, the more interesting the latch id(ADDR) is:SQL> select CHILD# "cCHILD" , ADDR "sADDR" , GETS "sGETS" , MISSES "sMISSES" , SLEEPS "sSLEEPS" from v$latch_children where name = 'cache buffers chains' order by 5, 1, 2, 3;Run the above query a few times

A key is a column or expression on which you can build an index. Follow theseguidelines for choosing keys to index:■ Consider indexing keys that are used frequently in WHERE clauses.■ Consider indexing keys that are used frequently to join tables in SQL statements.For more information on optimizing joins, see the section "Using Hash Clusters forPerformance" on page 15-11.■ Choose index keys that have high selectivity. The selectivity of an index is thepercentage of rows in a table h

wallacel -- Thanks for the question regarding "design the table", version 8.1.6Submitted on 14-Feb-2001 19:27 Central time zoneTom's latest followup | Bookmark | BottomLast updated 16-Feb-2010 11:12You Asked Tom: when doing the database design , i have the following question. let's say we have emp table which have empid,empname,deptno, as well as empPicture, empGreeting, empFamilyPict. since we don't use empPicture , empGreeting( which is avi), empFamilypicture a lot, do you t

In this Document Purpose Scope and Application ORA-01555 "Snapshot too old" - Detailed Explanation Terminology ORA-01555 Explanation Solutions Examples Special Cases Summary ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 8.1.7.0Information in this document applies to any platform.Purpose@Checked for relevance on 16-MAY-2008This article will discuss the circumstances under which a query can return the Oracle error ORA-01555: snapshot too

How To Troubleshoot Memory Leaks on UNIX [ID 477522.1]PURPOSE-------To determine the amount of memory being used by Oracle processeson an AIX system.SCOPE & APPLICATION-------------------This article is intended for AIX system administrators andDBAs working on AIX systems, but can be used by anyone whowould like a better understanding of the way Oracle uses memoryon an AIX system.UNDERSTANDING ORACLE PROGRAM TYPES----------------------------------The first program type you should be aware of

PURPOSE This article is a reference to understand the output generated by the STATSPACK utility. Since performance tuning is a very broad area this document only provide tuning advice in very specific areas. Several documents are available in Metalink to resolve contention in specific resources. The following resources are available to find specific documentation related to a performance topic: Note 94224.1 FAQ- Statspack Complete Reference Oracle9i Database Performance Tuning Guide and Referenc

一：安装编译#cd $ORACLE_HOME/rdbms/lib#make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed#./bbed parfile=par.bbd建立2个参数文件 a.txt par.bbdoracle@vm1 oracle]$ more a.txt6 /u01/oracle/oradata/test/users01.dbf 262225922 /u01/oracle/oradata/test/users01.dbf.bak 26222592查询数据文件的file_id，file_name ,bytes[oracle@vm1 oracle]$ more par.bbdblocksize=8192listfile=a.txtmode=edit二：常见数据块操作1：根据ROWID查询某行所在的文件号，数据块， 列内容的OFFSET具体位置 数据文件号：SQL> select DBMS_ROWID.RO

In this Document Purpose Overview Scope and Application 10gR2 Streams Recommended Configuration Configuration 1.0 Software Version 2.0 Database Parameters 3.0 Database Storage 3.1. Tablespace for Streams Administrator queues 3. 2. Separate queues for capture and apply 4.0 Privileges 5.0 Source Site Configuration 5.1. Streams and Flash Recovery Area (FRA) 5.2. Archive Logging must be enabled 5.3. Supplemental logging 5.4. Implement a Heartbea

查看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

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

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.=========================================