Home » RDBMS Server » Performance Tuning » Slow SQL with dedicated server?
Slow SQL with dedicated server? [message #276419] Thu, 25 October 2007 02:15 Go to next message
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 #276427 is a reply to message #276419] Thu, 25 October 2007 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64125
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation between query execution time and server type?

Regards
Michel
Re: Slow SQL with dedicated server? [message #276447 is a reply to message #276427] Thu, 25 October 2007 03:23 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Well, maybe the executiontimes will be lower with Shared Server? If you configure it correctly, that is...but Im quite sure that the problem is found else where.
Re: Slow SQL with dedicated server? [message #276466 is a reply to message #276447] Thu, 25 October 2007 04:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can you post here ...execution plan ...10046 wait event for that query.

Re: Slow SQL with dedicated server? [message #276479 is a reply to message #276447] Thu, 25 October 2007 04:52 Go to previous message
Michel Cadot
Messages: 64125
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
Previous Topic: materialized view
Next Topic: find the query/plsql block which is causing performance hurt
Goto Forum:
  


Current Time: Wed Dec 07 06:43:06 CST 2016

Total time taken to generate the page: 0.30217 seconds