老榕树社区

标题: 不知为什么sqlplus不停地向system表空间insert数据？ [打印本页]

作者: saksanekS 时间: 2014-9-27 10:55
标题: 不知为什么sqlplus不停地向system表空间insert数据？
[php] SQL> create table logmnr2 as select * from v$logmnr_contents; Table created. Elapsed: 00:00:31.76 SQL> exec print_sql(\'select * from logmnr2 where rownum=1\'); SCN : 86941469 CSCN : TIMESTAMP : 12-aug-2004 12:44:18 COMMIT_TIMESTAMP : THREAD# : 1 LOG_ID : 22921 XIDUSN : 3 XIDSLT : 39 XIDSQN : 38832 PXIDUSN : 3 PXIDSLT : 39 PXIDSQN : 38832 RBASQN : 22921 RBABLK : 2 RBABYTE : 16 UBAFIL : 0 UBABLK : 0 UBAREC : 0 UBASQN : 0 ABS_FILE# : 1 REL_FILE# : 1 DATA_BLK# : 29459 DATA_OBJ# : 19820 DATA_OBJD# : 19820 SEG_OWNER : SEG_NAME : SEG_TYPE : 0 SEG_TYPE_NAME : UNSUPPORTED TABLE_SPACE : ROW_ID : AAAE1sAABAAAHMTAAA SESSION# : 0 SERIAL# : 0 USERNAME : SESSION_INFO : TX_NAME : ROLLBACK : 0 OPERATION : DIRECT INSERT OPERATION_CODE : 1 SQL_REDO : insert into \"UNKNOWN\".\"OBJ# 19820\"(\"COL 1\",\"COL 2\",\"COL 3\",\"COL 4\",\"COL 5\",\"COL 6\",\"COL 7\",\"COL 8\",\"COL 9\",\"COL 10\",\"COL 11\",\"COL 12\",\"COL 13\",\"COL 14\",\"COL 15\",\"COL 16\",\"COL 17\",\"COL 18\",\"COL 19\",\"CO SQL_UNDO : delete from \"UNKNOWN\".\"OBJ# 19820\" where \"COL 1\" = HEXTORAW(\'c4575c1c0d\') and \"COL 2\" IS NULL and \"COL 3\" = HEXTORAW(\'7868080c0c3503\') and \"COL 4\" IS NULL and \"COL 5\" = HEXTORAW(\'c102\') and \"COL 6\" = RS_ID : 0x005989.00000002.0010 SEQUENCE# : 0 SSN : 0 CSF : 0 INFO : Dictionary Mismatch STATUS : 2 REDO_VALUE : 96E3A138 UNDO_VALUE : 96E3A144 SQL_COLUMN_TYPE : SQL_COLUMN_NAME : REDO_LENGTH : 0 REDO_OFFSET : 0 UNDO_LENGTH : 0 UNDO_OFFSET : 0 ----------------- PL/SQL procedure successfully completed. Elapsed: 00:00:01.05 SQL> select file_id,tablespace_name from dba_data_files; FILE_ID TABLESPACE_NAME ---------- ------------------------------ 1 SYSTEM 14 rows selected. Elapsed: 00:00:00.01 SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production [uniread] Saved history (1278 lines) [oracle@www1 sql]$ sql [uniread] Loaded history (1278 lines) SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 12 13:41:32 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production SQL> select object_name from dba_objects where object_id=19820; no rows selected -------------------------- [/php]

欢迎光临老榕树社区 (http://club.lrswl.com/)