| General Information |
| Description |
Provides interfaces which control logging in the OLAP component |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmscbl.sql |
| First Available |
11.2 |
Constants |
| Name |
Data Type |
Value |
|
Build |
| BUILD_V11106 |
BINARY_INTEGER |
1 |
| BUILD_V11106A |
BINARY_INTEGER |
2 |
| BUILD_V11107 |
BINARY_INTEGER |
3 |
| BUILD_V11200 |
BINARY_INTEGER |
4 |
| BUILD_VCURRENT |
BINARY_INTEGER |
BUILD_V11200 |
|
Dimension Compile |
| DIMENSION_COMPILE_V112ALPHA |
BINARY_INTEGER |
1 |
| DIMENSION_COMPILE_V112 |
BINARY_INTEGER |
2 |
| DIMENSION_COMPILE_VCURRENT |
BINARY_INTEGER |
DIMENSION_COMPILE_V112 |
|
Log Full Record
when no ROWID |
| FULL_RECORD_AUTO |
BINARY_INTEGER |
0 |
| FULL_RECORD_ALWAYS |
BINARY_INTEGER |
1 |
| FULL_RECORD_NEVER |
BINARY_INTEGER |
2 |
|
Log Levels |
| VERBOSE_ACTION |
BINARY_INTEGER |
1 |
| VERBOSE_NOTICE |
BINARY_INTEGER |
2 |
| VERBOSE_INFO |
BINARY_INTEGER |
3 |
| VERBOSE_STATS |
BINARY_INTEGER |
4 |
| VERBOSE_DEBUG |
BINARY_INTEGER |
5 |
|
Log Table
Versions |
| OPERATIONS_V112ALPHA |
BINARY_INTEGER |
1 |
| OPERATIONS_V112 |
BINARY_INTEGER |
2 |
| OPERATIONS_VCURRENT |
BINARY_INTEGER |
3 |
|
Log Targets |
| TARGET_TABLE |
BINARY_INTEGER |
1 |
| TARGET_TRACE |
BINARY_INTEGER |
2 |
| TARGET_FILE |
BINARY_INTEGER |
3 |
| TARGET_LOB |
BINARY_INTEGER |
4 |
|
Log Types |
| TYPE_OPERATIONS |
BINARY_INTEGER |
1 |
| TYPE_REJECTED_RECORDS |
BINARY_INTEGER |
2 |
| TYPE_DIMENSION_COMPILE |
BINARY_INTEGER |
3 |
| TYPE_BUILD |
BINARY_INTEGER |
4 |
|
Miscellaneous |
| MAX_ERRORS |
BINARY_INTEGER |
1 |
| FLUSH_INTERVAL |
BINARY_INTEGER |
2 |
| LOG_FULL_RECORD |
BINARY_INTEGER |
3 |
|
Rejected Records |
| REJECTED_RECORDS_V112ALPHA |
BINARY_INTEGER |
1 |
| REJECTED_RECORDS_V112 |
BINARY_INTEGER |
2 |
| REJECTED_RECORDS_VCURRENT |
BINARY_INTEGER |
REJECTED_RECORDS_V112 |
|
| Dependencies |
| ALL_TABLES |
DBMS_ASSERT |
DBMS_AW_LIB |
DBMS_UTILITY |
| ALL_TAB_COLUMNS |
DBMS_AW |
DBMS_OUTPUT |
|
|
Exceptions |
| Exception Name |
Error Code |
| INVALID_TYPE |
ORA-37561 |
| INVALID_TARGET |
ORA-37562 |
| INVALID_LEVEL |
ORA-37563 |
| INVALID_VERSION |
ORA-37564 |
| INVALID_SQL_ID |
ORA-37571 |
| INVALID_ID |
ORA-37572 |
| NO_LIMITS |
ORA-37573 |
|
| Security Model |
Execute is granted to PUBLIC |
| |
| DEFAULT_NAME |
Returns the default name for a logging type |
dbms_cube_log.default_name(log_type IN BINARY_INTEGER DEFAULT DBMS_CUBE_LOG.TYPE_OPERATIONS)
RETURN VARCHAR2; |
DECLARE
defname VARCHAR2(100);
BEGIN
defname := dbms_cube_log.default_name;
END;
/ |
| |
| DISABLE |
Disable logging to a location |
dbms_cube_log.disable(
log_type IN BINARY_INTEGER DEFAULT NULL,
log_target IN BINARY_INTEGER DEFAULT NULL); |
BEGIN
dbms_cube_log.disable(dbms_cube_log.type_operations, dbms_cube_log.target_table);
END;
/ |
| |
| ENABLE |
Enable logging to a specific location with a given level
Overload 1 |
dbms_cube_log.enable(
log_type IN BINARY_INTEGER DEFAULT NULL,
log_target IN BINARY_INTEGER DEFAULT NULL,
log_level IN BINARY_INTEGER DEFAULT NULL); |
conn sh/sh
BEGIN
dbms_cube_log.table_create(DBMS_CUBE_LOG.TYPE_BUILD, 'SH_CUBE_LOG');
dbms_cube_log.enable(dbms_cube_log.type_operations, dbms_cube_log.target_table, dbms_cube_log.verbose_action);
END;
/ |
Overload 2 |
dbms_cube_log.enable(
log_type IN BINARY_INTEGER DEFAULT NULL,
log_target IN BINARY_INTEGER DEFAULT NULL,
log_level IN BINARY_INTEGER DEFAULT NULL,
log_location IN OUT NOCOPY CLOB); |
conn sh/sh
DECLARE
log_loc CLOB;
BEGIN
dbms_cube_log.table_create(DBMS_CUBE_LOG.TYPE_BUILD, 'SH_CUBE_LOG');
dbms_cube_log.enable(dbms_cube_log.type_rejected_records, dbms_cube_log.target_trace,
dbms_cube_log.verbose_info, log_loc);
dbms_output.put_line(log_loc);
END;
/ |
Overload 3 |
dbms_cube_log.enable(
log_type IN BINARY_INTEGER DEFAULT NULL,
log_target IN BINARY_INTEGER DEFAULT NULL,
log_level IN BINARY_INTEGER DEFAULT NULL,
log_location IN VARCHAR2); |
conn sh/sh
DECLARE
log_loc VARCHAR2(100) := 'SH.SH_CUBE_LOG';
BEGIN
dbms_cube_log.table_create(DBMS_CUBE_LOG.TYPE_BUILD, 'SH_CUBE_LOG');
dbms_cube_log.enable(dbms_cube_log.type_build, dbms_cube_log.target_file, dbms_cube_log.verbose_stats, log_loc);
END;
/ |
| |
| FLUSH |
Force any open logs to flush |
dbms_cube_log.flush; |
| exec dbms_cube_log.flush; |
| |
| GET_LOG |
Get current logging information |
dbms_cube_log.get_log(
log_type IN BINARY_INTEGER DEFAULT NULL,
log_target IN BINARY_INTEGER DEFAULT NULL,
log_level OUT BINARY_INTEGER,
log_location OUT VARCHAR2); |
DECLARE
log_lvl BINARY_INTEGER;
log_loc VARCHAR2(100);
BEGIN
dbms_cube_log.get_log(ltyp, ltar, log_lvl, log_loc);
dbms_output.put_line(log_lvl);
dbms_output.put_line(log_loc);
END;
/ |
| |
| GET_LOG_SPEC |
Retrieve string describing current logging |
dbms_cube_log.get_log_spec RETURN VARCHAR2; |
set serveroutput on
DECLARE
logspec VARCHAR2(100);
BEGIN
logspec :=
dbms_cube_log.get_log_spec;
dbms_output.put_line(logspec);
dbms_cube_log.set_query_env(?);
dbms_output.put_line(logspec);
logspec := dbms_cube_log.get_log_spec;
dbms_output.put_line(logspec);
END;
/ |
| |
| GET_PARAMETER |
Retrieve a parameter's value |
dbms_cube_log.get_parameter(log_type IN BINARY_INTEGER, log_parameter IN BINARY_INTEGER)
RETURN BINARY_INTEGER; |
DECLARE
log_parm BINARY_INTEGER;
BEGIN
log_parm := dbms_cube_log.get_parameter(dbms_cube_log.type_operations,
dbms_output.put_line(log_parm);
END;
/ |
| |
| SET_LOG_SPEC |
| Set all logging based on string |
dbms_cube_log.set_log_spec(log_spec IN VARCHAR2); |
| exec dbms_cube_log.set_log_spec('OPERATIONS(TRACE)
REJECTED_RECORDS(TABLE)'); |
| |
| SET_PARAMETER |
Set a parameter's value |
dbms_cube_log.set_parameter(
log_type IN BINARY_INTEGER,
log_parameter IN BINARY_INTEGER,
value IN BINARY_INTEGER); |
BEGIN
dbms_cube_log.set_parameter(dbms_cube_log.type_rejected_records,
1, 150);
END;
/ |
| |
| SET_QUERY_ENV |
Set all limits for query environment |
dbms_cube_log.set_query_env(
sql_id IN VARCHAR2,
id IN NUMBER DEFAULT NULL,
tblname IN VARCHAR2 DEFAULT NULL); |
| See GET_LOG_SPEC Demo |
| |
| TABLE_CREATE |
Creates an appropriate table for the given log type |
dbms_cube_log.table_create(
log_type IN BINARY_INTEGER DEFAULT DBMS_CUBE_LOG.TYPE_OPERATIONS,
tblname IN VARCHAR2 DEFAULT NULL); |
exec
dbms_cube_log.table_create(DBMS_CUBE_LOG.TYPE_BUILD, 'SH_CUBE_LOG');
desc cube_build_log
SELECT sequence_name FROM user_sequences; |
| |
| VERSION |
Retrieve version of table, or current default version if tblname is NULL |
dbms_cube_log.version(
log_type IN BINARY_INTEGER DEFAULT DBMS_CUBE_LOG.TYPE_OPERATIONS,
tblname IN VARCHAR2 DEFAULT NULL)
RETURN BINARY_INTEGER; |
| SELECT dbms_cube_log.version FROM dual; |
