4 Replies Latest reply: May 10, 2013 11:43 PM by Alvaro RSS

    Alert log

    1000471
      1)How to monitor alert log file (using any tool or manual)?

      2) What are the implications of a database with multiple data block sizes?

      with regards
        • 1. Re: Alert log
          sb92075
          997468 wrote:
          1)How to monitor alert log file (using any tool or manual)?
          EXTERNAL TABLE

          >
          2) What are the implications of a database with multiple data block sizes?
          Most likely the person who did it did not know what he was doing.
          • 2. Re: Alert log
            TSharma-Oracle
            1)How to monitor alert log file (using any tool or manual)?
            You can use tool like OEM and have the alert setup on errors OR you can make your own script which will run periodically and checks for errors.
            2) What are the implications of a database with multiple data block sizes?
            No implications if you use those appropriately.
            • 3. Re: Alert log
              jgarry
              997468 wrote:
              1)How to monitor alert log file (using any tool or manual)?
              It varies by version.
              2) What are the implications of a database with multiple data block sizes?
              What sb said, with the possible exception of what the feature was designed for, transportable tablespaces.

              >
              with regards
              • 4. Re: Alert log
                Alvaro
                1) If on 11g, I would reccomend ADRCI.

                2) The implications are many. Database block size impacts how oracle access and manage your data and it's caches. As a general guideline a larger block tablespace is used for large sequential full table scans. Smaller blocksizes are used for improving sessions that typically do random access and retrieve only one row or two, and those are small rows. But again, this is just the tip of the iceberg, there are many more implications regarding buffer cache, metadata, block contention and so on.

                Edited by: Alvaro on 10/05/2013 21:42