Thanks for your reply. I will begin by saying that this is not my area of expertise. I am convinced that it is an issue with the connection to Oracle. We are running EA and Word(my report is written using the EA API in a Word Template) on a Citrix Server.
1. I am wondering if those that are successfully running EA on an Oracle database can explain to me how you are connecting.
2. Any idea about the following? It appears that everytime EA issues a call to grab something from the EA database, verification SQL is being run against the Oracle database. After working with the Oracle DBAs it appears that 90% of processing time is spent on these statements. The following are the three statements:
select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA, ac.table_name TABLE_NAME, acc.column_name COLUMN_NAME, null COLUMN_GUID, null COLUMN_PROPID, acc.position ORDINAL from all_constraints ac, all_cons_columns acc where ac.owner = acc.owner and ac.table_name = acc.table_name and ac.constraint_type = 'P' and ac.constraint_name = acc.constraint_name) DBSCHEMA_PRIMARY_KEYS WHERE TABLE_SCHEMA = 'E_ARCHITECT' AND TABLE_NAME = 'T_OBJECT' order by 3, 4 ;
select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA, ac.table_name TABLE_NAME, acc.column_name COLUMN_NAME, null COLUMN_GUID, null COLUMN_PROPID, acc.position ORDINAL from all_constraints ac, all_cons_columns acc where ac.owner = acc.owner and ac.table_name = acc.table_name and ac.constraint_type = 'P' and ac.constraint_name = acc.constraint_name) DBSCHEMA_PRIMARY_KEYS WHERE TABLE_SCHEMA = 'E_ARCHITECT' AND TABLE_NAME = 'T_DIAGRAMOBJECTS' order by 3, 4 ;
select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA, ac.table_name TABLE_NAME, acc.column_name COLUMN_NAME, null COLUMN_GUID, null COLUMN_PROPID, acc.position ORDINAL from all_constraints ac, all_cons_columns acc where ac.owner = acc.owner and ac.table_name = acc.table_name and ac.constraint_type = 'P' and ac.constraint_name = acc.constraint_name) DBSCHEMA_PRIMARY_KEYS WHERE TABLE_SCHEMA = 'E_ARCHITECT' AND TABLE_NAME = 'T_OBJECT' order by 3, 4 ;
select * from (select null TABLE_CATALOG, idx.table_owner TABLE_SCHEMA, idx.table_name TABLE_NAME, null INDEX_CATALOG, idx.owner INDEX_SCHEMA, idx.index_name INDEX_NAME, null PRIMARY_KEY, decode(idx.uniqueness, 'UNIQUE', -1, 0) UNIQUE_,null CLUSTERED,null TYPE, null FILL_FACTOR, idx.initial_extent INITIAL_SIZE, null NULLS, null SORT_BOOKMARKS, -1 AUTO_UPDATE, 2 NULL_COLLATION, col.column_position ORDINAL_POSITION, col.column_name COLUMN_NAME, null COLUMN_GUID, null COLUMN_PROPID, 1 COLLATION, null CARDINALITY, null PAGES, null FILTER_CONDITION, null INTEGRATED from all_indexes idx, all_ind_columns col where idx.owner = col.index_owner and idx.index_name = col.index_name and idx.table_owner = col.table_owner and idx.table_name = col.table_name ) DBSCHEMA_INDEXES WHERE TABLE_SCHEMA = 'E_ARCHITECT' AND TABLE_NAME = 'T_OBJECT' order by 8, 10, 5, 6, 17 ;
