Geek asks and answers

Mxlc value in Oracle Trace file

In the trace file, I see the following:

Binding # 3 oacdty = 01 mxl = 128 (35) mxlc = 36 mal = 00 scl = 00 pre = 00
oacflg = 03 fl2 = 1000010 frm = 01 csi = 31 siz = 0 off = 168
kxsbbbfp = ffffffff79f139a8 bln = 128 avl = 35 flg = 01 value = "1234 W 1234 West, West Groves City"

I am wondering what is the value of mxlc?

+5
source share
2 answers

I quote

Bind #n
oacdty  - Datatype code 
mxl     - Maximum length of the bind variable value (private maximum length in parentheses)
mxlc    - Unknown    :(
mal     - array length
scl     - Scale
pre     - Precision
oacflg  - Special flag indicating bind options
fl2     - second part of oacflg
frm     - Unknown        :(
csi     - Unknown        :(
siz     - Amount of memory to be allocated for this chunk
off     - Offset into this chunk for this bind buffer
kxsbbbfp- Bind address
bln     - Bind buffer length
avl     - actual value length
flg     - bind status flag
value   - Value of the bind variable

Source (& fragment in the book)

The book also cites -

There is currently no information on three parameters.

Which mxlc, frmand csi.

+4
source

Summary

mxlc , .

My Oracle mxlc. mxlc=00, NVARCHAR NCHAR. ID 552262.1. (99 123 char) , , mxlc , .

create table t1(ncol1 nvarchar2(100), col1 varchar2(100));

alter session set timed_statistics = true;
alter session set statistics_level=all;
alter session set max_dump_file_size = unlimited;
alter session set events '10046 trace name context forever,level 4';

VAR nvar1 NVARCHAR2(99)
VAR var1 VARCHAR2(123 char)
EXEC :nvar1 := 'nvarchar'
EXEC :var1 := 'varchar'

SELECT * FROM T1 WHERE ncol1 = :nvar1 and col1 = :var1;
ALTER SESSION SET EVENTS '10046 trace name context off';

:

 Bind#0
  oacdty=01 mxl=2000(198) mxlc=99 mal=00 scl=00 pre=00
  oacflg=03 fl2=1000010 frm=02 csi=2000 siz=4000 off=0
  kxsbbbfp=0e702edc  bln=2000  avl=16  flg=05
  value=0 6e 0 76 0 61 0 72 0 63 0 68 0 61 0 72 
 Bind#1
  oacdty=01 mxl=2000(369) mxlc=123 mal=00 scl=00 pre=00
  oacflg=03 fl2=1000010 frm=01 csi=873 siz=0 off=2000
  kxsbbbfp=0e7036ac  bln=2000  avl=07  flg=01
  value="varchar"

mxl mxlc . NVARCHAR, UTF16 2 , 198 99. - UTF8, 4 . , Oracle , 3 , , 123 369. , 369, , , ?

, 36 35, . ? Oracle - ?

+2

More articles:


All Articles