- 博客(11)
- 资源 (6)
- 收藏
- 关注
RSS订阅原创 Using Oracle Trace Analyzer (trcanlzr.sql)
Using Oracle Trace Analyzer (trcanlzr.sql)Dave Moore: Author of Oracle UtilitiesOracle has provided another utility initially designed for performance tuning Oracle Applications. Trace Analyze
2010-02-27 00:21:00
704
转载 Oracle Trace Analyzer is TKPROF on Steroids
Oracle Trace Analyzer is TKPROF on SteroidsWhen you generate a raw Oracle SQL Trace file you are faced with the arduous task of analyzing this trace file. Of course, TKPROF has always been there to
2010-02-27 00:19:00
679
转载 oracle mutex
An introduction to Mutexes in 10gR2By Connie Green, Kumar RajamaniFrom meetings with: Kumar Rajamani, Russell Green, Saureen Shah, Cecilia Gervasio and Connie GreenIntroductionThis paper is intend
2010-02-24 16:11:00
609
原创 dba_tables.blocks V$ dba_segments.blocks
SQL> select count(*) from TESTSIZE; COUNT(*)---------- 584576 SQL> select table_name,blocks,empty_blocks from dba_tables where owner=HXG;TABLE_NAME BLOCKS EMPTY_B
2010-02-23 14:26:00
796
转载 ORA-000060: Deadlock detected: deadlock引起数据库挂死
某天，应用程序突然挂了，程序中报错连不上数据库。登录数据库主机后，发现sqlplus也登录不了，登录时，sqlplus长时间没有响应，检查alertlog只是发现半小时前检测到一个deadlock，没有其他的报错信息。心想oracle检测到deadlock能自动解锁，因此一开始没怀疑到是因为deadlock的原因，由于登录不上数据库，为了尽快的回复业务，停掉应用程序，杀掉ps -ef |grep
2010-02-18 04:27:00
3185
转载 ORA-01407 错误解决
from:http://www.raincat.net/blog/showlog.asp?cat_id=6&log_id=428 示例：SQL> update tb_test_log a 2 set game_deal_log_id = (select game_deal_log_id 3 from test b 4
2010-02-16 16:27:00
13651
转载 ORA-01407: cannot update to null 错误解决
ORA-01407: cannot update to null 错误解决在更新客户数据时 出现ORA-01407错误SQL> select table_id,game_deal_log_id from tb_test_log; TABLE_ID GAME_DEAL_LOG_ID---------- ----------------G 0
2010-02-16 16:12:00
4147
转载 我发的OCP学习和培训ppt汇总(0901)
我发的OCP学习和培训ppt汇总(0901) Oracle9i Performance Turning（LZ0-033）actualtests q510 071126 http://www.itpub.net/985687.html 1z1-040模拟题 http://www.itpub.net/937806.html 1z1-042模拟题 http://www.i
2010-02-15 02:53:00
2714
转载 我发的OCP学习和培训ppt汇总(0901)
我发的OCP学习和培训ppt汇总(0901) 模拟题 Oracle9i Performance Turning（LZ0-033）actualtests q510 071126 1z1-040模拟题 1z1-042模拟题 1z1-043模拟题 1Z0-043 Q185 2008年4月14日 1z1-402模拟题 1z1-046模拟题 1z1-047模拟题 1z0-048模拟
2010-02-15 02:50:00
2304
原创 jdeveloper 9i download
http://download.oracle.com/otn/java/jdeveloper/904w/jdev904.zip
2010-02-11 05:51:00
609
转载 Oracle JDeveloper 10g Release Download
Oracle JDeveloper 10g Release Download Oracle JDeveloper 10g (version 9.0.5.1, build 1605) for Windows NT/2000/X, Linux, Solaris, and HP-UX. http://download.oracle.com/otn/java/jdeveloper/905/jdev9051
2010-02-11 05:47:00
591
java 13 distributed programming and java
2018-11-22
oracle 10g完全参考
2007-04-25
Oracle Performance Tuning and Optimization
2007-04-24
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人