Recently think ORACLE trace log file takes up too much room, statistics about the basic are related to insert a table data, log details as follows, the master can give interpretation, how should I solve this problem?
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
LibraryHandle: Address=5 c492b08 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_
-- -- -- -- -- -- -- -- -- -- -- -- and then there is
ChildTable: size='32768'
Child: id='0' Table=19 f35f60 Reference=19 f359b0 Handle=5 c24d488
Child: id='1' Table=19 f35f60 Reference=19 eca048 Handle=5 c234db0
Child: id='2' Table=19 f35f60 Reference=19 eca300 Handle=1060 aa30
-- -- -- -- -- -- -- -- a lot

CodePudding user response:

The contents of this part should be Shared pools, buffer, because the building is only part of this information is given, so, not give more specific information,