How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
8.40 V$LOG → V$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
11.5.2 Dropping Redo Log Members → until 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
11.5.1 Dropping Log Groups → the 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:
11.10 Redo Log Data Dictionary Views → views 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#
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
12.8.1 Archived Redo Log Files Views → catalog, 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
7.22 V$ARCHIVE → V$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
Recovering After the Loss of Online Redo Log Files → displays 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:
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
Recovering After Losing All Members of an Online Redo Log Group → group 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
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
Contents → 8.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
Summary of RMAN Recovery Catalog Views → View 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
ALTER DATABASE → the 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
LOG → Syntax 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
List of Tables → Optimization 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
10.5 Monitoring Primary, Physical Standby, and Snapshot Standby Databases → redo 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
CREATE DATABASE → log 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
5.7 DBA_HIST_LOG → snapshots 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
Table 7-5 Selected Database Performance Views → View 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