| Performance tuning in Oracle [message #423843] |
Mon, 28 September 2009 10:24  |
madhuottapalam
Messages: 10
Registered: September 2009
|
Junior Member |
|
|
Oracle Version : 10 G Enterprise 10.2.0.4.0
Is there any tool in oracle using which i can trace all the query running on a Database. Basically, in SQL Server we have SQL Profiler which trace all the query running on a Instance/Database(You can filter for a DB/User/session or by a procedure) . So as a first step in Performance tuning before going to production, what we do is, run profiler and trace all the query(read function/sp) which takes lets say more than 10 sec. Then go to each query and see how we can do query tuning or is it required index creation/defragmenation of data etc.
thanks
Madhu K Nair
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
