suggestion required for Reports
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: suggestion required for Reports

  1. #1
    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    code? version? explain plan?

    Read the post on how to ask questions

  3. #3
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

Posting Permissions

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



Click Here to Expand Forum to Full Width