-
编辑 删除
国内外各大奶粉品牌分析
牛栏牛栏。是超级不错的欧洲三大牌子之一！牛栏（Nutrilon）系列是纽迪希亚（NUTRICIA）公司优质产品，公司始创于1901年，被认为是高品质临床营养产品的世界领导者，专业从事人类营养研究至今已有100年历史。纽迪...
-
编辑 删除
dbua report datafile not exists
Because when DBA add datafiles, the datafile name with the end "space" For example: 'a ' !='a',the dbua check the datafiles trim the space, but when alter database datafile ' &...
-
编辑 删除
ORA-02019: connection description for remote database not found
昨日做数据库升级， 升级完毕后， 在alert log 里报如下错误：Node name: suzdrsas-updradeRelease: 5.10Version: ...
-
编辑 删除
ORA-00235: controlfile fixed table inconsistent due to concurrent update
偶遇00235 error , 找了半天，还是这个解释比较接近答案http://forums.oracle.com/forums/thread.jspa?messageID=2524868&tstart=0
-
编辑 删除
What database parameters are relevant to ORA-04031 problems?
CURSOR_SHARING Literal replacement is a feature where Oracle replaces literal values in SQL statements to reduce the application Shared Pool footprint and decrease "hard" parsing. ...
-
编辑 删除
What is an ORA-04031 Error?
The memory pool in the SGA are comprised of memory chunks in various sizes. When the database starts is started, you have a large chunk of memory allocated in the various pools and tracked in free ...
-
编辑 删除
What are Subpools?
In Oracle 9i and later versions, the Shared Pool can be divided into subpools. Each subpool is a "mini" shared pool, having its own set of Free Lists, memory structure entries, and L...
-
编辑 删除
How is memory allocated and deallocated in the SGA pools?
The SGA is comprised of fixed areas like the Log Buffers and the Buffer Cache(s) as well as memory pools (Shared Pool, Large Pool, Java Pool, and in 10g, the Streams Pool). Memory&nb...
-
编辑 删除
Copy files and directories recursively with tar
http://www.tech-recipes.com/rx/115/copy-files-and-directories-recursively-with-tar/Copying a directory tree and its contents to another filesystemusing tar will preserve ownership, permissions, and t...
-
编辑 删除
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一块硬盘，导致项目失败
说起来，你或许不相信。这么高端的存储， 坏了一块硬盘，尽然导致数据丢失，数据迁移项目失败。需要重头再来。
-
编辑 删除
关于贿选
昨天，和妈妈在电话中了解到，现在农村贿选的趋势越来越严重。农村的发展路在何方？为什么会发生贿选呢？看来当官可以为所欲为，这是肯定的。法律形同虚设，助长了不良风气。...
-
编辑 删除
巴菲特和李嘉诚的教子秘诀
巴菲特和李嘉诚的教子秘诀（香港） (2009-11-09)fieldset { width: 309px; border: 1px solid #990000; }legend { font-family: Arial,"宋体"; font-size: 12px; font-weight: bol...
-
编辑 删除
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...
-
编辑 删除
一个比较全面的计算表空间的脚本
select tablespace_name, sum(freesize) "FREE SIZE(M)", sum(extentleft) "EXTENTS LEFT" from(select file_id, a.tablespace_name tablespace_name, floor((maxbytes-bytes)/next_extent) extentleft, floor((...
-
编辑 删除
CEO-关于云计算的思考
最近CEO对google的东西很是着迷，也许是经济形势的不好。IT 方面的成本压力比较大。云计算， GOOGLE mail 或许是最后的稻草。
