-
编辑 删除
one lesson learn from tom for oracle
We have 2 fact tables in our dataware house. One for transactions of type V, another for transactions of type M. Each table is partitioned by day and there are 90 days online. There are 145 Milli...
-
编辑 删除
Rebuild index test result
记录一下今天的测试结果：System Configuration: Sun Microsystems sun4u Sun Fire V890System clock frequency: 150 MHzMemory size: 32768 Megabytes========================= CPUs ================...
-
编辑 删除
Oracle 10g impdp use schema mode
Use impdp schema= , show below error:ORA-23421: job number 43 is not a job in the job queueFailing sql is: BEGIN dbms_refresh.make('"AMTSMGR"."SEAINV_SEATRK_CATEGORIES_MV"',list=>null,next_date=...
-
编辑 删除
Oracle10g install on solaris 8
Backgoud : install oracle 10g on solaris 8 server which have already exitst oracle9i on it.When run installer , hit below error:********************************************************************...
-
编辑 删除
How to improve the data reorg performance?
Recently storage expansion, need move data to new storage .the sql like below:alter table ATTR move subpartition GW201026_26 tablespace ODS1_TAB_L1 PARALLEL ;alter index IP$ATTR$SN$TS$NAME rebuild...
-
编辑 删除
PX Deq Credit: send blkd - wait for what?（ZT)
Detail as belowhttp://www.asktherealtom.ch/?p=8"If a query is run in parallel there is a query coordinator (QC) and thequery slaves. The slaves do the actual work an send the result to thequery coor...
-
编辑 删除
How to Free Inode Usage(ZT)
Hi, I have a disk drive where the inode usage is 100% (using df -i command).However after deleting files substantially, the usage remain 100%. Answer: 2 ...
-
编辑 删除
oracle10g I/O burst increase
A very strange phenomenon on our one Solaris10 + oracle10g + Sun t5520 server oracle I/O per second avg increase from 4500 to 7500 .But the system average throughput is very stable....
-
编辑 删除
EMC一块硬盘，导致项目失败
说起来，你或许不相信。这么高端的存储， 坏了一块硬盘，尽然导致数据丢失，数据迁移项目失败。需要重头再来。
-
编辑 删除
A strange thing at 10G undo tablespace --续一
以上现象， 在我们的9I的数据库上没有发生过。9i的undo参数:SQL> show parameters undoNAME &...
-
编辑 删除
A strange thing at 10G undo tablespace
We have a cronjob at 8:00 and 16:00 to check tablespace free size , use below sql***************************************************select tablespace_name, sum(freesize) "FREE SIZE(M)", sum(extentleft...
