SQLa
deve
t
otlikerdbmsa
deve
t
otlikemo
orderbyeve
tselect
amewait_timefromvlatchlwhereexistsselect1fromselectsideve
tp1textp1p2textp2p3textp3fromvsessio
_wait
fwhereeve
t
otlikeSQLa
deve
t
otlikerdbmsa
deve
t
otlikemo
xwherexp1llatch求会话等待的对象colow
erformata18colsegme
t_
ameformata32colsegme
t_typeformata32selectow
ersegme
t_
amesegme
t_typefromdba_exte
tswherefile_idfile_ida
dblock_idbetwee
block_ida
dblock_idblocks1求buffercache中的块信息selectoOBJECT_TYPEsubstroOBJECT_NAME110obj
amebobjdbstatuscou
tbobjdfromvbhbdba_objectsowherebobjdodata_object_ida
doow
er1groupbyoobject_typeoobject_
amebobjdbstatus求日志文件的空间使用
fselectleleseqcurre
t_log_seque
ce100cpcpodr_b
olelesizperce
tage_fullfromxkcccpcpxkcclelewhereleleseqcpcpodr_seq求等待中的对象selectrulessidsuser
ameweve
toow
erosegme
t_
ameosegme
t_typeopartitio
_
amewseco
ds_i
_waitseco
dswstatefromvsessio
_waitwvsessio
sdba_exte
tsowhereweve
ti
select
amefromveve
t_
amewhereparameter1filea
dparameter2blocka
d
ame
otlikeco
trola
doow
ersysa
dwsidssida
dwp1ofile_ida
dwp2oblock_ida
dwp2oblock_idoblocks求当前事务的重做尺寸selectvaluefromvmystatvstat
amewherevmystatstatisticvstat
amestatistica
dvstat
ame
ameredosize
f唤醒smo
去清除临时段colum
pid
ew_valueSmo
settermoutoffselectppidfromsysv_bgprocessbsysv_processpwhereb
ameSMONa
dpaddrbpaddrsettermouto
oradebugwakeupSmo
u
defi
eSmo
求回退率selectbvalueavaluebvalueavaluebvaluefromvsysstatavsysstatbwhereastatistic4a
dbstatistic5求DISKREAD较多的SQLselectstsql_textfromvsqlsvsqltextstwheresaddressstaddressa
dshashvaluesthash_valuea
dsdisk_reads300求DISKSORT严重的SQL
fselectsessuser
amesqlsql_textsort1blocksfromvsessio
sessvsqlareasqlvsort_usagesort1wheresessserialsort1sessio
_
uma
dsort1sqladdrsqladdressa
dsort1sqlhashsqlhash_valuea
dsort1blocks200求对象的创建代码colum
colum
_
ameformata36colum
sql_textformata99selectdbms_metadataget_ddlTABLE1fromdualselectdbms_metadataget_ddlINDEX1fromdual求表的索引setli
esize131selectai
dex_
ameacolum
_
amebstatusbi
dex_typefromuser_i
d_colum
sauser_i
dexesbwhereai
dex_
amebi
dex_
amea
datable_
ame1求索引中行数较多的selecti
dex_
ameblevel
um_rowsCLUSTERING_FACTORstatusfromuser_i
dexeswhere
um_rows10000a
dblevel0
fselecttable_
amei
dex_
ameblevel
um_rowsCLUSTERING_FACTORsr