ITPub博客

http://jobs.zhaopin.com/P2/CC2856/3311/J902/500/CC285633119J90250000000.htm?f=sshttp://jobs.zhaopin.com/P2/CC3377/7991/J902/500/CC337779913J90250015000.htm?f=sshttp://jobs.zhaopin.com/P2/CC2822/7761/J902/500/CC282277614J90250009000.htm?f=sshttp://jobs.zhaopin.com/P2/CC2770/1991/J902/500/CC277019912J90250005000.htm?f=sshttp://jobs.zhaopin.com/P2/CC2584/1471/J902/500/CC258414710J90250005000.htm?f=sshttp://jobs.zhaopin.com/P10/CC0001/8449/J900/001/CC000184490J90000147000.htm?f=ss[@more@]

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

If you've been developing applications on Oracle for a while, you've no doubt come across the concept of «Bind Variables». Bind variables are one of those Oracle concepts that experts frequently cite as being key to application performance, but it's often not all that easy to pin down exactly what they are and how you need to alter your programming style to use them. To understand bind variables, consider an application that generates thousands of SELECT statements against a table; f

Trevor -- Thanks for the question regarding "Parse CPU to Parse Elapsed", version 8.1.7Submitted on 1-Jun-2003 20:12 Central time zoneTom's latest followup | Bookmark | BottomLast updated 26-May-2010 7:38You Asked Hi Tom, I got given a statspack report to check out. The Parse CPU to Parse Elapsed seems terrible. In you book Expert 1 on 1 page 481 your example was 87.88% and you say for every CPU second it spent about 1.13 seconds of wall clock time. How did you work out 1.13

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

razvan -- Thanks for the question regarding "in and out variables - whats the difference", version 7.3.2Submitted on 19-Jun-2000 9:36 Central time zoneTom's latest followup | Bookmark | BottomLast updated 4-Mar-2008 7:31You Asked hello tom, can you explain me what is the diference between variables in and out in pl/sql? thanks a lot razvan and we said...An IN parameter can be read but not written to in plsql. If I attempt to modify an IN parameter -- it will fail at compile t

Oracle RAC是一个比较复杂的东西，拥有众多进程和组件，每个进程都会写入自己的日志文件。 对于这些日志文件，有一些开关，可以控制写入信息的详细程度，这些开关，在Oracle文档光盘里面并未提供，要修改这些开关，大致有三种方法：一、通过配置文件来修改二、通过环境变量来修改三、通过为每个组件设置debug等级来修改 以下介绍每一种和第三种方法，附件的脚本，是将第三种方法做了自动化，只需要按照以下方法使用，即可完成debug开关的修改：perl crs_debug_level.pl level=1 要禁用debug模式，则设置level为0：perl crs_debug_level.pl

修改时间 08-MAR-2010 类型 FAQ 状态 PUBLISHED Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.1 - Release: 9.2 to 11.2PurposeFrequently Asked Questions for Real Application Clusters and Grid Infrastructure.Questions and AnswersGrid Computing / RACGeneral RACWhat is Cache Fusion and how does this affect applications? Is it difficult to transition (migrate) from Single Instance to Oracle RAC? What are the dependencies between OCFS and ASM in Oracle Database 10g ?

问题症状：ORA-1632: max # extents 4096 reached in index PERFSTAT.STATS$PARAMETER_PKORA-12012: error on auto execute of job 835ORA-01632: max # extents (4096) reached in index PERFSTAT.STATS$PARAMETER_PKORA-06512: at "PERFSTAT.STATSPACK", line 1390ORA-06512: at "PERFSTAT.STATSPACK", line 71ORA-06512: at line 1问题分析解决：The max extents error occurs when the current number of extents equals the maximum number of extents in the max_extents parameter for the object or the maxi

Applies to: Oracle Server - Enterprise Edition - Version: 7.3 to 9.2Microsoft Windows NT Terminal ServerMicrosoft Windows (32-bit)Oracle database instance, listener, clients attempting to connect via the listener. GoalThis document covers how to troubleshoot when the following errors are thrown to the client when it tries to connect from a client to the db instance running on Windows OS, via the listener -TNS-12500: TNS:listener failed to start a dedicated server processTNS-12540: TNS:internal l

问题产生：C:Documents and Settingsz9600261>sqlplus /nologSQL*Plus: Release 8.1.6.0.0 - Production on 星期三 5月 19 14:05:09 2010(c) Copyright 1999 Oracle Corporation. All rights reserved.SQL> connect sys/sys@orcl2.ap.enpad.org as sysdbaERROR：ORA-01031: insufficient privileges问题分析：以上使用远程SYSDBA连接管理数据库 ，所以必须满足2个条件1：remote_login_passwordfile=true2：正确创建密码文件orapwd FILE=$ORACLE_HOME/dbs/orapworclpassword=sys entries=20文件名称必须规范：orapwdSID[@more@]

... of the following errors: select output from table (dbms_workload_repository.awr_report_html (: Dbid, * ERROR at line 1: ORA-00904:: invalid identi . ...解决：sys用户授权grant all on dbms_workload_repository to perfstat;[@more@]

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

How does ASM work with RAID where striping and mirroring are already built-in? [ID 330398.1] 修改时间 24-NOV-2008 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application How does ASM work with RAID where striping and mirroring are already built-in?Applies to: Oracle Server - Enterprise Edition - Version: 10.1 to 11.1Information in this document applies to any platform.. PurposeHow does ASM work with storage subsystems such as RAID where striping and mirroring are

一：安装编译#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