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 cascading triggers.
What is difference between truncate and delete?
How to call a trigger inside a stored procedure?Give an example.
What is BBED in Oracle?
pls explain connect by prior with example and its real time use
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What is a cursor in oracle?
What are cursor?where are they used?
What is query image?
What are the oracle built-in data types?
where do i find oracle interview questions.
How to load data through external tables?