老徐的博客只有干货

All about Security - SQL Injection最近做个一个有关ORACLE数据库安全的网上研讨。我们有1300多位参与者，反馈相当丰富。I recently did a web seminar on Oracle Database Security (you can see a replay of it here).  We had over 1,

Selective System Grants 问题：我只想授予XX用户alter system set user_dump_dest 权限！I want to give users the ability to execute "alter system set user_dump_dest" only. I want to give them the ability to turn

Comparing the Contents of Two TablesA表和B表。拥有一致列，C2一列内容不同。I have two tables named A and B. They have identical columns and have the same number of rows via select count(*) from A and from B. Howe

原文：http://www.oracle.com/technetwork/issue-archive/2009/09-may/o39asktom-096149.htmloracle中约束（constraints）是如何影响查询计划的通常人们认为约束只是和数据完整性有关，没问题。但是约束也被优化器使用来优化执行计划。优化器会拿以下资源最为输入inputs：1）

关于动态抽样（Dynamic Sampling）原文：http://www.oracle.com/technetwork/issue-archive/2009/09-jan/o19asktom-086775.html本文将回答：什么是动态抽样？动态抽样有啥作用？以及不同级别的动态抽样的意思？1、什么是动态采样？动态抽样从 oracle 9i第2版引入。它使得优化器（

原文：http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13asktom-1886639.htmlI am using SQL Loader to load data into tables from a flat file. Some sample data in the file might be:我打算使

原文：http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13asktom-1886639.htmlI have a question about joining with collections and cardinality estimation. The optimizer is always estimati

tom大神写了一个用于查看Oracle数据库对象空间使用情况。 下面演示一下如何使用：–工具源码CREATE OR REPLACE PROCEDURE show_space(p_segname IN VARCHAR2, p_owner IN VARCHAR2 DEFAULT USER,