数据库管理员日常工作中必备sql列表.pdfVIP

1.监控索引是否使用 alter index index_namemonitoring usage; alter index index_namenomonitoring usage; select *fromv$object_usagewhereindex_name index_name; 2.求数据文件的I/O分布 selectdf.name,phyrds,phywrts,phyblkrd,phyblkwrt,singleblkrds,readtim,writetim fromv$filestatfs,v$dbfiledf wherefs.file# df.file#orderby df.name; 3.求某个隐藏参数的值 colksppinmformata54 colksppstvlformata54 selectksppinm, ksppstvl fromx$ksppipi,x$ksppcv cv where cv.indx pi.indx and pi.ksppinm like \_% escape \ and pi.ksppinm like %meer%; 4.求系统中较大的latch selectname,sum(gets),sum(misses),sum(sleeps),su