Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can I use TKPROF in Oracle 10g?

I have always used TKPROF to do SQL tuning in previous versions of Oracle (7,8 and 9). Can I still use TKPROF in Oracle 10g R2?

I have always used TKPROF to do SQL tuning in previous versions of Oracle (7,8 and 9). Can I still use TKPROF in Oracle 10g R2 or do I need to use SQL Advisor with ADDM and AWR?
Yes, you can still use TKPROF. I still use it quite a bit myself when I can identify the specify session causing the problem so I can trace that session. Reading a trace file is a little complicated so TKPROF is very helpful in formatting that into an easier-to-read format.

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close