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!

what happens if 100 querys hits database at one time?

hphanjra-JavaNetDec 21 2006 — edited Dec 22 2006

I have sever problem. I have java application and having conection pool upto 150. Let's say from the application my database get hit by 100 connection AT A TIME.
my cpu goes 99%.

Now my question is how can i get better performance out of this.

Assumtions: all queries are well written, net work is good
Expected solution: May trying increasing SGA size would increaase some performance?
I heard some thing about doing parralle queries. what 's that?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2007

Added on Dec 21 2006

#general-database-discussions

21 comments

1,868 views