Database SCON logging - reduce logging
To minimize output to the scon.log file, you can prune the content using this procedure:
Log into the database server and switch to aptare user.
Edit the config.sql file.
Linux: /opt/aptare/database/stored_procedures/config.sql
Windows: C:\opt\oracle\database\stored_procedures\config.sql
Change the output setting to LOW, as shown in BOLD in the following example.
set Echo Off set Feedback OffCREATE OR REPLACE PACKAGE config AS -- Valid APTARE StorageConsole Logging levels are as follows: -- constant.DEBUG_OFF -- constant.DEBUG_LOW -- constant.DEBUG_MEDIUM -- constant.DEBUG_HIGH -- To change the global APTARE StorageConsole logging level, change the following constant globalDebugLevel PLS_INTEGER := constant.DEBUG_LOW; reportTransLongerThan FLOAT := 0.85; -- Transactions that take longer than this number of seconds will be reported in aptare-trans.log --UNCOMMENT BELOW TO ENABLE SCON.LOG writing. SAME parameter is available under System Configurations> Database Administration > Enable scon.log real time logging (minutes) --UPDATE apt_system_parameter SET param_value = 10 WHERE param_name = 'ENABLE_SCON_REAL_LOG_MINS'; COMMIT; -- The following directory will be used to store the APTARE StorageConsole -- database logfiles scon.log and scon.err. On a Windows portal server, -- this will default to C:\opt\oracle\logs LOGDIRECTORY CONSTANT VARCHAR2(64) := '/tmp' ; -- Following parameters are used in datacoll_exec_tracking_pkg NO_OF_DC_SP_LOG_ROWS CONSTANT NUMBER(5) := 100;--Defines the number of Data Collection log rows. This log contains execution tracking. NO_OF_DC_QUERY_LOG_ROWS CONSTANT NUMBER(5) := 50;--Defines the number of rows for the Data Collection query log. This log contains execution tracking. DATACOLL_LOGGING_ENABLED CONSTANT NUMBER(1) := 1;--Enables/disables data persistance transaction logging during data collection. This logging helps to isolate collection performance issues. If collection performance is degraded, you can temporarily disable the process. END config; / SHOW ERRORS;Apply and validate new settings with the following utilities:
Linux:
sqlplus portal/<portal_password>@//localhost:1521/scdb@/opt/aptare/database/ stored_procedures/config.sql sqlplus portal/<portal_password>@//localhost:1521/scdb@/opt/aptare/database/tools/validate_sp
Windows:
sqlplus portal/<portal_password>@//localhost:1521/scdb@C:\opt\oracle\database\ stored_procedures\config.sql sqlplus portal/<portal_password>@//localhost:1521/scdb@C:\opt\oracle\database\tools\ validate_sp