OraFAQ Forum: Reports & Discoverer » Character Report generation too slow.....

Home » Developer & Programmer » Reports & Discoverer » Character Report generation too slow.....

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Character Report generation too slow..... [message #478681]

Mon, 11 October 2010 23:30

prisharma85
Messages: 1
Registered: October 2010
Location: Chandigarh

Junior Member

Hi Experts ... kindly resolve this ?

Problem:

I am using :

Database : Oracle 8i
Application Server: Oracle AS 9i
Developer Suite : Oracle 6i(forms & reports)

I have created some character reports in oracle reports 6i.. when reports used run from my ERP(oracle 6i oriented) ... report usually took time to create on server. Sometimes my ERP used to hang up due to reports lock. And then we have to kill some processes to finally create charater reports in emergency basis.

What is the valid reason for locks on report(character file )creation.?

Expecting a solution.

Thanks in advance

Priya

Report message to a moderator

Re: Character Report generation too slow..... [message #478682 is a reply to message #478681]

Mon, 11 October 2010 23:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Database : Oracle 8i
Obsoleted & unsupported
>Application Server: Oracle AS 9i
Obsoleted & unsupported
>Developer Suite : Oracle 6i(forms & reports)
Obsoleted & unsupported

>What is the valid reason for locks on report(character file )creation.?
Oracle SQL always allows SELECT to return result set.

How can we reproduce your problem?
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Character Report generation too slow..... [message #478694 is a reply to message #478682]

Tue, 12 October 2010 01:33

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is, perhaps, report's query "badly" written (i.e. should be optimized)? Maybe, quite a few years ago, when there was no that many data stored within the database, reports ran well. Now it struggles to complete.

Are columns (you use in WHERE clause) properly indexed?

Check our How to tune SQL or Identify Performance Problem and Bottleneck sticky in Performance Tuning forum; perhaps it'll help.

Report message to a moderator

Re: Character Report generation too slow..... [message #479043 is a reply to message #478694]

Thu, 14 October 2010 07:01

kumar2012
Messages: 3
Registered: September 2010
Location: chennai

Junior Member

Priya,

first checked out the versions of the oracle 8i,d2k and one more thing which apps version u can used.

Oracle SQL always allows SELECT to return result set.

regards,
Sureshkumar
consultant

Report message to a moderator

Re: Character Report generation too slow..... [message #479044 is a reply to message #479043]

Thu, 14 October 2010 07:22

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is not that select returns nothing, but it returns result set SLOWLY.

Report message to a moderator

Previous Topic:	Oracle 6i Report
Next Topic:	error in reports 6 on creating pdf file from a form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 17:59:40 CDT 2024