1) I am a Java developer and not having much expertise on Oracle Database. We have deployed our EJB aplication in two Websphere App Servers with Oracle 8.x databse (I will call as APPSERVER 1 and APPSERVER 2). I get the following error in APPSERVER 1 when I searched for a large chunk of data. /////////// ORA-01652: unable to extend temp segment by 64 in tablespace TEMP ///////////// I did not get this error in APPSERVER 2 By modifying the table space in Oracle Database in APPSERVER 1 to overcome the error ORA-01652 The issue is, APPSERVER 1 is pretty slow in response time compared APPSERVER2. My question is will the poor respose time (perfromance) be related this table space setting in the APPSERVER 1 database. 2) IS it true that Oracle Database Isolation "READ_COMMITED" will be faster than the Oracle Database Isolation "SERIALIZABLE"?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com