1 2 Previous Next 16 Replies Latest reply: Feb 26, 2013 1:23 AM by Moazzam Go to original post RSS
      • 15. Re: Find undo used by a session
        Moazzam
        >
        why are you looking for undo space for a session?
        >

        The undo is generated on master site (source table) during fast refresh of MV. The database especially undo tablespace which has fixed size, on master site is not in our control. Therefore, we want to get some guess as how much undo is being generated on local and remote sites during fast refresh of MV.

        Can any body tell me why undo is being generated on remote site although DML operations are performed on local site during synchronization by MV?

        I have posted separate question for this purpose:

        Unable to extend undo tabespace issue in Materialized view on remote site

        >
        As such there is no view/way to get the correct info which you are going to ask. Oracle don't have undo_generated_history kind of thing.
        >

        Thanks. I just want this confirmation.

        Edited by: Moazzam on Feb 25, 2013 3:54 PM
        • 16. Re: Find undo used by a session
          Moazzam
          >
          Can any body tell me why undo is being generated on remote site although DML operations are performed on local site during synchronization by MV?
          >

          After further investigation it is found that after successfully synchronizing the table data, on remote site, the mateiralized view log is deleted. During this operations UNDO is generated.
          1 2 Previous Next