Home » RDBMS Server » Performance Tuning » bottlenecks
bottlenecks [message #195517] Fri, 29 September 2006 03:00 Go to next message
oracle_coorgi
Messages: 185
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 Go to previous message
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.
Previous Topic: Which is faster count(*),count(1),count(rowid)
Next Topic: performance tools
Goto Forum:
  


Current Time: Sat Dec 10 00:55:24 CST 2016

Total time taken to generate the page: 0.22599 seconds