ef oracle sqlcommand,[ORACLE]Oracle 数据字典 V$SQLCOMMAND

=====================PARSINGIN CURSOR #140498482538928 len=156 dep=0 uid=0 oct=47 lid=0 tim=45795163585 hv=777087606 ad=‘207895c70‘ sqlid=‘ftqjy1wr52umq‘

begin

for i in 1..100000loopexecuteimmediate‘insert into ttt values(:x)‘using i;endloop;commit;end;END OFSTMT

PARSE #140498482538928:c=1537,e=2369,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=45795163582

=====================

PARSING IN CURSOR #140498482532488 len=26 dep=1 uid=0 oct=2 lid=0 tim=45795163960 hv=1741996203 ad=‘20493c508‘ sqlid=‘43b2vm1mx9h5b‘

insert into ttt values(:x)

=====================

PARSING IN CURSOR #140498482518688 len=314 dep=2 uid=0 oct=6 lid=0 tim=45795448603 hv=3096556448 ad=‘205380938‘ sqlid=‘0kkhhb2w93cx0‘

update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3

END OF STMT

=====================

PARSING IN CURSOR #140498482520800 len=226 dep=2 uid=0 oct=3 lid=0 tim=45796665754 hv=1011610568 ad=‘e9ac6ba0‘ sqlid=‘9tgj4g8y4rwy8‘

select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3

END OF STMT

=====================

PARSING IN CURSOR #140498482525520 len=6 dep=1 uid=0 oct=44 lid=0 tim=45801650319 hv=255718823 ad=‘0‘ sqlid=‘8ggw94h7mvxd7‘

COMMIT

END OF STMT

=====================

PARSE #140498482525520:c=15,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=45801650318 XCTEND rlbk=0, rd_only=0, tim=45801650356

=====================

=====================

PARSING IN CURSOR #140498482523536 len=59 dep=0 uid=0 oct=42 lid=0 tim=45809497780 hv=2633652776 ad=‘0‘ sqlid=‘fj94dakfgnqj8‘

alter session set events ‘10046 trace name context off‘