Change: Debug Information to Trace alter session set "_olap_poutlog_echo_to_eventlog"=true"_olap_dbgoutfile_echo_to_eventlog"=true Diagnose (OLAP DML Commands) Setting (if you are running OLAP Worksheet there is no need for the PL/SQL wrapper) Details when bad line of code exec dbms_aw.execute('BADLINE=yes'); OLAP Program Execution exec dbms_aw.execute('PRGTRACE=on'); OLAP Model Execution exec dbms_aw.execute('MODTRACE=on'); Show Error Messages exec   View changes from previous version. (Word count: 341)

Change: ''37390''37396 trace name context forever, level 1'' Query Debugging Diagnose Setting SQL Tracing (Binds and Waits) alter session set events ''10046 trace name context forever, level 12'' CBO Decisions alter session set events ''10053 trace name context forever, level 1'' OLAP Continuous Tracing alter session set "_olap_continuous_trace_file"=true OLAP   View changes from previous version. (Word count: 339)

Change:  This list is incomplete. There are far more diagnostic events that can be set with the assistance or Oracle Support. They are not being shared here because the level of detail is so complex that the typical database practitioner will gain no value in the information. Build Debugging Diagnose Setting   View changes from previous version. (Word count: 339)

Change: such as BI Beans, Discoverer for OLAP, Spreadsheet Add-in or any other application that utilizes the Oracle OLAP API, see Diagnose OLAP API Client Sessions with SYS.OLAP$ALTER_SESSION for more information) Build Debugging Diagnose Setting SQL Tracing alter session set sql_trace true OLAP Continuous Tracing alter session set "_olap_continuous_trace_file"=true OLAP   View changes from previous version. (Word count: 259)

Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 239)

Change: information.information) Build Debugging Diagnose Setting SQL Tracing alter session set sql_trace true OLAP Continuous Tracing alter session set "_olap_continuous_trace_file"=true OLAP Debug Information to Trace alter session set "_olap_dbgoutfile_echo_to_eventlog"=true OLAP POutLog to Trace alter session set "_olap_poutlog_echo_to_eventlog"=true OLAP SQL Import to Trace alter session set events   View changes from previous version. (Word count: 239)

Change: Created by olapdba Jan 22 2008, 10:21 AM EST for: no reason given