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$CONTROLFILE


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


Database Reference, 12c Release 1 (12.1)

V$CONTROLFILE

7.124 V$CONTROLFILEV$CONTROLFILE displays the names of the control files. Column Datatype Description STATUS VARCHAR2

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

Managing Control Files

10.8 Control Files Data Dictionary Viewsinformation from the control file V$CONTROLFILE Lists the names of control files V$CONTROLFILE_RECORD_SECTION … control files. SQL> SELECT NAME FROM V$CONTROLFILE; NAME ------------------------------------- /u01 … views display information about control files: View Description V$DATABASE

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

CREATE CONTROLFILE

CREATE CONTROLFILEThe CREATE CONTROLFILE statement should be used in only a few cases. Use this statement to re … DBNEWID utility rather than the CREATE CONTROLFILE statement. DBNEWID is preferable because no OPEN … for more information about the DBNEWID utility ALTER DATABASE \"BACKUP CONTROLFILE Clause\" for … issue a CREATE CONTROLFILE

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

Making User-Managed Database Backups

Listing Database Files Before a BackupUse the V$DATAFILE and V$CONTROLFILE views to identify the data files and control files for your … the current control files by querying the V$CONTROLFILE view. For example, issue the following query … : SELECT NAME FROM V$CONTROLFILE; You only need to back up one copy

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

file_specification

file_specificationfor data files, V$CONTROLFILE for control files, and so on). You can also obtain the filenumber and … a disk group file. A file_specification can appear in the following statements: CREATE CONTROLFILE … (see CREATE CONTROLFILE ) CREATE DATABASE (see CREATE DATABASE ) ALTER DATABASE (see ALTER DATABASE … disk groups

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

DESCRIBE

DESCRIBEdescribes the V$CONTROLFILE table: RMAN> desc v$controlfile Name Null? Type

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents$CONFIGURED_INTERCONNECTS 7.122 V$CONTAINERS 7.123 V$CONTEXT 7.124 V$CONTROLFILE 7.125 V … USER_ZONEMAP_MEASURES 6.624 USER_ZONEMAPS Part III Dynamic Performance Views 7 Dynamic Performance (V … $) Views: V$ACCESS to V$HVMASTER_INFO 7.1 About Dynamic

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

Managing Control Files

10.4.2 Handling Errors During CREATE CONTROLFILEcreating a new control file, the most likely cause is that you omitted a file from the CREATE CONTROLFILE

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

Managing Control Files

Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files.will produce one. SELECT MEMBER FROM V$LOGFILE; SELECT NAME FROM V$DATAFILE; SELECT VALUE FROM VCONTROLFILE statement. When creating a new control file, specify the RESETLOGS clause if you have lost

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

Using File Mapping Views With Oracle ASM Files

Using File Mapping Views With Oracle ASM Files… These views include V$MAP_COMP_LIST, V$MAP_ELEMENT, V$MAP_EXT_ELEMENT, V$MAP_FILE, V … $MAP_FILE_EXTENT, V$MAP_FILE_IO_STACK, V$MAP_LIBRARY, and V$MAP_SUBELEMENT. For example, you can view file … mappings with V$MAP_FILE. SQL>

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

Distributed Database Management

Part V Distributed Database ManagementYou can manage a distributed database environment.

Database Concepts, 12c Release 1 (12.1)

Oracle Instance Architecture

Part V Oracle Instance ArchitectureThis part describes the basic structural architecture of the Oracle database instance. This part contains the following chapters: Oracle Database Instance Memory Architecture Process Architecture Application and Networking Architecture

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics

Part V Optimizer StatisticsThe optimizer relies on statistics to create execution plans. This part contains the following chapters: Optimizer Statistics Concepts Histograms Managing Optimizer Statistics: Basic Topics Managing Optimizer Statistics: Advanced Topics

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

find

findsearch for control files by specifying type as CONTROLFILE. Valid values for type are listed in … Table 5-1. These are type values from the type column of the V$ASM_FILE view. Examples The following are … with undo. The second example returns the absolute path of all the control files ( --type CONTROLFILE … undo* +data/ORCL/DATAFILE/UNDOTBS1.258.691577151

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

PL/SQL Subprograms

PL/SQL Functions that SQL Statements Can InvokePackages and Types Reference. Dynamic performance views: [G]V$RESULT_CACHE_STATISTICS [G]V … $RESULT_CACHE_MEMORY [G]V$RESULT_CACHE_OBJECTS [G]V$RESULT_CACHE_DEPENDENCY See Oracle Database Reference for more … information about [G]V$RESULT_CACHE_STATISTICS, [G]V$RESULT_CACHE_MEMORY,

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

PL/SQL Collections and Records

Declaring Associative Array Constants'; Ret(9):= 'nine'; RETURN Ret; END Init_My_AA; END My_Types; / DECLARE v CONSTANT My_Types.My_AA … DBMS_OUTPUT.PUT_LINE(TO_CHAR(Idx, '999')||LPAD(v(Idx), 7)); Idx:= v.NEXT(Idx); END LOOP; END; END

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

PL/SQL Triggers

Event Attribute Functions for Client Event TriggersWhen most SQL DDL statements are issued. Not fired for ALTER DATABASE, CREATE CONTROLFILE, CREATE

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

PL/SQL Language Fundamentals

Conditional Compilation ExamplesDatabase release number. Each BOOLEAN constant of the form VER_LE_ v has the value TRUE if the database … version is less than or equal to v. otherwise, it has the value FALSE. Each BOOLEAN constant of the … form VER_LE_ v_r has the value TRUE if the database version is less than or equal to v and release

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

PL/SQL Reserved Words and Keywords

D PL/SQL Reserved Words and Keywordscan display them with the dynamic performance view V$RESERVED_WORDS. For information about this view … , SQL, START, SUBTYPE T TABAUTH, TABLE, THEN, TO, TYPE U UNION, UNIQUE, UPDATE V VALUES, VIEW, VIEWS W … , UNSIGNED, UNTRUSTED, USE, USING V VALIST, VALUE, VARIABLE, VARIANCE, VARRAY, VARYING, VOID W WHILE, WORK, WRAPPED, WRITE Y YEAR

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

PL/SQL Subprograms

Formal and Actual Subprogram ParametersSUBTYPE n1 IS NUMBER(1); SUBTYPE v1 IS VARCHAR2(1); PROCEDURE p (n n1, v v1) IS... But you cannot … ), v VARCHAR2(1)) IS... Tip: To avoid confusion, use different names for formal and actual parameters