[ORACLE]Oracle 数据字典 V$SQLCOMMAND

Oracle trace文件中的一段

 

=====================
PARSING IN 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..100000
       loop
               execute immediate
           'insert into ttt values(:x)' using i;
       end loop;
       commit;
end;
END OF STMT
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'  

 

OCT    Oracle command type 指Oracle中命令分类的类型  可以通过 V$SQL.COMMAND_TYPE获得对应关系

 

SQL> select command_type,command_name from V$SQLCOMMAND where command_type in(2,3,6,42,44,47);

COMMAND_TYPE COMMAND_NAME
------------ ----------------------------------------------------------------
       2 INSERT
       3 SELECT
       6 UPDATE
      42 ALTER SESSION
      44 COMMIT
      47 PL/SQL EXECUTE

6 rows selected.