| bottlenecks [message #195517] |
Fri, 29 September 2006 03:00  |
oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka
|
Senior Member |
|
|
hi
pls provide me with info on
Identifying the bottlenecks at the Database and as well as at Operating System which includes Memory utilization, I/O, CPU consumption, Identifying the SQL’s that can be tuned etc
Analyzing the database performance at peak hours and resolving the bottlenecks using tools like SQL Trace, Trace Analyzer, Statspack.
thanxs
[Updated on: Fri, 29 September 2006 03:09] Report message to a moderator |
|
|
|
| Re: bottlenecks [message #195600 is a reply to message #195517] |
Fri, 29 September 2006 10:39  |
skn
Messages: 6
Registered: September 2006
|
Junior Member |
|
|
Try the tool 'TOAD for oracle' for trace and execution plans.
Also you can use query viewer, script debugger and codexpert.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
