Oracle调优

[ 182 主题 / 292 回复 ]

版块介绍: 讨论ORACLE调优,INTERNAL,OPS,RAC.等高级技巧

版主: *空缺中*

讨论ORACLE调优,INTERNAL,OPS,RAC.等高级技巧
    标题 作者 回复/查看 最后发表
common   关于Statspack--Oracle性能调整的主要工具 xiangzhao 2008-7-9 2/74 xiangzhao 2008-7-9 12:53
common   Oracle性能调优实践中的几点心得 附件 xiangzhao 2008-7-9 0/112 xiangzhao 2008-7-9 12:52
common   statspack安装的方式 附件 xiangzhao 2008-7-9 0/68 xiangzhao 2008-7-9 12:51
common   Oracle 9i Dataguard技术中文资料 附件 xiangzhao 2008-7-9 0/70 xiangzhao 2008-7-9 12:49
common   深入理解嵌套循环执行计划 附件 xiangzhao 2008-7-9 0/62 xiangzhao 2008-7-9 12:45
common   oracle内存分配与调整 附件 xiangzhao 2008-7-9 0/36 xiangzhao 2008-7-9 12:44
common   INSTANCE_NAME与ORALCE_SID区别 xiangzhao 2008-7-9 1/81 xiangzhao 2008-7-9 12:41
common   常用的表连接方式的讲解 附件 xiangzhao 2008-7-9 0/89 xiangzhao 2008-7-9 12:40
common   数据库性能调优技术 xiangzhao 2008-7-9 4/65 xiangzhao 2008-7-9 12:38
common   为什么0条记录,count一下这么慢? xiangzhao 2008-7-9 3/79 xiangzhao 2008-7-9 12:36
common   Oracle专家调优秘密 xiangzhao 2008-7-9 3/74 xiangzhao 2008-7-9 12:31
common   PLSQL基础 附件 xiangzhao 2008-7-9 0/83 xiangzhao 2008-7-9 12:27
common   讨论最优化的sql如何写 xiangzhao 2008-7-9 2/77 xiangzhao 2008-7-9 12:06
common   请教SQL具体执行过程 xiangzhao 2008-7-9 2/47 xiangzhao 2008-7-9 11:54
common   Tuning PGA_AGGREGATE_TARGET in Oracle 9i 附件 xiangzhao 2008-7-9 0/72 xiangzhao 2008-7-9 11:53
common   statspack分析 xiangzhao 2008-7-9 12/76 xiangzhao 2008-7-9 11:17
common   statspack分析 xiangzhao 2008-7-9 0/42 xiangzhao 2008-7-9 11:13
common   一张具体表中数据导入另一张表的 xiangzhao 2008-7-9 1/48 xiangzhao 2008-7-9 11:11
common   数据库联机日志文件丢失的恢复方法 xiangzhao 2008-7-9 1/77 xiangzhao 2008-7-9 11:08
common   Installing Oracle 9i Real Application Cluster 附件 xiangzhao 2008-7-9 0/72 xiangzhao 2008-7-9 11:01
common   ORACLE9i DEVELOPER开发手册 附件 xiangzhao 2008-7-9 0/106 xiangzhao 2008-7-9 10:55
common   一个statspack工具 附件 xiangzhao 2008-7-9 0/79 xiangzhao 2008-7-9 10:52
common   最近研发的package 附件 xiangzhao 2008-7-9 1/101 xiangzhao 2008-7-9 10:48
common   ORACLE初始化参数文件详细文档 xiangzhao 2008-7-9 11/107 xiangzhao 2008-7-9 10:46
common   Oracle 9i STATSPACK高性能调整 附件 xiangzhao 2008-7-9 1/73 xiangzhao 2008-7-9 10:43
common   Oracle 9i STATSPACK高性能调整 附件 xiangzhao 2008-7-9 0/93 xiangzhao 2008-7-9 10:22
common   oracle9i的查询优化 附件 xiangzhao 2008-7-9 1/86 meng_xia_xue 2008-7-9 10:20
common   关于 INDEX xiangzhao 2008-7-9 5/64 xiangzhao 2008-7-9 10:09
common   哪位大侠维护的oracle每秒插入一万条记录 xiangzhao 2008-7-9 1/65 xiangzhao 2008-7-9 10:06
common   利用并行提高sql执行效率 xiangzhao 2008-7-9 0/55 xiangzhao 2008-7-9 10:04
common   数据库实战过程和心得 xiangzhao 2008-7-9 0/39 xiangzhao 2008-7-9 10:03
common   对于analyze table使用的一些探究 xiangzhao 2008-7-9 4/75 xiangzhao 2008-7-9 10:00
common   数据库服务突停,到底有哪些原因啊 xiangzhao 2008-7-9 1/43 xiangzhao 2008-7-9 09:57
common   logminer guideline xiangzhao 2008-7-8 0/44 xiangzhao 2008-7-8 22:28
common   此update语句应该如何优化 xiangzhao 2008-7-8 2/44 xiangzhao 2008-7-8 22:27
common   Oracle 分析函数的使用 xiangzhao 2008-7-8 10/58 xiangzhao 2008-7-8 22:26
common   存储过程编写方式:动态SQL好,还是硬编好? xiangzhao 2008-7-8 2/42 xiangzhao 2008-7-8 22:22
common   Cost-Based Oracle Fundamentals 附件 xiangzhao 2008-7-8 0/38 xiangzhao 2008-7-8 22:19
common   这里有一个相当于SQLPLUS的工具 附件 xiangzhao 2008-7-8 0/44 xiangzhao 2008-7-8 21:58
common   一个oradebug的详细操作文档 附件 xiangzhao 2008-7-8 0/39 xiangzhao 2008-7-8 21:56
common   Oracle Database Internals FAQ,你一定需要的! 附件 xiangzhao 2008-7-8 0/55 xiangzhao 2008-7-8 21:53
common   Oracle 分区技术 附件 xiangzhao 2008-7-8 0/126 xiangzhao 2008-7-8 21:51
common   Oracle的SQL语句执行效率问题查找与解决方法 附件 xiangzhao 2008-7-8 0/80 xiangzhao 2008-7-8 21:48
common   Statspack初步学和用 附件 xiangzhao 2008-7-8 0/45 xiangzhao 2008-7-8 21:46
common   共享Oracle RAC 在linux 和windows下安装手册 附件 xiangzhao 2008-7-8 0/86 xiangzhao 2008-7-8 20:57
common   这个DELETE语句怎么优化啊 xiangzhao 2008-7-8 1/50 xiangzhao 2008-7-8 20:49
common   共享Oracle RAC 在linux 和windows下安装手册 附件 xiangzhao 2008-7-8 0/34 xiangzhao 2008-7-8 20:47
common   SGA 附件 xiangzhao 2008-7-8 0/41 xiangzhao 2008-7-8 20:47
common   Oracle PL/SQL高级编程 附件 xiangzhao 2008-7-8 0/79 xiangzhao 2008-7-8 20:43
common   Oracle多粒度封锁机制研究 附件 xiangzhao 2008-7-8 0/53 xiangzhao 2008-7-8 20:23
common   Oracle优化说明 附件 xiangzhao 2008-7-8 0/45 xiangzhao 2008-7-8 20:14
common   共享资料,oracle10g 9i 常有脚本 附件 xiangzhao 2008-7-8 0/55 xiangzhao 2008-7-8 20:09
common   创建【分区表】的示例 附件 xiangzhao 2008-7-8 0/63 xiangzhao 2008-7-8 20:02
common   提供点ORACLE9i_优化设计与系统调整资料 附件 xiangzhao 2008-7-8 0/45 xiangzhao 2008-7-8 19:57
common   通过分析SQL语句的执行计划优化SQL(总结) xiangzhao 2008-7-8 13/58 xiangzhao 2008-7-8 19:54
common   ORACLE 数据库的统计数据及其生成方式 xiangzhao 2008-6-30 1/58 xiangzhao 2008-6-30 14:37
common   优化调整Oracle 8i数据库 xiangzhao 2008-6-30 0/28 xiangzhao 2008-6-30 12:53
common   ORACLE 数据库的统计数据及其生成方式 xiangzhao 2008-6-30 0/33 xiangzhao 2008-6-30 12:39
common   Scaling oracle 8i: James Morle's best book 附件 xiangzhao 2008-6-30 0/33 xiangzhao 2008-6-30 12:20
common   查询数据库中持锁和等待锁的用户信息 xiangzhao 2008-6-30 1/53 xiangzhao 2008-6-30 12:07
common   读数据文件一次读取的数据 xiangzhao 2008-6-30 0/46 xiangzhao 2008-6-30 12:02
common   delete大批量数据的性能优化 xiangzhao 2008-6-30 1/68 xiangzhao 2008-6-30 12:01
common   索引建立速度 xiangzhao 2008-6-30 1/62 xiangzhao 2008-6-30 12:00
common   一次standby open read only 故障的处理过程 xiangzhao 2008-6-30 0/64 xiangzhao 2008-6-30 09:14
common   探讨 Oracle 数据库 10g 等待接口 xiangzhao 2008-6-30 0/92 xiangzhao 2008-6-30 09:12
common   系统性奇慢,发现大量session 的status='SNIPED',如何处理? xiangzhao 2008-6-30 4/62 xiangzhao 2008-6-30 08:56
common   关于shared pool的深入探讨 xiangzhao 2008-6-30 2/51 xiangzhao 2008-6-30 08:50
common   Oracle Index 相關知識 xiangzhao 2008-6-30 2/37 xiangzhao 2008-6-30 08:46
common   关于shared pool的深入探讨 xiangzhao 2008-6-30 0/46 xiangzhao 2008-6-30 08:42
common   偶的执行计划中出现了cartesian是否表示有迪卡尔连接? xiangzhao 2008-6-30 1/33 xiangzhao 2008-6-30 08:24
common   alter table *** deallocate unused不影响high water mark么? xiangzhao 2008-6-30 1/53 xiangzhao 2008-6-30 08:23
common   关于shared pool的深入探讨 xiangzhao 2008-6-30 2/68 xiangzhao 2008-6-30 08:21
common   从minimize records_per_block联想开来 xiangzhao 2008-6-30 1/29 xiangzhao 2008-6-30 08:20
common   对于记录count(*)的优化 xiangzhao 2008-6-30 3/75 xiangzhao 2008-6-30 08:15
common   将表中数据print成insert语句的sql xiangzhao 2008-6-29 4/68 xiangzhao 2008-6-29 21:35
common   如何在存储过程中获取当前用户信息 xiangzhao 2008-6-29 0/114 xiangzhao 2008-6-29 21:32
common   在ORACLE里设置访问多个SQL Server数据库(轉) xiangzhao 2008-6-29 2/59 xiangzhao 2008-6-29 20:23
common   DBWn has not completed checkpointing the file when the LGWR needs the file again xiangzhao 2008-6-29 3/73 xiangzhao 2008-6-29 18:07
common   Oracle优化经典文章------索引原理篇 xiangzhao 2008-6-29 1/54 xiangzhao 2008-6-29 17:55
common   Oracle 9i 分析函数参考手册 xiangzhao 2008-6-29 8/75 xiangzhao 2008-6-29 17:39
    类型 排序方式 时间范围    

正在浏览此版块的会员