Base on SID find the trace file
今日系统要升级,需要对所有的应用程序,进行TRACE 。在应用系统里面有个里面有个程序CONTROL table :proc_control , 记录每个程序的SID,SERIAL#,可以方便的多特定的程序进行TRACE , 这个在应用设计的过程中可以学习...
笑话一则
Normal 0 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...
中印两国经济模式不同 印度超越中国迟早的事 薛涌
中印两国经济模式不同 印度超越中国迟早的事 薛涌 中国和印度两国的经济模式不同,本来可以是“你走你的阳关道,我走我的独木桥”,大家互不相扰。问题是,这样的局面究竟能够维持多久? 2010年10月第一期的《...
美国儿科医学会报告:玩耍的重要性
玩耍对于儿童健康成长以及建立亲子关系的重要作用 摘译自美国儿科医学会报告:原文链接:The Importance of Play in Promoting Healthy Child Development and Maintaining Strong Par...
20种开发幼儿大脑的方法
20种开发幼儿大脑的方法 EDUCARER @ 2010-10-25 1...
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:********************************************************************...
国内外各大奶粉品牌分析
牛栏牛栏。是超级不错的欧洲三大牌子之一!牛栏(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一块硬盘,导致项目失败
说起来,你或许不相信。这么高端的存储, 坏了一块硬盘,尽然导致数据丢失,数据迁移项目失败。需要重头再来。