Hi everybody,
could someone help me?
i have two similar oracle 9i databases with similar parameter setting and same data.one is on a Proliant server and the other is on a normal pc.I wrote a java program that executes near 800 queries on both databases.when i use a single connection for executing all queries in my program, the proliant responses about 4 times faster but when i make a connection per each query, the pc is two times faster.I think my oracle on the pc makes the connection faster than the proliant. How can i improve time to getting connection from oracle on the proliant?
Thanks.