|
|
Posted by DA Morgan on 05/04/06 20:42
mleal wrote:
> Does anyone have some more detailed information about how Oracle and MS
> implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
> differences between them?
>
> Which of them, In a deep comparison about it, allow better tuning and
> why.
>
>
> Regards,
> Marcio Evangelista
The tuning on the two systems is vastly different from multiple
standpoints. Speak with respect to Oracle most tuning done these
days is done using built-in tools that take advantage of Oracle's
wait interface, AWR (Automated Workload Repository) and ASH (Active
Session History).
Included in the Oracle kernel is an instrumented capability to see
and evaluate what is happening at both the database, operating
system, and hardware levels. Statistics are collected at predetermined
intervals (often enough to be useful, not so often as to burden the
system) and can be viewed through SQL queries (used by the dinosaurs)
through OEM, DBConsole, and the Grid Control.
When I look to tune queries in Oracle I use EXPLAIN PLAN AUTOTRACE,
and 10046 and 10053 traces. In 9i I use StatsPack. In 10g I use AWR,
ASH, and the Grid.
If you want to get an idea of the granularity of information
instrumented in Oracle go to www.psoug.org. Click on Morgan's Library,
then click on DBMS_SERVER_ALERT. The tables at the top of the page
show most of the metrics collected.
HTH
Daniel Morgan
www.psoug.org
Navigation:
[Reply to this message]
|