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

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2010年(35)

2009年(32)

2008年(1)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间: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......【阅读全文】

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

发布时间:2010-06-30 11:14:03

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

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

发布时间:2010-06-24 08:46:50

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

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

发布时间:2010-06-02 16:14:38

修改时间 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 ?......【阅读全文】

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

发布时间:2010-05-24 09:15:21

问题症状: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......【阅读全文】

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

登录 注册