Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Lightbulb Unanswered: How to increase the performance of oracle?


    Please tell me how to incease the performace of oracle.
    I'm using materelized views and its taking too much time to refresh them.
    I have approximatly 99,000 record in the table, so when I'm using simple views its taking soo much time.
    Help me please as soon as possible.


  2. #2
    Join Date
    Mar 2004
    Fort Worth, Texas, USA
    Please tell us more about the hardware running Oracle, the structure of your data, indexing, etc. Perhaps post the query that populates the MV?

    The good news is that 99,000 records is trivial for Oracle on most platforms. You should be able to get great performance.

Posting Permissions

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