Re: Newbie seeking help on performance tuning - Oracle 7.3 Server, NT4, Dual PPro 180, 64Meg

In article <33725420.80512250_at_news.total.net>, lao2_at_total.net writes:
|> Hello.
|>
|> Dual PPro 180, 64Meg, SCSI 2 gig (decent speed)
|> NT4 Server, Oracle 7.3 for NT, IIS3
|>
|> A 20meg database, containing strings and integers.
|>
|> Web part calls SQL through ODBC, and right now my most significant
|> problem is that some SQL calls takes forever to to finish (e.g.
|> 30secs). I have solved some of the problems by creating indexes,
|> however when I do calls like:
|>
|> select * from table where first_name like '%john%'
|>
|> takes 9 seconds. I noticed that the 2 CPUs are like 5% so the bottle
|> neck should not be the processors. Oracle doesn't seem to use the
|> first_name index at all for the above SQL.
|>

With the % at the start of the value you are searching for Oracle will not use the indexs.

|> Same SQL being called the second time doesn't really improve at all.
|>
|> I tried to increase RAM hoping to improve caching but oracle doesn't
|> seem to use the additional RAM.

Did you change the value in your init.ora to tell oracle to use more resources?

|>
|> Any comments on how to start would be greatly appreciated.
|>
|> Thanks a million in advance.

HTH

-- 
Bill Kannawin (303)844-1479 kannawin_at_osmre.gov|
Technical Information Processing System       |
US Office of Surface Mining; 1999 Broadway,   |
Suite 3320, Denver, Colorado 80202            |