Location:
Search - oracle优化
Search list
Description: oracle存储过程后优化
Platform: |
Size: 276615 |
Author: |
Hits:
Description: 没什么好说的，Oracle常见的优化策略，看了很有帮助的-nothing more to be said, Oracle common optimization strategy, read helpful
Platform: |
Size: 101586 |
Author: 唐壮 |
Hits:
Description: 对oracle的性能优化有比较好的介绍，还是可以 ，
Platform: |
Size: 74260 |
Author: 林林林 |
Hits:
Description: ORACLE_FAQ中是itpub高手的多年经验总结出来的oracle开发的经典资料，包括pl-sql技巧,oracle体系架构，oracle备份与恢复，oracle优化，不同O/S上的开发，网络开发等
Platform: |
Size: 96944 |
Author: 谢青 |
Hits:
Description: orcale优化规则汇总
包含多种orcale内置函数讲解
Platform: |
Size: 88772 |
Author: dv |
Hits:
Description: 介绍ORACLE PL/SQL 语句的优化方法
Platform: |
Size: 302111 |
Author: zxj721 |
Hits:
Description: oracle存储过程后优化-oracle memory process optimizes
Platform: |
Size: 276480 |
Author: 诸仕荣 |
Hits:
Description: 对oracle的性能优化有比较好的介绍，还是可以 ，-Performance optimization of the oracle have relatively good introduction, or can,
Platform: |
Size: 73728 |
Author: 林林林 |
Hits:
Description: ORACLE_FAQ中是itpub高手的多年经验总结出来的oracle开发的经典资料，包括pl-sql技巧,oracle体系架构，oracle备份与恢复，oracle优化，不同O/S上的开发，网络开发等-ORACLE_FAQ is a master of many years of experience itpub summed up the development of classical oracle information, including pl-sql skills, oracle architecture, oracle backup and recovery, oracle optimization, different O/S on the development, network development, etc.
Platform: |
Size: 96256 |
Author: 谢青 |
Hits:
Description: orcale优化规则汇总
包含多种orcale内置函数讲解-optimization rules orcale summary contains a wide range of built-in functions on orcale
Platform: |
Size: 88064 |
Author: dv |
Hits:
Description: Oracle性能优化总结说的挺不错的。 -Oracle performance optimization concluded that the very good.
Platform: |
Size: 101376 |
Author: ace |
Hits:
Description: 对oracle存储过程的详细描述，事务，以及调用，如何优化等-Oracle stored procedure on a detailed description, services, and call, how to optimize such
Platform: |
Size: 66560 |
Author: 飞侠 |
Hits:
Description: 《Oracle数据库DBA专题技术精粹》从DBA的角度阐述了Oracle数据库的结构内幕、管理经验和优化技巧，并列举了很多实用的案例。本书主要分为五大部分，基础篇主要介绍了一些基础技术与OCP认证相关的一些内容，内各种平台上安装与建库的技巧以及在9i里面出现的新特性；结构篇包括对回滚段、存储结构等的深入讨论，并彻底阐述了困扰许多用户的字符集问题；备份与恢复篇列举了大量实际案例，讲述了在不同的需求环境下所应采取的备份方案以及进行故障恢复的方法；性能篇深入分析了Statspack等常用的调整工具的原理与使用方法、判断依据，并从锁、内存、索引、执行计划等各个角度介绍了各种优化技巧；网络篇主要介绍了监听器、透明网关、数据迁移等方面的。-"Oracle Database DBA special technical essence" from the DBA perspective of the insider Oracle database structure, management experience and optimization techniques, and lists a number of practical cases. This book is divided into five parts, based on article introduces some basic techniques and some of the elements related to OCP certification, installation of various platforms and building a database of skills and which appears in the 9i new features structure of articles including rollback section, the storage structure of the in-depth discussion, and thoroughly describes the user s character set that plagues many problems backup and recovery chapter lists a large number of actual cases, about the needs in different circumstances to be taken by the backup program and fault recovery method performance-depth analysis of articles and other commonly used Statspack to adjust the principle and use tools to determine the basis, and from the lock, memory, indexes, and other point of view
Platform: |
Size: 17335296 |
Author: |
Hits:
Description: oracle教程，入门，使用，配置，优化，以及进行二次开发所需要的环境-oracle tutorial
Platform: |
Size: 1611776 |
Author: ycj |
Hits:
Description: 《基于成本的Oracle优化法则》数据库领域的超级畅销书，世界级0racle大师 Jonathan Lewis的最新力作，也是近几年来Oracle领域最重要的著作之一，荣获2006年度Oracle杂志编辑选择大奖：-" Oracle cost-based optimization of rule" super best-selling book database fields, world-class master 0racle Jonathan Lewis' s latest masterpiece, but also in recent years, Oracle is one of the most important works, was awarded the 2006 Oracle Magazine Editor' s Choice Award:
Platform: |
Size: 10176512 |
Author: 张三 |
Hits:
Description: Oracle语句优化53个规则详解.pdf-53 rules for Oracle Detailed statement optimization. Pdf
Platform: |
Size: 245760 |
Author: 郝强 |
Hits:
Description: 本文主要根据oracle10g数据库性能特点，描述数据库环境配置、数据库物理设计、数据库逻辑设计、视图、存储过程、应用程序设计等方面的设计规范。最后，还给出了方便Hibernate操作和性能优化的几个数据库设计建议。
Platform: |
Size: 415232 |
Author: xuan.yuan08 |
Hits:
Description: 针对Oracle开发过程中的一些优化思路(According to the optimization idea in the development of Oracle)
Platform: |
Size: 1756160 |
Author: 威尔安逸
|
Hits:
Description: ORACLE的优化器共有3种:
a. RULE (基于规则) b. COST (基于成本) c. CHOOSE (选择性)
设置缺省的优化器,可以通过对init.ora文件中OPTIMIZER_MODE参数的各种声明,如RULE,COST,CHOOSE,ALL_ROWS,FIRST_ROWS . 你当然也在SQL句级或是会话(session)级对其进行覆盖.
为了使用基于成本的优化器(CBO, Cost-Based Optimizer) , 你必须经常运行analyze 命令,以增加数据库中的对象统计信息(object statistics)的准确性.
如果数据库的优化器模式设置为选择性(CHOOSE),那么实际的优化器模式将和是否运行过analyze命令有关. 如果table已经被analyze过, 优化器模式将自动成为CBO , 反之,数据库将采用RULE形式的优化器.
在缺省情况下,ORACLE采用CHOOSE优化器, 为了避免那些不必要的全表扫描(full table scan) , 你必须尽量避免使用CHOOSE优化器,而直接采用基于规则或者基于成本的优化器.(init.ora OPTIMIZER_MODE RULE,COST,CHOOSE,ALL_ROWS,FIRST_ROWS)
Platform: |
Size: 47104 |
Author: kelivf
|
Hits:
Description: Oracle性能优化关注点，了解30种等待事件的概念及解决方法(Oracle performance tuning focus, understand the concepts of 30 wait for events and solving methods)
Platform: |
Size: 28672 |
Author: Rman0000
|
Hits: