Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

10g Database Gives Out of memory error:Java heap space

632013Jun 5 2008 — edited Jun 6 2008
hi experts,

I have a new 10g database. I ran a stmt to delete all rows in a table - did this in SQL Plus: delete * from SSU.tableX

The table has only 8000 rows but it has hung forever...

I noticed this in the command promt window: Exception in thread-18 java.lang OutofMemory error:Java Heap Space

Question 1. How can I cleanly stop this from running. Dont want to damage the database if at all possible.

Question 2. What memory setting, etc do I need to increase to avoid this error in the future. (I know that's a broad question - this is a new db - took the defaults when I created it)

Thanks to anyone who can help! John
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2008
Added on Jun 5 2008
#general-database-discussions
7 comments
2,529 views