`
mathfox
  • 浏览: 36486 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

Oracle access path logical read "rules of thumb"

阅读更多
  • Access paths that lead to less than about 5 logical reads per returned row are probably good
  • Access paths that lead to up to about 10-15 logical reads per returned row are probably acceptable.
  • Access paths that lead to more than about 15-20 logical reads per returned row are probably ineffcient. In other words, there is probably room for improvement.
分享到:
评论

相关推荐

    A Logical Calculus of Ideas Immanent in Nervous Activity

    McCulloch 和 Walter Pitts 合著的经典论文《A Logical Calculus of Ideas Immanent in Nervous Activity》(一种内在神经活动中思想的逻辑计算)。该论文标志着现代神经网络理论的基础,并对后续的人工智能研究...

    Oracle Core Essential Internals

    Since this book is only a couple of hundred pages and the 11g manuals extend to tens of thousands of pages it seems unlikely that I could possibly be describing “the whole thing ” so let me qualify...

    Oracle Concepts中英文对照版

    Overview of Logical Database Structures Overview of Schemas and Common Schema Objects Overview of the oracle Data Dictionar Overview of the Oracle Instance Overview of Accessing the Database Overview ...

    运用logical standby技术实现Oracle数据库的读写分离

    在 MySQL 中,这通常通过简单的配置实现,但在 Oracle 中,由于其复杂性,实现读写分离可以采用多种方式,如 RAC、Streams、Golden Gate 或 Logical Standby。 Logical Standby 是 Oracle Data Guard 功能的一部分...

    Logical Foundations of Cyber-Physical Systems

    《Cyber-Physical Systems的逻辑基础》是由André Platzer所著,于2018年出版的一部专业书籍。这本书深入探讨了信息物理系统的理论基础,尤其侧重于这些系统的设计和分析与逻辑和计算思维的结合。...

    A logical calculus of the ideas immanent in nervous activity

    标题《A logical calculus of the ideas immanent in nervous activity》翻译成中文为《神经活动固有观念的逻辑演算》。这篇文章是神经网络领域的重要文献,发表于1943年,由沃伦·S·麦克卡洛克(Warren S. ...

    Linux逻辑盘卷管理LVM详解

    Linux逻辑盘卷管理(LVM,Logical Volume Manager)应运而生,作为一种高级的磁盘分区管理技术,它极大地提高了磁盘管理的灵活性和效率。 #### 二、LVM的概念与优势 **2.1 LVM的概念** LVM是一种建立在硬盘和分区...

    oracle-support oracleasmlib kmod-oracleasm包

    Oracle Support for Oracle ASM (Automatic Storage Management) 和 Kmod-OracleASM 包是Oracle数据库系统在Linux环境下进行存储管理的关键组件。这些包确保了在Red Hat Enterprise Linux (RHEL)、CentOS以及Oracle ...

    Logical Channel Descriptor and Allocation of Logical Channel Numbers

    在数字电视广播领域,特别是澳大利亚的免费地面数字电视传输中,逻辑信道描述符(Logical Channel Descriptor,简称LCH)与逻辑信道号(Logical Channel Number,简称LCN)的使用与分配是至关重要的技术细节。...

    running rac on oracle vm server for sparc 2.0

    Deploying Oracle RAC on Oracle VM Server for SPARC leverages the power of CoolThreads technology and logical domains to enhance application scalability and system utilization. By virtualizing the ...

    数据库性能监控

    session logical reads db block changes execute count user commits Concurrent Trans redo size redo writes parse count (total) parse count (hard) 指标项: #IO Latency db file sequential read(ms) log ...

    oracle最全面官方文档

    - **高级复制**:讲解Oracle的复制技术,如Logical Standby、GoldenGate等,用于数据同步和灾难恢复。 - **存储优化**:涵盖表压缩、索引压缩和In-Memory Option等存储优化技术。 - **数据库云服务**:Oracle11g...

    2010年10月最新ORACLE OCP培训教程

    Tasks of an Oracle Database Administrator 2-3 Tools Used to Administer an Oracle Database 2-4 Installation: System Requirements 2-6 Checking the System Requirements 2-7 Optimal Flexible Architecture ...

    Logical Foundations of Computer Science 无水印原版pdf

    Logical Foundations of Computer Science 英文无水印原版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看...

    logicaldoc-community-installer-8.3.4.zip

    LogicalDOC是文档管理和协作系统。该软件具有许多功能,可以为任何组织和个人安全,安全地组织,索引,检索,控制和分发重要的业务文档。 公司使用纸质流程(例如打印,邮寄和手动归档纸质文档)的日子已经一去不...

    oracle英文版PPT

    "l3_overview_of_logical_structures.ppt"将讨论Oracle的逻辑结构,如表空间、段、区和块。这些是数据库内部组织数据的方式,了解它们可以帮助我们更有效地设计和管理数据库。 "l4_overview_schema_objects.ppt"将...

    Embedding Logical Queries on Knowledge Graphs.pdf

    of relations: predicting logical relationships in a network of drug-gene-disease interactions and in a graph-based representation of social interactions derived from a popular web forum.

    matlab开发-logical2cellstrcellstr2logical

    标题提到的"logical2cellstr"和"cellstr2logical"是两个关键函数,分别用于在逻辑数组和包含字符串"true"/"false"的单元格数组之间进行转换。这两个函数在处理逻辑数据表示时非常有用,尤其是在数据可视化、数据分析...

Global site tag (gtag.js) - Google Analytics