- 博客(5)
- 收藏
- 关注
原创 X$表资料
X$ks - Kernel Services =============================================== x$ksmfs kernel services, memory fixed SGA x$ksmfsv kernel services, memory fixed SGA vectors x$ksmjs kernel services,
2011-11-30 20:27:58 447
原创 Why Isn't Oracle Using My Index?!
The question in the title of this piece is probably the single most frequently occurring question that appears in the Metalink forums and U
2011-08-28 15:16:31 1186
原创 Top DBA Shell Scripts for Monitoring the Database
Introduction This article focuses on the DBA's daily responsibilities for monitoring Oracle databases and provides tips and techniques on
2011-08-28 15:08:58 433
原创 Monitoring Index Usage in Oracle9i
Introduction DBAs and developers love indexes. They speed up query searches, especially in a data warehouse environment, where the database
2011-08-28 15:05:12 469
转载 在oracle 9i下在线重定义表
9i提供了联机重定义表的方法,可以让你在基本不影响原表的DML情况下修改表结构。 实际上,联机重定义表并不是完全的联机重定义,在最后交换表名的时候会短暂地锁定原表和中间表,但这个过程很短暂,相对于传统方法来说,这是一个进步。 /* 9i提供了联机重定义表的方法,可以让你在基
2011-08-28 14:16:12 892
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人