Trace with bind extremely long for create table statement

Apr 4, 2014 8:11AM

Hello gurus,

trace with binds are extremely long for create table statements in 11.2.0.2/AIX 6.1.

When i set trace for a single create statement with dbms_monitor.session_trace_enable( session_id=>nnn, waits=>true, binds=>true ) or

alter session set events 'sql_trace level=12' , create table stetement raises from 1" without trace to 15" with trace.

The table to be created has 56 columns

Thanks to tkprof, i see

insert into col$(obj#,name,intcol#,segcol#,type#,length,precision#,scale,

null$,offset,fixedstorage,segcollength,deflength,default$,col#,property,

charsetid,charsetform,spare1,spare2,spare3)

values

(:1,:2,:3,:4,:5,:6,decode(:5,182/*DTYIYM*/,:7,183/*DTYIDS*/,:7,decode(:7,0,

null,:7)),decode(:5,2,decode(:8,-127/*MAXSB1MINAL*/,null,:8),178,:8,179,:8,

Database Administration (MOSC)