| slowness [message #468698] |
Sun, 01 August 2010 12:16  |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
hello all
actually i try every thing to solve his issue and not solved
the problem is that i have system on oracle 6i
and every thing is working fine there is screen it have button when u pressed it , it called report
and suddenly before two weeks when we request the report from the screen it take long time
before it was take just 30 second
now it took 6 minutes
and system stuck in this period
be note that the system working fine and another screens is working fine
please it urgent issue
thanks
|
|
|
|
|
|
|
|
|
|
|
|
| Re: slowness [message #468752 is a reply to message #468750] |
Mon, 02 August 2010 01:33  |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
"CORE 10.2.0.1.0 Production"
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
the database is 10g and the forms is 6i
i answered him and i reply that it forms 6i
|
|
|
|
|
|
| Re: slowness [message #468769 is a reply to message #468755] |
Mon, 02 August 2010 02:34 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Is it just that one report?
Does the report have one query or multiple queries?
If you run the report directly from report builder how long does it take?
|
|
|
|
| Re: slowness [message #468782 is a reply to message #468769] |
Mon, 02 August 2010 03:54 |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
no it not only this report
we have screen that pass the parameter form to the report
when we request the report from that pass the parameter form it take long time
before the report is executed
from report builder it run ok
|
|
|
|
|
|
| Re: slowness [message #468795 is a reply to message #468793] |
Mon, 02 August 2010 04:04 |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
it passing parameter and request the report
it before month working fine
and we not doing any modification
do u think it realted to database
|
|
|
|
|
|
| Re: slowness [message #468798 is a reply to message #468797] |
Mon, 02 August 2010 04:13 |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
we have application server
ya it client-server
i dont think that report server have problems coz there is some reports working fine
|
|
|
|
|
|
| Re: slowness [message #468822 is a reply to message #468804] |
Mon, 02 August 2010 04:51 |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
yes i said most not all
and actually the important this report
and this report was working fine before
and suddenly this problem happenned
to be clear all report which depend for these tables have problems
|
|
|
|
| Re: slowness [message #468825 is a reply to message #468822] |
Mon, 02 August 2010 04:59 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
When you tested the report from report builder did you do it against the production DB or a dev/test one?
Have you got more data in these tables than you used to have?
|
|
|
|
|
|
| Re: slowness [message #468832 is a reply to message #468827] |
Mon, 02 August 2010 05:06 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
You need to debug the form and find out where the time is being spent.
Put messages in various places showing the current date/time.
If all the time is spent after the call to the report then it's either the report itself or, as Littlefoot suggested, the report server that's causing the problem.
|
|
|
|
|
|
| Re: slowness [message #468843 is a reply to message #468841] |
Mon, 02 August 2010 05:19 |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
YES THEY HAVE INDEXES
AND I ANALYZE IT BUT IT NOT WORK
WHEN I ANALYZED IT ,IT RETURN TO 30 SECONDS AND IT NORMAL
BUT AFTER ONE HOUR IT RETURN TO SLOW
|
|
|
|
| Re: slowness [message #468855 is a reply to message #468843] |
Mon, 02 August 2010 05:27 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
1) Do not post in all caps!
2) Do you do a lot of inserts/updates/deletes on the tables referenced by the report?
|
|
|
|
|
|
|
|
| Re: slowness [message #468877 is a reply to message #468875] |
Mon, 02 August 2010 06:27 |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
no problem
i check cpu and ram
and i check also disk drive free space
and i check database free space
and every thing is fine
|
|
|
|
|
|
|
|
| Re: slowness [message #469015 is a reply to message #468885] |
Tue, 03 August 2010 00:32 |
muradjuber
Messages: 60
Registered: August 2010
|
Member |
|
|
hello all
after i check i found that there is view in the screen which pass it to the report
and this view it very slow when i run it on database
do any one have idea hpw to fast it???
thanks
|
|
|
|
| Re: slowness [message #469021 is a reply to message #469015] |
Tue, 03 August 2010 00:59 |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
A view is a stored SQL statement. Therefore, you'd have to tune that SELECT. Go to our Performance tuning forum and, as a first step, read a sticky. It might give you some ideas. If you still can't make it work any faster, open a topic in there, provide all details that might help people help you and - wait.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
