Interested to Buy Any Domain ? << Click Here >> for more details...
when i run my query on yesterday it is fast but today it is
slow why?
- 1 Answers
- 7559 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is an index associated with a constraint?
How to execute the package in oracle?
What is the usage of analyze command in oracle?
Is oracle a language?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is oracle data type?
How to invoke the data pump import utility?
How to use null as conditions in oracle?
What is materialized view in Oracle?
What is the order of defining local variables and sub procedures/functions?
Where are the settings stored for each instance in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
Explain what are synonyms used for?
How do I know if oracle is installed on windows?
how to handle exceptions in post production
