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
Sizing the Buffer Cache → buffer pool is small to begin with. To use V$DB_CACHE_ADVICE, the parameter DB_CACHE_ADVICE should … use of additional buffers that contribute little or nothing to the cache hit ratio. In the example … delta of these statistics over an interval while your application is running, then use them to
Auditing in a Multi-Tier Environment → enables auditing of actions taken on behalf of the client. To do so, you use the BY proxy clause in
Controlling the Growth and Size of the Audit Trail → execution of audited statements To control the growth of the audit trail, you can use the following
Auditing Administrative Users → be fully audited. Use the AUDIT_SYS_OPERATIONS initialization parameter to specify if user SYS is … who connect as SYSDBA, Oracle recommends that DBAs rarely use this connection and only when
Configuring the Reserved Pool → Although Oracle breaks down very large requests for memory into smaller chunks, on some systems there might still be a requirement to find a contiguous chunk (for example, over 5 KB) of memory. (The default minimum reserved pool allocation is 4,400 bytes.) If there is not enough free space in the shared pool, then Oracle must search for and free enough memory to satisfy this request. This operation
Setting Auditing Options → specific statements on specific objects, such as ALTER TABLE on the emp table To use the AUDIT … statement to set statement and privilege options, you must have the AUDIT SYSTEM privilege. To use it to set … options causes all subsequent database sessions to use these options; existing sessions continue using … audit use
Keep Audited Information Manageable → minimizes the size of the audit trail. Use the following general guidelines when devising an auditing
Considering Multiple Buffer Pools → batch job only once a day). Multiple buffer pools let you address these differences. You can use a … statement to use a more selective index. If the SQL statement is tuned, you can move the large segment … for that instance. Using Multiple Buffer Pools To define a default buffer pool for an object, use
Log Buffer Statistics → $SYSSTAT. Use the following query to monitor these statistics over a period of time while your
Configuring and Using the Shared Pool and Large Pool → … Proper use and sizing of the shared pool can reduce resource consumption in at least four ways: Parse … applications use the same pool of SQL statements and dictionary resources. I/O resources are saved, because
26 Auditing Database Use → This chapter describes how to use the Oracle database server's auditing facilities, and contains
Understanding Memory Allocation Issues → Oracle stores information in memory caches and on disk. Memory access is much faster than disk access. Disk scans (physical I/O) take a significant amount of time, compared with memory access, typically in the order of 10 milliseconds. Physical I/O also increases the CPU resources required, because of the path length in device drivers and operating system event schedulers. For this reason, it is more
Sizing the Log Buffer → Applications that insert, modify, or delete large volumes of data usually need to change the default log buffer size. The log buffer is small compared with the total SGA size, and a modestly sized log buffer can significantly enhance throughput on systems that perform many updates. A reasonable first estimate for such systems is to make the log buffer 1 MB. On most systems, sizing the log buffer larger
Guidelines for Auditing Normal Database Activity → activities, use the following guidelines: Audit only pertinent actions. To avoid cluttering meaningful
What Information is Contained in the Audit Trail? → Oracle can write records to either the database audit trail, an operating system file, or both. This section describes the makeup of this audit trail information.
Interpreting and Using the Buffer Cache Advisory Statistics → basis, there might be little purpose in keeping the block in memory for very long following its use. A … are doing full table scans or operations that do not use the buffer cache. Increasing Memory … specifies the size of the default cache for the database's standard block size. To create and use
Using CURSOR_SPACE_FOR_TIME → If you have no library cache misses, then you might be able to accelerate execution calls by setting the value of the initialization parameter CURSOR_SPACE_FOR_TIME to true. This parameter specifies whether a cursor can be deallocated from the library cache to make room for a new SQL statement. CURSOR_SPACE_FOR_TIME has the following values meanings: If CURSOR_SPACE_FOR_TIME is set to false (the default),
Application Considerations → needs. Conversely, tuning the application's use of the caches can greatly reduce resource requirements … . Efficient use of the Oracle memory caches also reduces the load on related resources, such as the
Operating System Memory Use → fit into real memory. On most operating systems, paging reduces performance. Use the operating
Interpreting Shared Pool Statistics → Shared pool statistics indicate adjustments that can be made. The following sections describe some of your choices. Increasing Memory Allocation Increasing the amount of memory for the shared pool increases the amount of memory available to both the library cache and the dictionary cache. Allocating Additional Memory for the Library Cache To ensure that shared SQL areas remain in the cache after their