Home » RDBMS Server » Performance Tuning » Performance tuning in Oracle (10 G)
Performance tuning in Oracle [message #423843] Mon, 28 September 2009 10:24 Go to next message
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
Re: Performance tuning in Oracle [message #423846 is a reply to message #423843] Mon, 28 September 2009 10:41 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have a read up on statspack and awr reports.
Re: Performance tuning in Oracle [message #423847 is a reply to message #423843] Mon, 28 September 2009 10:41 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
ALTER SESSION SET SQL_TRACE=TRUE
above produces a trace file which is then processed with TKPROF utility.
Re: Performance tuning in Oracle [message #423851 is a reply to message #423847] Mon, 28 September 2009 11:17 Go to previous message
madhuottapalam
Messages: 10
Registered: September 2009
Junior Member
I will try that.. thanks a lot ... BTB... No inbuilt tool with GUI in Enterprise Manager?

Madhu
Previous Topic: Slow query performance
Next Topic: Query tuning
Goto Forum:
  


Current Time: Mon Sep 26 17:54:12 CDT 2016

Total time taken to generate the page: 0.44529 seconds