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
- 7686 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
How to connect the oracle server as sysdba?
When do you get a .pll extension in oracle?
What are the differences between char and varchar2 in oracle?
Explain the use of Merge statement in oracle 11g
Can we save images in a database and if yes, how?
How to get a list of all user accounts in the database?
What is blob data type in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is a tns service name?
What are nested tables?
How to write a query with a right outer join in oracle?
How to create a server parameter file?
What is ASM (Automatic Storage Management) in Oracle?
How to call a stored function with parameters?
What are the uses of linked server and explain it in detail?
