- 博客(6)
- 资源 (4)
- 问答 (1)
- 收藏
- 关注
转载 ORACLE 执行计划2
SQL>set timing on --显示Elapsed执行总时间。区别于set time on方式一:SQL>set autotrace on/off --显示结果集、执行计划和统计信息(执行SQL)SQL>set autotrace traceonly
2012-11-16 10:07:45 523
转载 看懂SqlServer查询计划
近期在做SQL SERVER 的代码优化,所以拿SQL SERVER 与ORACLE 的执行计划进行一个对比,把SQL SERVER ,oracle 的执行进行再次进行一个温习,重新列在这里。以更好的学习。http://www.cnblogs.com/fish-li/archive/2011/06/06/2073626.html
2012-11-16 10:04:04 643
转载 如何看懂ORACLE执行计划
一、什么是执行计划An explain plan is a representation of the access path that is taken when a query is executed within Oracle.二、如何访问数据At the physical level Oracle reads blocks of data. The smallest amo
2012-11-16 10:01:30 1176
原创 [INS-08109] Unexpected error occurred while validating inputs at state 'getOCMDetails'.
在ORACLE11G R2 安装ORACLE时出现以下错误:[INS-08109] Unexpected error occurred while validating inputs at state 'getOCMDetails'.经GOOGLE看到http://www.linkedin.com/groups/I-try-clone-oracle-grid
2012-11-12 09:41:14 13955
转载 Oracle常用监控SQL
1.监控事例的等待:select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*) from v$session_wait group by event order by 4;2.回滚段的争用情况:select name,waits,gets,waits/gets rat
2012-11-12 09:40:19 777
转载 几篇关于Hadoop+Hive数据仓库的入门文章
Hadoop计算平台和Hadoop数据仓库的区别http://datasearch.ruc.edu.cn/~boliangfeng/blog/?tag=%E6%95%B0%E6%8D%AE%E4%BB%93%E5%BA%93Hive 随谈(三)– Hive 和数据库的异同http://www.tbdata.org/archives/551Hadoop Ecosystem解决
2012-11-12 09:38:45 792
Database.10g.Administration.Workshop.I.Student.Guide ORACLE 原厂培训教材
2009-02-06
无法使用BlueCloth,安装总是失败
2009-07-03
TA创建的收藏夹 TA关注的收藏夹
TA关注的人