摘要：
//* Formatted on 10/14/2011 4:56:17 PM (QP5 v5.163.1008.3004) */ SELECT a.tablespace_name, ROUND (a.total_size, 1) "total(M)", ROUND (a.total_size) - ROUND (NVL (b.free_size, 0), 1) "used(M)", ROUND (NVL (b.free_size, 0), 1) "free(M)", ROUND (NVL (b.free_size, 0) / tota 阅读全文
随笔档案-2011年10月
AskTom Oracle:SGA Size
2011-10-14 15:37 by Tracy., 395 阅读, 收藏, 编辑
摘要：
HiI am configuraring a new Oracle 10g instance for production purposes. I read from Oracle 10g new features for administrators exam guide (from Oracle Press) that when we use sga_target we should not set any parameters for the 4 dynamic tunable components, buffer cache, shared pool, java pool and la 阅读全文
Oracle:左外联outer join 与(+) From Itpub.
2011-10-14 15:01 by Tracy., 1354 阅读, 收藏, 编辑
摘要：
们知道，从Oracle9i开始，对于外连接(Outer join)Oracle支持SQL92标准：这个标准有很多新的连接语法，当然不仅是外连接了，这里，我主要讨论的是外连接的新语法：Left Outer Join和Right Outer Join,Full Outer Join这里不会讨论，我会额外总结所有的SQL92新的连接语法。对于接触Oracle比较早的开发人员或DBA来说，外连接用+号已经很习惯了，但是新语法有很多好的优点，Oracle也强烈建议9i以及之后的版本使用新的外连接语法。OK，下面进入正题，那么外连接的新旧语法之间有什么差异呢？请看DINGJUN123>drop ta 阅读全文
.NET调用ORACLE存储过程使用数组参数
2011-10-13 16:00 by Tracy., 394 阅读, 收藏, 编辑
摘要：
----------包定义create or replace package packtestas type string_array is table of varchar2(21) index by binary_integer; type int_array is table of number(4) index by binary_integer; procedure test(v_string in string_array, v_int out int_array); end packtest; --------包体 Create or replace package bo... 阅读全文
Oracle如何根据物化视图日志快速刷新物化视图
2011-10-13 15:32 by Tracy., 631 阅读, 收藏, 编辑
摘要：
===========================================================作者: yangtingkun(http://yangtingkun.itpub.net)发表于: 2005.03.05 23:49分类: ORACLE 出处: http://yangtingkun.itpub.net/post/468/20584--------------------------------------------------------------- Oracle物化视图的快速刷新机制是通过物化视图日志完成的。Oracle如何通过一个物化视图日志就可以支持 阅读全文
Asktom: Thanks for the question regarding "Partitioning question", version 8.1.7
2011-10-12 14:47 by Tracy., 315 阅读, 收藏, 编辑
摘要：
Brian -- Thanks for the question regarding "Partitioning question", version 8.1.7Submitted on 12-Oct-2001 13:16 Central time zoneTom's latest followup | Bookmark | BottomLast updated 8-Oct-2011 6:53You AskedLet's say we have a table of documents with key of doc_id. This table conta 阅读全文
