nologging 테이블 생성
> CREATE TABLE sk.tab1 (c1 NUMBER) nologging
0 row(s) modified.
> SELECT table_name, logging FROM dba_tables WHERE owner = 'SK'
TABLE_NAME|LOGGING|
----------+-------+
TAB1 |NO |
P_TAB2 | |
2 row(s) fetched.
-- 아카이브 모드 확인
> SELECT * FROM v$instance
INSTANCE_NUMBER|INSTANCE_NAME|HOST_NAME|VERSION |VERSION_LEGACY|VERSION_FULL|STARTUP_TIME |STATUS|PARALLEL|THREAD#|ARCHIVER|LOG_SWITCH_WAIT|LOGINS |SHUTDOWN_PENDING|DATABASE_STATUS|INSTANCE_ROLE |ACTIVE_STATE|BLOCKED|CON_ID|INSTANCE_MODE|EDITION|FAMILY|DATABASE_TYPE|
---------------+-------------+---------+----------+--------------+------------+-------------------+------+--------+-------+--------+---------------+-------+----------------+---------------+----------------+------------+-------+------+-------------+-------+------+-------------+
1|ent19 |svr |19.0.0.0.0|19.0.0.0.0 |19.24.0.0.0 |2024-08-02 07:35:02|OPEN |NO | 1|STARTED | |ALLOWED|NO |ACTIVE |PRIMARY_INSTANCE|NORMAL |NO | 0|REGULAR |EE | |SINGLE |
1 row(s) fetched.
-- 로그 스위치
> alter system switch logfile
0 row(s) modified.
-- 가장 최근 로그는 99번
> SELECT THREAD#, NAME, sequence#
, FIRST_CHANGE# -- 현재 로그의 MIN(SCN)
, NEXT_CHANGE# -- 다음 로그의 MIN(SCN)
, NEXT_TIME
FROM V$ARCHIVED_LOG
THREAD#|NAME |SEQUENCE#|FIRST_CHANGE#|NEXT_CHANGE#|NEXT_TIME |
-------+---------------------------------------+---------+-------------+------------+-------------------+
1|/home/ora19ent/arch/1_94_1115563313.dbf| 94| 3137971| 3139567|2024-02-22 15:56:34|
1|/home/ora19ent/arch/1_95_1115563313.dbf| 95| 3139567| 3139719|2024-02-22 15:56:41|
1|/home/ora19ent/arch/1_96_1115563313.dbf| 96| 3139719| 3152596|2024-02-22 15:59:50|
1|/home/ora19ent/arch/1_97_1115563313.dbf| 97| 3152596| 3182554|2024-08-02 04:00:25|
1|/home/ora19ent/arch/1_98_1115563313.dbf| 98| 3182554| 3200606|2024-08-02 08:20:35|
1|/home/ora19ent/arch/1_99_1115563313.dbf| 99| 3200606| 3213789|2024-08-02 12:51:30|
6 row(s) fetched.nologging 테이블에 일반DML 작업
> INSERT INTO sk.tab1 VALUES(1)
1 row(s) modified.
> COMMIT
0 row(s) modified.
-- 로그 스위치
> alter system switch logfile
0 row(s) modified.
-- 로깅된다면 100번 로그에 들어있을것이다
> SELECT THREAD#, NAME, sequence#
, FIRST_CHANGE# -- 현재 로그의 MIN(SCN)
, NEXT_CHANGE# -- 다음 로그의 MIN(SCN)
, NEXT_TIME
FROM V$ARCHIVED_LOG
THREAD#|NAME |SEQUENCE#|FIRST_CHANGE#|NEXT_CHANGE#|NEXT_TIME |
-------+----------------------------------------+---------+-------------+------------+-------------------+
1|/home/ora19ent/arch/1_94_1115563313.dbf | 94| 3137971| 3139567|2024-02-22 15:56:34|
1|/home/ora19ent/arch/1_95_1115563313.dbf | 95| 3139567| 3139719|2024-02-22 15:56:41|
1|/home/ora19ent/arch/1_96_1115563313.dbf | 96| 3139719| 3152596|2024-02-22 15:59:50|
1|/home/ora19ent/arch/1_97_1115563313.dbf | 97| 3152596| 3182554|2024-08-02 04:00:25|
1|/home/ora19ent/arch/1_98_1115563313.dbf | 98| 3182554| 3200606|2024-08-02 08:20:35|
1|/home/ora19ent/arch/1_99_1115563313.dbf | 99| 3200606| 3213789|2024-08-02 12:51:30|
1|/home/ora19ent/arch/1_100_1115563313.dbf| 100| 3213789| 3213826|2024-08-02 12:52:28|
7 row(s) fetched.
-- 로그마이너로 100번 로그 조회
> select * from v$logmnr_logs
LOG_ID|FILENAME |LOW_TIME |HIGH_TIME |DB_ID |DB_NAME|RESET_SCN|RESET_SCN_TIME |COMPATIBLE|THREAD_ID|THREAD_SQN|LOW_SCN|NEXT_SCN|DICTIONARY_BEGIN|DICTIONARY_END|TYPE |BLOCKSIZE|FILESIZE|INFO|STATUS|CON_ID|
------+----------------------------------------+-------------------+-------------------+---------+-------+---------+-------------------+----------+---------+----------+-------+--------+----------------+--------------+-------+---------+--------+----+------+------+
100|/home/ora19ent/arch/1_100_1115563313.dbf|2024-08-02 12:51:30|2024-08-02 12:52:28|980639087|ENT19 | 1920977|2022-09-16 14:41:53|19.0.0.0.0| 1| 100|3213789| 3213826|NO |NO |ARCHIVE| 512| 12800| | 0| 0|
1 row(s) fetched.
-- 수행한 insert 문 조회됨, DML 작업 로깅됨
> SELECT * FROM V$LOGMNR_CONTENTS WHERE seg_name='TAB1'
SCN |START_SCN|COMMIT_SCN|TIMESTAMP |START_TIMESTAMP|COMMIT_TIMESTAMP|XIDUSN|XIDSLT|XIDSQN|XID |PXIDUSN|PXIDSLT|PXIDSQN|PXID |TX_NAME|OPERATION|OPERATION_CODE|ROLLBACK|SEG_OWNER|SEG_NAME|TABLE_NAME|SEG_TYPE|SEG_TYPE_NAME|TABLE_SPACE|ROW_ID |USERNAME|OS_USERNAME|MACHINE_NAME|AUDIT_SESSIONID|SESSION#|SERIAL#|SESSION_INFO|THREAD#|SEQUENCE#|RBASQN|RBABLK|RBABYTE|UBAFIL|UBABLK |UBAREC|UBASQN|ABS_FILE#|REL_FILE#|DATA_BLK#|DATA_OBJ#|DATA_OBJV#|DATA_OBJD#|SQL_REDO |SQL_UNDO |RS_ID |SSN|CSF|INFO |STATUS|REDO_VALUE|UNDO_VALUE|SAFE_RESUME_SCN|CSCN|OBJECT_ID|EDITION_NAME|CLIENT_ID|SRC_CON_NAME|SRC_CON_ID|SRC_CON_UID|SRC_CON_DBID|SRC_CON_GUID|CON_ID|
-------+---------+----------+-------------------+---------------+----------------+------+------+------+----------------+-------+-------+-------+----------------+-------+---------+--------------+--------+---------+--------+----------+--------+-------------+-----------+------------------+--------+-----------+------------+---------------+--------+-------+------------+-------+---------+------+------+-------+------+--------+------+------+---------+---------+---------+---------+----------+----------+-------------------------------------------+--------------------------------------------------------------------------+------------------------+---+---+------------------------------+------+----------+----------+---------------+----+---------+------------+---------+------------+----------+-----------+------------+------------+------+
3213820| | |2024-08-02 12:52:24| | | 8| 12| 1196|08000C00AC040000| 8| 12| 1196|08000C00AC040000| |INSERT | 1| 0|SK |TAB1 |TAB1 | 2|TABLE |USERS |AAASR7AAHAAAAHDAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 100| 23| 360| 4|16778090| 17| 340| 7| 7| 451| 74875| 0| 74875|insert into "SK"."TAB1"("C1") values ('1');|delete from "SK"."TAB1" where "C1" = '1' and ROWID = 'AAASR7AAHAAAAHDAAA';| 0x000064.00000017.0168 | 0| 0|no supplemental log data found| 3| 42| 43| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
1 row(s) fetched.direct path(nologging 작동) 상황 테스트
-- 로깅모드 확인
> SELECT table_name, logging FROM dba_tables WHERE owner = 'SK'
TABLE_NAME|LOGGING|
----------+-------+
TAB1 |NO |
P_TAB2 | |
2 row(s) fetched.
-- append 및 insert ... select from ... 문으로 로깅안되게 insert
> INSERT /*+ append */ INTO sk.tab1 SELECT 2 FROM dual
1 row(s) modified.
> COMMIT
0 row(s) modified.
-- 테이블 데이터 조회
> SELECT * FROM sk.tab1
C1|
--+
1|
2|
2 row(s) fetched.
-- 로그 스위치
> alter system switch logfile
0 row(s) modified.
-- 조금 전의 작업은 101번에 기록되어있을것
> SELECT THREAD#, NAME, sequence#
, FIRST_CHANGE# -- 현재 로그의 MIN(SCN)
, NEXT_CHANGE# -- 다음 로그의 MIN(SCN)
, NEXT_TIME
FROM V$ARCHIVED_LOG
THREAD#|NAME |SEQUENCE#|FIRST_CHANGE#|NEXT_CHANGE#|NEXT_TIME |
-------+----------------------------------------+---------+-------------+------------+-------------------+
1|/home/ora19ent/arch/1_94_1115563313.dbf | 94| 3137971| 3139567|2024-02-22 15:56:34|
1|/home/ora19ent/arch/1_95_1115563313.dbf | 95| 3139567| 3139719|2024-02-22 15:56:41|
1|/home/ora19ent/arch/1_96_1115563313.dbf | 96| 3139719| 3152596|2024-02-22 15:59:50|
1|/home/ora19ent/arch/1_97_1115563313.dbf | 97| 3152596| 3182554|2024-08-02 04:00:25|
1|/home/ora19ent/arch/1_98_1115563313.dbf | 98| 3182554| 3200606|2024-08-02 08:20:35|
1|/home/ora19ent/arch/1_99_1115563313.dbf | 99| 3200606| 3213789|2024-08-02 12:51:30|
1|/home/ora19ent/arch/1_100_1115563313.dbf| 100| 3213789| 3213826|2024-08-02 12:52:28|
1|/home/ora19ent/arch/1_101_1115563313.dbf| 101| 3213826| 3213990|2024-08-02 12:57:46|
8 row(s) fetched.
-- 로그마이너 101번 로그 확인
> select * from v$logmnr_logs
LOG_ID|FILENAME |LOW_TIME |HIGH_TIME |DB_ID |DB_NAME|RESET_SCN|RESET_SCN_TIME |COMPATIBLE|THREAD_ID|THREAD_SQN|LOW_SCN|NEXT_SCN|DICTIONARY_BEGIN|DICTIONARY_END|TYPE |BLOCKSIZE|FILESIZE|INFO|STATUS|CON_ID|
------+----------------------------------------+-------------------+-------------------+---------+-------+---------+-------------------+----------+---------+----------+-------+--------+----------------+--------------+-------+---------+--------+----+------+------+
101|/home/ora19ent/arch/1_101_1115563313.dbf|2024-08-02 12:52:28|2024-08-02 12:57:46|980639087|ENT19 | 1920977|2022-09-16 14:41:53|19.0.0.0.0| 1| 101|3213826| 3213990|NO |NO |ARCHIVE| 512| 35840| | 0| 0|
1 row(s) fetched.
-- 이력없음, 로깅안됨
> SELECT * FROM V$LOGMNR_CONTENTS WHERE seg_name='TAB1'
SCN|START_SCN|COMMIT_SCN|TIMESTAMP|START_TIMESTAMP|COMMIT_TIMESTAMP|XIDUSN|XIDSLT|XIDSQN|XID|PXIDUSN|PXIDSLT|PXIDSQN|PXID|TX_NAME|OPERATION|OPERATION_CODE|ROLLBACK|SEG_OWNER|SEG_NAME|TABLE_NAME|SEG_TYPE|SEG_TYPE_NAME|TABLE_SPACE|ROW_ID|USERNAME|OS_USERNAME|MACHINE_NAME|AUDIT_SESSIONID|SESSION#|SERIAL#|SESSION_INFO|THREAD#|SEQUENCE#|RBASQN|RBABLK|RBABYTE|UBAFIL|UBABLK|UBAREC|UBASQN|ABS_FILE#|REL_FILE#|DATA_BLK#|DATA_OBJ#|DATA_OBJV#|DATA_OBJD#|SQL_REDO|SQL_UNDO|RS_ID|SSN|CSF|INFO|STATUS|REDO_VALUE|UNDO_VALUE|SAFE_RESUME_SCN|CSCN|OBJECT_ID|EDITION_NAME|CLIENT_ID|SRC_CON_NAME|SRC_CON_ID|SRC_CON_UID|SRC_CON_DBID|SRC_CON_GUID|CON_ID|
---+---------+----------+---------+---------------+----------------+------+------+------+---+-------+-------+-------+----+-------+---------+--------------+--------+---------+--------+----------+--------+-------------+-----------+------+--------+-----------+------------+---------------+--------+-------+------------+-------+---------+------+------+-------+------+------+------+------+---------+---------+---------+---------+----------+----------+--------+--------+-----+---+---+----+------+----------+----------+---------------+----+---------+------------+---------+------------+----------+-----------+------------+------------+------+
0 row(s) fetched.
-- 조건없이 전체 조회, 해당 작업 내역 없음
> SELECT * FROM V$LOGMNR_CONTENTS
SCN |START_SCN|COMMIT_SCN|TIMESTAMP |START_TIMESTAMP |COMMIT_TIMESTAMP |XIDUSN|XIDSLT|XIDSQN|XID |PXIDUSN|PXIDSLT|PXIDSQN|PXID |TX_NAME|OPERATION |OPERATION_CODE|ROLLBACK|SEG_OWNER|SEG_NAME |TABLE_NAME |SEG_TYPE|SEG_TYPE_NAME|TABLE_SPACE|ROW_ID |USERNAME|OS_USERNAME|MACHINE_NAME|AUDIT_SESSIONID|SESSION#|SERIAL#|SESSION_INFO|THREAD#|SEQUENCE#|RBASQN|RBABLK|RBABYTE|UBAFIL|UBABLK |UBAREC|UBASQN|ABS_FILE#|REL_FILE#|DATA_BLK#|DATA_OBJ#|DATA_OBJV#|DATA_OBJD#|SQL_REDO |SQL_UNDO |RS_ID |SSN|CSF|INFO |STATUS|REDO_VALUE|UNDO_VALUE|SAFE_RESUME_SCN|CSCN |OBJECT_ID|EDITION_NAME|CLIENT_ID|SRC_CON_NAME|SRC_CON_ID|SRC_CON_UID|SRC_CON_DBID|SRC_CON_GUID|CON_ID|
-------+---------+----------+-------------------+-------------------+-------------------+------+------+------+----------------+-------+-------+-------+----------------+-------+-----------+--------------+--------+---------+---------------------------------------------------------------------+---------------------------+--------+-------------+-----------+------------------+--------+-----------+------------+---------------+--------+-------+------------+-------+---------+------+------+-------+------+--------+------+------+---------+---------+---------+---------+----------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+---+---+-------------------------------+------+----------+----------+---------------+-------+---------+------------+---------+------------+----------+-----------+------------+------------+------+
3213826| | |2024-08-02 12:52:28| | | 5| 2| 1296|0500020010050000| 5| 2| 1296|0500020010050000| |START | 6| 0| | | | 0| | |AAASLEAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 2| 16| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000002.0010 | 0| 0| | 0| 130| 131| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213826| | |2024-08-02 12:52:28| | | 5| 2| 1296|0500020010050000| 5| 2| 1296|0500020010050000| |INSERT | 1| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ+AAO|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 2| 16| 4|16778963| 10| 351| 3| 3| 70718| 74436| 0| 74436|insert into "AUDSYS"."AUD$UNIFIED"("INST_ID","AUDIT_TYPE","SESSIONID","PROXY_SESSIONID","OS_USER","HOST_NAME","TERMINAL","INSTANCE_ID","DBID","AUTHENTICATION_TYPE","USERID","PROXY_USERID","EXTERNAL_USERID","GLOBAL_USERID","CLIENT_PROGRAM_NAME","DBLINK_INF|delete from "AUDSYS"."AUD$UNIFIED" where "INST_ID" IS NULL and "AUDIT_TYPE" = '4' and "SESSIONID" = '3290332875' and "PROXY_SESSIONID" = '0' and "OS_USER" = 'CJ' and "HOST_NAME" = 'DESKTOP-QE9FGB2' and "TERMINAL" = 'unknown' and "INSTANCE_ID" = '1' and "D| 0x000065.00000002.0010 | 14| 0|no supplemental log data found | 3| 132| 133| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213826| | |2024-08-02 12:52:28| | | 5| 2| 1296|0500020010050000| 5| 2| 1296|0500020010050000| |UPDATE | 3| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ+AAO|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 3| 472| 4|16778963| 10| 351| 4| 3| 70718| 74436| 0| 74436|update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = 'alter system switch logfile ' where "SQL_TEXT" = EMPTY_CLOB() and ROWID = 'AAASLEAADAAARQ+AAO'; |update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = EMPTY_CLOB() where "SQL_TEXT" = 'alter system switch logfile ' and ROWID = 'AAASLEAADAAARQ+AAO'; | 0x000065.00000003.01d8 | 0| 0|no supplemental log data found | 2| 134| 135| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213827| 3213826| 3213827|2024-08-02 12:52:28|2024-08-02 12:52:28|2024-08-02 12:52:28| 5| 2| 1296|0500020010050000| 5| 2| 1296|0500020010050000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 4| 360| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000004.0168 | 0| 0| | 0| 136| 137| 3213827|3213827| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213839| | |2024-08-02 12:53:00| | | 3| 18| 1295|030012000F050000| 3| 18| 1295|030012000F050000| |START | 6| 0| | | | 0| | |AAASLEAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 5| 232| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000005.00e8 | 0| 0| | 0| 138| 139| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213839| | |2024-08-02 12:53:00| | | 3| 18| 1295|030012000F050000| 3| 18| 1295|030012000F050000| |INSERT | 1| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ+AAP|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 5| 232| 4|16779222| 15| 573| 3| 3| 70718| 74436| 0| 74436|insert into "AUDSYS"."AUD$UNIFIED"("INST_ID","AUDIT_TYPE","SESSIONID","PROXY_SESSIONID","OS_USER","HOST_NAME","TERMINAL","INSTANCE_ID","DBID","AUTHENTICATION_TYPE","USERID","PROXY_USERID","EXTERNAL_USERID","GLOBAL_USERID","CLIENT_PROGRAM_NAME","DBLINK_INF|delete from "AUDSYS"."AUD$UNIFIED" where "INST_ID" IS NULL and "AUDIT_TYPE" = '4' and "SESSIONID" = '2539885574' and "PROXY_SESSIONID" = '0' and "OS_USER" = 'CJ' and "HOST_NAME" = 'DESKTOP-QE9FGB2' and "TERMINAL" = 'unknown' and "INSTANCE_ID" = '1' and "D| 0x000065.00000005.00e8 | 15| 0|no supplemental log data found | 3| 140| 141| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213839| | |2024-08-02 12:53:00| | | 3| 18| 1295|030012000F050000| 3| 18| 1295|030012000F050000| |UPDATE | 3| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ+AAP|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 7| 88| 4|16779222| 15| 573| 4| 3| 70718| 74436| 0| 74436|update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME=>''/home/ora19ent/arch/1_100_1115563313.dbf'', OPTIONS=>DBMS_LOGMNR.NEW) ;¶END; ' where "SQL_TEXT" = EMPTY_CLOB() and ROWID = 'AAASLEAADAAARQ+AAP'; |update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = EMPTY_CLOB() where "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME=>''/home/ora19ent/arch/1_100_1115563313.dbf'', OPTIONS=>DBMS_LOGMNR.NEW) ;¶END; ' and ROWID = 'AAASLEAADAAARQ+AAP'; | 0x000065.00000007.0058 | 0| 0|no supplemental log data found | 2| 142| 143| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213840| 3213839| 3213840|2024-08-02 12:53:00|2024-08-02 12:53:00|2024-08-02 12:53:00| 3| 18| 1295|030012000F050000| 3| 18| 1295|030012000F050000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 8| 264| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000008.0108 | 0| 0| | 0| 144| 145| 3213840|3213840| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213853| | |2024-08-02 12:53:28| | | 2| 3| 1332|0200030034050000| 2| 3| 1332|0200030034050000| |START | 6| 0| | | | 0| | |AAAALSAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 10| 16| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000000a.0010 | 0| 0| | 0| 146| 147| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213853| | |2024-08-02 12:53:28| | | 2| 3| 1332|0200030034050000| 2| 3| 1332|0200030034050000| |INSERT | 1| 0|SYS |EXP_HEAD$ |EXP_HEAD$ | 2|TABLE |SYSAUX |AAAALSAADAAAAVsAAV|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 10| 16| 4|16777800| 36| 397| 3| 3| 1388| 722| 0| 722|insert into "SYS"."EXP_HEAD$"("EXP_ID","OBJN","SUB_ID","FIXED_COST","TEXT","COL_LIST","FLAGS","CTIME") values ('9115520146931569219','1427','0','.0000000268215720022949','"LOGMNR_UID" ','1 ','8',TO_DATE('24/08/02', 'RR/MM/DD')); |delete from "SYS"."EXP_HEAD$" where "EXP_ID" = '9115520146931569219' and "OBJN" = '1427' and "SUB_ID" = '0' and "FIXED_COST" = '.0000000268215720022949' and "TEXT" = '"LOGMNR_UID" ' and "COL_LIST" = '1 ' and "FLAGS" = '8' and "CTIME" = TO_DATE('24/08/02',| 0x000065.0000000a.0010 | 21| 0|no supplemental log data found | 3| 148| 149| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213854| 3213853| 3213854|2024-08-02 12:53:28|2024-08-02 12:53:28|2024-08-02 12:53:28| 2| 3| 1332|0200030034050000| 2| 3| 1332|0200030034050000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 11| 420| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.0000000b.01a4 | 0| 0| | 0| 150| 151| 3213854|3213854| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213855| | |2024-08-02 12:53:28| | | 8| 21| 1194|08001500AA040000| 8| 21| 1194|08001500AA040000| |START | 6| 0| | | | 0| | |AAAALSAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 12| 28| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000000c.001c | 0| 0| | 0| 152| 153| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213855| | |2024-08-02 12:53:28| | | 8| 21| 1194|08001500AA040000| 8| 21| 1194|08001500AA040000| |INSERT | 1| 0|SYS |EXP_HEAD$ |EXP_HEAD$ | 2|TABLE |SYSAUX |AAAALSAADAAAAVsAAW|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 12| 28| 4|16778090| 18| 340| 3| 3| 1388| 722| 0| 722|insert into "SYS"."EXP_HEAD$"("EXP_ID","OBJN","SUB_ID","FIXED_COST","TEXT","COL_LIST","FLAGS","CTIME") values ('8257699414779645755','1427','0','.0000000268215720022949','"LOGMNR_DID" ','2 ','8',TO_DATE('24/08/02', 'RR/MM/DD')); |delete from "SYS"."EXP_HEAD$" where "EXP_ID" = '8257699414779645755' and "OBJN" = '1427' and "SUB_ID" = '0' and "FIXED_COST" = '.0000000268215720022949' and "TEXT" = '"LOGMNR_DID" ' and "COL_LIST" = '2 ' and "FLAGS" = '8' and "CTIME" = TO_DATE('24/08/02',| 0x000065.0000000c.001c | 22| 0|no supplemental log data found | 3| 154| 155| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213856| 3213855| 3213856|2024-08-02 12:53:28|2024-08-02 12:53:28|2024-08-02 12:53:28| 8| 21| 1194|08001500AA040000| 8| 21| 1194|08001500AA040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 13| 336| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.0000000d.0150 | 0| 0| | 0| 156| 157| 3213856|3213856| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213857| | |2024-08-02 12:53:28| | | 10| 11| 1153|0A000B0081040000| 10| 11| 1153|0A000B0081040000| |START | 6| 0| | | | 0| | |AAAALSAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 13| 440| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000000d.01b8 | 0| 0| | 0| 158| 159| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213857| | |2024-08-02 12:53:28| | | 10| 11| 1153|0A000B0081040000| 10| 11| 1153|0A000B0081040000| |INSERT | 1| 0|SYS |EXP_HEAD$ |EXP_HEAD$ | 2|TABLE |SYSAUX |AAAALSAADAAAAVsAAX|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 13| 440| 4|16957760| 19| 541| 3| 3| 1388| 722| 0| 722|insert into "SYS"."EXP_HEAD$"("EXP_ID","OBJN","SUB_ID","FIXED_COST","TEXT","COL_LIST","FLAGS","CTIME") values ('3756838915459512084','1425','0','.0000000268215720022949','"SESSION#" ','1 ','8',TO_DATE('24/08/02', 'RR/MM/DD')); |delete from "SYS"."EXP_HEAD$" where "EXP_ID" = '3756838915459512084' and "OBJN" = '1425' and "SUB_ID" = '0' and "FIXED_COST" = '.0000000268215720022949' and "TEXT" = '"SESSION#" ' and "COL_LIST" = '1 ' and "FLAGS" = '8' and "CTIME" = TO_DATE('24/08/02', '| 0x000065.0000000d.01b8 | 23| 0|no supplemental log data found | 3| 160| 161| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213858| 3213857| 3213858|2024-08-02 12:53:28|2024-08-02 12:53:28|2024-08-02 12:53:28| 10| 11| 1153|0A000B0081040000| 10| 11| 1153|0A000B0081040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 15| 300| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.0000000f.012c | 0| 0| | 0| 162| 163| 3213858|3213858| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213859| | |2024-08-02 12:53:28| | | 6| 13| 1271|06000D00F7040000| 6| 13| 1271|06000D00F7040000| |START | 6| 0| | | | 0| | |AAAALSAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 15| 388| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000000f.0184 | 0| 0| | 0| 164| 165| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213859| | |2024-08-02 12:53:28| | | 6| 13| 1271|06000D00F7040000| 6| 13| 1271|06000D00F7040000| |INSERT | 1| 0|SYS |EXP_HEAD$ |EXP_HEAD$ | 2|TABLE |SYSAUX |AAAALSAADAAAAVsAAY|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 15| 388| 4|16778793| 9| 293| 3| 3| 1388| 722| 0| 722|insert into "SYS"."EXP_HEAD$"("EXP_ID","OBJN","SUB_ID","FIXED_COST","TEXT","COL_LIST","FLAGS","CTIME") values ('7526245721054545028','1425','0','.0000000268215720022949','"LOGMNR_DID" ','2 ','8',TO_DATE('24/08/02', 'RR/MM/DD')); |delete from "SYS"."EXP_HEAD$" where "EXP_ID" = '7526245721054545028' and "OBJN" = '1425' and "SUB_ID" = '0' and "FIXED_COST" = '.0000000268215720022949' and "TEXT" = '"LOGMNR_DID" ' and "COL_LIST" = '2 ' and "FLAGS" = '8' and "CTIME" = TO_DATE('24/08/02',| 0x000065.0000000f.0184 | 24| 0|no supplemental log data found | 3| 166| 167| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213860| 3213859| 3213860|2024-08-02 12:53:28|2024-08-02 12:53:28|2024-08-02 12:53:28| 6| 13| 1271|06000D00F7040000| 6| 13| 1271|06000D00F7040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 17| 196| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000011.00c4 | 0| 0| | 0| 168| 169| 3213860|3213860| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213862| | |2024-08-02 12:53:28| | | 5| 26| 1295|05001A000F050000| 5| 26| 1295|05001A000F050000| |START | 6| 0| | | | 0| | |AAASLEAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 18| 156| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000012.009c | 0| 0| | 0| 170| 171| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213862| | |2024-08-02 12:53:28| | | 5| 26| 1295|05001A000F050000| 5| 26| 1295|05001A000F050000| |INSERT | 1| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ/AAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 18| 156| 4|16778963| 12| 351| 3| 3| 70719| 74436| 0| 74436|insert into "AUDSYS"."AUD$UNIFIED"("INST_ID","AUDIT_TYPE","SESSIONID","PROXY_SESSIONID","OS_USER","HOST_NAME","TERMINAL","INSTANCE_ID","DBID","AUTHENTICATION_TYPE","USERID","PROXY_USERID","EXTERNAL_USERID","GLOBAL_USERID","CLIENT_PROGRAM_NAME","DBLINK_INF|delete from "AUDSYS"."AUD$UNIFIED" where "INST_ID" IS NULL and "AUDIT_TYPE" = '4' and "SESSIONID" = '2539885574' and "PROXY_SESSIONID" = '0' and "OS_USER" = 'CJ' and "HOST_NAME" = 'DESKTOP-QE9FGB2' and "TERMINAL" = 'unknown' and "INSTANCE_ID" = '1' and "D| 0x000065.00000012.009c | 0| 0|no supplemental log data found | 3| 172| 173| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213862| | |2024-08-02 12:53:28| | | 5| 26| 1295|05001A000F050000| 5| 26| 1295|05001A000F050000| |UPDATE | 3| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ/AAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 19| 484| 4|16778963| 12| 351| 4| 3| 70719| 74436| 0| 74436|update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.START_LOGMNR(OPTIONS=>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG+DBMS_LOGMNR.SKIP_CORRUPTION) ;¶END; ' where "SQL_TEXT" = EMPTY_CLOB() and ROWID = 'AAASLEAADAAARQ/AAA'; |update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = EMPTY_CLOB() where "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.START_LOGMNR(OPTIONS=>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG+DBMS_LOGMNR.SKIP_CORRUPTION) ;¶END; ' and ROWID = 'AAASLEAADAAARQ/AAA'; | 0x000065.00000013.01e4 | 0| 0|no supplemental log data found | 2| 174| 175| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213863| 3213862| 3213863|2024-08-02 12:53:28|2024-08-02 12:53:28|2024-08-02 12:53:28| 5| 26| 1295|05001A000F050000| 5| 26| 1295|05001A000F050000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 21| 48| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000015.0030 | 0| 0| | 0| 176| 177| 3213863|3213863| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213914| | |2024-08-02 12:55:40| | | 7| 6| 1130|070006006A040000| 7| 6| 1130|070006006A040000| |START | 6| 0| | | | 0| | |AAASLEAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 30| 16| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000001e.0010 | 0| 0| | 0| 178| 179| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213914| | |2024-08-02 12:55:40| | | 7| 6| 1130|070006006A040000| 7| 6| 1130|070006006A040000| |INSERT | 1| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ/AAB|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 30| 16| 4|17256564| 9| 240| 3| 3| 70719| 74436| 0| 74436|insert into "AUDSYS"."AUD$UNIFIED"("INST_ID","AUDIT_TYPE","SESSIONID","PROXY_SESSIONID","OS_USER","HOST_NAME","TERMINAL","INSTANCE_ID","DBID","AUTHENTICATION_TYPE","USERID","PROXY_USERID","EXTERNAL_USERID","GLOBAL_USERID","CLIENT_PROGRAM_NAME","DBLINK_INF|delete from "AUDSYS"."AUD$UNIFIED" where "INST_ID" IS NULL and "AUDIT_TYPE" = '4' and "SESSIONID" = '3290332875' and "PROXY_SESSIONID" = '0' and "OS_USER" = 'CJ' and "HOST_NAME" = 'DESKTOP-QE9FGB2' and "TERMINAL" = 'unknown' and "INSTANCE_ID" = '1' and "D| 0x000065.0000001e.0010 | 1| 0|no supplemental log data found | 3| 180| 181| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213914| | |2024-08-02 12:55:40| | | 7| 6| 1130|070006006A040000| 7| 6| 1130|070006006A040000| |UPDATE | 3| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ/AAB|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 31| 392| 4|17256564| 9| 240| 4| 3| 70719| 74436| 0| 74436|update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME=>''/home/ora19ent/arch/1_100_1115563313.dbf'', OPTIONS=>DBMS_LOGMNR.NEW) ;¶END; ' where "SQL_TEXT" = EMPTY_CLOB() and ROWID = 'AAASLEAADAAARQ/AAB'; |update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = EMPTY_CLOB() where "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME=>''/home/ora19ent/arch/1_100_1115563313.dbf'', OPTIONS=>DBMS_LOGMNR.NEW) ;¶END; ' and ROWID = 'AAASLEAADAAARQ/AAB'; | 0x000065.0000001f.0188 | 0| 0|no supplemental log data found | 2| 182| 183| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213915| 3213914| 3213915|2024-08-02 12:55:40|2024-08-02 12:55:40|2024-08-02 12:55:40| 7| 6| 1130|070006006A040000| 7| 6| 1130|070006006A040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 32| 468| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000020.01d4 | 0| 0| | 0| 184| 185| 3213915|3213915| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213918| | |2024-08-02 12:55:47| | | 2| 8| 1322|020008002A050000| 2| 8| 1322|020008002A050000| |START | 6| 0| | | | 0| | |AAASLEAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 36| 96| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000024.0060 | 0| 0| | 0| 186| 187| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213918| | |2024-08-02 12:55:47| | | 2| 8| 1322|020008002A050000| 2| 8| 1322|020008002A050000| |INSERT | 1| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ/AAC|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 36| 96| 4|16777800| 38| 397| 3| 3| 70719| 74436| 0| 74436|insert into "AUDSYS"."AUD$UNIFIED"("INST_ID","AUDIT_TYPE","SESSIONID","PROXY_SESSIONID","OS_USER","HOST_NAME","TERMINAL","INSTANCE_ID","DBID","AUTHENTICATION_TYPE","USERID","PROXY_USERID","EXTERNAL_USERID","GLOBAL_USERID","CLIENT_PROGRAM_NAME","DBLINK_INF|delete from "AUDSYS"."AUD$UNIFIED" where "INST_ID" IS NULL and "AUDIT_TYPE" = '4' and "SESSIONID" = '3290332875' and "PROXY_SESSIONID" = '0' and "OS_USER" = 'CJ' and "HOST_NAME" = 'DESKTOP-QE9FGB2' and "TERMINAL" = 'unknown' and "INSTANCE_ID" = '1' and "D| 0x000065.00000024.0060 | 2| 0|no supplemental log data found | 3| 188| 189| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213918| | |2024-08-02 12:55:47| | | 2| 8| 1322|020008002A050000| 2| 8| 1322|020008002A050000| |UPDATE | 3| 0|AUDSYS |AUD$UNIFIED,SYS_P501 |AUD$UNIFIED | 19|TABPART |SYSAUX |AAASLEAADAAARQ/AAC|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 38| 16| 4|16777800| 38| 397| 4| 3| 70719| 74436| 0| 74436|update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.START_LOGMNR(OPTIONS=>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG+DBMS_LOGMNR.SKIP_CORRUPTION) ;¶END; ' where "SQL_TEXT" = EMPTY_CLOB() and ROWID = 'AAASLEAADAAARQ/AAC'; |update "AUDSYS"."AUD$UNIFIED" set "SQL_TEXT" = EMPTY_CLOB() where "SQL_TEXT" = 'BEGIN¶DBMS_LOGMNR.START_LOGMNR(OPTIONS=>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG+DBMS_LOGMNR.SKIP_CORRUPTION) ;¶END; ' and ROWID = 'AAASLEAADAAARQ/AAC'; | 0x000065.00000026.0010 | 0| 0|no supplemental log data found | 2| 190| 191| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213919| 3213918| 3213919|2024-08-02 12:55:47|2024-08-02 12:55:47|2024-08-02 12:55:47| 2| 8| 1322|020008002A050000| 2| 8| 1322|020008002A050000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 39| 76| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000027.004c | 0| 0| | 0| 192| 193| 3213919|3213919| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213931| | |2024-08-02 12:56:06| | | 1| 13| 1144|01000D0078040000| 1| 13| 1144|01000D0078040000| |START | 6| 0| | | | 0| | |AAAC1dAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 41| 16| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000029.0010 | 0| 0| | 0| 194| 195| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213931| | |2024-08-02 12:56:06| | | 1| 13| 1144|01000D0078040000| 1| 13| 1144|01000D0078040000| |UPDATE | 3| 0|SYS |WRM$_WR_CONTROL |WRM$_WR_CONTROL | 2|TABLE |SYSAUX |AAAC1dAADAAAC2GAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 41| 16| 4| 0| 0| 0| 4| 3| 11654| 11613| 0| 11613|update "SYS"."WRM$_WR_CONTROL" set "STATUS_FLAG" = '3', "MRCT_SNAP_STEP_TM" = '1722570965', "MRCT_SNAP_STEP_ID" = '5' where "STATUS_FLAG" = '2' and "MRCT_SNAP_STEP_TM" = '1722570606' and "MRCT_SNAP_STEP_ID" = '4' and ROWID = 'AAAC1dAADAAAC2GAAA'; |update "SYS"."WRM$_WR_CONTROL" set "STATUS_FLAG" = '2', "MRCT_SNAP_STEP_TM" = '1722570606', "MRCT_SNAP_STEP_ID" = '4' where "STATUS_FLAG" = '3' and "MRCT_SNAP_STEP_TM" = '1722570965' and "MRCT_SNAP_STEP_ID" = '5' and ROWID = 'AAAC1dAADAAAC2GAAA'; | 0x000065.00000029.0010 | 0| 0|no supplemental log data found | 3| 196| 197| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213932| 3213931| 3213932|2024-08-02 12:56:06|2024-08-02 12:56:06|2024-08-02 12:56:06| 1| 13| 1144|01000D0078040000| 1| 13| 1144|01000D0078040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 42| 68| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.0000002a.0044 | 0| 0| | 0| 198| 199| 3213932|3213932| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213934| | |2024-08-02 12:56:06| | | 4| 17| 1156|0400110084040000| 4| 17| 1156|0400110084040000| |START | 6| 0| | | | 0| | |AAAC05AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 43| 16| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000002b.0010 | 0| 0| | 0| 200| 201| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213934| | |2024-08-02 12:56:06| | | 4| 17| 1156|0400110084040000| 4| 17| 1156|0400110084040000| |UNSUPPORTED| 255| 0|SYS |WRM$_DATABASE_INSTANCE |WRM$_DATABASE_INSTANCE | 2|TABLE |SYSAUX |AAAC05AADAAACyVAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 43| 16| 4| 0| 0| 0| 4| 3| 11413| 11577| 0| 11577|Unsupported |Unsupported | 0x000065.0000002b.0010 | 0| 0|Object or Data type Unsupported| 2| 202| 203| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213934| | |2024-08-02 12:56:06| | | 4| 17| 1156|0400110084040000| 4| 17| 1156|0400110084040000| |INSERT | 1| 0|SYS |WRH$_ACTIVE_SESSION_HISTORY,WRH$_ACTIVE_SESSION_HISTORY_980639087_116|WRH$_ACTIVE_SESSION_HISTORY| 19|TABPART |SYSAUX |AAASMCAADAAAT/cAAP|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 44| 28| 4|16780650| 4| 284| 3| 3| 81884| 74311| 0| 74498|insert into "SYS"."WRH$_ACTIVE_SESSION_HISTORY"("SNAP_ID","DBID","INSTANCE_NUMBER","SAMPLE_ID","SAMPLE_TIME","SESSION_ID","SESSION_SERIAL#","USER_ID","SQL_ID","SQL_CHILD_NUMBER","SQL_PLAN_HASH_VALUE","SERVICE_HASH","SESSION_TYPE","SQL_OPCODE","QC_SESSION_|delete from "SYS"."WRH$_ACTIVE_SESSION_HISTORY" where "SNAP_ID" = '162' and "DBID" = '980639087' and "INSTANCE_NUMBER" = '1' and "SAMPLE_ID" = '307308' and "SAMPLE_TIME" = TO_TIMESTAMP('24/08/02 12:52:56.038') and "SESSION_ID" = '7' and "SESSION_SERIAL#" | 0x000065.0000002c.001c | 15| 0|no supplemental log data found | 3| 204| 205| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213934| | |2024-08-02 12:56:06| | | 4| 17| 1156|0400110084040000| 4| 17| 1156|0400110084040000| |INSERT | 1| 0|SYS |WRH$_ACTIVE_SESSION_HISTORY,WRH$_ACTIVE_SESSION_HISTORY_980639087_116|WRH$_ACTIVE_SESSION_HISTORY| 19|TABPART |SYSAUX |AAASMCAADAAAT/cAAQ|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 44| 28| 4|16780650| 4| 284| 3| 3| 81884| 74311| 0| 74498|insert into "SYS"."WRH$_ACTIVE_SESSION_HISTORY"("SNAP_ID","DBID","INSTANCE_NUMBER","SAMPLE_ID","SAMPLE_TIME","SESSION_ID","SESSION_SERIAL#","USER_ID","SQL_ID","SQL_CHILD_NUMBER","SQL_PLAN_HASH_VALUE","SERVICE_HASH","SESSION_TYPE","SQL_OPCODE","QC_SESSION_|delete from "SYS"."WRH$_ACTIVE_SESSION_HISTORY" where "SNAP_ID" = '162' and "DBID" = '980639087' and "INSTANCE_NUMBER" = '1' and "SAMPLE_ID" = '307298' and "SAMPLE_TIME" = TO_TIMESTAMP('24/08/02 12:52:46.037') and "SESSION_ID" = '247' and "SESSION_SERIAL#| 0x000065.0000002c.001c | 16| 0|no supplemental log data found | 3| 206| 207| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213934| | |2024-08-02 12:56:06| | | 4| 17| 1156|0400110084040000| 4| 17| 1156|0400110084040000| |INSERT | 1| 0|SYS |WRH$_ACTIVE_SESSION_HISTORY,WRH$_ACTIVE_SESSION_HISTORY_980639087_116|WRH$_ACTIVE_SESSION_HISTORY| 19|TABPART |SYSAUX |AAASMCAADAAAT/cAAR|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 44| 28| 4|16780650| 4| 284| 3| 3| 81884| 74311| 0| 74498|insert into "SYS"."WRH$_ACTIVE_SESSION_HISTORY"("SNAP_ID","DBID","INSTANCE_NUMBER","SAMPLE_ID","SAMPLE_TIME","SESSION_ID","SESSION_SERIAL#","USER_ID","SQL_ID","SQL_CHILD_NUMBER","SQL_PLAN_HASH_VALUE","SERVICE_HASH","SESSION_TYPE","SQL_OPCODE","QC_SESSION_|delete from "SYS"."WRH$_ACTIVE_SESSION_HISTORY" where "SNAP_ID" = '162' and "DBID" = '980639087' and "INSTANCE_NUMBER" = '1' and "SAMPLE_ID" = '307108' and "SAMPLE_TIME" = TO_TIMESTAMP('24/08/02 12:49:36.022') and "SESSION_ID" = '247' and "SESSION_SERIAL#| 0x000065.0000002c.001c | 17| 0|no supplemental log data found | 3| 208| 209| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213934| | |2024-08-02 12:56:06| | | 4| 17| 1156|0400110084040000| 4| 17| 1156|0400110084040000| |INSERT | 1| 0|SYS |WRM$_SNAPSHOT_DETAILS |WRM$_SNAPSHOT_DETAILS | 2|TABLE |SYSAUX |AAAC09AADAAAQL4ABp|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 47| 136| 4|16780650| 6| 284| 3| 3| 66296| 11581| 0| 11581|insert into "SYS"."WRM$_SNAPSHOT_DETAILS"("SNAP_ID","DBID","INSTANCE_NUMBER","TABLE_ID","BEGIN_TIME","END_TIME","STEP_ID") values ('162','980639087','1','45',TO_TIMESTAMP('24/08/02 12:56:06.951'),TO_TIMESTAMP('24/08/02 12:56:06.952'),'5'); |delete from "SYS"."WRM$_SNAPSHOT_DETAILS" where "SNAP_ID" = '162' and "DBID" = '980639087' and "INSTANCE_NUMBER" = '1' and "TABLE_ID" = '45' and "BEGIN_TIME" = TO_TIMESTAMP('24/08/02 12:56:06.951') and "END_TIME" = TO_TIMESTAMP('24/08/02 12:56:06.952') an| 0x000065.0000002f.0088 |105| 0|no supplemental log data found | 3| 210| 211| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213935| 3213934| 3213935|2024-08-02 12:56:06|2024-08-02 12:56:06|2024-08-02 12:56:06| 4| 17| 1156|0400110084040000| 4| 17| 1156|0400110084040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 48| 320| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000030.0140 | 0| 0| | 0| 212| 213| 3213935|3213935| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213937| | |2024-08-02 12:56:06| | | 10| 2| 1128|0A00020068040000| 10| 2| 1128|0A00020068040000| |START | 6| 0| | | | 0| | |AAAC09AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 49| 16| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000031.0010 | 0| 0| | 0| 214| 215| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213937| | |2024-08-02 12:56:06| | | 10| 2| 1128|0A00020068040000| 10| 2| 1128|0A00020068040000| |INSERT | 1| 0|SYS |WRM$_SNAPSHOT_DETAILS |WRM$_SNAPSHOT_DETAILS | 2|TABLE |SYSAUX |AAAC09AADAAAQL4ABq|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 49| 16| 4|16957765| 1| 541| 3| 3| 66296| 11581| 0| 11581|insert into "SYS"."WRM$_SNAPSHOT_DETAILS"("SNAP_ID","DBID","INSTANCE_NUMBER","TABLE_ID","BEGIN_TIME","END_TIME","STEP_ID") values ('162','980639087','1','165',TO_TIMESTAMP('24/08/02 12:56:06.953'),TO_TIMESTAMP('24/08/02 12:56:06.953'),'5'); |delete from "SYS"."WRM$_SNAPSHOT_DETAILS" where "SNAP_ID" = '162' and "DBID" = '980639087' and "INSTANCE_NUMBER" = '1' and "TABLE_ID" = '165' and "BEGIN_TIME" = TO_TIMESTAMP('24/08/02 12:56:06.953') and "END_TIME" = TO_TIMESTAMP('24/08/02 12:56:06.953') a| 0x000065.00000031.0010 |106| 0|no supplemental log data found | 3| 216| 217| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213938| 3213937| 3213938|2024-08-02 12:56:06|2024-08-02 12:56:06|2024-08-02 12:56:06| 10| 2| 1128|0A00020068040000| 10| 2| 1128|0A00020068040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 50| 420| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000032.01a4 | 0| 0| | 0| 218| 219| 3213938|3213938| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213940| | |2024-08-02 12:56:06| | | 8| 27| 1188|08001B00A4040000| 8| 27| 1188|08001B00A4040000| |START | 6| 0| | | | 0| | |AAAC1dAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 52| 16| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000034.0010 | 0| 0| | 0| 220| 221| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213940| | |2024-08-02 12:56:06| | | 8| 27| 1188|08001B00A4040000| 8| 27| 1188|08001B00A4040000| |UPDATE | 3| 0|SYS |WRM$_WR_CONTROL |WRM$_WR_CONTROL | 2|TABLE |SYSAUX |AAAC1dAADAAAC2GAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 52| 16| 4| 0| 0| 0| 4| 3| 11654| 11613| 0| 11613|update "SYS"."WRM$_WR_CONTROL" set "STATUS_FLAG" = '2' where "STATUS_FLAG" = '3' and ROWID = 'AAAC1dAADAAAC2GAAA'; |update "SYS"."WRM$_WR_CONTROL" set "STATUS_FLAG" = '3' where "STATUS_FLAG" = '2' and ROWID = 'AAAC1dAADAAAC2GAAA'; | 0x000065.00000034.0010 | 0| 0|no supplemental log data found | 3| 222| 223| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213941| 3213940| 3213941|2024-08-02 12:56:06|2024-08-02 12:56:06|2024-08-02 12:56:06| 8| 27| 1188|08001B00A4040000| 8| 27| 1188|08001B00A4040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 53| 28| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000035.001c | 0| 0| | 0| 224| 225| 3213941|3213941| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213971| | |2024-08-02 12:57:24| | | 7| 24| 1128|0700180068040000| 7| 24| 1128|0700180068040000| |START | 6| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 58| 68| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000003a.0044 | 0| 0| | 0| 226| 227| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213971| | |2024-08-02 12:57:24| | | 7| 24| 1128|0700180068040000| 7| 24| 1128|0700180068040000| |INTERNAL | 0| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 58| 68| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0| | | 0x000065.0000003a.0044 | 0| 0| | 0| 228| 229| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213972| | |2024-08-02 12:57:24| | | 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |START | 6| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 58| 296| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.0000003a.0128 | 0| 0| | 0| 230| 231| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213972| | |2024-08-02 12:57:24| | | 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |INTERNAL | 0| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 58| 296| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0| | | 0x000065.0000003a.0128 | 0| 0| | 0| 232| 233| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213972| | |2024-08-02 12:57:24| | | 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |INTERNAL | 0| 0| | | | 0| | |D/////AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 59| 96| 4| 0| 0| 0| 4| 0| 0| 1| 0|4294967295| | | 0x000065.0000003b.0060 | 0| 0| | 0| 234| 235| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213972| | |2024-08-02 12:57:24| | | 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |INTERNAL | 0| 0| | | | 0| | |D/////AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 59| 436| 0| 0| 0| 0| 7| 0| 0| 1| 0|4294967295| | | 0x000065.0000003b.01b4 | 0| 0| | 0| 236| 237| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213972| | |2024-08-02 12:57:24| | | 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |INTERNAL | 0| 0| | | | 0| | |AAASR7AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 60| 188| 4| 0| 0| 0| 4| 0| 0| 74875| 0| 74875| | | 0x000065.0000003c.00bc | 0| 0| | 0| 238| 239| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213972| | |2024-08-02 12:57:24| | | 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |INTERNAL | 0| 0| | | | 0| | |AAASR7AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 60| 408| 4| 0| 0| 0| 7| 0| 0| 1| 0| 74875| | | 0x000065.0000003c.0198 | 0| 0| | 0| 240| 241| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213972| | |2024-08-02 12:57:24| | | 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |UNSUPPORTED| 255| 0|SYS |SEG$ |SEG$ | 2|TABLE |SYSTEM |AAAAAIAABAAAMgRAAS|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 61| 176| 4|17256565| 5| 240| 1| 1| 51217| 14| 0| 8|Unsupported |Unsupported | 0x000065.0000003d.00b0 | 0| 0|Object or Data type Unsupported| 2| 242| 243| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213973| 3213972| 3213973|2024-08-02 12:57:24|2024-08-02 12:57:24|2024-08-02 12:57:24| 7| 13| 1126|07000D0066040000| 7| 13| 1126|07000D0066040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 62| 32| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.0000003e.0020 | 0| 0| | 0| 244| 245| 3213971|3213973| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213975| | |2024-08-02 12:57:26| | | 7| 24| 1128|0700180068040000| 7| 24| 1128|0700180068040000| |INTERNAL | 0| 0| | | | 0| | |AAASR7AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 63| 136| 4| 0| 0| 0| 4| 0| 0| 74875| 0| 74875| | | 0x000065.0000003f.0088 | 0| 0| | 0| 246| 247| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213976| | |2024-08-02 12:57:26| | | 7| 24| 1128|0700180068040000| 7| 24| 1128|0700180068040000| |INTERNAL | 0| 0| | | | 0| | |AAASR7AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 65| 16| 4| 0| 0| 0| 4| 0| 0| 74875| 0| 74875| | | 0x000065.00000041.0010 | 0| 0| | 0| 248| 249| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213976| | |2024-08-02 12:57:26| | | 7| 24| 1128|0700180068040000| 7| 24| 1128|0700180068040000| |INTERNAL | 0| 0| | | | 0| | |AAASR7AAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 65| 460| 4| 0| 0| 0| 4| 0| 0| 74875| 0| 74875| | | 0x000065.00000041.01cc | 0| 0| | 0| 250| 251| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213977| 3213971| 3213977|2024-08-02 12:57:26|2024-08-02 12:57:24|2024-08-02 12:57:26| 7| 24| 1128|0700180068040000| 7| 24| 1128|0700180068040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 66| 292| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000042.0124 | 0| 0| | 0| 252| 253| 3213977|3213977| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213981| | |2024-08-02 12:57:34| | | 9| 3| 1272|09000300F8040000| 9| 3| 1272|09000300F8040000| |START | 6| 0| | | | 0| | |AAAALSAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 67| 208| 4| 0| 0| 0| 0| 0| 0| 0| 0| 0|set transaction read write; | | 0x000065.00000043.00d0 | 0| 0| | 0| 254| 255| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213981| | |2024-08-02 12:57:34| | | 9| 3| 1272|09000300F8040000| 9| 3| 1272|09000300F8040000| |INSERT | 1| 0|SYS |EXP_HEAD$ |EXP_HEAD$ | 2|TABLE |SYSAUX |AAAALSAADAAAAVrABQ|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 67| 208| 4|16777911| 15| 268| 3| 3| 1387| 722| 0| 722|insert into "SYS"."EXP_HEAD$"("EXP_ID","OBJN","SUB_ID","FIXED_COST","TEXT","COL_LIST","FLAGS","CTIME") values ('5152072325949408644','74875','0','.0000000268215720022949','"C1" ','1 ','8',TO_DATE('24/08/02', 'RR/MM/DD')); |delete from "SYS"."EXP_HEAD$" where "EXP_ID" = '5152072325949408644' and "OBJN" = '74875' and "SUB_ID" = '0' and "FIXED_COST" = '.0000000268215720022949' and "TEXT" = '"C1" ' and "COL_LIST" = '1 ' and "FLAGS" = '8' and "CTIME" = TO_DATE('24/08/02', 'RR/MM| 0x000065.00000043.00d0 | 80| 0|no supplemental log data found | 3| 256| 257| | | | |UNKNOWN |ent19 | 0| 0| 0| | 0|
3213982| 3213981| 3213982|2024-08-02 12:57:34|2024-08-02 12:57:34|2024-08-02 12:57:34| 9| 3| 1272|09000300F8040000| 9| 3| 1272|09000300F8040000| |COMMIT | 7| 0| | | | 0| | |AAAAAAAAAAAAAAAAAA|UNKNOWN |UNKNOWN |UNKNOWN | 0| 0| 0|UNKNOWN | 1| 1| 101| 69| 64| 4| 0| 0| 0| 4| 0| 0| 0| 0| 0|commit; | | 0x000065.00000045.0040 | 0| 0| | 0| 258| 259| 3213982|3213982| | |UNKNOWN |ent19 | 0| 0| 0| | 0|
65 row(s) fetched.'DBMS > ORACLE' 카테고리의 다른 글
| [oracle] ASM disk 추가 rebalance 시간 비교 (2) | 2024.10.12 |
|---|---|
| [oracle] 계정 만료(expired) 시 account_status 상태 변경 시점 (1) | 2024.09.26 |
| [oracle] WITH GRANT OPTION 회수 (1) | 2024.09.06 |
| [oracle] RU 패치 적용/롤백 시 기존 interim 패치 상태는? (0) | 2024.08.29 |
| [oracle] ORA-27300 에러 발생 status: 105 (0) | 2024.07.26 |
댓글