From Oracle FAQ
Jump to: navigation, search

A bottleneck is the slowest operation in a set of operations. It is important to identify the bottleneck in computer systems to know what needs to be tuned to provide better performance and scalability.

Some examples:

  • The I/O system may become a bottleneck on a large database system;
  • If a database used more memory than what's available, paging and swapping will become a bottleneck;
  • In a RAC system the interconnect may be overloaded (cannot handle all data transfers).

Also see[edit]

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #