Managing undo data

Xem 1-7 trên 7 kết quả Managing undo data
  • Managing Undo Data Automatic Undo Management The Oracle server automatically manages the creation, allocation, and tuning of undo segments. Manual Undo Management You manually manage the creation, allocation, and tuning of undo segments. It was the only method available prior to Oracle9i. Information about manual undo management can be found in “Appendix B: Manually Managing Undo Data.”

    ppt32p trinh02 28-01-2013 28 3   Download

  • Allocation of a Rollback Segment When a transaction begins, a rollback segment must be assigned to this transaction. A transaction can request a specific rollback segment using the following command: SET TRANSACTION USE ROLLBACK SEGMENT rollback_segment If no such request is made, the Oracle server chooses the rollback segment with the fewest transactions and assigns it to the transaction. Using Extents Transactions use extents of a rollback segment in a sequential, circular fashion, moving from one to the next after the current extent is full.

    ppt22p trinh02 28-01-2013 38 3   Download

  • After completing this lesson, you should be able to do the following: Describe the concept of automatic undo management Create and maintain the automatic managed undo tablespace Set the retention period Use dynamic performance views to check rollback segment performance Reconfigure and monitor rollback segments Define the number and sizes of rollback segments Allocate rollback segments to transactions

    ppt36p trinh02 28-01-2013 20 4   Download

  • Small shared pool Small database buffer cache Small redo log buffer cache Missing indexes Rollback segments and undo tablespace Sort area size incorrectly set Assorted

    ppt16p trinh02 28-01-2013 35 4   Download

  • Oracle Universal Installer The Java-based Oracle Universal Installer offers an installation solution for all Java-enabled platforms, allowing for a common installation flow and user experience independent of the platform. The Universal Installer Detects dependencies among components and performs an installation accordingly Can be used to point to a URL where a release or staging area was defined and install software remotely over HTTP Can be used to remove products installed. The deinstallation actions are the “undo” of installation actions.

    ppt22p trinh02 28-01-2013 20 3   Download

  • Using Online Redo Log Files Online redo log files provide the means to redo transactions in the event of a database failure. Every transaction is written synchronously to the Redo Log Buffer, then gets flushed to the online redo log files in order to provide a recovery mechanism in case of media failure. (With exceptions such as direct load inserts in objects with the NOLOGGING clause enabled.) This includes transactions that have not yet been committed, undo segment information, and schema and object management statements.

    ppt30p trinh02 28-01-2013 23 3   Download

  • The simplest way to think of Oracle’s implementation of read consistency is to imagine each user operating a private copy of the database, hence the multiversion consistency model. Read Consistency, Undo Records, and Transactions To manage the multiversion consistency model, Oracle must create a read-consistent set of data when a table is queried (read) and simultaneously updated (written). When an update occurs, the original data values changed by the update are recorded in the database undo records.

    pdf542p nhacsihuytuan 13-04-2013 17 2   Download


Đồng bộ tài khoản