We have a large number of java store procedures and looks like we have
hit some limitation. When we compile some modules the database hangs.
No messages are provided, nothing in the alert logs give us any idea of
what may be wrong. Has anybody else experience this problem?

Below is the information on db release level and os level.

spconover29 > prtconf | more
System Model: IBM,9076-270
Machine Serial Number: 0017019
Processor Type: PowerPC_POWER3
Number Of Processors: 2
Processor Clock Speed: 375 MHz
CPU Type: 64-bit
Kernel Type: 32-bit
LPAR Info: -1 NULL
Memory Size: 1024 MB
Good Memory Size: 1024 MB

Oracle Enterprise 9.2.0.4

spconover29 > ls
inittaxu.ora
spconover29 > grep java inittaxu.ora
java_pool_size=400M
java_soft_sessionspace_limit = 8000000

thanks, Bob

--
Robert Morton
State Of New Jersey
Work: (609) 633-8978
Fax : (609) 633-0011



Oracle LazyDBA home page