MEMORY MANAGEMENT Oracle Interview Questions [114 Questions]

  1. Materialized View RefreshHi All,


    I have a Materialized views Group, on this group I have 57 MVs these are all created on Master data (OLAP) log files and we have dependency schedule to run this jobs. Load dependency is like (MD tabs Then  Log files MVs) this is not a problem with us.

    For 57 views to get updated (refreshed) in 4 hours in these views one view is taking nearly 2 hours to update. We are updating this group using shell script as Batch dependency.

    Refresh type: Force complete
    On demand
    In this view we have simple select statement only and it is contains nearly 10 million records as this is taking more than two hours to update and reaming 56 views are taking 1 hour only.

    Here my question is.

    For reduce the Batch time, we want divide the group into 2 groups and trying to run simultaneously (we want to change Shell script).

    Can you please let me know; is this working fine or not?

    Hope I would get valid advises from DB experts.
  2. Oracle Shared poolWhat is meant by Shared pool fragmentation.
  3. Enterprise Linux OS Block SizeMy platform is Enterprise Linux (RHEL AS4) How to find BLOCK SIZE.
  4. What is the difference between Row Changing and Row Migration ?Migration and Changing are two distinctly different types of problems that can exist when a row is too large to fit into a single data block.

    Row Changing:: Row changing occurs when a row is too large to fit into a single empty data block. When this occurs, Oracle will spread the row across as many blocks as are needed. Changing the row from from one block to the next.

    Row Migration:: Row migration occurs when a row is updated and it will not fit back into the original block. When this happens, the Oracle server attempts to find another block that the entire row can be moved to. If it does find a block, the entire row is moved to the new block. The row piece(head ROWID) remains in the original block, with original ROWID and points to the migrated rowin the new block.
  5. Why we do use very small size of RAM compairing then HARD DISK?
  6. You must first Login or Register to view all 114 questions from this category.


    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.