검색을 통해 이슈를 손쉽게 찾아보세요: #<이슈 ID>
예시: #1832
다음의 검색으로 회원을 쉽게 찾으세요: <사용자 이름>, <명> 와 <성>.
예시: smith를 검색하면, smith 와 adamsmith의 검색결과를 가져옵니다.
| Oracle DBA Tools - Rollback Manager Provides the monitoring and maintenance of rollback segments, including current statements, transactions and execution plans. |
|
| Toolbar Operations - Refresh : Will refresh all tabs in the rollback manager from the database Create Rollback Segment: Create a new rollback segment Edit Rollback Segment: Edit selected rollback segment Drop Rollback Segment: Drop selected rollback segment Rollback Segment Properties: View properties of selected rollback segment Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds" |
|
| General Tab - Provides a list of available rollback segments Segment: Name of the rollback segment Owner: Owner of the rollback segment Tablespace: Name of the tablespace containing the rollback segment Status: Rollback segment status Transactions: Number of active transactions Initial: Initial extent size Next: Secondary extent size PCT Increase: Percent increase for extent size Current: Size of the rollback segment Optimal: Optimal size of the rollback segment Used: Current size of active extents, averaged over time Extents: Number of extents in the rollback segment Current: Current extent Block: Current block Gets: Number of header gets Waits: Number of header waits Hit Rate: (Gets-Waits)*100/Gets USN: ID number of the rollback segment |
|
| Transaction Users Tab - Provides a list of active transactions on the selected rollback segment Rollback Seg: ID number of the rollback segment Session ID: Session identifier Serial #: Session serial number OS User: Operating System client user name Oracle User: Oracle username Start Time: Starting time of the operation Status: Status of the session |
|
| Current Statement Tab - The current SQL statement on the select transaction. |
|
| Open Cursors Tab - Provides a list of open cursors on the session ID of the selected transaction SQL: SQL Text for the open cursor Last Loaded: Time at which the query plan was loaded into the library cache |
|