Home » RDBMS Server » Networking and Gateways » Performance tuning help - from a newbie.....
Performance tuning help - from a newbie..... [message #66122] Thu, 29 November 2001 06:36 Go to next message
Rob Mason
Messages: 1
Registered: November 2001
Junior Member
so please be gentle...

We have a client who is running our access front-end Oracle 8.0.5 back end app over netware 5.1 to an NT4 server - and the performance is awful!!!! I am looking for suggestions that could improve the current performance if possible.

Thanks in advance!

----------------------------------------------------------------------
Re: Performance tuning help - from a newbie..... [message #66130 is a reply to message #66122] Thu, 06 December 2001 19:31 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
hi ,
so you worring about performance ha ?.

How large is your database ?
How many database objects do you have ?
You need first analyse your sql queries .Check out wheather all the queires are using indexes if not then rewrite it .The retrieving time is fast when we use indexes .use hints , which optimization mode u uing ?

check
Shared_pool_size
buffer_cache
pin the subprograms

there is no such hard and fast method so that u will do it and u get good performance , this process start from database design .

----------------------------------------------------------------------
Previous Topic: Re: asp page says: ORA-12224: TNS:no listener
Next Topic: Re: Can't Install 8i Client on Pentium 4 , NT 4 machine??
Goto Forum:
  


Current Time: Sun Feb 25 07:05:09 CST 2024