Posted by Coder.
Results > Posts Filed Under > Oracle
Nov
2
Posted by Coder.
Oracle Enterprise Manager Java Application Diagnostic Expert (JADE)
Oracle Enterprise Manager Java Application Diagnostic Expert (JADE) improves the availability, performance and provides in-depth diagnostics for Java applications with low overhead. It enables:
1. Production diagnostics with no application instrumentation, saving time in reproducing problems
2. Visibility into Java activity including in-flight transactions, allowing administrators to proactively identify issues rather than diagnosing after-the-fact (application hangs, crashes, memory leaks, locks)
3. Tracing of transactions from Java to Database and vice-versa, enabling faster resolution of problems that …
Nov
1
Posted by Coder.
Performance Agora: ORACLE Scalability Oracles
Cary Milsap, “Optimizing Oracle Performance” (O’Reilly, 2003). On p. 361, there is a definition of scalability expressed in terms of the response time (R). [ed. scalability: The rate of change of response time with respect to some specified parameter. For example, one may speak of the scalability of a query with respect to the number of rows returned, the scalability of a system with respect to the number of CPUs …
Oct
3
Posted by Coder.
Cary Millsap, former VP of Oracle’s System Performance Group and the cofounder of Hotsos.
…doing things an application doesn’t need to do is exactly what makes it slow, unscalable, and—in the end—economically inefficient.
Don’t run reports that nobody reads.
Don’t generate more output than you need.
Don’t execute a business process any more often than the business needs.
Don’t write SQL that visits more blocks in the database buffer cache than necessary.
Don’t update a column’s value to the same value it already has.
Push data when …