Oracle Database performance on Windows 2003 with IIS 6

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Seung Y. Kim
    #1

    Oracle Database performance on Windows 2003 with IIS 6

    Hi everyone.

    I am having a big performance issue with my ASP application with
    Oracle database.

    The application itself is a very database-generic one, so I can switch
    from Access to SQLServer to Oracle with ease.

    The web-application runs great with Access and SQLServer. But when it
    comes to Oracle, the performance really lags.

    The Oracle server is 8.1.7 located in other server, and the web-server
    is the Oracle client. In windows 2000, I never had any performance
    issue with Oracle (actually Oracle was the fastest of all three
    database)

    Now that I move the application to Windows 2003 with IIS 6 on, the
    performance really lags.

    I have tried using both ODBC and OLE DB Drivers (from Microsoft and
    Oracle), and none of them seem to make any improvements.


    Any ideas of what's going on?
    Tags: None
    • Ana C. Dent
      #2
      Re: Oracle Database performance on Windows 2003 with IIS 6

      seungykim@hotma il.com (Seung Y. Kim) wrote in
      news:d75ccfe9.0 409011621.75e23 d8d@posting.goo gle.com:
      Hi everyone.
      >
      I am having a big performance issue with my ASP application with
      Oracle database.
      >
      The application itself is a very database-generic one, so I can switch
      from Access to SQLServer to Oracle with ease.
      >
      The web-application runs great with Access and SQLServer. But when it
      comes to Oracle, the performance really lags.
      >
      The Oracle server is 8.1.7 located in other server, and the web-server
      is the Oracle client. In windows 2000, I never had any performance
      issue with Oracle (actually Oracle was the fastest of all three
      database)
      >
      Now that I move the application to Windows 2003 with IIS 6 on, the
      performance really lags.
      >
      I have tried using both ODBC and OLE DB Drivers (from Microsoft and
      Oracle), and none of them seem to make any improvements.
      >
      >
      Any ideas of what's going on?
      >
      You are paying the price of being database neutral?
      On the average, it all evens out.

        Comment

        • Pratap
          #3
          Re: Oracle Database performance on Windows 2003 with IIS 6

          It's a very generic question and there are no straight answer. Just a
          few guidelines -

          1. Make sure you gather statistics on tables and indexes to be used by
          CBO

          2. Identify the problem areas. Drill down to the screens, functions
          that are having performance issues.

          3. There is no generic solution to performance problems. Identify the
          problem areas to the micro level and then tackle them.

          Pratap

            Comment

            Previous template Next
            Working...