Oracle8 Server Migration Release 8.0 A54650_01

Library Product Contents Index

C
Control File Fixed View Changes in Oracle8

Date Columns in Control File Views

In Oracle7 all control file views date columns are VARCHAR2(20) strings in 'MM/DD/YY HH24:MI:SS' format.

In Oracle8 every new date column is a real DATE column. In contrast to the previous VARCHAR2(20) string, DATE provides users the following benefits:

• Consistency of having all date columns in DATE datatype.
• Easier to perform date arithmetic (including sorting) in SQL and PL/SQL with dates.
• Lets users set their date format using NLS_DATE_FORMAT.
• Users who want to see dates in the old format can set NLS_DATE_FORMAT to MM/DD/YY HH24:MI:SS.
• Avoids two-digit year numbers at the year 2000 and beyond

This appendix lists the names of the views and the names of the columns in the views that have been changed or added to Oracle8. Refer to the Oracle8 Server Reference Manual for descriptions of each column and for a complete listing of the columns in the tables.

Obsolete Views Kept in Oracle8

V$ARCHIVE still shows logs that need archiving.

V$LOG was superceded by V$LOG_HISTORY, which is superseded by the new Oracle8 view, V$ARCHIVED_LOG. In Oracle8, however, V$LOG is still provided and still lists all archived logs in its ARCHIVED column.

The obsolete V$LOGHIST view is retained for historical compatibility.

V$LOG_HISTORY Retained and Upgraded

In Oracle8, several V$LOG_HISTORY columns have been renamed from their Oracle7 column names, as shown in the following table. Further, the (Oracle7) ARCHIVE_NAME column is not present in Oracle8.

V$ARCHIVED_LOG Replaces V$LOG_HISTORY

The new Oracle8 view, V$ARCHIVED_LOG, shows archived logs, including their names. If a log is never archived, the V$ARCHIVED_LOG view does not return any row for that log. If a log is archived twice, V$ARCHIVED_LOG returns two rows for that log. Certain columns in this new view correspond to Oracle7 V$LOG_HISTORY names and use formats that match the column names in other Oracle8 views. The V$ARCHIVED_LOG view shows archived log information from the control file:

An archive log record is inserted each time the online redo log is successfully archived or cleared-the name column is null when the log was cleared. If the log is archived twice, two archive log records are inserted with the same thread#, sequence#, and first_change#, but with different names. An archive log record is inserted also when an archive log is restored from a backup set or a copy.

V$BACKUP_CORRUPTION

The V$BACKUP_CORRUPTION view shows information about corruptions in datafile backups from the control file. Note that corruptions are not tolerated in control file and archived log backups .

V$BACKUP_DATAFILE

The V$bBACKUP_DATAFILE view shows backup datafile and backup control file information from the control file. A datafile backup set can contain one control file and multiple datafiles.

V$BACKUP_DEVICE

The new Oracle8 view, V$BACKUP_DEVICE, shows information about supported backup devices. If a device type does not support named devices, then one row with the device type and a null device name is returned for that device type. If a device type supports named devices then one row is returned for each available device of that type. The special device type DISK is not returned by this view because it is always available.

V$BACKUP_PIECE

The new Oracle8 view, V$BACKUP_PIECE, shows information about backup pieces stored in the control file. Each backup set consist of one or more backup pieces.

V$BACKUP_REDOLOG

The V$BACKUP_REDOLOG view shows information about archived logs in backup sets from the control file. Note that online redo logs cannot be backed up directly, they must be archived first to disk and then backed up. An archive log backup set can contain one or more archived logs. d

V$BACKUP_SET

The V$BACKUP_SET view shows backup set information from the control file. A backup set record is inserted after the backup set is successfully completed.

V$CONTROLFILE_RECORD_SECTION

The new Oracle8 view, V$CONTROLFILE_RECORD_SECTION, shows information about the control file record sections.

V$COPY_CORRUPTION

The new Oracle8 view, V$COPY_CORRUPTION, shows information about datafile copy corruptions from the control file.

V$DATABASE New Columns

The V$DATABASE view shows database information from the control file. The following V$DATABASE columns are new to Oracle8:

