September 10, 2018 at 1:11 am
I have been asked to tune a query in Oracle. I know about SQL Server estimate execution plan and other tools to find out if indexing is required but for Oracle, I need some tool that can use to tune for indexing, if there is any one who works on Oracle too, can fine tune a query or provide such a free tool that can fasten the query, May I post it here? or where can i Post for help?
Regards,
September 10, 2018 at 3:48 am
Hi,
Well, perhaps an Oracle forum would be a better place to submit this demand...
Anyway... What is the edition and the version of this database ? If it's Enterprise Edition AND if the extra cost features Diagnostic Packs and Tuning Packs have been purchased (it's not exactly a free tool... but if you already have the appropriate licenses, why not use it ?), then you can use SQL Access Advisor in Enterprise Manager to obtain tuning suggestions...
But have you tried to simply display the execution plan of this query ?
Regards,
September 10, 2018 at 9:05 am
Regarding oracle tuning I refer to orafaq How to tune SQL or Identify Performance Problem and Bottleneck
September 10, 2018 at 10:49 am
Pierre Moyroud - Monday, September 10, 2018 3:48 AMHi,Well, perhaps an Oracle forum would be a better place to submit this demand...
Anyway... What is the edition and the version of this database ? If it's Enterprise Edition AND if the extra cost features Diagnostic Packs and Tuning Packs have been purchased (it's not exactly a free tool... but if you already have the appropriate licenses, why not use it ?), then you can use SQL Access Advisor in Enterprise Manager to obtain tuning suggestions...
But have you tried to simply display the execution plan of this query ?
Regards,
Yup...an Oracle forum would be best. In addition to Access Advisor, Another option would be to look at using Statspack:
Oracle Statspack Survival Guide
Sue
September 10, 2018 at 1:46 pm
If you work regularly with Oracle I would also push for Toad for Oracle. It will provide tools for query performance tuning. Not free, but if I had to work with Oracle again it is a product I would strongly advocate getting.
September 10, 2018 at 2:54 pm
Lynn Pettis - Monday, September 10, 2018 1:46 PMIf you work regularly with Oracle I would also push for Toad for Oracle. It will provide tools for query performance tuning. Not free, but if I had to work with Oracle again it is a product I would strongly advocate getting.
I second this recommendation... before my time with SQL Server I worked with Oracle and I found TOAD to be my go-to tool.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply