SYMPTOM:
The sys.obj table is an Oracle system table where all changes to the database objects are written (i.e., creation of temp tables). Locks created by Strategy reports sometimes cause all applications that need to create/modify any database objects to wait until the sys.obj table is released.
The SQL generated by the report may contain the nologging option, as shown in the example below:
create table ZZT5H0600QLSP000 nologging as select
CAUSE:
The syntax "create table #### nologging as select..." does not actually create true temporary tables on Oracle. Global temporary tables should therefore be created against Oracle during report execution.
ACTION:
Refer to the following Strategy Knowledge Base document for information to enable the engine to generate "create global temporary table" syntax against Oracle:
KB6964: How to enable true temporary tables in Oracle in MicroStrategy SQL Generation Engine
Third Party Software Installation
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
