Monitoring and tuning database performance

I am writing some coursework for students that describes the tools used to
monitor and tune database performance in Oracle. I have experience of doing
this in MS SQL Server, but not in Oracle.

What tools do you guys use in order to achieve this in Oracle? For example
how do I find out the most common transactions? How do I monitor hardware
resource usage?

I am using Windows XP and Oracle 10g.


.

Relevant Pages

  • Re: Tools for Oracle DBAs
    ... Try to download Twisted Nail for Oracle. ... *Monitor alert.log file to find out ORA-nnnnn error messages ... events, Multi-Thread Servers, Real Application Cluster ... *Kill oracle session and OS kill ...
    (comp.databases.oracle.server)
  • Re: Display question
    ... On November 16, 2004 08:04 pm, Bob Metelsky wrote: ... > DBA and am setting up Oracle RAC in a lab environment, ... > on a 17 in monitor ... then restart X and you will be able to cycle thru the resolutions with "ctrl ...
    (RedHat)
  • Re: Monitor Transaction log
    ... Not really a publication but a simple monitoring tool to update another app ... if anything changes on the SQL or Oracle. ... is only a few tables and monitor the change ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Application, session and performance.
    ... I need to monitor the performance of an application that executes ... queries against an Oracle database. ... Long-running queries. ... Can YOU modify the application you are being asked to monitor? ...
    (comp.databases.oracle.server)
  • Re: SQL Sniffer
    ... > Has anyone an idea how I could monitor the SQL-Statements, ... Wolfgang, please give versionof db used. ... Oracle, 9.2.0.1.0 ... time analysing and attempting to help, ...
    (comp.databases.oracle.misc)