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 |
Explain integrity constraints?
how to delete all duplicate records from a table using subquery?
Who developed oracle & when?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
What is SYSTEM tablespace and When is it Created?
How to use like conditions in oracle?
How many memory layers are in the shared pool?
How to export several tables together?
What is a initialization parameter file in oracle?
structural difference between bitmap and btree index ?
What is currency type in database ?