• 博客访问: 147784
  • 博文数量: 68
  • 用 户 组: 普通用户
  • 注册时间: 2008-05-04 11:19
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2010年(35)

2009年(32)

2008年(1)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间:2010-07-20 10:49:19

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......【阅读全文】

阅读(846) | 评论(0) | 转发(0)

发布时间:2010-07-16 10:11:38

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 ......【阅读全文】

阅读(4128) | 评论(0) | 转发(0)

发布时间:2010-07-02 10:49:38

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......【阅读全文】

阅读(1190) | 评论(0) | 转发(0)

发布时间:2010-04-12 10:57:51

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......【阅读全文】

阅读(1162) | 评论(0) | 转发(0)

发布时间:2010-04-08 14:36:01

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 ......【阅读全文】

阅读(2132) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册