ITPub博客

ORA-04098错误解决方法http://www.sudu.cn/info/html/edu/20071225/21007.html-- some piece copy:此时触发器不能编译过去，也不能删除了，因为触发器本身里面定义了ddl操作的触发，产生ora-04098: 触发器 ddl_deny 无效且未通过重新验证。发现是内部严重错误，其他看不出太多错误信息，于是想到采用隐含参数_system_trigger_enabled=false，在数据库启动的时候让所有触发器不起作用，然后删除。数据库8.1.5的提示没这个参数，于是查询了一下：select ksppinm from x$ksppi where substr(ksppinm,1,1)=_and ksppinm like %tri% order by k

绍Oracle数据库的优化之数据库磁盘I/Ohttp://doc.chinaunix.net/oracle/200905/208827.shtmlv$filestat ,v$latch, v$queue, v$shared_server v$waitstat[@more@]

public stored in schema of outln.dic table: ol$, ol$hintskey knowledge:signature column of ol$. It is similar as sql hash value but with some different characteristic:1, space char and line-feed char are not including to calculated signature.2, Upper case and lower case of a character get the same signature value.---- optimize sql by outline method guide.1, create current sql outline .2, tune sql code until be satisfied with the performance. Some skill can used in this stage: 1>use sql hints

http://blog.chinaunix.net/u2/71105/showart_1000523.htmlhttp://bbs.chinaunix.net/thread-1160015-1-1.html[@more@]

ORA-16038的解决(日志无法归档)(http://blog.sina.com.cn/s/blog_525394060100h2c6.html[@more@]

http://ask.bluemotor.net/index.php AIX命令参考大全:http://www.kuqin.com/aixcmds/aixcmds3/lslv.htm[@more@]

http://david3389.itpub.net/post/38225/501523[@more@]

数据库迁移方案 ---专题http://tech.ccidnet.com/zt/qianyi/数据库迁移方案-- 概要http://www.examw.com/oracle/zhonghe/115174/[@more@]

ChinaUnix >> 文档中心 >> 数据库技术 >> Oracle ：http://doc.chinaunix.net/oracle/[@more@]

还是让我们给磁带一个机会吧http://www.stor-age.com/stor-age/2008/0117/710883.shtml使用SATA存储的真实成本http://stor-age.zdnet.com.cn/stor-age/2007/0516/393013.shtml[@more@]

---reference:http://hi.baidu.com/rhuang666/blog/item/860358f5430c5cd7f2d3859c.htmlhttp://hi.baidu.com/rhuang666/blog/item/7ff9911019c38e70ca80c48f.htmlhttp://forums.oracle.com/forums/thread.jspa?messageID=4403169[@more@]---1reate index online nologging中断后，出问题oracle 10204 rac ,我有张2G的表，建索引加了online nologging,后来我看建不上去，给他中断了。现在就删不掉了,rebuild的不也行。用DBMS_REPAIR.ONLINE_INDEX_CLEAN ();去修复，修复成功了。但是表还是无法drop ，rebuild就报错rac1> ALTER INDEX te

http://www.08.la/news2010/newshtml/JiShuWenZhang/ORACLE/18696.htmlhttp://space.itpub.net/23754390/viewspace-672214dbms_space source:http://www.chinaitpower.com/A/2002-11-23/41783.htmlhttp://hi.baidu.com/iceriversun/blog/item/38b987dd738f465894ee379d.htmldb2 oracle lockhttp://www.360doc.com/content/10/0916/19/2727796_54177725.shtml[@more@]

aix 4k,http://bitirainy.itpub.net/post/330/28684[@more@]

http://yumianfeilong.com/html/2010/04/10/427.html建立虚拟索引后，可以使用dbms_stats.generate_stats收集该虚拟索引的统计信息，以便更好的帮助CBO判断。dbms_stats.gather_index_stats无法分析virtual index。CREATE INDEX INDEX_NAMEON TABLE_NAME (INDEX_COLUMN)NOSEGMENT; invisible index 确实应该是用来解决virtual index无法解决的问题的, 但不完全是..比如可以直接将某个index 改为invisible就可以避免系统使用一个已有索引, 这在由个别索引导致执行计划出问题时也是很有帮助的..设计高效SQL: 一种视觉的方法http://www.itpub

http://space.itpub.net/27378/viewspace-670316http://www.sucai.com/Tech/List4/20745.htmORADEBUG EVENT event TRACE NAME CONTEXT FOREVER, LEVEL level在Session中实现Enable:ORADEBUG SESSION_EVENT event TRACE NAME CONTEXT FOREVER, LEVEL level[@more@]

-- 看来，学习还是要时常牢记那句话：纸上得来终觉浅，绝知此事要躬行。http://yong321.freeshell.org/oranotes/Histogram.htmlhttp://www.oracle.com.cn/viewthread.php?tid=67935表字段柱状图的理解：-- dictionary : dba_tab_col_statistics/user_tab_col_statisticsdba_tab_histogram/user_tab_histogram-- definition:the definition name is base the meaning of column endpoint_number.1， 当字段列DISTINCT VALUE>255 时，只能建立HBH(HEIGHT-BALANCED)HISTOGRAM. 即：平衡树。here endpoint_number is stand for card-weight

http://hi.baidu.com/gkl0818/blog/item/65ec81240a32021b8b82a146.html[@more@]

tkprof or explain paln :http://wenku.baidu.com/view/42639a7101f69e3143329460.html[@more@]

http://www.cnblogs.com/mrchenzh/archive/2010/06/12/1757297.htmlhttp://www.5ienet.com/note/html/scheduler/http://blog.sina.com.cn/s/blog_465a4a1e010007wj.html[@more@]

v$session_event , v$session_waithttp://hi.baidu.com/linuxocp/blog/item/daef1013cadf72caa7ef3f15.html(1)-V$SESSION_WAIT 　　这是一个寻找性能瓶颈的关键视图。它提供了任何情况下session在数据库中当前正在等待什么(如果session当前什么也没在做，则显示它最后的等待事件)。当系统存在性能问题时，本视图可以做为一个起点指明探寻问题的方向。　　V$SESSION_WAIT中，每一个连接到实例的session都对应一条记录。v$system_event :v$system_event shows the total number of waits and timeouts, and the totalwaiting time recorded