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
PREPARED_SCN NUMBER The PREPARER processes have successfully transformed all redo records below this… → the rows containing data This column is available starting with Oracle Database 12 c Release 1 (184.108.40.206). See Also: \" V$LOGMNR_CONTENTS \"
8.51 V$LOGMNR_SESSION → V$LOGMNR_SESSION displays information about active LogMiner persistent sessions. (A LogMiner … of querying the V$LOGMNR_CONTENTS view) do not show up in the V$LOGMNR_SESSION view. The statistics
LogMiner V$ Views and DBA Views in a CDB → affected by this new behavior: V$LOGMNR_DICTIONARY_LOAD V$LOGMNR_LATCH V$LOGMNR_PROCESS V$LOGMNR_SESSION V … $LOGMNR_STATS Note: To support CDBs, the V$LOGMNR_CONTENTS view has several other new columns in … addition to CON_ID. See \" The V$LOGMNR_CONTENTS
Contents → $LOGMNR_SESSION 8.52 V$LOGMNR_STATS 8.53 V$LOGSTDBY 8.54 V$LOGSTDBY_PROCESS 8.55 V$LOGSTDBY_PROGRESS … 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
Part V Distributed Database Management → You can manage a distributed database environment.
Part V Oracle Instance Architecture → This 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
7.2.5 The XStream Out Client Application Is Unresponsive → capture process. Query the V$LOGMNR_SESSION view: SELECT SESSION_NAME AS CAP, MAX_MEMORY_SIZE/(1024*1024 … database that contains the outbound server: Query the V$PROPAGATION_RECEIVER view.: SELECT STATE FROM … V$PROPAGATION_RECEIVER; If the state is WAITING FOR MEMORY, then consider increasing the Streams … pool
Part V Optimizer Statistics → The 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
PL/SQL Functions that SQL Statements Can Invoke → Packages 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,
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
Conditional Compilation Examples → Database 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
D PL/SQL Reserved Words and Keywords → can 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
Formal and Actual Subprogram Parameters → SUBTYPE 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
Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO → You 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
9.110 V$TEMPSEG_USAGE → V$TEMPSEG_USAGE describes temporary segment usage. Column Datatype Description USERNAME VARCHAR2(30
9.116 V$TIMEZONE_NAMES → V$TIMEZONE_NAMES displays valid time zone names. Column Datatype Description TZNAME VARCHAR2(64
7.68 V$AW_CALC → V$AW_CALC reports on the effectiveness of various caches used by Oracle OLAP during dynamic
8.84 V$NFS_OPEN_FILES → V$NFS_OPEN_FILES displays information about all the files currently opened by clients at the NFS
7.124 V$CONTROLFILE → V$CONTROLFILE displays the names of the control files. Column Datatype Description STATUS VARCHAR2
7.7 V$ACTIVE_SESSION_HISTORY → V$ACTIVE_SESSION_HISTORY displays sampled session activity in the database. It contains snapshots … the CPU or was waiting for an event that didn't belong to the Idle wait class. Refer to the V … the session in the active session history are present in the V$SESSION view. Column Datatype … Session identifier; maps to V$SESSION.SID