| mohamed riaz |
Posted: Feb 27, 2008 12:48:27 AM |
Total Post: 74
Joined: Sep, 2006
|
Hi all,
please answer this question?
Let's say, user says performance of the database is low, in this case how will the DBA tune the database?
|
|
|
 Mohammed Taj |
| Posted: Feb 27, 2008 12:52:59 AM |  |
|
Total Post: 634
Joined: Jul, 2007
|
database tuning is not single line answer.
it is very vast.
need to search , research, please use google ,oracle forms or post here more details for more and clear answer.
|
|
|
|
|
| mohamed riaz |
| Posted: Feb 27, 2008 07:00:05 AM | |
|
Total Post: 74
Joined: Sep, 2006
|
Hi,
Basically how will you tune the database if the performance of the database is low.
Riaz
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 27, 2008 08:25:09 AM | |
|
Total Post: 634
Joined: Jul, 2007
|
you didn't understand what i said in my previous post.
for instance: generate statspack report and analyze
|
|
|
|
|
| Gitesh |
| Posted: Mar 12, 2008 11:13:10 PM | |
|
Total Post: 157
Joined: May, 2005
|
Hi,
There are lot of reasons to slow down performance of database. You can start with following steps.
Check tnsping to server how it reacts.
check usage of CPU and memory using top or topas command
Check memory and paging usage using sar and vmstat command
check database wait events for session level
Generate statspack reports for more investigation
Check alert.log any error logs in the trace files.
Check listener.log for newer entries.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
