IV90434: Long-running query was causing performance issues


The following SQL was running on the customer installation and was not originating from TRIRIGA itself. This SQL was a long-running query, originating from Oracle, running often, and resulted in TRIRIGA performance problems:

SELECT NULL AS table_cat, t.owner AS table_schem, t.table_name AS table_name, t.column_name AS column_name, DECODE( (SELECT a.typecode FROM ALL_TYPES A WHERE a.type_name = t.data_type), 'OBJECT', 2002, 'COLLECTION', 2003, DECODE(substr(t.data_type, 1, 9), 'TIMESTAMP', DECODE(substr(t.data_type, 10, 1), '(', DECODE(substr(t.data_type, 19, 5), 'LOCAL', -102, 'TIME ', -101, 93), ...

Continue reading

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s