Index-Usage / Optimizing
Hi,
in mid of July we've migrated an Oracle Database EE 9.2 (OS OpenVMS 7.3-2 Alpha) to Oracle Database EE 10.2.0.4 (OS HP-UX B.11.31 Itanium).
Since this time we got some perfomance-issues especially on table, which seems to be related to index-usage respectively optimizer related things. In this database we've got one table called fms_message, on this table exists an index called fms_message_i:
CREATE TABLE ELAS.FMS_MESSAGE
(
ID NUMBER NOT NULL ,
TIMESTAMP DATE,
PROCESS VARCHAR2(32),
MESSAGE VARCHAR2(512),
FMS_ID NUMBER NOT NULL
)
TABLESPACE FMS_ORDER
PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT)
LOGGING ENABLE ROW MOVEMENT;
in mid of July we've migrated an Oracle Database EE 9.2 (OS OpenVMS 7.3-2 Alpha) to Oracle Database EE 10.2.0.4 (OS HP-UX B.11.31 Itanium).
Since this time we got some perfomance-issues especially on table, which seems to be related to index-usage respectively optimizer related things. In this database we've got one table called fms_message, on this table exists an index called fms_message_i:
CREATE TABLE ELAS.FMS_MESSAGE
(
ID NUMBER NOT NULL ,
TIMESTAMP DATE,
PROCESS VARCHAR2(32),
MESSAGE VARCHAR2(512),
FMS_ID NUMBER NOT NULL
)
TABLESPACE FMS_ORDER
PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT)
LOGGING ENABLE ROW MOVEMENT;
0