Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
The Data Dictionary
|
123
Log group views
A log group is used to multiplex standby log files across dif-
ferent locations, for the purpose of reducing the impact of a
disk failure disaster on the recovery process. The following
views provide information about log groups:
Materialized view views
A materialized view is a view that is used to speed up data
warehouse queries with precalculated aggregates. The fol-
lowing views provide information about materialized views:
Networking and distributed transaction views
The following views provide information about the status of
Oracle networking, remote databases, and distributed trans-
actions to these remote databases:
*_LOCKS
Lists all locks held or requested in the database.
*_WAITERS
Lists all sessions that are waiting on a lock held by
another session.
DBMS_LOCK_ALLOCATED
Shows which locks the current user has allocated.
*_LOG_GROUPS
Lists the tables that are associated with log groups.
*_LOG_GROUP_COLUMNS
Lists the columns assigned to log groups.
*_BASE_TABLE_MVIEWS
Lists information about existing materialized views.
*_MVIEW_LOGS
Lists information about materialized view logs, which
track changes to the master tables that can be used to
refresh the materialized views.
*_2PC_NEIGHBORS
Contains information about the commit point for
distributed transactions listed in *_2PC_PENDING.
*_2PC_PENDING
Lists information about distributed transactions
requiring recovery.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843