Performance
Performance is a somewhat nebulous term; everyone has a different idea about what it means. Performance can be measured by how fast one person can get a long query done, or by how many people can perform concurrent OLTP transactions, or by how fast a given batch job runs. Good performance for one user may mean poor performance for another, so it is important to define your expectations before pursuing performance improvements. Performance can, however, be measured objectively, and, therefore, changes to the system can be observed and quantified.
Performance is impacted by how queries are written, how disks are laid out, the amount of memory, and the CPU, disk, and bus speeds. You will probably need to work with your system administrator and/or hardware vendor to determine whether your system has sufficient capacity to provide good performance.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
