Home » RDBMS Server » Performance Tuning » bottlenecks
bottlenecks [message #195517] Fri, 29 September 2006 03:00 Go to next message
Messages: 188
Registered: September 2006
Location: INDIA-karnataka
Senior Member
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.


[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 Go to previous message
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.
Previous Topic: Inefficient sql
Next Topic: Rosco's Performance Tuning Guide
Goto Forum:

Current Time: Sun Aug 20 10:41:45 CDT 2017

Total time taken to generate the page: 0.04484 seconds