1 2 Previous Next 15 Replies Latest reply: Feb 7, 2013 4:12 AM by Billy~Verreynne Go to original post RSS
      • 15. Re: Host operating system was experiencing significant paging
        Rob_J
        Hi,

        The best way to look at the general health of the DB is to use the [url http://www.ora00600.com/articles/oracle-awr.html]AWR utility. From that you can get an indication as to what is happening in the DB for the time period you select for the report. It also allows you to drill down to the SQL statements.

        Once you get an overall picture of how the database is performing and where there is potential room for improvement then you know where to start in testing changes.

        Hope that helps,
        Rob
        1 2 Previous Next