DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: suggestion required for Reports

  1. 08-11-2003, 01:24 AM #1
    mike1972
    mike1972 is offline Junior Member
    Join Date
    Aug 2003
    Posts
    5

    suggestion required for Reports

    Hi All,

    I have a Report developed in Excel which connects to about 30 databases and fetches data.what happens is when ever this report is run it consumes a lot of CPU resources and all other operations become very slow.Any suggestions of how else can the report be developed?
    Is there any alternative to get the output in Excel developed with aome other s/w?

    TIA

    Mike
    Reply With Quote Reply With Quote
  2. 08-11-2003, 03:57 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    code? version? explain plan?

    Read the post on how to ask questions
    Reply With Quote Reply With Quote
  3. 08-11-2003, 05:49 AM #3
    mike1972
    mike1972 is offline Junior Member
    Join Date
    Aug 2003
    Posts
    5

    Suggestion for reports

    My databases are running on 8.0.5 and the OC is HP Unix 10.2.
    I do know of the options of explain plan I just wanted to know if there is a faster way of developing reports rather than use Ora Excel?

    TIA

    Mike
    Reply With Quote Reply With Quote
  4. 08-11-2003, 06:01 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    all depends on wha you want to get out of them and what tools are available to use.

    i've seen reports run from excel really quickly. You need to trace to code to see why its taking too long and using too many resources
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width