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
- 7480 Views
- I also Faced
- E-Mail Answers
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 |
How to create an oracle database?
Explain view?
Explain alias?
What are the commands youd issue to show the explain plan for select
what is the difference between no rows returned and null returned?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Can a Tablespace hold objects from different Schemes ?
How to connect asp pages to oracle servers?
What is the difference between translate and replace in oracle?
How to divide query output into groups in oracle?
How to loop through a cursor variable?
Difference between an implicit & an explicit cursor.?
Oracle General 
