dancle的专栏

TKPROF and Problem Solving==========================Purpose-------This document discusses the use of the following:        *       SQL TRACE        *       EXPLAIN PLAN        *       TK

前段时间使用oracle分区功能并参考了一篇英文文档,现在与大家分享一下,有些是直接翻译的,英文水平不高,见笑!Oracle分区的5W+H说明:5W:what,why,whern,who,whereH:how 分区使得表和索引或者索引表再细分成更小的易管理的片,将这些细分的每个小片称为”分区”.从”应用程序设计”的观点看,分区表与非分区表是没有区别的,如果应用程序开

Hints are used to give specific information that we know about our data and application, to Oracle. This further improves the performance of our system. There can be instances where the default optimi

遇到ORA-1555问题,通过查询WEB,已解决问题,特将以下文章推荐给各位Rollback Segments Overview Rollback Segments allow users to undo, or rollback, DML transactions that have been made against a database. DML transac