You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for V$LOG


1 to 20 of 8834 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 12c Release 1 (12.1)

V$LOG

8.40 V$LOGV$LOG displays log file information from the control file. Column Datatype Description GROUP … # NUMBER Log group number THREAD# NUMBER Log thread number SEQUENCE# NUMBER Log sequence number BYTES … NUMBER Size of the log (in bytes) BLOCKSIZE NUMBER Block size of the

Database Administrator's Guide, 12c Release 1 (12.1)

Managing the Redo Log

11.5.2 Dropping Redo Log Membersuntil the other members become valid. To see a redo log file status, use the V$LOGFILE view. A redo … . To see whether this has happened, use the V$LOG view. To drop specific inactive redo log members … You can drop redo log members. To drop a redo log member, you must

Database Administrator's Guide, 12c Release 1 (12.1)

Managing the Redo Log

11.5.1 Dropping Log Groupsthe V$LOG view. SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG; GROUP# ARC STATUS … You can drop a redo log group. To drop a redo log group, you must have the ALTER DATABASE system … privilege. Before dropping a redo log group, consider the following restrictions and precautions:

Database Administrator's Guide, 12c Release 1 (12.1)

Managing the Redo Log

11.10 Redo Log Data Dictionary Viewsviews provide information on redo logs. View Description V$LOG Displays the redo log file information … from the control file V$LOGFILE Identifies redo log groups and members and member status V$LOG_HISTORY … , FIRST_CHANGE#, FIRST_TIME FROM V$LOG; GROUP#

Database Administrator's Guide, 12c Release 1 (12.1)

Managing the Redo Log

11.2.4 Planning the Block Size of Redo Log Files> SELECT BLOCKSIZE FROM V$LOG; BLOCKSIZE --------- 512 See Also: Oracle Database SQL Language Reference for … Unlike the database block size, which can be between 2K and 32K, redo log files always default to a … detect this larger sector size. The database then automatically creates redo log files with a 4K

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Archived Redo Log Files

12.8.1 Archived Redo Log Files Viewscatalog, the RC_BACKUP_REDOLOG contains similar information. V$LOG Displays all redo log groups for the … database and indicates which need to be archived. V$LOG_HISTORY Contains log history information such … You can query a set of dynamic performance views for information about archived redo log

Database Reference, 12c Release 1 (12.1)

V$ARCHIVE

7.22 V$ARCHIVEV$ARCHIVE displays information about redo log files in need of archiving. Each row displays … information for one thread. This information is also available in V$LOG. Oracle recommends that you use V … $LOG. See Also: \" V$LOG \" Column Datatype Description

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Performing User-Managed Recovery: Advanced Scenarios

Recovering After the Loss of Online Redo Log Filesdisplays V$LOG status information that can be crucial in a recovery situation involving online redo logs … . Table 31-3 STATUS Column of V$LOG Status Description UNUSED The online redo log has never been … procedure depends on the following considerations: The configuration of the online redo log:

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

About Setting Database Initialization Parameters for Use with Oracle ASM

About Setting Database Initialization Parameters for Use with Oracle ASM*1024) FROM V$LOGFILE a, V$LOG b WHERE a.group#=b.group#; SELECT SUM(bytes)/(1024*1024*1024) FROM V … aggregated value as input. SELECT SUM(bytes)/(1024*1024*1024) FROM V$DATAFILE; SELECT SUM(bytes)/(1024*1024

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Performing User-Managed Recovery: Advanced Scenarios

Recovering After Losing All Members of an Online Redo Log Groupgroup is active or inactive. Locate the file name of the lost redo log in V$LOGFILE and then look … following SQL query (sample output included): SELECT GROUP#, MEMBERS, STATUS, ARCHIVED FROM V$LOG; GROUP … If a media failure damages all members of an online redo log group, then different scenarios can

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Migrating the Database to Oracle ASM Using RMAN

