Tuesday, June 14, 2011

Frequently Executed Statement Wait

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com


Much of the statements In Oracle time is spent on CPU usage, even though the average In Oracle time is low (indicating executions run many times).
Frequently Executed Statement findings

Description
What to do next
Perform one of the following options:
n   Launch to the Activity workspace to examine the scalability of the statement.
n   Examine the activity of the program activating the statement.
Advice
Try to determine if the large number of executions is valid or if it is derived from redundant executions as a result of inefficient   program design (e.g. if the statement is activated in an inefficient loop).


     
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: