mea
dchildco
strai
t_
amecpco
strai
t_
amea
dpare
tco
strai
t_
amepcco
strai
t_
amea
d
fcppositio
pcpositio
a
dchildtable_
ametable_
ameorderbychildow
erchildtable_
amechildco
strai
t_
amecppositio
显示表的分区及子分区user_tab_subpartitio
scoltable_
ameformata16colpartitio
_
ameformata16colhigh_valueformata81selecttable_
amepartitio
_
ameHIGH_VALUEfromuser_tab_partitio
swheretable_
ametable_
ame使用dbms_xpla
生成一个执行计划explai
pla
setstateme
t_idsql_idforsqlselectfromtabledbms_xpla
display求某个事务的重做信息bytesselects
amemvaluefromvmystatmvstat
ameswheremstatisticsstatistica
ds
amelikeredosize求cache中缓存超过其5的对象selectoow
eroobject_typeoobject_
amecou
tbobjdfromvbhbdba_objectso
fwherebobjdoobject_idgroupbyoow
eroobject_typeoobject_
amehavi
gcou
tbobjdselectto_
umbervalue005fromvparameterwhere
amedb_block_buffers求谁阻塞了某个sessio
10gselectsiduser
ameeve
tblocki
g_sessio
seco
ds_i
_waitwait_timefromvsessio
wherestatei
WAITINGa
dwait_classIdle求sessio
的OS进程IDcolprogramformata54selectpspid