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 USE


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


Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Sizing the Buffer Cachebuffer 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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

Auditing in a Multi-Tier Environmentenables auditing of actions taken on behalf of the client. To do so, you use the BY proxy clause in

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

Controlling the Growth and Size of the Audit Trailexecution of audited statements To control the growth of the audit trail, you can use the following

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

Auditing Administrative Usersbe 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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Configuring the Reserved PoolAlthough 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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

Setting Auditing Optionsspecific 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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

Keep Audited Information Manageableminimizes the size of the audit trail. Use the following general guidelines when devising an auditing

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Considering Multiple Buffer Poolsbatch 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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Log Buffer Statistics$SYSSTAT. Use the following query to monitor these statistics over a period of time while your

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

26 Auditing Database UseThis chapter describes how to use the Oracle database server's auditing facilities, and contains

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Understanding Memory Allocation IssuesOracle 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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Sizing the Log BufferApplications 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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

Guidelines for Auditing Normal Database Activityactivities, use the following guidelines: Audit only pertinent actions. To avoid cluttering meaningful

Administrator's Guide, 9i Release 2 (9.2.0.2)

Auditing Database Use

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.

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Interpreting and Using the Buffer Cache Advisory Statisticsbasis, 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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Using CURSOR_SPACE_FOR_TIMEIf 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),

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Application Considerationsneeds. 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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Operating System Memory Usefit into real memory. On most operating systems, paging reduces performance. Use the operating

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Memory Configuration and Use

Interpreting Shared Pool StatisticsShared 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