sqlldr ($ORACLE_HOME/bin/sqlldr.exe), installed as part of OC4J 10.1.3.4, fails with the following error when executed.
..>sqlldr
Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL.
Process explorer showed that it was looking for $ORACLE_HOME/rdbms/mesg/ulus.msb, and it did not find it there. Not sure whether the bundled version is same as the Oracle client install on a different computer, but found this file anyway and copied it over to OC4J/rdbms/mesg/ directory.
It worked!
Monday, October 21, 2013
Thursday, October 17, 2013
Oracle BPEL - Slow "Search by Title" and "Tree Finder" Actions
Search by "Title" in the instances tab and also "Tree Finder" in an individual instance page got really slow - 10 - 24 secs, in 10.1.3.4 instance.
The following custom indexes were added to bring them below 0.06 secs. in our instance.
See the highlighted indexes added recently.
SQL> select index_name, index_type, table_name, uniqueness from all_indexes where table_name = 'CUBE_INSTANCE';
INDEX_NAME INDEX_TYPE TABLE_NAME UNIQUENESS
----------------- --------------------- -------------- ----------
STATE_IND NORMAL CUBE_INSTANCE NONUNIQUE
CI_CUSTOM4 FUNCTION-BASED NORMAL CUBE_INSTANCE NONUNIQUE
CI_PARENT_ID_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_TITLE_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_ROOT_ID_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_CONV_ID_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_PK NORMAL/REV CUBE_INSTANCE UNIQUE
CI_CUSTOM2 NORMAL CUBE_INSTANCE NONUNIQUE
CI_CUSTOM3 NORMAL CUBE_INSTANCE NONUNIQUE
The following custom indexes were added to bring them below 0.06 secs. in our instance.
See the highlighted indexes added recently.
SQL> select index_name, index_type, table_name, uniqueness from all_indexes where table_name = 'CUBE_INSTANCE';
INDEX_NAME INDEX_TYPE TABLE_NAME UNIQUENESS
----------------- --------------------- -------------- ----------
STATE_IND NORMAL CUBE_INSTANCE NONUNIQUE
CI_CUSTOM4 FUNCTION-BASED NORMAL CUBE_INSTANCE NONUNIQUE
CI_PARENT_ID_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_TITLE_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_ROOT_ID_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_CONV_ID_IDX NORMAL CUBE_INSTANCE NONUNIQUE
CI_PK NORMAL/REV CUBE_INSTANCE UNIQUE
CI_CUSTOM2 NORMAL CUBE_INSTANCE NONUNIQUE
CI_CUSTOM3 NORMAL CUBE_INSTANCE NONUNIQUE
Subscribe to:
Posts (Atom)