Re: Why is query time SLOW on NT?

Well there a lot of things you can look into to make the database query faster. There is a manual on Oracle Tuning. No matter how big the machine is if the right resources are not allocated to the database it will not perform to your expectations.

Quick thing to look at:

1. Shared Pool Size in the initSID.ora file. Make the parameters in this file to Medium if you have enough resources.
2. Big enough temp tablespace for sorting.
3. Index tablespace and indexes on all tables (at least for the keys).

After that you can look into the advanced tuning techniques including explain plan, etc.

HTH Prasad Chavali
pchavali_at_assettech.com

PERRY wrote in message <6rcj1m$6qb$1_at_sun500.nas.nasa.gov>...
>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
>
>
Received on Tue Aug 18 1998 - 14:38:28 CDT