Slow SQL with dedicated server? [message #276419] |
Thu, 25 October 2007 02:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Hi!
Some developers runs SQL-questions against a 9.2.0.8 Oracle DB. They run against two tables. On with over 300k rows and the other with around 200k rows.
But the response time is really slow from 5 to 40 seconds. And the SQL queries are not that complicated. They do run many full table scans however.
There around 35-40 sessions connected to the DB.
Do you think the DB should run in Shared Server mode instead?
//Hristo, newbie
|
|
|
|
|
|
Re: Slow SQL with dedicated server? [message #276479 is a reply to message #276447] |
Thu, 25 October 2007 04:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It is much more complicated than that. It depends:
- on your oracle version
- on the use or not of pga_aggregate_target
- on the global worload
...
So it can be:
- slower
- faster
- same thing
Regards
Michel
|
|
|