when i run my query on yesterday it is fast but today it is
slow why?
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
How to shutdown your 10g xe server from command line?
Difference between cartesian join and cross join?
What is a package in oracle?
How to pass parameters to procedures?
Explain about functional dependency and its relation with table design?
How to rename an existing table?
What is Virtual Private Database in Oracle?
What is the difference between $oracle_base and $oracle_home?
what is the difference between substr and instr function in oracle?
Can you drop an index associated with a unique or primary key constraint?
What is an Oracle index?
How do I know if oracle client is installed on windows?
How to lock and unlock a user account in oracle?
How to use existing values in update statements using oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?