| Slow SQL with dedicated server? [message #276419] |
Thu, 25 October 2007 02:15  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
