Vincent的专栏

#!/bin/sh # Get Hostname HOSTNAME=`hostname` logfile=xunjian_`date +%y%m%d`.log hostinfodir=/home/oracle/xunjian if [[ ! -d  $hostinfodir ]] then   mkdir -p $hostinfodir fi date >> $hostinfod

with force_mathces as  (select l.force_matching_signature mathces,  max(l.sql_id || l.child_number) max_sql_child,  COUNT(*) COUNT,  dense_rank() over(order by count(*) desc) ranking  from v$sql

oracle 索引何时需要重建 1.analyze index PUB_USER_FUNC_RESOURCE_INDEX3 validate structure; 2. 查询索引碎片： select name, del_lf_rows, lf_rows, round((del_lf_rows/(lf_rows+0.0000000001))*100) frag_pct from ind