- 博客(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
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
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关注的人