Ticket #25323 (closed: invalid)
HammerOra execution hangs
|Reported by:||jasathra||Owned by:|
|Keywords:||HORA hang issue||Cc:||rajendra.jasathy@…|
I am executing TPCH benchmarks on a testbed with following config;
a. 64 bit win2k3 server (4 dual core processors, 8gb ram) connected to an EMC VNX array.
b. Oracle 11 R1 installed with ASM on a group having 8 disks (1000GB size).
c. tpchtab tablespace size 120gb, temp table size 60gb +
d. HORA 10.2
I have created records with scale factor = 1. While executing tpch benchmarks, HORA hangs after executing few queries. it remain there for a long time and then executes few more and then again hangs. I noticed this on two machines (32 bit, and again 64 bit installation).
To make sure that my Oracle/host setup does not any issue, I executed HORA queries on the db from sql prompt return results within 45secs (tried excuting queries parallelly from multiple sql prompts, with no hang issue). Can you suggest this behaviour.