V$DATAFILE New Columns

The V$DATAFILE view shows datafile information from the control file. The Oracle8 V$DATAFILE view shows the following new columns in addition to the columns of the existing Oracle7 V$DATAFILE view. See also the view, V$DATAFILE_HEADER, which shows information from datafile headers.

V$DATAFILE_COPY

The V$DATAFILE_COPY view shows datafile copy information from the control file. A datafile copy record is inserted after the datafile (or datafile copy) is successfully copied or restored from a backup set.

V$DATAFILE_HEADER

The new Oracle8 view, V$DATAFILE_HEADER, shows datafile information from the datafile head.

V$DELETED_OBJECT

The new Oracle8 view, V$DELETED_OBJECT, shows information about deleted archived logs, datafile copies, and backup pieces from the control file. The only purpose of this view is to optimize the recovery catalog resync operation. When an archived log, datafile copy or backup piece is deleted also the corresponding record is marked deleted.

V$INSTANCE

The new Oracle8 view, V$INSTANCE, shows status information for the database instance. Returning only one row, it is incompatible with the Oracle7 view, V$INSTANCE, which returns one row per value. The STARTUP_TIME, LOGINS, and SHUTDOWN_PENDING columns return the same information as the Oracle7 version of the V$INSTANCE:

SVRMGR> select startup_time, logins, shutdown_pending from v$instance; 

SQLDBA> select * from v$instance;

Although the Oracle8 V$INSTANCE view is not compatible with the Oracle7 V$INSTANCE view, it does provide the same information and more:

If the instance is not started, a query from this view will signal ORA-1034.

V$OFFLINE_RANGE

The V$OFFLINE_RANGE view shows offline range information from the control file. Note that the most recent offline range of each datafile is stored in the datafile record. V$OFFLINE_RANGE: Datafile offline range information from control file:

Last offline range of each datafile is kept in the datafile record; see the V$DATAFILE view.

V$RESOURCE_LIMIT

The new Oracle8 view, V$RESOURCE_LIMIT, displays information about global resource use for some of the system resources.

V$TABLESPACE

The new Oracle8 view, V$TABLESPACE, shows tablespace information from the control file:

V$THREAD

The V$THREAD view contains thread information from the control file.

Changed Column Types

In Oracle8, the datatype of the following time stamp columns has been changed to DATE from Oracle7 VARCHAR2(20).

Database Scheduling Facilities

The main goal of the Database Scheduling feature is to give more control over

Changed Fixed Views

• V$SESSION has SCHEDULER_CLASS column added
• V$MYSESSION has SCHEDULER_CLASS column added
• DBA_USERS has DEFAULT_SCHEDULER_CLASS column added
• USER_USERS has DEFAULT_SCHEDULER_CLASS column added

New Fixed Views

• V$SERVER_THRESHOLD: data about current server thresholds
• V$SCHEDULER_CLASS: data about currently active scheduler classes
• V$COMMON_SERVER: data about currently active common servers
• V$COMMON_SERVER_REQUEST: data about types of requests currently being processed
• V$COMMON_SERVER_REQUEST_HISTORY: data about types of requests that have been processed
• V$COMMON_SERVER_QUEUE: data about queues of currently active common servers
• DBA_SCHEDULER_CLASS_PRIVS: new DBA view showing all scheduler classes and users/roles to which they have been granted
• DBA_SCHEDULER_CLASSES: new DBA view showing all scheduler classes that exist in the database
• DBA_SCHEDULER_PLANS: new DBA view showing all scheduler plans that exist in the database
• DBA_SCHEDULER_PLAN_ENTRIES: new DBA view showing all scheduler plan entries that exist in the database
• SCHEDULER_CLASS_POLICIES: new DBA view showing all available scheduling policies for scheduler classes
• SCHEDULER_PLAN_POLICIES: new DBA view showing all available scheduling policies for scheduler plans
• USER_SCHEDULER_CLASS_PRIVS: new PUBLIC view showing all scheduler classes granted to the user

Table (View) Name Changes

Prev Next

Copyright © 1997 Oracle Corporation. All Rights Reserved.

Library Product Contents Index