when i run my query on yesterday it is fast but today it is
slow why?
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 |
What is flashback Query ? And Use ?
How to see the table columns used in an index?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
How many categories of data types?
Can we create database in oracle using command line ?
How to write numeric literals in oracle?
what is shell?
What is a dead lock in oracle?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
What is set operator oracle?
What is the disadvantage of User defind function?
What is the relationship among database, tablespace and data file?