Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

SQL Performance Analyzer in Oracle Database 11g Release 1 - Compare the performance of the statements in an SQL tuning set before and after database changes.



Greg said...

Very clear, very good :)

Vengata said...

Thanks Tim for all the new features of 11g...you are doing a gr8 job by simplifying all the concepts and explaining with simple examples.

Shubha said...

How do I compare 2 tasks run on diff machines for same sql set. I dont want to run the sql over dblink. Intent is to find on which machine sqls performed well.


Tim... said...

Hi.

Run the same statement on both servers, using the analyze on each server individually.

Cheers

Tim...

MASK said...

Hi Tim,
You have explained this topic in a very easy way….. Please carry on your good work….God Bless you…

rogers42 said...

Hi Tim,

All in all, a great tutorial. However using the command line interface, I cannot seem to generate the comparison report. All I see is the report header ?

Has anybody else run into the same problem?

Thanks

Tim... said...

Hi.

Not seen that problem myself. Perhaps you should start a thread in the forum and give a bit more detail about what you are doing and the result you are getting. :)

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired