| santosh |
Posted: Jul 07, 2006 05:10:58 AM |
Total Post: 1
Joined: Jul, 2006
|
Dea All,
Pls tel me how can i increase the performance of the data base when i have 200 user data base is oracle 9i
User complain abt response time of the data base ,its vary slow
Pls tel me how can i resloved the problem.Where i can look 1st
If My Hit ratio's are ok and no any heavy transaction on the data base .
Pls tel me how can i approach with this problem |
|
|
 Salman |
| Posted: Aug 30, 2006 01:38:24 AM |  |
|
Total Post: 14
Joined: Aug, 2006
|
There are many many things which need to be considered, noone can tell you that where you could find the culprit as noone knows about your environment.
If you hit percentages are fine, there might be extra over head of hard parsing because your application is poor written.
You might have slow machine which is unable to hold the burden of processing done by your users.
You might have slow hard disks which are slow in IO thus decreasing your performance.
Also try to look at the PGA Aggregate size if workarea size policy is on.
Run statspack report on regular intervals to find out the bottlenecks
Regards
|
|
|
|
|
| wizdb |
| Posted: Sep 04, 2006 02:05:34 AM | |
|
Total Post: 1
Joined: Sep, 2006
|
You can query your data dictionary to understand your instance performance.
you can query v$session_wait, v$session_event, v$system_event to find your resource contention in your instance.
you can use oracle tools like statspack or you can use a 3rd party tools like Quest Performance analysis which monitor your instance behavior.
|
|
|
|
|
| PP |
| Posted: Oct 26, 2006 01:34:41 AM | |
|
Total Post: 11
Joined: Oct, 2006
|
The first place to look would be oracle documentation on performance tuning, it will certainly hellp you to find where the culprit lies.
|
|
|
|
|
| Avi |
| Posted: Apr 27, 2007 01:21:07 AM | |
|
Total Post: 7
Joined: Apr, 2007
|
HI ,
THE FIRST THING U NEED TO USE Is to check ur settings for shared pool-ie. library cache and dictionary cache....
increase ur shared pool so maximum sql statements can be reused...
that mus b a problem....
n declare muliple buffer cache and reserved share pool too
ur problem will b solved
|
|
|
|
|
| kareem |
| Posted: Jun 04, 2007 01:06:32 AM | |
|
Total Post: 5
Joined: May, 2007
|
If you database is in deticated server than change to shared server and change the max_despatcher parameter to 20 .Definately it will help to you.
and also increase sga_max_size,shared_pool_size which will take care of DDL and DML language.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
