Loading...
Please wait, while we are loading the content...
Oracle Workload Management Using Time Based Optimization Techniques
| Content Provider | Semantic Scholar |
|---|---|
| Author | Rivenes, A. S. |
| Copyright Year | 2003 |
| Abstract | In computer based systems, system capacity is generally categorized into four areas: CPU, memory, disk, and network. In an Oracle database, workload is typically motivated by the execution of SQL, but increasingly can also be created by Java and PL/SQL programs that may or may not invoke SQL calls to the database. In all these cases CPU is required to perform the work, with memory, disk, and network components supporting the production of this work. Therefore, workload can be considered as the measurement of the “rates” of work being performed. In an Oracle database we can think of CPU time in the context of “service time”, since it is CPU that drives our workload, with the other components of system capacity as additional rates to be measured that contribute to the ability to provide service time. The Oracle database has been instrumented with events that account for all time not spent in “service time”. These “wait” events are due to the costs of synchronization of access to common resources. Combined, service time and wait time can provide a complete picture of the time consumed in an Oracle database. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.129.6954&rep=rep1&type=pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
