English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (423)
PLSQL (1)
PMI (5)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 9i: New Features For Administrators 

АвторSubject: Q92
written 19 January 2008 10:10   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
This view displays a histogram of statistical data to show how well the system is working. Each row in the view keeps statistics collected in the instance for a 10-minute interval.You can use this view to estimate the amount of undo space required for the current workload. The database uses this view to tune undo usage in the system. This view is available in both SMU (system managed undo) mode and RBU (rollback segment undo) mode.
Incorrect Answers:
2: This dynamic view contains rollback segment statistics.
3: This dynamic view lists the active transactions in the system
4: The DBA_UNDO_EXTENTS data dictionary view is used to show information about extents in the UNDO segments.
5: The DBA_ROLLBACK_SEGS data dictionary view contains information about rollback segments.
Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-164
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 24-25
Chapter 1: Oracle9i Database Administration and Management Features

Current tread:
back to list

Q92 - Go to question 10:10 19.01.08

back to list
Up ^ gen. 0.068 Server date 10:34 09-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments