| Performance tuning help - from a newbie..... [message #66122] |
Thu, 29 November 2001 06:36  |
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  |
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 .
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
