83 lines
3.9 KiB
SQL
83 lines
3.9 KiB
SQL
@@header
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display OLAP Sessions
|
|
* Parameters : NONE
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 27-Nov-12 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
PROMPT **********************************
|
|
PROMPT * Cube Logging Setttings
|
|
PROMPT **********************************
|
|
|
|
COLUMN log_type HEADING "Log Type" FORMAT a20
|
|
COLUMN max_errors HEADING "Max Errors" FORMAT 999999999
|
|
COLUMN flush_interval HEADING "Flush|Interval|(sec)" FORMAT 999999999
|
|
COLUMN log_full_record HEADING "Log Full|Record" FORMAT a20
|
|
COLUMN log_every_n HEADING "Log Every|N records" FORMAT 999999999
|
|
COLUMN allow_errors HEADING "Allow Errors" FORMAT 999999999
|
|
|
|
SELECT 'Build' Log_Type
|
|
, 0 max_errors
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_build,2) flush_interval
|
|
, CASE sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_build,3)
|
|
WHEN 0 THEN 'FULL_RECORD_AUTO'
|
|
WHEN 1 THEN 'FULL_RECORD_ALWAYS'
|
|
WHEN 2 THEN 'FULL_RECORD_NEVER'
|
|
ELSE TO_CHAR(sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_build,3))
|
|
END log_full_record
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_build,4) log_every_n
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_build,5) allow_errors
|
|
FROM DUAL
|
|
UNION ALL
|
|
SELECT 'Operations' Log_Type
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_operations,1) max_errors
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_operations,2) flush_interval
|
|
, CASE sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_operations,3)
|
|
WHEN 0 THEN 'FULL_RECORD_AUTO'
|
|
WHEN 1 THEN 'FULL_RECORD_ALWAYS'
|
|
WHEN 2 THEN 'FULL_RECORD_NEVER'
|
|
ELSE TO_CHAR(sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_operations,3))
|
|
END log_full_record
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_operations,4) log_every_n
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_operations,5) allow_errors
|
|
FROM DUAL
|
|
UNION ALL
|
|
SELECT 'Dimension Compile' Log_Type
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_dimension_compile,1) max_errors
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_dimension_compile,2) flush_interval
|
|
, CASE sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_dimension_compile,3)
|
|
WHEN 0 THEN 'FULL_RECORD_AUTO'
|
|
WHEN 1 THEN 'FULL_RECORD_ALWAYS'
|
|
WHEN 2 THEN 'FULL_RECORD_NEVER'
|
|
ELSE TO_CHAR(sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_dimension_compile,3))
|
|
END log_full_record
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_dimension_compile,4) log_every_n
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_dimension_compile,5) allow_errors
|
|
FROM DUAL
|
|
UNION ALL
|
|
SELECT 'Rejected Records' Log_Type
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_rejected_records,1) max_errors
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_rejected_records,2) flush_interval
|
|
, CASE sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_rejected_records,3)
|
|
WHEN 0 THEN 'FULL_RECORD_AUTO'
|
|
WHEN 1 THEN 'FULL_RECORD_ALWAYS'
|
|
WHEN 2 THEN 'FULL_RECORD_NEVER'
|
|
ELSE TO_CHAR(sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_rejected_records,3))
|
|
END log_full_record
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_rejected_records,4) log_every_n
|
|
, sys.dbms_cube_log.get_parameter(sys.dbms_cube_log.type_rejected_records,5) allow_errors
|
|
FROM DUAL
|
|
;
|
|
|
|
|
|
@@footer
|