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
Explain index?
How to use "for" statements in oracle?
How to create a new oracle data file?
How to retrieve data from an cursor to a record?
State all possible different index configurations a table can possibly have?
What are the built-in functions used for sending Parameters to forms ?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is merge in oracle?
What are the differences between primary key and unique key?
How to increment dates by 1 in oracle?
How to select all columns of all rows from a table in oracle?
What is an oracle wallet?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Is there a function to split a string in plsql?
How to drop an index in oracle?