Home » RDBMS Server » Performance Tuning » simultaneous query processing (11g,solaris (urgent))
simultaneous query processing [message #453952] Mon, 03 May 2010 02:46 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Hi all,

I am running some warehouse related queries simultaneously which on the whole is taking much time.
But when the same queries are run individually they take less time. Is there any way I can make the simultaneous queries run faster by changing any system/session related parameters

Report message to a moderator

Re: simultaneous query processing [message #453960 is a reply to message #453952] Mon, 03 May 2010 03:36 Go to previous message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enlarge db cache size and pga_aggregate_target (if used) or hash/sort area size but it depends on execution plans.

Regards
Michel

Report message to a moderator

Previous Topic: Interpreting tuning task Report
Next Topic: Tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 13 14:45:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.