一:创建测试数据
create table cjc.t1(id int,name varchar(10),time time,primary key (id));
insert into cjc.t1 values(1,'x',now());
insert into cjc.t1 values(2,'y',now());
insert into cjc.t1 values(3,'z',now());
commit;
二:dexp导出1张表
dexp USERID=CJC/******:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1
前台日志:
dexp V8
start dexp:
CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1
----- [2025-10-17 21:30:16]导出表：t1 -----
导出表对象权限...
表t1导出结束，共导出 3 行数据
整个导出过程共花费 0.115 s
成功终止导出, 没有出现警告
三:SQL日志分析:
dexp导出cjc.t1表时，后台执行了如下28个SQL:
SQL_1:
查询了很多参数:LENGTH_IN_CHAR,CASE_SENSITIVE_FLAG,PAGE,BLANK_PAD_MODE …
SELECT
SF_GET_LENGTH_IN_CHAR(),
SF_GET_CASE_SENSITIVE_FLAG(),
PAGE(),
SF_GET_EXTENT_SIZE(),
UNICODE(),
BLANK_PAD_MODE(),
sf_get_para_value(2,'ENABLE_PAGE_CHECK'),
sf_get_para_value(2,'SEC_PRIV_MODE'),
sf_get_para_value(2,'PAGE_ENC_SLICE_SIZE'),
sf_get_para_string_value(2, 'EXTERNAL_CRYPTO_NAME'),
SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_CIPHER_ID')),
SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_HASH_ID')),
SF_GET_CIPHER_NAME(sf_get_para_value(2,'DB_BLOCK_ENC_ID'));
手动执行结果如下:
##set isql_mode 3 使用\G格式输出:
*************************** 1. row ***************************
SF_GET_LENGTH_IN_CHAR(): 1
SF_GET_CASE_SENSITIVE_FLAG(): 0
PAGE(): 32768
SF_GET_EXTENT_SIZE(): 32
UNICODE(): 1
BLANK_PAD_MODE(): 0
sf_get_para_value(2,'ENABLE_PAGE_CHECK'): 3
sf_get_para_value(2,'SEC_PRIV_MODE'): 0
sf_get_para_value(2,'PAGE_ENC_SLICE_SIZE'): 4096
sf_get_para_string_value(2,'EXTERNAL_CRYPTO_NAME'):
SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_CIPHER_ID')): NULL
SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_HASH_ID')): NULL
SF_GET_CIPHER_NAME(sf_get_para_value(2,'DB_BLOCK_ENC_ID')): AES256_ECB
SQL_2:
查询补丁版本
select id_code();
行号 id_code()
---------- ------------------------------------------
1 --xxxxxx-202xxxxx-xxxxxx-2xxxx Pack2x
SQL_3:
RESOURCE_FLAG 参数和CONNECT_TIME、CONNECT_IDLE_TIME有关，RESOURCE_FLAG 取值 1、0 时，CONNECT_TIME 和 CONNECT_IDLE_TIME 单位分别为秒、分钟。
SELECT SF_GET_PARA_VALUE(2, 'RESOURCE_FLAG');
行号 SF_GET_PARA_VALUE(2,'RESOURCE_FLAG')
---------- ------------------------------------
1 0
SQL_4:
查询CJC用户的CONN_IDLE_TIME配置。
SELECT CONN_IDLE_TIME FROM SYS.SYSUSERS WHERE ID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='UR' AND SCHID=0 AND NAME='CJC');
行号 CONN_IDLE_TIME
---------- --------------
1 0
SQL_5:
MPP 系统内的库初始化时设置 dm.ini 中的 MPP_INI。取值范围为 0 或 1。缺省值为 0。可选参数。
1 表示设置 MPP_INI=1，启用 MPP 系统。
0 表示设置 MPP_INI=0，不启用 MPP 系统。
SELECT SF_GET_PARA_VALUE(1, 'MPP_INI');
行号 SF_GET_PARA_VALUE(1,'MPP_INI')
---------- ------------------------------
1 0
SQL_6:
SP_SET_DEXP_SESS(3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 ');
SQL_7:
SF_SET_SESSION_PARA_VALUE('ENABLE_INVISIBLE_COL',0);
SQL_8:
SELECT ID,INFO3,NAME FROM SYS.SYSOBJECTS
WHERE
SUBTYPE$='UTAB' AND
NAME = 'T1' and
NAME NOT IN('##PLAN_TABLE','##SYSTMPBAK','##SYSTMPBAKFILE','##HISTOGRAMS_TABLE') AND
SCHID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME = 'CJC');
行号 ID INFO3 NAME
---------- ----------- -------------------- ----
1 14816 4503599627436032 t1
SQL_9:
where 1=0,可能是检查表是否存在？
SELECT COUNT(*) FROM "CJC"."T1" where 1=0;
行号 COUNT(*)
---------- --------------------
1 0
SQL_10:
SELECT NAME,(SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC') SCHID FROM SYS.SYSOBJECTS
WHERE
TYPE$='UR' AND
SUBTYPE$='USER' AND
ID = (SELECT PID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC');
行号 NAME SCHID
---------- ---- -----------
1 CJC 150995960
SQL_11:
查询表结构，建表语句。
SELECT TABLEDEF2('CJC', 't1', 4, 2) , 't1' AS TABLE_NAME;
行号 TABLEDEF2('CJC','t1',4,2)
---------- ---------------------------------------------------------------------------------------------------------------------------
TABLE_NAME
----------
1 CREATE TABLE "t1"
(
"id" INT NOT NULL,
"name" VARCHAR(10),
"TIME" TIME(0),
NOT CLUSTER PRIMARY KEY("id")) STORAGE(CLUSTERBTR) ;
t1
SQL_12:
SELECT TABCOLDEFVAL('CJC', 't1') , 't1' AS TABLE_NAME;
行号 TABCOLDEFVAL('CJC','t1') TABLE_NAME
---------- ------------------------ ----------
1 t1
SQL_13:
查询表注释信息
SELECT COMMENT$,TVNAME,SCHNAME FROM SYS.SYSTABLECOMMENTS WHERE TVNAME='t1' AND SCHNAME='CJC';
SQL_14:
SELECT C.DEF, C.NAME, C.XTYPE, D.MONITORING, C.VALID FROM
(SELECT INDEXDEF2(B.ID, 0, 2) AS DEF, A.NAME AS NAME, B.XTYPE AS XTYPE, A.VALID AS VALID
FROM SYS.SYSOBJECTS A, SYS.SYSINDEXES B
WHERE
A.SUBTYPE$ = 'INDEX' AND
A.PID = 14816 AND A.ID = B.ID AND
(B.FLAG & 0X00000001) = 0
AND (B.FLAG & 0X00000002) = 0
AND (B.XTYPE & 0x00004000) != 0x00004000
AND (B.XTYPE & 0x00002000) != 0x00002000
AND ((B.XTYPE & 0x00000001) != 0
OR A.NAME != 'INDEX' || CAST(B.ID AS VARCHAR))) C
LEFT JOIN
(SELECT INDEX_NAME, MONITORING from
SYS.SYSOBJECTS, SYS.V$OBJECT_USAGE
WHERE
NAME = SCH_NAME AND TYPE$ = 'SCH') D
ON D.INDEX_NAME = C.NAME;
SQL_15:
SELECT O.DEF, O.NAME, P.MONITORING, O.VALID
FROM
(SELECT CONTEXT_INDEX_DEF(A.ID, 0) AS DEF, A.NAME AS NAME, C.NAME as SCH, B.VALID AS VALID
FROM CTISYS.SYSCONTEXTINDEXES A, SYS.SYSOBJECTS B, SYS.SYSOBJECTS C
WHERE
A.TABLEID = 14816 AND
A.ID = B.ID AND B.SCHID = C.ID) O
LEFT JOIN SYS.V$OBJECT_USAGE P
ON O.SCH = P.SCH_NAME AND O.NAME = P.INDEX_NAME;
SQL_16:
SELECT A.TXT,B.NAME, B.INFO1 & 0x1000
FROM SYS.SYSTEXTS A,SYS.SYSOBJECTS B
WHERE
A.ID = B.ID AND
B.TYPE$ = 'SCHOBJ' AND
B.SUBTYPE$ = 'TRIG'
AND B.INFO1&0x00000002 != 0
AND B.INFO1&0x20 = 0
AND B.PID = 14816;
SQL_17:
SELECT CONSDEF2(B.ID, 0), NAME
FROM SYS.SYSOBJECTS A,SYS.SYSCONS B
WHERE
A.SUBTYPE$ = 'CONS'
AND A.PID = 14816
AND A.ID = B.ID
AND (B.TYPE$ = 'F' OR B.TYPE$ = 'C')
AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID;
SQL_18:
SELECT CONSDEF2( B.ID, 0), NAME
FROM SYS.SYSOBJECTS A,SYS.SYSCONS B
WHERE
A.SUBTYPE$ = 'CONS'
AND A.PID = 14816
AND A.ID = B.ID
AND B.TYPE$ IN ('U')
AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID;
SQL_19:
SELECT PID FROM SYS.SYSOBJECTS WHERE NAME = 'CJC' AND TYPE$='SCH';
行号 PID
---------- -----------
1 50331763
SQL_20:
SELECT
SF_GET_USERNAME_BY_ID_EX(GRANTOR),
SF_GET_USERNAME_BY_ID_EX(URID),
SF_GET_SYS_PRIV(PRIVID),
SF_GET_SCHEMA_NAME_BY_ID( SCHID),
NAME,
GRANTABLE
FROM
SYS.SYSGRANTS, SYS.SYSOBJECTS
WHERE
SUBTYPE$ = 'UTAB'
AND GRANTOR = 50331763
AND OBJID = 14816
AND OBJID = SYS.SYSOBJECTS.ID and COLID = -1;
SQL_21:
SELECT
SF_GET_USERNAME_BY_ID_EX(GRANTOR),
SF_GET_USERNAME_BY_ID_EX(URID),
SF_GET_SYS_PRIV(PRIVID),
SF_GET_SCHEMA_NAME_BY_ID(SCHID),
NAME,
GRANTABLE
FROM
SYS.SYSGRANTS, SYS.SYSOBJECTS
WHERE
SUBTYPE$ = 'UTAB'
AND URID = 50331763
AND OBJID = 14816
AND OBJID = ID and COLID = -1;
SQL_22:
SELECT
SF_GET_USERNAME_BY_ID_EX(GRANTOR),
SF_GET_USERNAME_BY_ID_EX(URID),
SF_GET_SYS_PRIV(PRIVID),
SF_GET_SCHEMA_NAME_BY_ID(SCHID),
SYS.SYSOBJECTS.NAME,
SYS.SYSCOLUMNS.NAME,
GRANTABLE
FROM
SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS
WHERE
SUBTYPE$ IN('UTAB','STAB')
AND GRANTOR = 50331763
AND OBJID = 14816
AND OBJID = SYS.SYSOBJECTS.ID
AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID
AND OBJID = SYS.SYSCOLUMNS.ID;
SQL_23:
SELECT
SF_GET_USERNAME_BY_ID_EX(GRANTOR),
SF_GET_USERNAME_BY_ID_EX(URID),
SF_GET_SYS_PRIV(PRIVID),
SF_GET_SCHEMA_NAME_BY_ID(SCHID),
SYS.SYSOBJECTS.NAME,
SYS.SYSCOLUMNS.NAME,
GRANTABLE
FROM
SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS
WHERE
SUBTYPE$ IN('UTAB','STAB')
AND URID = 50331763
AND OBJID = 14816
AND OBJID = SYS.SYSOBJECTS.ID
AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID AND OBJID = SYS.SYSCOLUMNS.ID;
SQL_24:
查看表行数。
SELECT COUNT(*) FROM "CJC"."t1" ;
行号 COUNT(*)
---------- --------------------
1 3
SQL_25:
SELECT A.NAME FROM SYS.SYSCOLUMNS A
WHERE
A.ID = (
SELECT ID FROM SYS.SYSOBJECTS
WHERE
SCHID= 150995960 AND
NAME='t1' AND
SUBTYPE$ IN ('UTAB' ,'STAB'))
AND A.COLID NOT IN (SELECT COLID FROM SYS.SYSCOLINFOS B WHERE A.ID=B.ID AND B.INFO1 & 0x01 = 1)
ORDER BY A.COLID;
SQL_26:
和SQLServer的分页语法一样:
SELECT TOP 0 "id", "name", "TIME"FROM "CJC"."t1";
SQL_27:
并发查询。
SELECT /*+parallel(t 1)*/ TOP 0,4 "id", "name", "TIME"FROM "CJC"."t1";
行号 id name TIME
---------- ----------- ---- --------
1 1 x 12:12:40
2 2 y 12:13:09
3 3 z 12:13:19
SQL_28:
导出结束
SP_END_DEXP_SESS(1, 3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 ');
完整SQL日志如下:
2025-10-17 21:30:16.434 (EP[0] sess:0x7ffdc0043648 thrd:-1 user:NULL trxid:NULL stmt:NULL appname:) ALLOC SESSION
2025-10-17 21:30:16.441 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:NULL trxid:0 stmt:NULL appname:) STARTUP
2025-10-17 21:30:16.442 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:0 stmt:NULL appname:dexp) [LGN] LOGIN
2025-10-17 21:30:16.442 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:0 stmt:NULL appname:dexp) ALLOC STMT
......
2025-10-17 21:30:16.444 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:0 stmt:0x7ffdc0088648 appname:dexp ip:::1) [ORA]: SELECT SF_GET_LENGTH_IN_CHAR(), SF_GET_CASE_SENSITIVE_FLAG(), PAGE(), SF_GET_EXTENT_SIZE(), UNICODE(),BLANK_PAD_MODE(),sf_get_para_value(2,'ENABLE_PAGE_CHECK'), sf_get_para_value(2,'SEC_PRIV_MODE'),sf_get_para_value(2,'PAGE_ENC_SLICE_SIZE'), sf_get_para_string_value(2, 'EXTERNAL_CRYPTO_NAME'), SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_CIPHER_ID')), SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_HASH_ID')), SF_GET_CIPHER_NAME(sf_get_para_value(2,'DB_BLOCK_ENC_ID'));
2025-10-17 21:30:16.445 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:NULL appname:dexp) TRX: START
2025-10-17 21:30:16.445 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0088648 appname:dexp ip:::1) [SEL] SELECT SF_GET_LENGTH_IN_CHAR(), SF_GET_CASE_SENSITIVE_FLAG(), PAGE(), SF_GET_EXTENT_SIZE(), UNICODE(),BLANK_PAD_MODE(),sf_get_para_value(2,'ENABLE_PAGE_CHECK'), sf_get_para_value(2,'SEC_PRIV_MODE'),sf_get_para_value(2,'PAGE_ENC_SLICE_SIZE'), sf_get_para_string_value(2, 'EXTERNAL_CRYPTO_NAME'), SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_CIPHER_ID')), SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_HASH_ID')), SF_GET_CIPHER_NAME(sf_get_para_value(2,'DB_BLOCK_ENC_ID'));
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0088648 appname:dexp ip:::1) [SEL] SELECT SF_GET_LENGTH_IN_CHAR(), SF_GET_CASE_SENSITIVE_FLAG(), PAGE(), SF_GET_EXTENT_SIZE(), UNICODE(),BLANK_PAD_MODE(),sf_get_para_value(2,'ENABLE_PAGE_CHECK'), sf_get_para_value(2,'SEC_PRIV_MODE'),sf_get_para_value(2,'PAGE_ENC_SLICE_SIZE'), sf_get_para_string_value(2, 'EXTERNAL_CRYPTO_NAME'), SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_CIPHER_ID')), SF_GET_CIPHER_NAME(sf_get_para_value(2,'EXTERNAL_HASH_ID')), SF_GET_CIPHER_NAME(sf_get_para_value(2,'DB_BLOCK_ENC_ID')); EXECTIME: 1(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293700.
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0087648 appname:dexp ip:::1) [ORA]: select id_code();
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0087648 appname:dexp ip:::1) [SEL] select id_code();
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0087648 appname:dexp ip:::1) [SEL] select id_code(); EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293701.
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0086648 appname:dexp ip:::1) [ORA]: SELECT SF_GET_PARA_VALUE(2, 'RESOURCE_FLAG');
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0086648 appname:dexp ip:::1) [SEL] SELECT SF_GET_PARA_VALUE(2, 'RESOURCE_FLAG');
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0086648 appname:dexp ip:::1) [SEL] SELECT SF_GET_PARA_VALUE(2, 'RESOURCE_FLAG'); EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293702.
2025-10-17 21:30:16.447 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0086648 appname:dexp ip:::1) [ORA]: SELECT CONN_IDLE_TIME FROM SYS.SYSUSERS WHERE ID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='UR' AND SCHID=0 AND NAME='CJC');
2025-10-17 21:30:16.449 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0086648 appname:dexp ip:::1) [SEL] SELECT CONN_IDLE_TIME FROM SYS.SYSUSERS WHERE ID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='UR' AND SCHID=0 AND NAME='CJC');
2025-10-17 21:30:16.449 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0086648 appname:dexp ip:::1) [SEL] SELECT CONN_IDLE_TIME FROM SYS.SYSUSERS WHERE ID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='UR' AND SCHID=0 AND NAME='CJC'); EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293703.
2025-10-17 21:30:16.450 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:NULL appname:dexp) ALLOC STMT
2025-10-17 21:30:16.450 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc008a648 appname:dexp ip:::1) [ORA]: SELECT SF_GET_PARA_VALUE(1, 'MPP_INI');
2025-10-17 21:30:16.450 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc008a648 appname:dexp ip:::1) [SEL] SELECT SF_GET_PARA_VALUE(1, 'MPP_INI');
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc008a648 appname:dexp ip:::1) [SEL] SELECT SF_GET_PARA_VALUE(1, 'MPP_INI'); EXECTIME: 4(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293704.
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0085648 appname:dexp ip:::1) [ORA]: SP_SET_DEXP_SESS(3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 ');
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0085648 appname:dexp ip:::1) [CAL] SP_SET_DEXP_SESS(3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 ');
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0085648 appname:dexp ip:::1) [CAL] SP_SET_DEXP_SESS(3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 '); EXECTIME: 0(ms) EXEC_ID: 2293705.
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0084648 appname:dexp ip:::1) [ORA]: SF_SET_SESSION_PARA_VALUE('ENABLE_INVISIBLE_COL',0)
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0084648 appname:dexp ip:::1) [CAL] SF_SET_SESSION_PARA_VALUE('ENABLE_INVISIBLE_COL',0)
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0084648 appname:dexp ip:::1) [CAL] SF_SET_SESSION_PARA_VALUE('ENABLE_INVISIBLE_COL',0) EXECTIME: 0(ms) EXEC_ID: 2293706.
2025-10-17 21:30:16.455 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0083648 appname:dexp ip:::1) [ORA]: SELECT ID,INFO3,NAME FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND NAME = 'T1' and NAME NOT IN('##PLAN_TABLE','##SYSTMPBAK','##SYSTMPBAKFILE','##HISTOGRAMS_TABLE') AND SCHID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME = 'CJC')
2025-10-17 21:30:16.473 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0083648 appname:dexp ip:::1) [SEL] SELECT ID,INFO3,NAME FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND NAME = 'T1' and NAME NOT IN('##PLAN_TABLE','##SYSTMPBAK','##SYSTMPBAKFILE','##HISTOGRAMS_TABLE') AND SCHID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME = 'CJC')
2025-10-17 21:30:16.473 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0083648 appname:dexp ip:::1) [SEL] SELECT ID,INFO3,NAME FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND NAME = 'T1' and NAME NOT IN('##PLAN_TABLE','##SYSTMPBAK','##SYSTMPBAKFILE','##HISTOGRAMS_TABLE') AND SCHID = (SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME = 'CJC') EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293707.
2025-10-17 21:30:16.473 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0081648 appname:dexp ip:::1) [ORA]: SELECT COUNT(*) FROM "CJC"."T1" where 1=0;
2025-10-17 21:30:16.474 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0081648 appname:dexp ip:::1) [SEL] SELECT COUNT(*) FROM "CJC"."T1" where 1=0;
2025-10-17 21:30:16.474 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0081648 appname:dexp ip:::1) [SEL] SELECT COUNT(*) FROM "CJC"."T1" where 1=0; EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293708.
2025-10-17 21:30:16.474 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0082648 appname:dexp ip:::1) [ORA]: SELECT NAME,(SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC') SCHID FROM SYS.SYSOBJECTS WHERE TYPE$='UR' AND SUBTYPE$='USER' AND ID = (SELECT PID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC')
2025-10-17 21:30:16.474 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0082648 appname:dexp ip:::1) [SEL] SELECT NAME,(SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC') SCHID FROM SYS.SYSOBJECTS WHERE TYPE$='UR' AND SUBTYPE$='USER' AND ID = (SELECT PID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC')
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0082648 appname:dexp ip:::1) [SEL] SELECT NAME,(SELECT ID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC') SCHID FROM SYS.SYSOBJECTS WHERE TYPE$='UR' AND SUBTYPE$='USER' AND ID = (SELECT PID FROM SYS.SYSOBJECTS WHERE TYPE$='SCH' AND NAME='CJC') EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293709.
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0080648 appname:dexp ip:::1) [ORA]: SELECT TABLEDEF2('CJC', 't1', 4, 2) , 't1' AS TABLE_NAME
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0080648 appname:dexp ip:::1) [SEL] SELECT TABLEDEF2('CJC', 't1', 4, 2) , 't1' AS TABLE_NAME
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0080648 appname:dexp ip:::1) [SEL] SELECT TABLEDEF2('CJC', 't1', 4, 2) , 't1' AS TABLE_NAME EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293710.
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007f648 appname:dexp ip:::1) [ORA]: SELECT TABCOLDEFVAL('CJC', 't1') , 't1' AS TABLE_NAME
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007f648 appname:dexp ip:::1) [SEL] SELECT TABCOLDEFVAL('CJC', 't1') , 't1' AS TABLE_NAME
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007f648 appname:dexp ip:::1) [SEL] SELECT TABCOLDEFVAL('CJC', 't1') , 't1' AS TABLE_NAME EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293711.
2025-10-17 21:30:16.475 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007e648 appname:dexp ip:::1) [ORA]: SELECT COMMENT$,TVNAME,SCHNAME FROM SYS.SYSTABLECOMMENTS WHERE TVNAME='t1' AND SCHNAME='CJC';
2025-10-17 21:30:16.476 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007e648 appname:dexp ip:::1) [SEL] SELECT COMMENT$,TVNAME,SCHNAME FROM SYS.SYSTABLECOMMENTS WHERE TVNAME='t1' AND SCHNAME='CJC';
2025-10-17 21:30:16.476 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007e648 appname:dexp ip:::1) [SEL] SELECT COMMENT$,TVNAME,SCHNAME FROM SYS.SYSTABLECOMMENTS WHERE TVNAME='t1' AND SCHNAME='CJC'; EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293712.
2025-10-17 21:30:16.476 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007d648 appname:dexp ip:::1) [ORA]: SELECT COMMENT$,TVNAME,SCHNAME,COLNAME FROM SYS.SYSCOLUMNCOMMENTS WHERE TVNAME='t1' AND SCHNAME='CJC';
2025-10-17 21:30:16.476 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007d648 appname:dexp ip:::1) [SEL] SELECT COMMENT$,TVNAME,SCHNAME,COLNAME FROM SYS.SYSCOLUMNCOMMENTS WHERE TVNAME='t1' AND SCHNAME='CJC';
2025-10-17 21:30:16.476 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007d648 appname:dexp ip:::1) [SEL] SELECT COMMENT$,TVNAME,SCHNAME,COLNAME FROM SYS.SYSCOLUMNCOMMENTS WHERE TVNAME='t1' AND SCHNAME='CJC'; EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293713.
2025-10-17 21:30:16.476 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007c648 appname:dexp ip:::1) [ORA]: SELECT C.DEF, C.NAME, C.XTYPE, D.MONITORING, C.VALID FROM (SELECT INDEXDEF2(B.ID, 0, 2) AS DEF, A.NAME AS NAME, B.XTYPE AS XTYPE, A.VALID AS VALID FROM SYS.SYSOBJECTS A, SYS.SYSINDEXES B WHERE A.SUBTYPE$ = 'INDEX' AND A.PID = 14816 AND A.ID = B.ID AND (B.FLAG & 0X00000001) = 0 AND (B.FLAG & 0X00000002) = 0 AND (B.XTYPE & 0x00004000) != 0x00004000 AND (B.XTYPE & 0x00002000) != 0x00002000 AND ((B.XTYPE & 0x00000001) != 0 OR A.NAME != 'INDEX' || CAST(B.ID AS VARCHAR))) C LEFT JOIN (SELECT INDEX_NAME, MONITORING from SYS.SYSOBJECTS, SYS.V$OBJECT_USAGE WHERE NAME = SCH_NAME AND TYPE$ = 'SCH') D ON D.INDEX_NAME = C.NAME
2025-10-17 21:30:16.480 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007c648 appname:dexp ip:::1) [SEL] SELECT C.DEF, C.NAME, C.XTYPE, D.MONITORING, C.VALID FROM (SELECT INDEXDEF2(B.ID, 0, 2) AS DEF, A.NAME AS NAME, B.XTYPE AS XTYPE, A.VALID AS VALID FROM SYS.SYSOBJECTS A, SYS.SYSINDEXES B WHERE A.SUBTYPE$ = 'INDEX' AND A.PID = 14816 AND A.ID = B.ID AND (B.FLAG & 0X00000001) = 0 AND (B.FLAG & 0X00000002) = 0 AND (B.XTYPE & 0x00004000) != 0x00004000 AND (B.XTYPE & 0x00002000) != 0x00002000 AND ((B.XTYPE & 0x00000001) != 0 OR A.NAME != 'INDEX' || CAST(B.ID AS VARCHAR))) C LEFT JOIN (SELECT INDEX_NAME, MONITORING from SYS.SYSOBJECTS, SYS.V$OBJECT_USAGE WHERE NAME = SCH_NAME AND TYPE$ = 'SCH') D ON D.INDEX_NAME = C.NAME
2025-10-17 21:30:16.481 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007c648 appname:dexp ip:::1) [SEL] SELECT C.DEF, C.NAME, C.XTYPE, D.MONITORING, C.VALID FROM (SELECT INDEXDEF2(B.ID, 0, 2) AS DEF, A.NAME AS NAME, B.XTYPE AS XTYPE, A.VALID AS VALID FROM SYS.SYSOBJECTS A, SYS.SYSINDEXES B WHERE A.SUBTYPE$ = 'INDEX' AND A.PID = 14816 AND A.ID = B.ID AND (B.FLAG & 0X00000001) = 0 AND (B.FLAG & 0X00000002) = 0 AND (B.XTYPE & 0x00004000) != 0x00004000 AND (B.XTYPE & 0x00002000) != 0x00002000 AND ((B.XTYPE & 0x00000001) != 0 OR A.NAME != 'INDEX' || CAST(B.ID AS VARCHAR))) C LEFT JOIN (SELECT INDEX_NAME, MONITORING from SYS.SYSOBJECTS, SYS.V$OBJECT_USAGE WHERE NAME = SCH_NAME AND TYPE$ = 'SCH') D ON D.INDEX_NAME = C.NAME EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293714.
2025-10-17 21:30:16.493 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007b648 appname:dexp ip:::1) [ORA]: SELECT O.DEF, O.NAME, P.MONITORING, O.VALID FROM (SELECT CONTEXT_INDEX_DEF(A.ID, 0) AS DEF, A.NAME AS NAME, C.NAME as SCH, B.VALID AS VALID FROM CTISYS.SYSCONTEXTINDEXES A, SYS.SYSOBJECTS B, SYS.SYSOBJECTS C WHERE A.TABLEID = 14816 AND A.ID = B.ID AND B.SCHID = C.ID) O LEFT JOIN SYS.V$OBJECT_USAGE P ON O.SCH = P.SCH_NAME AND O.NAME = P.INDEX_NAME;
2025-10-17 21:30:16.495 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007b648 appname:dexp ip:::1) [SEL] SELECT O.DEF, O.NAME, P.MONITORING, O.VALID FROM (SELECT CONTEXT_INDEX_DEF(A.ID, 0) AS DEF, A.NAME AS NAME, C.NAME as SCH, B.VALID AS VALID FROM CTISYS.SYSCONTEXTINDEXES A, SYS.SYSOBJECTS B, SYS.SYSOBJECTS C WHERE A.TABLEID = 14816 AND A.ID = B.ID AND B.SCHID = C.ID) O LEFT JOIN SYS.V$OBJECT_USAGE P ON O.SCH = P.SCH_NAME AND O.NAME = P.INDEX_NAME;
2025-10-17 21:30:16.496 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007b648 appname:dexp ip:::1) [SEL] SELECT O.DEF, O.NAME, P.MONITORING, O.VALID FROM (SELECT CONTEXT_INDEX_DEF(A.ID, 0) AS DEF, A.NAME AS NAME, C.NAME as SCH, B.VALID AS VALID FROM CTISYS.SYSCONTEXTINDEXES A, SYS.SYSOBJECTS B, SYS.SYSOBJECTS C WHERE A.TABLEID = 14816 AND A.ID = B.ID AND B.SCHID = C.ID) O LEFT JOIN SYS.V$OBJECT_USAGE P ON O.SCH = P.SCH_NAME AND O.NAME = P.INDEX_NAME; EXECTIME: 1(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293715.
2025-10-17 21:30:16.496 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007a648 appname:dexp ip:::1) [ORA]: SELECT A.TXT,B.NAME, B.INFO1 & 0x1000 FROM SYS.SYSTEXTS A, SYS.SYSOBJECTS B WHERE A.ID = B.ID AND B.TYPE$ = 'SCHOBJ' AND B.SUBTYPE$ = 'TRIG' AND B.INFO1&0x00000002 != 0 AND B.INFO1&0x20 = 0 AND B.PID = 14816
2025-10-17 21:30:16.496 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007a648 appname:dexp ip:::1) [SEL] SELECT A.TXT,B.NAME, B.INFO1 & 0x1000 FROM SYS.SYSTEXTS A, SYS.SYSOBJECTS B WHERE A.ID = B.ID AND B.TYPE$ = 'SCHOBJ' AND B.SUBTYPE$ = 'TRIG' AND B.INFO1&0x00000002 != 0 AND B.INFO1&0x20 = 0 AND B.PID = 14816
2025-10-17 21:30:16.497 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc007a648 appname:dexp ip:::1) [SEL] SELECT A.TXT,B.NAME, B.INFO1 & 0x1000 FROM SYS.SYSTEXTS A, SYS.SYSOBJECTS B WHERE A.ID = B.ID AND B.TYPE$ = 'SCHOBJ' AND B.SUBTYPE$ = 'TRIG' AND B.INFO1&0x00000002 != 0 AND B.INFO1&0x20 = 0 AND B.PID = 14816 EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293716.
2025-10-17 21:30:16.497 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0079648 appname:dexp ip:::1) [ORA]: SELECT CONSDEF2(B.ID, 0), NAME FROM SYS.SYSOBJECTS A,SYS.SYSCONS B WHERE A.SUBTYPE$ = 'CONS' AND A.PID = 14816 AND A.ID = B.ID AND (B.TYPE$ = 'F' OR B.TYPE$ = 'C') AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID
2025-10-17 21:30:16.498 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0079648 appname:dexp ip:::1) [SEL] SELECT CONSDEF2(B.ID, 0), NAME FROM SYS.SYSOBJECTS A,SYS.SYSCONS B WHERE A.SUBTYPE$ = 'CONS' AND A.PID = 14816 AND A.ID = B.ID AND (B.TYPE$ = 'F' OR B.TYPE$ = 'C') AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID
2025-10-17 21:30:16.498 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0079648 appname:dexp ip:::1) [SEL] SELECT CONSDEF2(B.ID, 0), NAME FROM SYS.SYSOBJECTS A,SYS.SYSCONS B WHERE A.SUBTYPE$ = 'CONS' AND A.PID = 14816 AND A.ID = B.ID AND (B.TYPE$ = 'F' OR B.TYPE$ = 'C') AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293717.
2025-10-17 21:30:16.498 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0078648 appname:dexp ip:::1) [ORA]: SELECT CONSDEF2( B.ID, 0), NAME FROM SYS.SYSOBJECTS A,SYS.SYSCONS B WHERE A.SUBTYPE$ = 'CONS' AND A.PID = 14816 AND A.ID = B.ID AND B.TYPE$ IN ('U') AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID
2025-10-17 21:30:16.500 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0078648 appname:dexp ip:::1) [SEL] SELECT CONSDEF2( B.ID, 0), NAME FROM SYS.SYSOBJECTS A,SYS.SYSCONS B WHERE A.SUBTYPE$ = 'CONS' AND A.PID = 14816 AND A.ID = B.ID AND B.TYPE$ IN ('U') AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID
2025-10-17 21:30:16.500 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0078648 appname:dexp ip:::1) [SEL] SELECT CONSDEF2( B.ID, 0), NAME FROM SYS.SYSOBJECTS A,SYS.SYSCONS B WHERE A.SUBTYPE$ = 'CONS' AND A.PID = 14816 AND A.ID = B.ID AND B.TYPE$ IN ('U') AND EXISTS(SELECT 1 FROM SYS.SYSOBJECTS WHERE SUBTYPE$='UTAB' AND ID= 14816 AND (INFO3 & 192) == 0) ORDER BY B.ID EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293718.
2025-10-17 21:30:16.500 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0077648 appname:dexp ip:::1) [ORA]: SELECT PID FROM SYS.SYSOBJECTS WHERE NAME = 'CJC' AND TYPE$='SCH';
2025-10-17 21:30:16.501 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0077648 appname:dexp ip:::1) [SEL] SELECT PID FROM SYS.SYSOBJECTS WHERE NAME = 'CJC' AND TYPE$='SCH';
2025-10-17 21:30:16.501 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0077648 appname:dexp ip:::1) [SEL] SELECT PID FROM SYS.SYSOBJECTS WHERE NAME = 'CJC' AND TYPE$='SCH'; EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293719.
2025-10-17 21:30:16.501 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [ORA]: SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID( SCHID), NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS WHERE SUBTYPE$ = 'UTAB' AND GRANTOR = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID and COLID = -1;
2025-10-17 21:30:16.501 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID( SCHID), NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS WHERE SUBTYPE$ = 'UTAB' AND GRANTOR = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID and COLID = -1;
2025-10-17 21:30:16.501 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID( SCHID), NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS WHERE SUBTYPE$ = 'UTAB' AND GRANTOR = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID and COLID = -1; EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293720.
2025-10-17 21:30:16.501 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [ORA]: SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS WHERE SUBTYPE$ = 'UTAB' AND URID = 50331763 AND OBJID = 14816 AND OBJID = ID and COLID = -1;
2025-10-17 21:30:16.502 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS WHERE SUBTYPE$ = 'UTAB' AND URID = 50331763 AND OBJID = 14816 AND OBJID = ID and COLID = -1;
2025-10-17 21:30:16.502 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS WHERE SUBTYPE$ = 'UTAB' AND URID = 50331763 AND OBJID = 14816 AND OBJID = ID and COLID = -1; EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293721.
2025-10-17 21:30:16.517 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [ORA]: SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), SYS.SYSOBJECTS.NAME, SYS.SYSCOLUMNS.NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS WHERE SUBTYPE$ IN('UTAB','STAB') AND GRANTOR = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID AND OBJID = SYS.SYSCOLUMNS.ID;
2025-10-17 21:30:16.518 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), SYS.SYSOBJECTS.NAME, SYS.SYSCOLUMNS.NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS WHERE SUBTYPE$ IN('UTAB','STAB') AND GRANTOR = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID AND OBJID = SYS.SYSCOLUMNS.ID;
2025-10-17 21:30:16.518 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), SYS.SYSOBJECTS.NAME, SYS.SYSCOLUMNS.NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS WHERE SUBTYPE$ IN('UTAB','STAB') AND GRANTOR = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID AND OBJID = SYS.SYSCOLUMNS.ID; EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293722.
2025-10-17 21:30:16.518 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [ORA]: SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), SYS.SYSOBJECTS.NAME, SYS.SYSCOLUMNS.NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS WHERE SUBTYPE$ IN('UTAB','STAB') AND URID = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID AND OBJID = SYS.SYSCOLUMNS.ID;
2025-10-17 21:30:16.518 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), SYS.SYSOBJECTS.NAME, SYS.SYSCOLUMNS.NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS WHERE SUBTYPE$ IN('UTAB','STAB') AND URID = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID AND OBJID = SYS.SYSCOLUMNS.ID;
2025-10-17 21:30:16.519 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0076648 appname:dexp ip:::1) [SEL] SELECT SF_GET_USERNAME_BY_ID_EX(GRANTOR), SF_GET_USERNAME_BY_ID_EX(URID), SF_GET_SYS_PRIV(PRIVID), SF_GET_SCHEMA_NAME_BY_ID(SCHID), SYS.SYSOBJECTS.NAME, SYS.SYSCOLUMNS.NAME, GRANTABLE FROM SYS.SYSGRANTS, SYS.SYSOBJECTS, SYS.SYSCOLUMNS WHERE SUBTYPE$ IN('UTAB','STAB') AND URID = 50331763 AND OBJID = 14816 AND OBJID = SYS.SYSOBJECTS.ID AND SYS.SYSGRANTS.COLID = SYS.SYSCOLUMNS.COLID AND OBJID = SYS.SYSCOLUMNS.ID; EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293723.
2025-10-17 21:30:16.519 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0075648 appname:dexp ip:::1) [ORA]: SELECT COUNT(*) FROM "CJC"."t1"
2025-10-17 21:30:16.519 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0075648 appname:dexp ip:::1) [SEL] SELECT COUNT(*) FROM "CJC"."t1"
2025-10-17 21:30:16.519 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0075648 appname:dexp ip:::1) [SEL] SELECT COUNT(*) FROM "CJC"."t1" EXECTIME: 0(ms) ROWCOUNT: 1(rows) EXEC_ID: 2293724.
2025-10-17 21:30:16.528 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0074648 appname:dexp ip:::1) [ORA]: SELECT A.NAME FROM SYS.SYSCOLUMNS A WHERE A.ID = (SELECT ID FROM SYS.SYSOBJECTS WHERE SCHID= 150995960 AND NAME='t1' AND SUBTYPE$ IN ('UTAB' ,'STAB')) AND A.COLID NOT IN (SELECT COLID FROM SYS.SYSCOLINFOS B WHERE A.ID=B.ID AND B.INFO1 & 0x01 = 1) ORDER BY A.COLID;
2025-10-17 21:30:16.529 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0074648 appname:dexp ip:::1) [SEL] SELECT A.NAME FROM SYS.SYSCOLUMNS A WHERE A.ID = (SELECT ID FROM SYS.SYSOBJECTS WHERE SCHID= 150995960 AND NAME='t1' AND SUBTYPE$ IN ('UTAB' ,'STAB')) AND A.COLID NOT IN (SELECT COLID FROM SYS.SYSCOLINFOS B WHERE A.ID=B.ID AND B.INFO1 & 0x01 = 1) ORDER BY A.COLID;
2025-10-17 21:30:16.530 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0074648 appname:dexp ip:::1) [SEL] SELECT A.NAME FROM SYS.SYSCOLUMNS A WHERE A.ID = (SELECT ID FROM SYS.SYSOBJECTS WHERE SCHID= 150995960 AND NAME='t1' AND SUBTYPE$ IN ('UTAB' ,'STAB')) AND A.COLID NOT IN (SELECT COLID FROM SYS.SYSCOLINFOS B WHERE A.ID=B.ID AND B.INFO1 & 0x01 = 1) ORDER BY A.COLID; EXECTIME: 0(ms) ROWCOUNT: 3(rows) EXEC_ID: 2293725.
2025-10-17 21:30:16.530 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0073648 appname:dexp ip:::1) [ORA]: SELECT TOP 0 "id", "name", "TIME"FROM "CJC"."t1"
2025-10-17 21:30:16.530 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0073648 appname:dexp ip:::1) [SEL] SELECT TOP 0 "id", "name", "TIME"FROM "CJC"."t1"
2025-10-17 21:30:16.530 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0073648 appname:dexp ip:::1) [SEL] SELECT TOP 0 "id", "name", "TIME"FROM "CJC"."t1" EXECTIME: 0(ms) ROWCOUNT: 0(rows) EXEC_ID: 2293726.
2025-10-17 21:30:16.530 (EP[0] sess:0x7ffdb4012028 thrd:-1 user:NULL trxid:NULL stmt:NULL appname:) ALLOC SESSION
2025-10-17 21:30:16.540 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:NULL trxid:0 stmt:NULL appname:) STARTUP
2025-10-17 21:30:16.541 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:0 stmt:NULL appname:dexp) [LGN] LOGIN
2025-10-17 21:30:16.542 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:0 stmt:NULL appname:dexp) ALLOC STMT
2025-10-17 21:30:16.542 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:0 stmt:0x7ffdb4038028 appname:dexp ip:::1) [ORA]: SELECT /*+parallel(t 1)*/ TOP 0,4 "id", "name", "TIME"FROM "CJC"."t1"
2025-10-17 21:30:16.542 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:473659 stmt:NULL appname:dexp) TRX: START
2025-10-17 21:30:16.559 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:473659 stmt:0x7ffdb4038028 appname:dexp ip:::1) [SEL] SELECT /*+parallel(t 1)*/ TOP 0,4 "id", "name", "TIME"FROM "CJC"."t1"
2025-10-17 21:30:16.559 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:473659 stmt:0x7ffdb4038028 appname:dexp ip:::1) [SEL] SELECT /*+parallel(t 1)*/ TOP 0,4 "id", "name", "TIME"FROM "CJC"."t1" EXECTIME: 0(ms) ROWCOUNT: 3(rows) EXEC_ID: 2293800.
2025-10-17 21:30:16.559 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:473659 stmt:NULL appname:dexp) [LGN] FREE SESSION
2025-10-17 21:30:16.559 (EP[0] sess:0x7ffdb4012028 thrd:14316 user:CJC trxid:473659 stmt:NULL appname:dexp) TRX: ROLLBACK
2025-10-17 21:30:16.571 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0072648 appname:dexp ip:::1) [ORA]: SP_END_DEXP_SESS(1, 3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 ');
2025-10-17 21:30:16.571 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0072648 appname:dexp ip:::1) [CAL] SP_END_DEXP_SESS(1, 3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 ');
2025-10-17 21:30:16.571 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:0x7ffdc0072648 appname:dexp ip:::1) [CAL] SP_END_DEXP_SESS(1, 3, 'CJC/******@LOCALHOST:5238 FILE=DM_DEXP_TAB_20251017.dmp LOG=DM_DEXP_TAB_20251017.log DIRECTORY=/db/dm8/bak/tmp TABLES=CJC.T1 '); EXECTIME: 0(ms) EXEC_ID: 2293727.
2025-10-17 21:30:16.580 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:NULL appname:dexp) [LGN] FREE SESSION
2025-10-17 21:30:16.580 (EP[0] sess:0x7ffdc0043648 thrd:14312 user:CJC trxid:473658 stmt:NULL appname:dexp) TRX: ROLLBACK
欢迎关注我的公众号《IT小Chen》
扫一扫
859
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
