Home » RDBMS Server » Performance Tuning » Performance Issue
Performance Issue [message #182180] Thu, 13 July 2006 08:01 Go to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member
Hi Guys.

We have a database of which users accesses via a website to pull different kinds of reports and these reports takes a long time to come up,sometimes the website times out,is there anything that can be done from the Db's point of view to make sure that users get reports quickly or are there any other suggestions.And is there any recommended java_pool_size.The Db is 8i running on linux.

Thank you

Report message to a moderator

Re: Performance Issue [message #182194 is a reply to message #182180] Thu, 13 July 2006 09:16 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
There is a lot that can be done. However, there is no magic "go_faster=true" parameter. I suggest you start with the Oracle Performance Tuning Guide.

Report message to a moderator

Previous Topic: how to make it faster
Next Topic: Compressing indexes that have a timestamp in first column.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 12:33:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.