when i run my query on yesterday it is fast but today it is
slow why?
Answer / chockalingam
There might be several reasons for the dealy
1) Network might be slower today compared to yesterday
2) Data might have increased substantially
3) Concorrent users might be running the query at the same
time
4) There might be lock established on the table from
another resource
5) temp memory might be less today. May be Server space
related issue.
| Is This Answer Correct ? | 4 Yes | 0 No |
what is query and types of query
What is null value in oracle?
Who developed oracle & when?
Tell me New Feature of Oracle 10g?
What is archive log in Oracle?
Explain table?
What types of joins are used in writing subqueries?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is a subquery?
What is tns name?
What are the differences between char and nchar in oracle?
How would you begin to troubleshoot an ORA-3113 error?