1 2 Previous Next 15 Replies Latest reply on Feb 7, 2013 10:22 AM by Rob_J Go to original post
      • 15. Re: Host operating system was experiencing significant paging

        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,
        1 2 Previous Next