From: victor.savkin <vic...@tr...> - 2011-06-01 16:00:52
|
Hi Nicholas, Thank you for your response. Answering your questions: 1. I'm creating 8 separate connections. 2. I don't think that there is a limit to 8 threads somewhere. I can run another query using 12 parallel threads and everything works fine. 3. 7 queries disappear from DBA_SQL_STATEMENTS but one is there. For each thread it takes about 10 seconds to perform the query except the one that gets stuck (I waited for 10 minutes, no result). I can also see several blocked threads with similar name (something like qtp5016452-42). Thanks, Victor -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/LucidDB-Gets-Stuck-Processing-Many-Concurrent-Queries-tp6424597p6427586.html Sent from the luciddb-users mailing list archive at Nabble.com. |