监控索引是否使用alteri
dexi
dex_
amemo
itori
gusagealteri
dexi
dex_
ame
omo
itori
gusageselectfromvobject_usagewherei
dex_
amei
dex_
ame求数据文件的IO分布selectdf
amephyrdsphywrtsphyblkrdphyblkwrtsi
gleblkrdsreadtimwritetimfromvfilestatfsvdbfiledfwherefsfiledffileorderbydf
ame求某个隐藏参数的值colksppi
mformata54colksppstvlformata54selectksppi
mksppstvlfromxksppipixksppcvcvwherecvi
dxpii
dxa
dpiksppi
mlike_escapea
dpiksppi
mlikemeer求系统中较大的latchselect
amesumgetssummissessumsleepssumwait_time
ffromvlatch_childre
groupby
amehavi
gsumgets50orderby2求归档日志的切换频率生产系统可能时间会很长selectstart_recidstart_timee
d_recide
d_timemi
utesfromselecttestrow
umasr
fromselectbrecidstart_recidto_charbfirst_timeyyyymmddhh24missstart_timearecide
d_recidto_charafirst_timeyyyymmddhh24misse
d_timerou
dafirst_timebfirst_time24602mi
utesfromvlog_historyavlog_historybwherearecidbrecid1a
dbfirst_timesysdate1orderbyafirst_timedesctestywhereyr
30求回滚段正在处理的事务selecta
amebxactscsidcserialdsql_textfromvroll
ameavrollstatbvsessio
cvsqltextdvtra
sactio
ewhereaus
bus
a
dbus
exidus
a
dctaddreaddra
dcsql_addressdaddressa
dcsql_hashvaluedhash_valueorderbya
amecsiddpiece求出无效的对象
fselectalterprocedureobject_
amecompilefromdba_objectswherestatusINVALIDa
dw
era
dobject_typei
PACKAGEPACKAGEBODYselectow
erobject_
ameobject_typestatusfromdba_objectswherestatusINVALID求processsessio
的状态selectppidpspidsprogramssidsserialfromvprocesspvsessio
swherespaddrpaddr求当前sessio
的状态selects
amemsvaluefromvmystatmsvstat
ames
wheremsstatistics
statistica
dmsvalue0求表的索引信息selectuitable_
ameuii
dex_
amefromuser_i
dexesuiuser_i
d_colum
suicwhereuitable_
ameuictable_
amea
duii
dex_
ameuici
dex_
ame
fa
duitable_
ameliketable_
amea
duiccolum
_
amecolum
_
ame显示表的外键信息colsearch_co
ditio
formata54selecttable_
ameco
strai
t_
amefromuser_co
strai
tswhereco
strai
t_typeRa
dco
strai
t_
amei
selectco
strai
t_
amefromuser_co
s_colum
swherecolum
_
ame1selectrpadchildtable_
ame25child_table
amerpadcpcolum
_
ame17referri
g_colum
rpadpare
ttable_
ame25pare
t_table
amerpadpccolum
_
ame15referred_colum
rpadchildco
strai
t_
ame25co
strai
t_
amefromuser_co
strai
tschilduser_co
strai
tspare
tuser_co
s_colum
scpuser_co
s_colum
spcwherechildco
strai
t_typeRa
dchildr_co
strai
t_
amepare
tco
strai
t_
ar