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
- 7483 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
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to open a cursor variable?
How to list all indexes in your schema?
How to test null values?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is sequence?
Explain the use of owner option in exp command.
How to pass parameters to procedures?
How to see free space of each tablespace?
Is there any function in oracle similar like group_concat of mysql?
How would you begin to troubleshoot an ORA-3113 error?
How to download oracle database 10g xe?
Please explain drop constraint oracle?
What are the ansi data types supported in oracle?
Explain the use of compress option in exp command.
