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


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


Database Reference, 12c Release 1 (12.1)

V$IOSTAT_FILE

8.15 V$IOSTAT_FILEV$IOSTAT_FILE displays information about disk I/O statistics of database files (including data

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

I/O Configuration and Design

Prerequisites for I/O Calibrationfollowing query: COL NAME FORMAT A50 SELECT NAME,ASYNCH_IO FROM V$DATAFILE F,V$IOSTAT_FILE I WHERE

Database Reference, 12c Release 1 (12.1)

DBA_HIST_IOSTAT_FILETYPE_NAME

4.267 DBA_HIST_IOSTAT_FILETYPE_NAMEcontains snapshots of V$IOSTAT_FILE. Column Datatype NULL Description DBID NUMBER NOT NULL Database ID … the rows containing data See Also: \" V$IOSTAT_FILE \"

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

Instance Tuning Using Performance Views

Examine the Oracle Database Statisticsare part of the currently enabled resource plan are captured. V$IOSTAT_FILE The V$IOSTAT_FILE view … Reference for information about the V$IOSTAT_CONSUMER_GROUP, V$IOSTAT_FUNCTION, V$IOSTAT_FILE, and V … be identified using V$

Database Reference, 12c Release 1 (12.1)

DBA_HIST_IOSTAT_DETAIL

4.265 DBA_HIST_IOSTAT_DETAIL(component). This view contains snapshots of V$IOSTAT_FILE and V$IOSTAT_FUNCTION. Column Datatype … root n: Where n is the applicable container ID for the rows containing data See Also: \" V$IOSTAT_FILE \" \" V$IOSTAT_FUNCTION \"

Database Reference, 12c Release 1 (12.1)

DBA_HIST_IOSTAT_FILETYPE

4.266 DBA_HIST_IOSTAT_FILETYPEsnapshots of V$IOSTAT_FILE. Column Datatype NULL Description SNAP_ID NUMBER NOT NULL Unique snapshot ID … the root n: Where n is the applicable container ID for the rows containing data See Also: \" V$IOSTAT_FILE \"

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsV$IOFUNCMETRIC_HISTORY 8.14 V$IOSTAT_CONSUMER_GROUP 8.15 V$IOSTAT_FILE 8.16 V$IOSTAT_FUNCTION 8.17 … 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

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_RESOURCE_MANAGER

CALIBRATE_IO Procedurestatement: col name format a50 SELECT name, asynch_io FROM v$datafile f,v$iostat_file i WHERE f.file … V$IO_CALIBRATION_STATUS view and results for a successful calibration run are located in … ); DBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps); end; / View for I/O calibration results SQL> desc V$IO_CALIBRATION_STATUS

Database High Availability Best Practices, 12c Release 1 (12.1)

Configuring Oracle Database

4.1.7 Set DISK_ASYNCH_IO Initialization Parameterasynchronous I/O is actually being used. Query the V$IOSTAT_FILE view to determine whether … asynchronous I/O is used: SQL> select file_no,filetype_name,asynch_io from v$iostat_file; To explicitly

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

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 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 Backup and Recovery User's Guide, 12c Release 1 (12.1)

Tuning RMAN Performance

Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IOYou can use the V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO views to determine the source of backup or … restore bottlenecks and to see detailed progress of backup jobs. V$BACKUP_SYNC_IO contains rows when … the I/O is synchronous to the process (or thread on some platforms) performing the backup. V … SQL*Plus and

Database Reference, 12c Release 1 (12.1)

V$TEMPSEG_USAGE

9.110 V$TEMPSEG_USAGEV$TEMPSEG_USAGE describes temporary segment usage. Column Datatype Description USERNAME VARCHAR2(30

Database Reference, 12c Release 1 (12.1)

V$TIMEZONE_NAMES

9.116 V$TIMEZONE_NAMESV$TIMEZONE_NAMES displays valid time zone names. Column Datatype Description TZNAME VARCHAR2(64

Database Reference, 12c Release 1 (12.1)

V$AW_CALC

7.68 V$AW_CALCV$AW_CALC reports on the effectiveness of various caches used by Oracle OLAP during dynamic

Database Reference, 12c Release 1 (12.1)

V$NFS_OPEN_FILES

8.84 V$NFS_OPEN_FILESV$NFS_OPEN_FILES displays information about all the files currently opened by clients at the NFS