自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(1)
  • 资源 (8)
  • 收藏
  • 关注

原创 DBA SQL 2019015

ANALYZE TABLE PROD_PARTS COMPUTE STATISTICS; ANALYZE TABLE PROD_PARTS COMPUTE STATISTICS FOR ALL INDEXED COLUMNS; ANALYZE TABLE PROD_PARTS COMPUTE STATISTICS FOR TABLE FOR ALL INDEXES FOR ALL INDEXED ...

2019-01-15 17:15:53 268

Data Purge Process

This document introduces how to configure the log tables data retention policy.

2019-01-15

Oracle Schema Compare and Sync up

用于比较用户下面的表、索引,并生成同步SQL。 可以比较表、列、主键、外键、索引。

2019-01-15

高性能MySQL-第3版-中英文版本

中英文对比看高性能MySQL,理解掌握更多的细节知识。

2018-11-27

Troubleshooting Oracle Performance, 2nd Edition

Part 1 covers some basics that are required to read the rest of the book. Chapter 1, “Performance Problems,” explains not only why it’s essential to approach performance problems at the right moment and in a methodological way, but also why understanding business needs and problems is essential. It also describes the most common database-related design problems that lead to suboptimal performance. Chapter 2, “Key Concepts,” describes the operations carried out by the database engine when parsing and executing SQL statements and how to instrument application code and database calls. It also introduces some important terms that are frequently used in the book. Part 2 explains how to approach performance problems in an environment that uses Oracle Database. Chapter 3, “Analysis of Reproducible Problems,” describes how to identify performance problems with the help of SQL trace and PL/SQL profilers. Chapter 4, “Real-time Analysis of Irreproducible Problems,” describes how to take advantage of information provided by dynamic performance views. Several tools and techniques that can be used with them are also introduced. Chapter 5, “Postmortem Analysis of Irreproducible Problems,” describes how to analyze performance problems that happened in the past with the help of Automatic Workload Repository and Statspack. Part 3 describes the component that is responsible for turning SQL statements into execution plans: the query optimizer. Chapter 6, “Introducing the Query Optimizer,” provides an overview of what the query optimizer does and how it does it. Chapters 7 and 8, “System Statistics” and “Object Statistics,” describe what system statistics and object statistics are, how to gather them, and why they are important for the query optimizer. Chapter 9, “Configuring the Query Optimizer,” covers a configuration road map that you can use to find a good configuration for the query optimizer. Chapter 10, “Execution Plans,” describes in detail how to obtain, interpret, and judge the efficiency of execution plans.

2018-11-27

Tomcat 7.0

Tomcat 服务器是一个免费的开放源代码的Web 应用服务器。Tomcat最新版。

2010-06-25

Subversion 权威指南1.4

Subversion 权威指南 针对 Subversion 1.4 (根据 r2866 编译)

2009-11-20

Subversion 权威指南1.5

Subversion 权威指南 针对 Subversion 1.5(根据 r3301 编译)

2009-11-20

Symantec Ghost

大名鼎鼎的硬盘备份工具,它可以把一个磁盘上的全部内容复 制到另外一个磁盘上,也可以把磁盘内容复制为一个磁盘的镜 像文件,以后你可以用镜像文件创建一个原始磁盘的拷贝。它 可以最大限度地减少你每次安装 Win95、WinNT 和 OS/2 等操 作系统的时间,如果你有好几台配置相似的机器需要安装Win95 , 你会发现使用 GHOST 使事情变得十分简单。GHOST在DOS下 运行,并且可以从一张 DOS 引导盘上运行。支持从 NFTS中恢 复镜像文件(但不要将程序安装在 NTFS 分区内,否则在 DOS 下无法运行Ghost);ghost.exe 及 gdisk.exe 在 Dos/Win9x 下使用;ghost32.exe 及 gdisk32.exe 在 Win2000/XP/2003 下使用。

2008-12-16

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除