Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Tuning Parameters for 10gAS
Tuning Parameters for 10gAS [message #117391] Tue, 26 April 2005 20:32 Go to next message
qnhu
Messages: 3
Registered: April 2005
Location: California
Junior Member
I would like to know what parameters I should focus on to tune Oracle apps running on 10gAS? The same report running on client/server mode is so much faster than on 10g. Thanks for your help.

Nhu
Re: Tuning Parameters for 10gAS [message #117503 is a reply to message #117391] Wed, 27 April 2005 10:35 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I assume you have given your app server time to warm up by running the report a few times? I would personally try running a sql_trace at the db level because that's easiest to do. If your app server is on a separate box, you could also just run "top" on the app server or database server to see if you can see which box the load is on. Obviously you could get false leads if there is other activity on the boxes...

Try searching on metalink.oracle.com for ideas - or logging a TAR.
Previous Topic: how to get network application information?
Next Topic: ORACLE Internet directory
Goto Forum:
  


Current Time: Thu Mar 28 07:41:33 CDT 2024