Re: Why is query time SLOW on NT?

Hi Perry,

        I just ran the query on a four processor Pentium and counted a 38500 row table in under three seconds. I have my init<sid>.ora parameters all set to large -- and then some :-) Edit the init file and set everything to large. shutdown the database and then start it up and look at the configuration statistics to see how big your SGA is. This will give you some indication as to how far you can push the parameters. Next look at the distribution of your tables and oracle system files across your disks. Spread stuff out as far as you can.

        I strongly recommend that you get a book or two on Oracle Performance Tuning. Two good ones are the O'Reilly and Associates book by Corrigan and Gurry and the Oracle Press Osborne McGraw-Hill book on tuning. (I found them both to be excellent but if I was only buying one I would go with Corrigan and Gurry.)

regards

Jerry

PERRY wrote:
>
> Hi all,
>
> I am running Personal Oracle 8 on a dual 200 Pentium pro NT system. It has
> plenty of fast disk storage and 128mb RAM. Should be fast, right? Not with
> Oracle!
>
> I have a sample table with 1337 rows. When I use SQL*Plus to issue the
> command
>
> select count(rowid) from ca2p1;
>
> it takes 45 seconds to return the response
>
> COUNT(ROWID)
> ------------
> 1337
>
> This seems a bit excessive and leads me to believe there is something
> seriously amiss with the default database tuning parameters. Can anyone
> suggest a 'reasonable' level to assign some of the tuning parameters so that
> this pig actually flies?
>
> Ultimately, I will have a single fairly large database with multiple
> tables - I would hate to think how long a simple query on a table with
> 100,000 records would take!
>
> Thanks,
>
> Perry
> PMeade_at_mail.arc.nasa.gov

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group