oracle9i

How do we optimize oracle database ?

Hello, We have a Oracle 9i Database with 7 tables each with 15+ Million records. There is no relation between the table i.e. no foreign keys. Here is an example of one of the tables CREATE TABLE GSS.SHOWPD ( INSERVID VARCHAR2(7 CHAR) NOT NULL, CAGEPOS VARCHAR2(8 CHAR) DEFAULT NULL, DETA...

Ibatis+Oracle: How to update a float value

I'm trying to update a float value in oracle database, but the saved value is only the integer part of the float value. I'm using the expression update TABLE SET VALUE = #value:NUMERIC# WHERE ID = #id# The Value is defined as Number(19,4) NULL ...