wood burning stoves 2.0*
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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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"?
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Oracle - ORA -01652 clarification
Similar Threads
Don't work spatial index
Problem inserting into DB in a JSP
Scenario where one should use Read committed or Serializable as Isolation level?
Searching words in VARCHAR2 & CLOB
Reports using Oracle