Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle performances on NT

Re: Oracle performances on NT

From: Carl Tierney <carltierney_at_email.msn.com>
Date: Sat, 1 Aug 1998 17:09:04 -0400
Message-ID: <#BHYNGZv9GA.241@upnetnews05>


I would start with general Oracle tuning before I looked for NT specific help. Try using an explain plan on your query. The Oracle 8 tuning book is a good place to start, if you can't find it there, I would start looking at your physical design then.

Tanner Alexandre wrote in message <01bdbbbc$4a927580$2100a8c0_at_alexandre>...
>Hello everyone,
>
>Could someone tell me what I have to do to accelerate the Oracle server on
>NT4.0 platform ?
>Database has 435 tables with 10 to 190000 rows; I use a native driver for
>the main appli and ODBC driver for reporting.
>When runing a simple query, it takes ages to show the result.
>Does it have to see with indexes or special parameters ?
>
>Thanks, Alexandre
>
Received on Sat Aug 01 1998 - 16:09:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US