Migrating the Database to Oracle ASM Using RMAN# GRP, THREAD# THR, BYTES, 'NO' SRL FROM V$LOG UNION SELECT GROUP# GRP, THREAD# THR, BYTES, 'YES' SRL … TEMPFILE; Migrate the online redo log files. If this is a primary database, then add new log group members … online redo log groups into an Oracle ASM disk group. The PL/SQL script assumes that the

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents8.36 V$LOCK 8.37 V$LOCK_ACTIVITY 8.38 V$LOCK_TYPE 8.39 V$LOCKED_OBJECT 8.40 V$LOG 8.41 V$LOG_HISTORY … USER_ZONEMAP_MEASURES 6.624 USER_ZONEMAPS Part III Dynamic Performance Views 7 Dynamic Performance (V … $) Views: V$ACCESS to V$HVMASTER_INFO

Database Backup and Recovery Reference, 12c Release 1 (12.1)

Summary of RMAN Recovery Catalog Views

Summary of RMAN Recovery Catalog ViewsView Description RC_ARCHIVED_LOG V$ARCHIVED_LOG Archived and unarchived redo log files … RC_BACKUP_ARCHIVELOG_DETAILS V$BACKUP_ARCHIVELOG_DETAILS Details about archived redo log backups for Enterprise … archived redo log backups for Enterprise Manager RC_BACKUP_CONTROLFILE V$BACKUP_DATAFILE

Database SQL Language Reference, 12c Release 1 (12.1)

LOG

LOGSyntax Description of the illustration ''log.gif'' Purpose LOG returns the logarithm, base n2, of … returns the log of 100: SELECT LOG(10,100) \"Log base 10 of 100\" FROM DUAL; Log base 10 of 100 ------------------ 2

Database SQL Language Reference, 12c Release 1 (12.1)

ALTER DATABASE

ALTER DATABASEthe THREAD clause to assign the log file group to a specific primary database redo thread. Query the V … dynamic performance view V$LOG. redo_log_file_spec   Each redo_log_file_spec specifies a redo log file … current log sequence number to 1, archives any unarchived logs (including

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Managing Physical and Snapshot Standby Databases

10.5 Monitoring Primary, Physical Standby, and Snapshot Standby Databasesredo thread Alert log V$THREAD Alert log Display database role, protection mode, protection level … redo log file group Alert log V$LOG STATUS column of V$LOGFILE Alert log CREATE CONTROLFILE Alert … log Alert log

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

List of Tables

List of TablesOptimization 6-1 Channel Control Options 7-1 V$SYSSTAT Statistics 9-1 Sample Archived Redo Log Records 9-2 … Lost 31-2 Options for Creating the Control File 31-3 STATUS Column of V$LOG 31-4 Recovering After the Loss of an Online Redo Log Group … Auxiliary Database 23-1 Data File Read Buffer Sizing Algorithm

Database Reference, 12c Release 1 (12.1)

DBA_HIST_LOG

5.7 DBA_HIST_LOGsnapshots of V$LOG. Column Datatype NULL Description SNAP_ID NUMBER NOT NULL Unique snapshot ID DBID … container ID for the rows containing data See Also: \" V$LOG \" … DBA_HIST_LOG displays historical log file information from the control file. This view contains … snapshot GROUP# NUMBER NOT

Database SQL Language Reference, 12c Release 1 (12.1)

CREATE DATABASE

CREATE DATABASElog file group through the dynamic performance view V$LOG. MAXLOGFILES Clause Specify the maximum … handle redo log files for this database. LOGFILE Clause Specify one or more files to be used as … redo log files. Use the redo_log_file_spec form of file_specification to create regular redo log

OLAP User's Guide, 12c Release 1 (12.1)

Administering Oracle OLAP

Table 7-5 Selected Database Performance ViewsView Description V$LOG Displays log file information from the control file. V$LOGFILE Contains … information about redo log files. V$PGASTAT Provides PGA memory usage statistics and statistics about … the automatic PGA memory manager when PGA_AGGREGATE_TARGET is set. V$ROWCACHE