ORACLE跟踪日志一个问题的解读INSERT_INTO_LOG1__MD_USER_OPERATION
最近觉得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
--------很多