Help - Search - Members - Calendar
Full Version: SQL Analyzer
Oracle DBA Forums > Oracle > Oracle Forum
jstoner
Hello,

I am not really a specialist in SQL tuning and currently
covering the DBA who seems to be away today. We have some
queries which are consuming a lot of i/o and memory.

I understand I can upload a statspack report for analysis and
recommendations and was wondering whether there was something
similar where I can upload a SQL statement and it will provide recommendations
on how best to tune the query or suggestions:

Your help will be much appreciated
dave
oracle version? os?
Littlewheat
Hi jstoner,
on 10g (and higher) is possible for gathering statistic use ADDM
(Automatic Database Diagnostic Monitor) available in OEM.
(without install STATSPACK)
jstoner
Thanks for you info, but this is not what I really want.

I am after a site or similar where I can paste the copy of a SQL statement and the tool/program and it will provide a recommendqtion of whqt to do with the statement. I mean if you are not specialised in SQL tuning, but need to improve the execution of the statement how can you do this in a simple way. We now have a way to upload statspack reports, saving you endless hours, hopefully there is something similar for SQL statements. ADDM and OEM do not do this

jstoner
HAL9000
"a site or similar where I can paste the copy of a SQL statement and the tool/program and it will provide a recommendqtion of whqt to do with the statement. "

I've never heard of one.

SQL tuning depends on dictionary statistics, the external I/O system, and many other things besides the SQL statement itself.

Here is a list of the step of SQL tuning:

http://www.dba-oracle.com/art_sql_tune.htm
jstoner
Hello again,

without sounding condesending, still not getting the correct feedback.
Without knowing much about Oracle Perf, I can generate a statspack report,
upload that report and recieve recommendations, based on the values in my statspack.

I was hoping that there is something similar for SQL statements which run for a length
of time. I do not want to relearn SQL (time issue) as I am only standing in for the official
DBA who returns on Monday.

I would have expected that there is a tool, which takes the statement and makes
recommendations on the efficiency and resource cost of the code.

Thanks again
aussie_dba
"I was hoping that there is something similar for SQL statements "

No, there is not.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.