GeeCON Prague 2014*
The moose likes JDBC 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
Bookmark "Oracle - ORA -01652 clarification" Watch "Oracle - ORA -01652 clarification" New topic
Author

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"?
 
GeeCON Prague 2014
 
subject: Oracle - ORA -01652 clarification