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
8.72 V$MEMORY_TARGET_ADVICE → V$MEMORY_TARGET_ADVICE provides information about how the MEMORY_TARGET parameter should be sized … information provided in V$MEMORY_TARGET_ADVICE could be used to improve performance. The data … improvement in performance. Table 8-2 Example of Using V$MEMORY_TARGET_ADVICE MEMORY_SIZE
6.3.3 Monitoring and Tuning Automatic Memory Management → , run the following query: SQL> select * from v$memory_target_advice order by memory_size; MEMORY_SIZE … information about the V$MEMORY_TARGET_ADVICE dynamic performance view Oracle Database Performance Tuning Guide for a definition of DB time. … The dynamic performance view V$MEMORY_DYNAMIC_COMPONENTS
Monitoring Memory Management → operations that are currently in progress. V$MEMORY_TARGET_ADVICE Displays tuning advice for the … Memory Management Views View Description V$MEMORY_CURRENT_RESIZE_OPS Displays information about memory … resize operations (both automatic and manual) that are currently in progress. V … , including the total sizes
6.8.2 Memory Management Data Dictionary Views → about the last 800 completed SGA component resize operations. V$MEMORY_TARGET_ADVICE Displays … A set of dynamic performance views provide information on memory management. View Description V$SGA … Displays summary information about the system global area (SGA). V$SGAINFO Displays size … . V$SGASTAT
The dynamic performance view V$MEMORY_DYNAMIC_COMPONENTS shows the current sizes of all dynamically… → is similar to that provided in the V$MEMORY_TARGET_ADVICE view for automatic memory management. See … Monitoring and Tuning SGA Target Size The V$SGAINFO view provides information on the current tuned … sizes of various SGA components. The V$SGA_TARGET_ADVICE view provides information that helps you decide … on
Using Automatic Memory Management → startup. If you need tuning advice for the MEMORY_TARGET parameter, then use the V … $MEMORY_TARGET_ADVICE view. See Also: Oracle Database Administrator's Guide for information about using automatic memory management
5.10 DBA_HIST_MEMORY_TARGET_ADVICE → of V$MEMORY_TARGET_ADVICE. Column Datatype NULL Description SNAP_ID NUMBER NOT NULL Unique snapshot … applicable container ID for the rows containing data See Also: \" V$MEMORY_TARGET_ADVICE \"
Contents → $MEMORY_CURRENT_RESIZE_OPS 8.70 V$MEMORY_DYNAMIC_COMPONENTS 8.71 V$MEMORY_RESIZE_OPS 8.72 V$MEMORY_TARGET_ADVICE … 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
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
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
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
Cursors Overview → cursors that each user session currently has opened and parsed, query the dynamic performance view V … for information about the dynamic performance view V$OPEN_CURSOR Oracle Database Reference for information about the initialization parameter OPEN_CURSORS
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
Using the V$DB_CACHE_ADVICE View → The V$DB_CACHE_ADVICE view shows the simulated miss rates for a range of potential buffer cache … is not used if the number of buffers in a buffer pool is small to begin with. To use the V … workload on the database instance. Allow the workload to stabilize before querying the V … $DB_CACHE_ADVICE view. Query the V$DB_CACHE_ADVICE
V → Classes A B C D E F G H I J L M N O P R S T U V V validate … V Overview Package Class Use Tree Deprecated Index Help Oracle® Universal Connection Pool for