A Wetpaint Site

Sign in to Wetpaint

Sign in or

Diagnose OLAP API Client Sessions with SYS.OLAP$ALTER_SESSION

Page Versions

Key: additions deletions

Showing 9 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Feb 12 2008, 11:05 AM EST	olapdba		edit	34 words added 2 words deleted
Change: (this may seem like overkill, feel free to remove any tracing that may not be needed).call olap_api_session_init.add_alter_session('D4O_TRACE','set "_xsolapi_debug_output"=TRACE');"_olap_continuous_trace_file"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','set "_olap_continuous_trace_file"=TRUE');"_olap_dbgoutfile_echo_to_eventlog"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','set "_olap_poutlog_echo_to_eventlog"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','set "_olap_table_function_statistics"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','set "_xsolapi_debug_output"=TRACE');call olap_api_session_init.add_alter_session('D4O_TRACE','set "_xsolapi_source_trace"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','set events ''10046 trace name context forever, level 12'''); call olap_api_session_init.add_alter_session('D4O_TRACE','set View changes from previous version. (Word count: 372)
	Feb 12 2008, 10:58 AM EST	olapdba		edit	8 words added 4 words deleted
Change: olap_api_session_init.add_alter_session('D4O_TRACE','set "_xsolapi_debug_output"=TRACE');call olap_api_session_init.add_alter_session('D4O_TRACE','"_olap_continuous_trace_file"=TRUE');olap_api_session_init.add_alter_session('D4O_TRACE','set "_olap_continuous_trace_file"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','"_olap_table_function_statistics"=TRUE');olap_api_session_init.add_alter_session('D4O_TRACE','set "_olap_table_function_statistics"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','"_xsolapi_source_trace"=TRUE');olap_api_session_init.add_alter_session('D4O_TRACE','set "_xsolapi_source_trace"=TRUE');call olap_api_session_init.add_alter_session('D4O_TRACE','set events ''10046 trace name context forever, level 12'''); call olap_api_session_init.add_alter_session('D4O_TRACE','set events ''37377 trace name context forever, level 4''');3. Now grant the role to your user in order to run diagnosticsgrant role View changes from previous version. (Word count: 329)
	Jan 22 2008, 10:58 AM EST	olapdba		edit	2 words added 2 words deleted
Change: the OLAP_USERD4O_TRACE role: call olap_api_session_init.delete_alter_session('D4O_TRACE','SET SQL_TRACE=TRUE'); Clean up all orphaned rows in the OLAP$ALTER_SESSION Table related to a non-existent roles call olap_api_session_init.clean_alter_session(); Add an EVENT setting for session assigned the OLAP_USERD4O_TRACE role using the OLAP API: call OLAP_API_SESSION_INIT.ADD_ALTER_SESSION('D4O_TRACE','set events ''10046 trace name context forever, level 12'''); View changes from previous version. (Word count: 325)
	Jan 18 2008, 9:03 AM EST	olapdba		edit	5 words added 2 words deleted
Change: or performance concern. As expected you will need to check with support prior to using "_" parameters as their behaviour can differ between release and they are typically undocumented. Run these commands as SYS in SQL*Plus.1. Create a role for the type View changes from previous version. (Word count: 325)
	Jan 18 2008, 9:02 AM EST	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 322)
	Jan 18 2008, 9:01 AM EST	olapdba		edit	79 words added
Change: assigned the OLAP_USER role: call olap_api_session_init.delete_alter_session('D4O_TRACE','SET SQL_TRACE=TRUE'); Clean up all orphaned rows in the OLAP$ALTER_SESSION Table related to a non-existent roles call olap_api_session_init.clean_alter_session(); Add an EVENT setting for session assigned the OLAP_USER role using the OLAP API: call OLAP_API_SESSION_INIT.ADD_ALTER_SESSION('D4O_TRACE','set events ''10046 trace name context forever, level 12'''); View changes from previous version. (Word count: 322)
	Jan 18 2008, 8:55 AM EST	olapdba		edit	44 words added
Change: NOTE: The diagnostic material you collect here may help Oracle Support with their diagnose of the problem. As expected you will need to check with support prior to using "_" parameters as their behaviour can differ between release and they are typically undocumented. 1. Create a role View changes from previous version. (Word count: 227)
	Jan 18 2008, 8:51 AM EST	olapdba		edit	162 words added
Change: 1. Create a role for the type of session you wish to diagnose. For this example we will create a role named D4O_TRACE in order View changes from previous version. (Word count: 184)
	Jan 18 2008, 8:40 AM EST	olapdba		create	No content added or deleted.
Change: Created by olapdba Jan 18 2008, 8:40 AM EST for: no reason given

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home