| Tuning Parameters for 10gAS [message #117391] |
Tue, 26 April 2005 20:32  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
