I have a huge amount of data which is displayed in a report. The data is viewe

I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer.

Question Posted / d. shyamala

4 Answers
7195 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / prasad

Im giving few suggestions known to me.

- Update table statistics regularly.
- ur log might be full. clear the log using dump tran with
no_log
- if u r connecting ur server in a network, check the
network connections.

Is This Answer Correct ?

4 Yes

1 No

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / arun sql gamer

Might be a performance tuning problem.Previously it may
have less data ,since it wont give u that much trouble in
processing the query.Subsequently the size of the data may
get increased which leads to more processing time of query
hence forth arrive with the problem of tuning and to check
for proper indexing in table and also in query.

Is This Answer Correct ?

3 Yes

1 No

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / monal

Update table statistics.

Is This Answer Correct ?

0 Yes

1 No

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / jerry joseph

Number of hits might have increased..

you can try increasing the timeout

Is This Answer Correct ?

0 Yes

2 No

Post New Answer