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
- 7590 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 a tns service name?
what is the use of system.effective.date variable in oracle?
What is difference between sid and service name in oracle?
What is a trace file and how is it created in oracle?
How data locks are respected in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Describe an oracle table?
What is the usage of synonyms?
How can we view last record added to a table?
Explain about integrity constraint?
How much memory your 10g xe server is using?
What are the most common interview questions on ETL Testing for experience?
How oracle handles dead locks?
What is MTTR advisor in Oracle?
Can a formula column referred to columns in higher group ?
