-
编辑 删除
Resetting High Water Mark in Oracle10g
I would like to write how to reset HWM in oracle10g. Prior to Oracle10g, resetting high water mark is painful procedure in busy environment. Oracle made our life easy to reset the High Water Mark in o...
-
编辑 删除
How to Export and Import Statistics(Alejandro Vargas)
How to Export and Import Statistics Alejandro Vargas Oracle Israel Case Definition A critical application suddenly seems to hang, wait events show long table scans running on the OLTP environment...
-
编辑 删除
Eg to show how to use system_context
selectSYS_CONTEXT('USERENV','TERMINAL') terminal,SYS_CONTEXT('USERENV','LANGUAGE') language,SYS_CONTEXT('USERENV','SESSIONID') sessionid,SYS_CONTEXT('USERENV','INSTANCE') instance,SYS_CONTEXT('USERENV...
-
编辑 删除
some sql
SQL> create table tmp_test (id number,phone varchar2(20),create_time date) compress;SQL> alter table tmp_test compress;SQL> alter table tmp_test nocompress;SQL> alter ...
-
编辑 删除
Oracle Dimension in DWH
重读 Tom 大师的 Expert One-on-One Oracle, 发现有对dimension的精彩讲解， 并在强大的网络中找到了如下资料，最宝贵的是有sample： 在数据仓库环境中，我们通常利用物化视图强大的查询重写功能来提升统计查...
-
编辑 删除
Add / drop columns in compressed table
The question come from Ask Tom:Would it be possible to add or remove the columns from a Compressed table?Below is the answer and sample:ops$tkyte%ORA10GR2> create table test_compress compress ...
