最近覺得ORACLE的跟蹤日志檔案占用空間過大,統計了一下發現基本都跟插入一個表資料有關。日志詳情如下,那位高手可以給解讀一下,我該如何解決此問題?
----------------------
LibraryHandle: Address=5c492b08 Hash=c8ef666a LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=INSERT INTO "LOG1"."MD_USER_OPERATION"
("C_CORP_ID","V_CORP_NAME","C_USER_ID","V_USER_NAME","N_STATION_CODE","V_STATION_NAME","V_IP","V_MAC","V_OPERATION_SYS","V_OPERATION_BROWSER","D_TIME","V_TYPE","V_PAGE","V_RFFERRER_PAGE","V_EVENT_ID","V_EVENT_NAME","D_EVENT_TIME","N_EVENT_INTERVAL","V_TAG","V_TAG_ID","V_TAG_CLASS","V_TAG_VALUE","V_REMARK","V_VERSION")
VALUES
(:C_CORP_ID,:V_CORP_NAME,:C_USER_ID,:V_USER_NAME,:N_STATION_CODE,:V_STATION_NAME,:V_IP,:V_MAC,:V_OPERATION_SYS,:V_
------------然后就是
ChildTable: size='32768'
Child: id='0' Table=19f35f60 Reference=19f359b0 Handle=5c24d488
Child: id='1' Table=19f35f60 Reference=19eca048 Handle=5c234db0
Child: id='2' Table=19f35f60 Reference=19eca300 Handle=1060aa30
--------很多
uj5u.com熱心網友回復:
這個應該是共享池庫緩沖部分的內容,因為樓主只給出了這部分資訊,所以,不好給出更具體的資訊。轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/19571.html
標籤:高級技術
