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

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

Database Reference, 12c Release 1 (12.1)


8.96 V$OPTIONV$OPTION displays Oracle Database options and features. Typically, although not always, options … PARAMETER VARCHAR2(64) Name of the option (or feature) VALUE VARCHAR2(64) Indicates whether the option

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

Displaying the ASMCMD Version Number

Displaying the ASMCMD Version NumberYou can specify the -V option when starting asmcmd to display the asmcmd version number. After … displaying the version number, asmcmd immediately exits. For example: $ asmcmd -V asmcmd version $

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

Specifying the Verbose Mode

Specifying the Verbose ModeYou can specify the -v option with the asmcmd command to display additional information with some … commands to help users diagnose problems as shown in the following example: $ asmcmd -v debug When … the -v errors, -v warning, or -v normal display level. The trace.trc file is created

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

acfsutil encr rekey

acfsutil encr rekeyhome environmental variable ( OKV_HOME ) must be set when using the -v option to generate a new volume … the -v option. The file owner can also run this command with the -f option to rekey encryption on … rekey -h acfsutil encr rekey -m mount_point {-f [-r] path [path…] |-v } [-a {AES}

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

acfsutil sec realm audit enable

acfsutil sec realm audit enableapplied. An exception to this behavior occurs when the command is run with the -v option and the … enable realm -m mount_point [-l commandrule,commandrule,...] [-a ] [-v [ -u] ] acfsutil sec realm … command Option Description realm Specifies the security realm name. -m mount_point Specifies the … auditing. If

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

acfsutil info fs

acfsutil info fs… The optional -d option displays more detailed statistical information. -f [ -v ] Displays file system … fragmentation. The -v option displays additional fragmentation information. mount_point Specifies … fs -h acfsutil info fs [ {-o item | -s [interval [count] [-d] ] | -f [-v] } ] [mount_point

Database Security Guide, 12c Release 1 (12.1)

Introduction to Auditing

Checking if Your Database Has Migrated to Unified AuditingThe V$OPTION dynamic view indicates if your database has been migrated to unified auditing. Query … the VALUE column of the V$OPTION dynamic view as follows, entering Unified Auditing in the case shown … : SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing'; PARAMETER VALUE

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents8.96 V$OPTION 8.97 V$OSSTAT 8.98 V$PARALLEL_DEGREE_LIMIT_MTH 8.99 V$PARAMETER 8.100 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

TimesTen In-Memory Database Reference, 12c Release 1 (12.1)


ttXactLoga database to be replicated for one or all of the subscribers.Use with the -v option to print: 1 … full log records (see -m option). -x xid Specifies the transaction ID. Examples ttXactLog -v 3 -m 100 … requires the ADMIN privilege. Syntax ttXactLog {-h | -help | -?} ttXactLog {-V | -version} ttXactLog

Database Security Guide, 12c Release 1 (12.1)

Configuring Audit Policies

Audit Policy Data Dictionary Viewsuser UNIFIED_AUDIT_TRAIL Displays all audit records V$OPTION You can query the PARAMETER column for … Vault policies SYSTEM_PRIVILEGE_MAP (table) Describes privilege (auditing option) type codes. This … table can be used to map privilege (auditing option) type numbers to type names. USER_AUDIT_POLICIES … Unified

Database Installation Guide for Microsoft Windows, 12c Release 1 (12.1)

Oracle Database Postinstallation Tasks

7.7 Enabling and Disabling Database Options… You can view the enabled Oracle Database options by querying the V$OPTION view using SQL*Plus. See … Running the Chopt Tool To enable the Oracle Data Mining RDBMS Files option in your Oracle binary files

Database Upgrade Guide, 12c Release 1 (12.1)

Downgrading Oracle Database to an Earlier Release

6.4 Performing Required Pre-Downgrade Steps for Oracle DatabaseVault before downgrading the database. To find if Oracle Database Vault is enabled, query the V$OPTION … Vault. To find out if Oracle Label Security is enabled, query the V$OPTION dynamic view as follows … : SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security'; Run

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,

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

Mounting Disk Groups Using the FORCE Option

Mounting Disk Groups Using the FORCE OptionOracle ASM provides a MOUNT FORCE option with ALTER DISKGROUP to enable Oracle ASM disk groups to … the disk group at mount time. The default behavior without the FORCE option is to fail to mount a … disk group that has damaged or missing disks. The MOUNT FORCE option is useful in situations where a … you correct the situation

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

PL/SQL Reserved Words and Keywords


OLAP DML Reference, 12c Release 1 (12.1)

  DBMS_AW PL/SQL Package

OLAP_ON Functionparameter in the V$OPTION table. Example The following PL/SQL code tests the value returned by … The OLAP_ON function returns a boolean indicating whether or not the OLAP option is installed in … OLAP option is installed'); ELSE dbms_output.put_line('The OLAP option is not installed'); END IF; END; /

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 Upgrade Guide, 12c Release 1 (12.1)

Upgrading Oracle Database

3.10.13 Understanding Component Status of the Post-Upgrade Status Toolrequired for the component was not installed or was not linked with the server. Check the V$OPTION view … component was not upgraded because it was removed from the database. OPTION OFF The server option … and the install logs. Install the component or relink the server with the required option, and

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