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
High Performance → improves performance. PL/SQL does not create bind variables automatically when you use dynamic SQL, but … compiler has an optimizer that can rearrange code for better performance. For more information about the optimizer, see \"PL/SQL Optimizer\".
Contents → Conventions What's New in Oracle Database Performance Tuning Guide? Oracle Database 11 g Release 2 … (184.108.40.206) New Features in Oracle Database Performance Oracle Database 11 g Release 2 (220.127.116.11) New … Features in Oracle Database Performance Oracle Database 11 g Release 2 (18.104.22.168) New Features in Oracle … Database Performance
Monitoring Performance → Monitoring database performance is covered in detail in Oracle Database Performance Tuning Guide … Monitoring Wait Events Performance Monitoring Data Dictionary Views
Monitoring General Oracle ASM Performance → You can monitor Oracle ASM performance with the Oracle Enterprise Manager Performance page, shown … in Figure 9-15. Figure 9-15 Oracle Automatic Storage Management Performance Page Description of … \"Figure 9-15 Oracle Automatic Storage Management Performance Page\" To monitor Oracle ASM performance
Performance Characteristics When Grouping Disks → group be of similar performance characteristics. For example, the newest and fastest disks might reside … have disks of different sizes and performance characteristics coexist in a disk group. This would
Performance Diagnostics and Tuning → to learn about the Scheduler Performance Diagnostics and Tuning As a DBA, you are responsible for … the performance of your Oracle database. Typically, performance problems result from unacceptable … performance regression after tuning SQL statements Concurrency and contention issues Database configuration … performance
Performance Planning → Part II Performance Planning Part II describes ways to improve Oracle Database performance by … starting with sound application design and using statistics to monitor application performance. It … explains the Oracle Performance Improvement Method and emergency performance techniques for dealing with
Performance Tuning → Part I Performance Tuning Part I provides an introduction and overview of performance tuning. The … chapter in this part is: Chapter 1, \"Performance Tuning Overview\"
Performance and Scalability Considerations for Disk Groups → , an extent might not be mirrored to another site. This can diminish the read performance of the … performance issues with Oracle ASM preferred read failure groups, use the V$ASM_DISK_IOSTAT view. This view … instance. In general, optimal preferred read extended cluster configurations balance performance with disk … performance
Task 9: Tune Database Performance → Optimizing the performance of the database is one of your ongoing responsibilities as a DBA. Oracle … , \"Managing Resources with Oracle Database Resource Manager\". See Also: Oracle Database Performance
Order Index Columns for Performance → The order of columns in the CREATE INDEX statement can affect query performance. In general
Performance Monitoring Data Dictionary Views → This section lists some of the data dictionary views that you can use to monitor an Oracle Database instance. These views are general in their scope. Other views, more specific to a process, are discussed in the section of this book where the process is described. View Description V$LOCK Lists the locks currently held by Oracle Database and outstanding requests for a lock or latch DBA_BLOCKERS Displays
Monitoring Oracle ASM Performance with Oracle Enterprise Manager → This section describes how to perform the following performance-related Oracle ASM administrative … tasks: Monitoring General Oracle ASM Performance Checking Disk Group Integrity
Optimizing Instance Performance → Part III Optimizing Instance Performance Part III describes how to tune various elements of your … database system to optimize performance of an Oracle database instance. The chapters in this part are … : Chapter 4, \"Configuring a Database for Performance\" Chapter 5, \"Automatic Performance Statistics … \" Chapter
2.7.2 Performance Checklist → To assist in the rollout, build a list of tasks that increase the chance of optimal performance in … Chapter 4, \"Configuring a Database for Performance\" for information about parameter settings in … automatic undo management. See Chapter 4, \"Configuring a Database for Performance\" for information … Oracle performance
22 Tuning RMAN Performance → This chapter contains the following topics: Purpose of RMAN Performance Tuning Basic Concepts of … RMAN Performance Tuning Using V$ Views to Diagnose RMAN Performance Problems Tuning RMAN Backup Performance
3.2 Emergency Performance Methods → This section provides techniques for dealing with performance emergencies. You presumably have a … methodology for establishing and improving application performance. However, in an emergency situation … that is unpredictable and not satisfying user requests. In this case, the performance engineer must … as possible. In many cases,
3 Performance Improvement Methods → Oracle Performance Improvement Method Emergency Performance Methods
1 Performance Tuning Overview → This chapter provides an introduction to performance tuning and contains the following sections … : Introduction to Performance Tuning Introduction to Performance Tuning Features and Tools
6 Automatic Performance Diagnostics → This chapter describes Oracle Database automatic features for performance diagnosing and tuning … Setting Up ADDM Diagnosing Database Performance Problems with ADDM Views with ADDM Information See Also … : Oracle Database 2 Day + Performance Tuning Guide for information about using Oracle Enterprise