高手来啦，我重装了下显卡驱动，装完后网页打不开了，但qq还能用，这是怎么回事啊_百度知道
高手来啦，我重装了下显卡驱动，装完后网页打不开了，但qq还能用，这是怎么回事啊
手来啦，但qq还能用，我重装了下显卡驱动，装完后网页打不开了
······哥们，官方下的，有毒sis该倒闭了
提问者采纳
不是驱动的问题
建议你重新装一下 “E” Internet
若还不行那我就没办法了
我以前遇到过这个情况 就是这样解决的 还有就是我以前装 完全安装的系统时 就打不开网页 后来换了 镜像盘
对了 你可以下载一个 驱动精灵 试试若还不行那我就没办法了
其他类似问题
为您推荐：
其他2条回答
使Windows XP快上几倍的三招，设置起来非常简单，但是文章又不乏实用性。
1、减少开机磁盘扫描等待时间，开始→运行，键入:chkntfs /t:0
2、删除系统备份文件：
在各种软硬件安装妥当之后，其实XP需要更新文件的时候就很少了。开始→运行，敲入:sfc.exe /purgecache 然后回车即可,近3xxMb。
3、压缩文件夹：
这是一个相当好的优化，Windows XP内置了对.ZIP文件的，我们可以把zip文件当成文件夹浏览。不过，系统要使用部分资源来实现 这一
功能，因此禁用这一功能可以提升系统性能。实现方法非常简单，只需取消zipfldr.dll的注册就可以了，点击开始——运行，
敲入: regsvr32 /u zipfldr.dll。然后回车即可。
千元电脑跑Win XP全攻略及心得
作者:阿榕在线 时间: ...
是不是显卡驱动带病毒啊。
显卡驱动的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁查看: 2699|回复: 10
ros5.26新主板经典问题
签到天数: 45 天[LV.5]常住居民I
本帖最后由 xw451 于
01:44 编辑
新年换新路由 网吧做大了
原有的单核ROS软路由老版本已经不能满足网吧需求了
软硬件一起升级
原有的ROS3.30升级ROS5.26
硬件从AMD单核升级到I3 、主板Z77
按照以前的方法 用IMG写盘工具 将ROS5.26.IMG包写入硬盘
完毕后重启电脑
出现一行错误 提示找不到硬盘
后来将BIOS中IDE模式改成AHCI或恢复BIOS默认设置
可以正常进入
设置完毕后也连上了
重启拔掉U盘
启动到中间卡住
排除了半天&&都没办法完整启动到login:界面
插上优盘 忘记从U盘启动
竟然正常启动ROS了
拔掉U盘 重启ROS 又不行了
猜想到可以一定要U盘支持
所以换个U口 也能正常启动
再换个U盘 依然正常启动
来来回回试了N次&&一定要插U盘才能启动
禁止U口也是无法启动的
这啥子道理
求解 希望有用新电脑做ROS的有过类似经验的告知下
本帖子中包含更多资源
才可以下载或查看，没有帐号？
签到天数: 847 天[LV.10]以坛为家III
你试试把img写入后拔掉u盘再启动，在没有U盘的情况下首次启动看看。另外你的图最好把call trace之前一屏的信息贴出来，tracer的信息作用不大，只能看出来是内核崩溃。。。我强烈怀疑是有文件写在了你U盘上。。。拔了U盘导致文件不全
我怀疑ROS是不是也和无盘软件一样 需要回写？
文件写在U盘上 可能性不大 因为后面我已经排除了用其它U盘 尝试都可以启动
即使是张刚刚格式化的U盘只要插上任何U口都可以启动&
签到天数: 1290 天[LV.10]以坛为家III
建议H61后期的主板 用U盘做 ROS启动+数据盘？
U盘只是启动PE系统
进入PE用IMG工具将ros5.26.img写入串口硬盘中&
签到天数: 45 天[LV.5]常住居民I
你试试把img写入后拔掉u盘再启动，在没有U盘的情况下首次启动看看。另外你的图最好把call trace之前一屏的 ...
我怀疑ROS是不是也和无盘软件一样 需要回写？
文件写在U盘上 可能性不大 因为后面我已经排除了用其它U盘 尝试都可以启动
即使是张刚刚格式化的U盘只要插上任何U口都可以启动
签到天数: 45 天[LV.5]常住居民I
建议H61后期的主板 用U盘做 ROS启动+数据盘？
U盘只是启动PE系统&&进入PE用IMG工具将ros5.26.img写入串口硬盘中
我意思 不使用硬盘 拿U盘当 读取数据的盘 直接使用 就当是电子盘一样用 了解？&
签到天数: 18 天[LV.4]偶尔看看III
支持楼主，大家都来支持啊‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎
签到天数: 1290 天[LV.10]以坛为家III
U盘只是启动PE系统&&进入PE用IMG工具将ros5.26.img写入串口硬盘中
我意思 不使用硬盘 拿U盘当 读取数据的盘 直接使用 就当是电子盘一样用 了解？
签到天数: 847 天[LV.10]以坛为家III
我怀疑ROS是不是也和无盘软件一样 需要回写？
文件写在U盘上 可能性不大 因为后面我已经排除了用其它U盘 ...
呵呵那就纠结了。也有可能是你带着U盘启动ROS，然后系统内核里就留下了U盘的信息，拔掉u盘后ROS启动中还是要mount这个盘，结果找不到就出错。先试下写完IMG拔掉U盘再进行第一次启动，看看情况吧。这种不熟悉的东西，去纠结什么原因导致出问题很难，修起来比正常用要难。。。。。。
签到天数: 4 天[LV.2]偶尔看看I
学习一下，看看怎么样
签到天数: 750 天[LV.10]以坛为家III
想不明白为什么要那么高的配置，难道要带一千台机。
签到天数: 289 天[LV.8]以坛为家I
用ISO安装试下了
网盟推荐 /1
天下网盟自2012年5月正式上线以来，一直以打造优质服务与信誉为宗旨，这几年一直得到网盟会员的大力支持。截至，网盟增值平台注册用户突破30000大关。
Powered byLinux安装的问题 end TRACE_百度知道
Linux安装的问题 end TRACE
为什么开机总是显示END TRACE 后面就是一堆数值
我还试过了雨林木风的linux也是一样的
深度的LINUX
还是一样的 怎么办
我的主板是
AMD K8 NF4
我想安装ubuntu11我的老机子为什么只能安装ubuntu10
我有更好的答案
装11.04跟10.10没有什么区别的。
其他类似问题
为您推荐：
trace的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁10053&trace&file&解读
最近比较烦，在做10046事件研究的时候发现 这个事件只能解决
Oracle是怎么执行的问题，而不能解答为何它要这么做，所以就顺着去看了10053事件，这个事件的确不错，站在量化的角度上
一定程度上解决了我的疑惑，只是新的麻烦就来了 ，没有完全读懂这个trace
file，而且试着去解读发现自己算的结果和文件中的结果有出入，所以有点郁闷。。。 先贴出来些，日后会补上这个解读。
******************************************
Current SQL statement
for this session:
EXPLAIN PLAN SET
STATEMENT_ID='PLUS' FOR select e.ename, d.dname
from scott.emp e,
scott.dept d
e.deptno=d.deptno
d.dname='SALES'
*******************************************
The following
abbreviations are used by optimizer trace.
CBQT - cost-based
query transformation
JPPD - join predicate
FPD - filter
PM - predicate
move-around
CVM - complex view
select-project-join
SJC - set join
conversion
SU - subquery
OBYE - order by
elimination
transformation
qb - query
DK - distinct
LB/K - average number
of leaf blocks per key
DB/K - average number
of data blocks per key
CLUF - clustering
NDV - number of
distinct values
Resp - response
cardinality
Resc - resource
NL - nested loops
SM - sort merge
CPUCSPEED - CPU
IOTFRSPEED - I/O
transfer speed
IOSEEKTIM - I/O seek
SREADTIM - average
single block read time
MREADTIM - average
multiblock read time
MBRC - average
multiblock read count
MAXTHR - maximum I/O
system throughput
SLAVETHR - average
slave I/O throughput
dmeth - distribution
&&1: no partitioning required
&&2: value partitioned
&&4: right is random (round-robin)
&&512: left is random (round-robin)
&&8: broadcast right and partition
&&16: broadcast left and partition
&&32: partition left using partitioning
&&64: partition right using partitioning
&&128: use hash partitioning
&&256: use range partitioning
&&2048: use list partitioning
&&1024: run the join in serial
&&0: invalid distribution method
selectivity
ptn - partition
*******************************************
Peeked values of the
binds in SQL statement
*******************************************
***************************************
PARAMETERS USED BY
THE OPTIMIZER
********************************
&&*************************************
&&PARAMETERS WITH ALTERED VALUES
&&******************************
&&*************************************
&&PARAMETERS WITH DEFAULT VALUES (影响优化的参数包括很多隐含参数)
&&******************************
&&optimizer_mode_hinted & & & &
& & & = false
&&optimizer_features_hinted & & & &
&&parallel_execution_enabled & & & &
&&parallel_query_forced_dop & & & &
&&parallel_dml_forced_dop & & & &
&&parallel_ddl_forced_degree & & & &
&&parallel_ddl_forced_instances & & & =
&&_query_rewrite_fudge & & & & &
&&optimizer_features_enable & & & &
& = 10.2.0.1
&&_optimizer_search_limit & & & &
&&cpu_count
& & & & & & & & &
& & & & = 2
&&active_instance_count & & & &
&&parallel_threads_per_cpu & & & &
&&hash_area_size & & & & &
& & & & & &= 131072
&&bitmap_merge_area_size & & & &
& & &= 1048576
&&sort_area_size & & & & &
& & & & & &= 65536
&&sort_area_retained_size & & & &
&&_sort_elimination_cost_ratio & & &
&&_optimizer_block_size & & & &
& & & = 8192
&&_sort_multiblock_read_count & & & &
&&_hash_multiblock_io_count & & & &
&&_db_file_optimizer_read_count & & & =
&&_optimizer_max_permutations & & & &
= 2000 &(最大计算join顺序)
&&pga_aggregate_target & & & & &
& & &= 198656 KB
&&_pga_max_size & & & & & &
& & & & & = 204800 KB
&&_query_rewrite_maxdisjunct & & & &
&&_smm_auto_min_io_size & & & &
& & & = 56 KB
&&_smm_auto_max_io_size & & & &
& & & = 248 KB
&&_smm_min_size & & & & & &
& & & & & = 198 KB
&&_smm_max_size & & & & & &
& & & & & = 39731 KB
&&_smm_px_max_size & & & & &
& & & & &= 99328 KB
&&_cpu_to_io & & & & & &
& & & & & & &= 0
&&_optimizer_undo_cost_change & & & &
= 10.2.0.1
&&parallel_query_mode & & & & &
& & & = enabled
&&parallel_dml_mode & & & & &
& & & & = disabled
&&parallel_ddl_mode & & & & &
& & & & = enabled
&&optimizer_mode & & & & &
& & & & & &= all_rows(CBO模式)
&&sqlstat_enabled & & & & &
& & & & & = false
&&_optimizer_percent_parallel & & & &
&&_always_anti_join & & & & &
& & & & = choose
&&_always_semi_join & & & & &
& & & & = choose
&&_optimizer_mode_force & & & &
& & & = true
&&_partition_view_enabled & & & &
& & = true
&&_always_star_transformation & & & &
&&_query_rewrite_or_error & & & &
& & = false
&&_hash_join_enabled & & & & &
& & & &= true
&&cursor_sharing & & & & &
& & & & & &= exact
&&_b_tree_bitmap_plans & & & & &
& & &= true
&&star_transformation_enabled & & & &
&&_optimizer_cost_model & & & &
& & & = choose
&&_new_sort_cost_estimate & & & &
& & = true
&&_complex_view_merging & & & &
& & & = true
&&_unnest_subquery & & & & &
& & & & &= true
&&_eliminate_common_subexpr & & & &
&&_pred_move_around & & & & &
& & & & = true
&&_convert_set_to_join & & & & &
& & &= false
&&_push_join_predicate & & & & &
& & &= true
&&_push_join_union_view & & & &
& & & = true
&&_fast_full_scan_enabled & & & &
& & = true
&&_optim_enhance_nnull_detection & & &=
&&_parallel_broadcast_enabled & & & &
&&_px_broadcast_fudge_factor & & & &
&&_ordered_nested_loop & & & & &
& & &= true
&&_no_or_expansion & & & & &
& & & & &= false
&&optimizer_index_cost_adj & & & &
&&optimizer_index_caching & & & &
& & = 0(影响索引的效果效果为100-0)
&&_system_index_caching & & & &
&&_disable_datalayer_sampling & & & &
&&query_rewrite_enabled & & & &
& & & = true
&&query_rewrite_integrity & & & &
& & = enforced
&&_query_cost_rewrite & & & & &
& & & = true
&&_query_rewrite_2 & & & & &
& & & & &= true
&&_query_rewrite_1 & & & & &
& & & & &= true
&&_query_rewrite_expression & & & &
&&_query_rewrite_jgmigrate & & & &
&&_query_rewrite_fpc & & & & &
& & & &= true
&&_query_rewrite_drj & & & & &
& & & &= true
&&_full_pwise_join_enabled & & & &
&&_partial_pwise_join_enabled & & & &
&&_left_nested_loops_random & & & &
&&_improved_row_length_enabled & & &
&&_index_join_enabled & & & & &
& & & = true
&&_enable_type_dep_selectivity & & &
&&_improved_outerjoin_card & & & &
&&_optimizer_adjust_for_nulls & & & &
&&_optimizer_degree & & & & &
& & & & = 0
&&_use_column_stats_for_function & & &=
&&_subquery_pruning_enabled & & & &
&&_subquery_pruning_mv_enabled & & &
&&_or_expand_nvl_predicate & & & &
&&_like_with_bind_as_equality & & & &
&&_table_scan_cost_plus_one & & & &
&&_cost_equality_semi_join & & & &
&&_default_non_equality_sel_check & & =
&&_new_initial_join_orders & & & &
&&_oneside_colstat_for_equijoins & & &=
&&_optim_peek_user_binds & & & &
& & &= true
&&_minimal_stats_aggregation & & & &
&&_force_temptables_for_gsets & & & &
&&workarea_size_policy & & & & &
& & &= auto
&&_smm_auto_cost_enabled & & & &
& & &= true
&&_gs_anti_semi_join_allowed & & & &
&&_optim_new_default_join_sel & & & &
&&optimizer_dynamic_sampling & & & &
&&_pre_rewrite_push_pred & & & &
& & &= true
&&_optimizer_new_join_card_computation = true
&&_union_rewrite_for_gs & & & &
& & & = yes_gset_mvs
&&_generalized_pruning_enabled & & &
&&_optim_adjust_for_part_skews & & &
&&_force_datefold_trunc & & & &
& & & = false
&&statistics_level & & & & &
& & & & &= typical
&&_optimizer_system_stats_usage & & & =
&&skip_unusable_indexes & & & &
& & & = true
&&_remove_aggr_subquery & & & &
& & & = true
&&_optimizer_push_down_distinct & & & =
&&_dml_monitoring_enabled & & & &
& & = true
&&_optimizer_undo_changes & & & &
& & = false
&&_predicate_elimination_enabled & & &=
&&_nested_loop_fudge & & & & &
& & & &= 100
&&_project_view_columns & & & &
& & & = true
&&_local_communication_costing_enabled = true
&&_local_communication_ratio & & & &
&&_query_rewrite_vop_cleanup & & & &
&&_slave_mapping_enabled & & & &
& & &= true
&&_optimizer_cost_based_transformation = linear
&&_optimizer_mjc_enabled & & & &
& & &= true
&&_right_outer_hash_enable & & & &
&&_spr_push_pred_refspr & & & &
& & & = true
&&_optimizer_cache_stats & & & &
& & &= false
&&_optimizer_cbqt_factor & & & &
&&_optimizer_squ_bottomup & & & &
& & = true
&&_fic_area_size & & & & &
& & & & & &= 131072
&&_optimizer_skip_scan_enabled & & &
&&_optimizer_cost_filter_pred & & & &
&&_optimizer_sortmerge_join_enabled & = true
&&_optimizer_join_sel_sanity_check & &=
&&_mmv_query_rewrite_enabled & & & &
&&_bt_mmv_query_rewrite_enabled & & & =
&&_add_stale_mv_to_dependency_list & &=
&&_distinct_view_unnesting & & & &
& &= false
&&_optimizer_dim_subq_join_sel & & &
&&_optimizer_disable_strans_sanity_checks = 0
&&_optimizer_compute_index_stats & & &=
&&_push_join_union_view2 & & & &
& & &= true
&&_optimizer_ignore_hints & & & &
& & = false
&&_optimizer_random_plan & & & &
&&_query_rewrite_setopgrw_enable & & &=
&&_optimizer_correct_sq_selectivity & = true
&&_disable_function_based_index & & & =
&&_optimizer_join_order_control & & & =
&&_optimizer_cartesian_enabled & & &
&&_optimizer_starplan_enabled & & & &
&&_extended_pruning_enabled & & & &
&&_optimizer_push_pred_cost_based & & =
&&_sql_model_unfold_forloops & & & &
&= run_time
&&_enable_dml_lock_escalation & & & &
&&_bloom_filter_enabled & & & &
& & & = true
&&_update_bji_ipdml_enabled & & & &
&&_optimizer_extended_cursor_sharing &= udo
&&_dm_max_shared_pool_pct & & & &
&&_optimizer_cost_hjsmj_multimatch & &=
&&_optimizer_transitivity_retain & & &=
&&_px_pwg_enabled & & & & &
& & & & & = true
&&optimizer_secure_view_merging & & & =
&&_optimizer_join_elimination_enabled = true
&&flashback_table_rpi & & & & &
& & & = non_fbt
&&_optimizer_cbqt_no_size_restriction = true
&&_optimizer_enhanced_filter_push & & =
&&_optimizer_filter_pred_pullup & & & =
&&_rowsrc_trace_level & & & & &
&&_simple_view_merging & & & & &
& & &= true
&&_optimizer_rownum_pred_based_fkr & &=
&&_optimizer_better_inlist_costing & &=
&&_optimizer_self_induced_cache_cost &= false
&&_optimizer_min_cache_blocks & & & &
&&_optimizer_or_expansion & & & &
& & = depth
&&_optimizer_order_by_elimination_enabled = true
&&_optimizer_outer_to_anti_enabled & &=
&&_selfjoin_mv_duplicates & & & &
& & = true
&&_dimension_skip_null & & & & &
& & &= true
&&_force_rewrite_enable & & & &
& & & = false
&&_optimizer_star_tran_in_with_clause = true
&&_optimizer_complex_pred_selectivity = true
&&_gby_hash_aggregation_enabled & & & =
&&***************************************
&&PARAMETERS IN OPT_PARAM HINT
&&****************************
***************************************
Column Usage
Monitoring is ON: tracking level = 1
***************************************
****************
QUERY BLOCK
****************
select e.ename,
from scott.emp e,
scott.dept d
e.deptno=d.deptno
d.dname='SALES'
*********************
QUERY BLOCK
*********************
qb name was
(optimizer): qb_name=SEL$1 nbfros=2 flg=0
&&fro(0): flg=0 objn=51149
hint_alias="D"@"SEL$1"
&&fro(1): flg=0 objn=51151
hint_alias="E"@"SEL$1"
*****************************
SYSTEM STATISTICS
INFORMATION ----
*****************************
来自于select *
&from aux_stats$;
可更改： execute
DBMS_STATS.SET_SYSTEM_STATS (pname =& 'cpuspeednw',
pvalue =& 8000);&
NOWORKLOAD Stats & & &
&&CPUSPEED: 485 millions instruction/sec
&&IOTFRSPEED: 4096 bytes per millisecond
(default is 4096)
&&IOSEEKTIM: 10 milliseconds (default is
***************************************
BASE STATISTICAL
INFORMATION &
***********************
Stats:: &
(dba_tab_columns)
&Table: DEPT &Alias:
&#Rows: 4 &
#Blks: &5 &
AvgRowLen: &20.00 &
&Column (#1): DEPTNO(NUMBER)
&AvgLen: 3.00&
4 & (NUM_DISTINCT 列的不重复值数)
Nulls: 0 (NUM_NULLS &列的空行数)
Density: 0.25 (DENSITY 列密度，没有直方图的情况下= 1/NDV)
10 (列的最小值 只对数字)
40 (列的最大值 只对数字)
Stats:: & (dba_indexes) &
----索引的知识
&&Index: PK_DEPT
&Col#: 1
&LVLS: 0 &(BLEVEL BTREE索引高度)&
1 (LEAF_BLOCKS 索引叶块数)&
4 (DISTINCT_KEYS 不重复索引关键字)&
1.00 (AVG_LEAF_BLOCKS_PER_KEY 叶块/关键字)&
1.00 (AVG_DATA_BLOCKS_PER_KEY 数据块/关键字)&
1.00 (CLUSTERING_FACTOR 索引聚合因子)
***********************
Stats::
&&Table: EMP &Alias:
&#Rows: 14 &#Blks:
AvgRowLen: &37.00 & &Column
(#8): DEPTNO(NUMBER)
&AvgLen: 3.00 NDV: 3
Nulls: 0 Density: 0.33333
Min: 10 Max: 30
Stats::
&&Index: PK_EMP
&Col#: 1
&LVLS: 0 &
1 &#DK: 14 &LB/K: 1.00
&DB/K: 1.00 &CLUF:
***************************************/(分析单表的访问路径，有些信息来自于dba_tables)
注：COST是
在noworkload
statistics下
cost=io_cost+cpu_cost/cpuspeednw*(ioseektim+db_block_size/iotfrspeed)*1000
而在workload
statistic下
COST=IO_COST+cpu_cost/cpuspeed*sreadtim*1000
SINGLE TABLE ACCESS
&&Table: EMP &Alias:
&Card: Original: 14
Rounded: 14 &
Computed: 14.00 &
Adjusted: 14.00
Path: TableScan
&Cost: &3.01 &
Degree: 0
&Cost_io: 3.00 &Cost_cpu:
&Resp_io: 3.00 &Resp_cpu:
&&Best::
AccessPath: TableScan &(全表扫描成本)
& & Cost: 3.01
&Degree: 1 &Resp: 3.01
&Card: 14.00 &Bytes:
***************************************
SINGLE TABLE ACCESS
Table: DEPT &Alias:
&Column (#2): DNAME(VARCHAR2)
&AvgLen: 10.00&
4 (NUM_DISTINCT 列的不重复值数)&
Nulls: 0 (NUM_NULLS &列的空行数)
Density: 0.25 (DENSITY 列密度，没有直方图的情况下= 1/NDV) &
&Card: Original: 4
Rounded: 1 &
Computed: 1.00 &
Adjusted: 1.00 &
(Computed=Card: Original *FF Filter Factor
&FF在没有直方图的情况下=Density)
Path: TableScan
&Cost: &3.01 &
Degree: 0
&Cost_io: 3.00 &Cost_cpu:
&Resp_io: 3.00 &Resp_cpu:
&&Best::
AccessPath: TableScan (全表扫描成本)
& & Cost: 3.01
&Degree: 1 &Resp: 3.01
&Card: 1.00 &Bytes:
***************************************
OPTIMIZER STATISTICS
AND COMPUTATIONS
***************************************
GENERAL PLANS
***************************************
Considering
cardinality-based initial join order.
***********************
order[1]: &DEPT[D]#0 &EMP[E]#1
&(第一种连接方式，EMP为内表)
***************
joining: EMP[E]#1
***************
NL Join(一)
table: Card: 1.00
&Cost: 3.01 &Resp: 3.01
&Degree: 1 &Bytes:
table: EMP &Alias: E
Path: TableScan
Join: &Cost: 6.01
&Resp: 6.01 &Degree:
&Cost_io: 6.00 &Cost_cpu:
&Resp_io: 6.00 &Resp_cpu:
cost: 6.01
& & &resc: 6.01
resc_io: 6.00 resc_cpu: 76154
& & &resp: 6.01
resp_io: 6.00 resp_cpu: 76154
Card: &4.67 = outer (1.00) * inner (14.00) *
sel (0.33333)
Join Card -
Rounded: 5 Computed: 4.67
SM Join(二)
table: resc: 3.01 &card 1.00
&bytes: 13 &deg: 1
&resp: 3.01
table: EMP &Alias: E
&resc: 3.01 &card: 14.00
&bytes: 9 &deg: 1
&resp: 3.01
&using dmeth: 2 &#groups:
&SORT resource & & &Sort statistics
&Sort width: & & & & 231
Area size: & & &202752 Max Area
size: & &
&Degree: & & & & &
&Blocks to Sort: & & & 1 Row
size: & & & & & 25 Total
Rows: & & & & & &
&Initial runs: & & & & 1
Merge passes: & & & &0 IO Cost
/ pass: & & & & &0
&Total IO sort cost: 0 & &
&Total CPU sort cost: 5819699
&Total Temp space used: 0
&SORT resource & & &Sort statistics
&Sort width: & & & & 231
Area size: & & &202752 Max Area
size: & &
&Degree: & & & & &
&Blocks to Sort: & & & 1 Row
size: & & & & & 20 Total
Rows: & & & & & &
&Initial runs: & & & & 1
Merge passes: & & & &0 IO Cost
/ pass: & & & & &0
&Total IO sort cost: 0 & &
&Total CPU sort cost: 5822101
&Total Temp space used: 0
join: Resc: 8.01
&Resp: 8.01 &[multiMatchCost=0.00]
cost: 8.01
resc: 8.01 resc_io: 6.00
resc_cpu:
resp: 8.01 resp_io: 6.00
resp_cpu:
SM Join (with index
on outer) (三)
Path: index (FullScan)
&Index: PK_DEPT
&resc_io: 2.00 &resc_cpu:
&ix_sel: 1
&ix_sel_with_filters: 1
&Cost: 2.00 &Resp: 2.00
&Degree: 1
table:&
&resc: 2.00 &card 1.00
&bytes: 13 &deg: 1
&resp: 2.00
table: EMP &Alias: E
&resc: 3.01 &card: 14.00
&bytes: 9 &deg: 1
&resp: 3.01
&using dmeth: 2 &#groups:
&SORT resource & & &Sort statistics
&Sort width: & & & & 231
Area size: & & &202752 Max Area
size: & &
&Degree: & & & & &
&Blocks to Sort: & & & 1 Row
size: & & & & & 20 Total
Rows: & & & & & &
&Initial runs: & & & & 1
Merge passes: & & & &0 IO Cost
/ pass: & & & & &0
&Total IO sort cost: 0 & &
&Total CPU sort cost: 5822101
&Total Temp space used: 0
join: Resc: 6.01
&Resp: 6.01 &[multiMatchCost=0.00]
HA Join (四)
table:&
&resc: 3.01 &card 1.00
&bytes: 13 &deg: 1
&resp: 3.01
table: EMP &Alias: E
&resc: 3.01 &card: 14.00
&bytes: 9 &deg: 1
&resp: 3.01
&using dmeth: 2 &#groups:
&Cost per ptn: 0.50
&#ptns: 1
&hash_area: 0 (max=0) & Hash
join: Resc: 6.51
&Resp: 6.51 &[multiMatchCost=0.00]
cost: 6.51
resc: 6.51 resc_io: 6.00
resc_cpu: 2987554
resp: 6.51 resp_io: 6.00
resp_cpu: 2987554
Best:: JoinMethod:
SortMerge & (第一种join推出来的结果是选择SM)
& Cost: 6.01 &Degree: 1
&Resp: 6.01 &Card: 4.67
&Bytes: 22
***********************
far: Table#: 0
&cost: 2.0027 &card:
1.0000 &bytes: 13
& & & & Table#: 1
&cost: 6.0100 &card:
4.6667 &bytes: 110
***********************
order[2]: &EMP[E]#1 &DEPT[D]#0
&(第二种连接方式,DEPT为内表)
***************
joining: DEPT[D]#0
***************
NL Join(一)
table: Card: 14.00
&Cost: 3.01 &Resp: 3.01
&Degree: 1 &Bytes:
table: DEPT &Alias: D
Path: TableScan
Join: &Cost: 20.09
&Resp: 20.09 &Degree:
&Cost_io: 20.00
&Cost_cpu: 550488
&Resp_io: 20.00
&Resp_cpu: 550488
Path: index (UniqueScan)
&Index: PK_DEPT
&resc_io: 1.00 &resc_cpu:
&ix_sel: 0.25
&ix_sel_with_filters: 0.25
Join: Cost: 4.03
&Resp: 4.03 &Degree:
&Cost_io: 4.00 &Cost_cpu:
&Resp_io: 4.00 &Resp_cpu:
Path: index (AllEqUnique)
&Index: PK_DEPT
&resc_io: 1.00 &resc_cpu:
&ix_sel: 0.25
&ix_sel_with_filters: 0.25
Join: Cost: 4.03
&Resp: 4.03 &Degree:
&Cost_io: 4.00 &Cost_cpu:
&Resp_io: 4.00 &Resp_cpu:
cost: 4.03
& & &resc: 4.03
resc_io: 4.00 resc_cpu:
& & &resp: 4.03
resp_io: 4.00 resp_cpu:
Card: &4.67 = outer (14.00) * inner (1.00) *
sel (0.33333)
Join Card -
Rounded: 5 Computed: 4.67
SM Join(二)
table:&
&resc: 3.01 &card 14.00
&bytes: 9 &deg: 1
&resp: 3.01
table: DEPT &Alias: D
&resc: 3.01 &card: 1.00
&bytes: 13 &deg: 1
&resp: 3.01
&using dmeth: 2 &#groups:
&SORT resource & & &Sort statistics
&Sort width: & & & & 231
Area size: & & &202752 Max Area
size: & &
&Degree: & & & & &
&Blocks to Sort: & & & 1 Row
size: & & & & & 20 Total
Rows: & & & & & &
&Initial runs: & & & & 1
Merge passes: & & & &0 IO Cost
/ pass: & & & & &0
&Total IO sort cost: 0 & &
&Total CPU sort cost: 5822101
&Total Temp space used: 0
&SORT resource & & &Sort statistics
&Sort width: & & & & 231
Area size: & & &202752 Max Area
size: & &
&Degree: & & & & &
&Blocks to Sort: & & & 1 Row
size: & & & & & 25 Total
Rows: & & & & & &
&Initial runs: & & & & 1
Merge passes: & & & &0 IO Cost
/ pass: & & & & &0
&Total IO sort cost: 0 & &
&Total CPU sort cost: 5819699
&Total Temp space used: 0
join: Resc: 8.01
&Resp: 8.01 &[multiMatchCost=0.00]
cost: 8.01
resc: 8.01 resc_io: 6.00
resc_cpu:
resp: 8.01 resp_io: 6.00
resp_cpu:
HA Join(三)
table:&
&resc: 3.01 &card 14.00
&bytes: 9 &deg: 1
&resp: 3.01
table: DEPT &Alias: D
&resc: 3.01 &card: 1.00
&bytes: 13 &deg: 1
&resp: 3.01
&using dmeth: 2 &#groups:
&Cost per ptn: 0.50
&#ptns: 1
&hash_area: 0 (max=0) & Hash
join: Resc: 6.51
&Resp: 6.51 &[multiMatchCost=0.00]
cost: 6.51
resc: 6.51 resc_io: 6.00
resc_cpu: 2988604
resp: 6.51 resp_io: 6.00
resp_cpu: 2988604
Best:: JoinMethod:
NestedLoop
& Cost: 4.03 &Degree: 1
&Resp: 4.03 &Card: 4.67
&Bytes: 22 &&
***********************
far: Table#: 1
&cost: 3.0068 &card:
14.0000 &bytes: 126
& & & & Table#: 0
&cost: 4.0270 &card:
4.6667 &bytes: 110
(newjo-stop-1)
k:0, spcnt:0,
perm:2, maxperm:2000
*********************************
Number of join
permutations tried: 2
*********************************
(newjo-save) &
Final - All Rows
Plan: &Best join order:
&&Cost: 4.0270
&Degree: 1 &Card: 5.0000
&Bytes: 110
&&Resc: 4.0270
&Resc_io: 4.0000
&Resc_cpu: 157147
&&Resp: 4.0270
&Resp_io: 4.0000
&Resc_cpu: 157147
kkoipt: Query block SEL$1 (#0)
******* UNPARSED
QUERY IS *******
SELECT "E"."ENAME"
"ENAME","D"."DNAME" "DNAME" FROM "SCOTT"."EMP" "E","SCOTT"."DEPT"
"D" WHERE "E"."DEPTNO"="D"."DEPTNO" AND "D"."DNAME"='SALES'
kkoqbc-end
& & &: call(in-use=31608, alloc=0),
compile(in-use=32844, alloc=0)
apadrv-end: call(in-use=31608, alloc=0),
compile(in-use=33432, alloc=0)
sql_id=6jnkt04yzj5z3.
Current SQL statement
for this session:
EXPLAIN PLAN SET
STATEMENT_ID='PLUS' FOR select e.ename, d.dname
from scott.emp e,
scott.dept d
e.deptno=d.deptno
d.dname='SALES'
============
Plan Table
============
------------------------------------------------+-----------------------------------+
Operation & & & & & & & &
& & | Name & &| Rows &| Bytes | Cost
&| Time & & &|
------------------------------------------------+-----------------------------------+
| 0 & | SELECT
STATEMENT & & & & & & &| &
& & & | & & & | & & &
| & & 4 | & & & & & |
&NESTED LOOPS & & & & & & &
& | & & & & | & & 5 | & 110
| & & 4 | &00:00:01
TABLE ACCESS FULL & & & & & | EMP &
& | & &14 | & 126 | & & 3 |
&00:00:01 |
TABLE ACCESS BY INDEX ROWID | DEPT & &| & & 1 |
& &13 | & & 1 |
&00:00:01 |
&INDEX UNIQUE SCAN & & & & &| PK_DEPT
| & & 1 | & & & | & & 0 | &
------------------------------------------------+-----------------------------------+
Information:
----------------------
filter("D"."DNAME"='SALES')
access("E"."DEPTNO"="D"."DEPTNO")
Content of other_xml
===========================
&&db_version & & :
&&parse_schema & : SYS
&&plan_hash
& & &:
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。