- 博客(13)
- 收藏
- 关注
原创 Oracle tuning the operating system
<br />tuning:memory io cpu<br />vmstat iostat top sar<br />para:lock_sga<br />cpu busy rate:90% ,os/usr 40/60<br />monitor usage
2011-02-20 10:47:00 502
原创 Oracle monitoring and detecting lock contention
<br />modes of locking:exclusive,share<br />types of locks:dml,ddl,internal<br />v$lock type tm:id1 -> table and meterailize log<br />v$lock type tx:id1 -> high 16 bit =xidusn(v$transaction) low 16 bit = xidslot(v$transaction)<br />v$lock v$transaction v$s
2011-02-20 10:46:00 555
原创 oracle use materialized views
<br />refresh types:complete(delete->insert rowid changed),fast(update,rowid not changed)<br />dbms_mview refresh<br />materialized view log: mlog$_xxx<br />query rewrites para:query_rewrite_enabled,query_rewrite_integrity, query rewrite privilige,hints
2011-02-20 10:45:00 577
原创 Oracle using oracle data storage structures efficiently
<br />types:heap table ,cluster,index organized table,partition table<br />cluster:index cluster(<> between and),hash cluster(=)<br />partition:range,hash,list,composite<br />partition pruning<br />partition-wise join<br />ps:range(maxvalue新纪录如何整理,add part
2011-02-20 10:44:00 467
原创 Oracle application tuning
<br />redefine a table online: dbms_redefinition<br />compressed index<br />reverse key index<br />index organized table:pctthreshold,including,overflow,mapping table
2011-02-20 10:44:00 459
原创 Oracle sql statement tuning
<br /><br /><br /> optimizer modes:rule-based,cost-based<br /> optimizer :throughput,response time<br /> optimizer_features_enable=8.1.5<br /> package:dbms_spm(sql plan management)<br /> v$sql_plan<br /> plan_table :explain plan for select * from t;
2011-02-09 14:25:00 598
原创 Oracle managing statistics
<br /><br /><br /> statistics:sys,table,index,column<br /> package:dbms_stats (exec dbms_stats.gather_table_stats('HR','T'))<br /> dba_tables dba_indexes <br /> v$user_tab_statistics v$user_tab_col_statistics<br /> v$segstat_name v$segstat v$segment_s
2011-02-09 14:25:00 492
原创 Oracle using blocks efficiently
<br /><br /> dba_tables: empty_blocks/(blocks+empty_blocks)<0.1%<br /> analyze table t compute statistics -> get empty_blocks<br /> truncate init hwm<br /> package:dbms_space<br /> recover space:export and import,alter table move ,alter table t deall
2011-02-09 14:25:00 492
原创 Oracle optimizing sort operations
<br /><br /> optimal,one pass,multi pass<br /> auto manage para:pga_aggregate_target<br /> v$pgastat v$sql_workarea v$sql_workarea_histogram v$sql_workarea_active v$sql v$sql_plan v$tempseg_usage v$pga_target_advice v$sysstat v$pga_target_advice_histogr
2011-02-09 14:24:00 484
原创 Oracle using resource manager
<br /><br /> package:dbms_resource_manage<br /> unit: group<br /> auto group switch<br /> execution time limit<br /> undo pool<br /> idle time limit<br /> dd: dba_rsrc_*<br /> view:v$session v$rsrc_plan v$rsrc_consumer_group
2011-02-09 14:24:00 506
原创 Oracle sizing other sga structures
<br /><br /> log_buffer<br /> v$session_wait(log buffer space)<br /> v$sysstat(redo entries,redo buffer allocation retries <1%)<br /> v$system_event(log file switch%)<br /> redo log buffer,java pool
2011-02-09 14:23:00 408
原创 Oracle tuning the oracld shared server
<br /><br /> para:max_shared_servers circuits processes<br /> v$dispatcher v$dispatcher_rate v$queue<br /> v$shared_server v$circuit
2011-02-09 14:23:00 448
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人