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
V$SESSION_WAIT_HISTORY → displays the last 10 wait events for each active session. Column Datatype Description SID NUMBER Session identifier SEQ# NUMBER Sequence of wait events; 1 is the most recent EVENT# NUMBER Event number EVENT VARCHAR2(64) Resource or event for which the session is waiting P1TEXT VARCHAR2(64) Description of the first additional parameter P1 NUMBER First additional parameter P2TEXT VARCHAR2(64) Description
V$DBFILE → compatibility. Use of V$DATAFILE is recommended instead. Column Datatype Description FILE# NUMBER File … identifier NAME VARCHAR2(513) Name of the file See Also: \"V$DATAFILE\"
V$PGASTAT → when it is enabled (that is, when PGA_AGGREGATE_TARGET is set). Cumulative values in V$PGASTAT are … statistic (see Table 7-2 ) VALUE NUMBER Statistic value UNIT VARCHAR2(12) Unit for the value (microseconds, bytes, or percent) Table 7-2 V$PGASTAT Statistics
V$WAITSTAT → This view lists block contention statistics. This table is only updated when timed statistics are enabled. Column Datatype Description CLASS VARCHAR2(18) Class of the block COUNT NUMBER Number of waits by this OPERATION for this CLASS of block TIME NUMBER Sum of all wait times for all the waits by this OPERATION for this CLASS of block
V$SQL_REDIRECTION → identifies SQL statements that are redirected. Column Datatype Description ADDRESS RAW(4 | 8) Address of the cursor handle PARENT_HANDLE RAW(4 | 8) Address of the parent cursor handle HASH_VALUE NUMBER Hash value of the SQL statement SQL_ID VARCHAR2(13) SQL identifier of the SQL statement CHILD_NUMBER NUMBER Number of the child (instance) for the hash PARSING_USER_ID NUMBER Parsing user ID PARSING_SCHEMA_ID
V$SEGMENT_STATISTICS → displays information about segment-level statistics. Column Datatype Description OWNER VARCHAR2(30) Owner of the object OBJECT_NAME VARCHAR2(30) Name of the object SUBOBJECT_NAME VARCHAR2(30) Name of the subobject TABLESPACE_NAME VARCHAR2(30) Name of the table space to which the object belongs TS# NUMBER Tablespace number OBJ# NUMBER Dictionary object number of the object DATAOBJ# NUMBER Data object
V$LOGMNR_PROCESS → first time or by creating Streams capture.) This view can be joined with either the V$SESSION view or … the V$PROCESS view to gather process-specific information. Column Datatype Description SESSION_ID … the SQL Apply or Streams capture process (same as the V$PROCESS.PID ) SPID VARCHAR2(12) Operating … system process identifier
V$MAP_EXT_ELEMENT → contains supplementary information for all element mapping structures. Column Datatype Description ELEM_IDX NUMBER Index corresponding to element NUM_ATTRB NUMBER Number of Attributes (maximum is 5) ATTRB1_NAME VARCHAR2(256) Name of the first Attribute ATTRB1_VAL VARCHAR2(256) Value of the first attribute ATTRB2_NAME VARCHAR2(256) Name of the second attribute ATTRB2_VAL VARCHAR2(256) Value of the
V$GC_ELEMENTS_WITH_COLLISIONS → The V$GC_ELEMENTS_WITH_COLLISIONS view is deprecated. Column Datatype Description GC_ELEMENT_ADDR
V$SYSTEM_WAIT_CLASS → displays the instance-wide time totals for each registered wait class. Column Datatype Description WAIT_CLASS_ID NUMBER Identifier of the wait class WAIT_CLASS# NUMBER Number of the wait class WAIT_CLASS VARCHAR2(64) Name of the wait class TOTAL_WAITS NUMBER Number of times waits of the class occurred TIME_WAITED NUMBER Amount of time spent in the wait by all sessions in the instance
V$ROLLSTAT → This view contains rollback segment statistics. Column Datatype Description USN NUMBER Rollback segment number LATCH NUMBER Latch for the rollback segment EXTENTS NUMBER Number of extents in the rollback segment RSSIZE NUMBER Size (in bytes) of the rollback segment. This value differs by the number of bytes in one database block from the value of the BYTES column of the ALL / DBA / USER_SEGMENTS views.
V$LATCH_CHILDREN → contains statistics about child latches. This view includes all columns of V$LATCH plus the CHILD … you can query the appropriate rows of the V$EVENT_HISTOGRAM view where the EVENT column has a value … have a value of zero. As a substitute for this column you can query the appropriate rows of the V … spent waiting for the latch
V$TRANSPORTABLE_PLATFORM → displays all platforms that support cross-platform tablespace transport. Specifically, it lists all platforms supported by the RMAN CONVERT TABLESPACE command, along with the endianness of each platform. Column Datatype Description PLATFORM_ID NUMBER Platform identification number PLATFORM_NAME VARCHAR2(101) Platform name ENDIAN_FORMAT VARCHAR2(14) Platform endian format: Platform endian format: Big
V$LOGFILE → This view contains information about redo log files. Column Datatype Description GROUP# NUMBER Redo log group identifier number STATUS VARCHAR2(7) Status of the log member: Status of the log member: INVALID - File is inaccessible STALE - File's contents are incomplete DELETED - File is no longer used - File is in use TYPE VARCHAR2(7) Type of the logfile: Type of the logfile: ONLINE STANDBY MEMBER
V$BACKUP_ASYNC_IO → different backup sets RMAN_STATUS_RECID NUMBER Owning V$RMAN_STATUS record ID RMAN_STATUS_STAMP NUMBER … Owning V$RMAN_STATUS record stamp DEVICE_TYPE VARCHAR2(17) Device type where the file is located
V$DISPATCHER_RATE → displays rate statistics for a number of activities performed by the dispatcher processes. Collected samples have an activity-specific \"time-to-live\" ( TTL_* columns). Statistics are reported over the following two types of time intervals: Current statistics ( CUR_ columns) Current statistics use samples collected over the most recent time-to-live interval. Historical statistics ( AVG_ and most
V$SESS_IO → This view lists I/O statistics for each user session. Column Datatype Description SID NUMBER Session identifier BLOCK_GETS NUMBER Block gets for this session CONSISTENT_GETS NUMBER Consistent gets for this session PHYSICAL_READS NUMBER Physical reads for this session BLOCK_CHANGES NUMBER Block changes for this session CONSISTENT_CHANGES NUMBER Consistent changes for this session
V$PROCESS_MEMORY → displays dynamic PGA memory usage by named component categories for each process. Column Datatype Description PID NUMBER Oracle process identifier SERIAL# NUMBER Oracle process serial number CATEGORY VARCHAR2(15) Category name. Categories include \"SQL\", \"PL/SQL\", \"OLAP\" and \"JAVA\". Special categories are \"Freeable\" and \"Other\". Freeable memory has been allocated to the process by the operating
V$DB_OBJECT_CACHE → when an object has been invalidated. EXECUTIONS NUMBER Not used Not used See Also: \"V$SQLAREA\" to
V$SQL_WORKAREA → pool has one or more child cursors that are listed in the V$SQL view. V$SQL_WORKAREA lists all work … areas needed by these child cursors; V$SQL_WORKAREA can be joined with V$SQLAREA on ( ADDRESS … , HASH_VALUE ) and with V$SQL on ( ADDRESS, HASH_VALUE, CHILD_NUMBER ). You can use this view to find out