File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle - ORA -01652 clarification Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle - ORA -01652 clarification" Watch "Oracle - ORA -01652 clarification" New topic

Oracle - ORA -01652 clarification

Sri Rangan
Ranch Hand

Joined: Dec 08, 2001
Posts: 160
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 agree. Here's the link:
subject: Oracle - ORA -01652 clarification
jQuery in Action, 3rd edition