| Paul R |
Posted: Jan 18, 2008 10:37:41 PM |
Total Post: 2
Joined: Jan, 2008
|
Hello There ,
Can anyone briefly explain me the minimal parameters required for configuring standby database ? and also please provide me a simple method to handle performance issues .
Cheers ,
Paul
|
|
|
 Vinod |
| Posted: Jan 18, 2008 11:27:55 PM |  |
|
Total Post: 54
Joined: Oct, 2007
|
Hi Paul,
The minimal parameters required to configure a standby database are listed below ,and for basic monitoring of performance you could make use of ASH,AWR,ADDM reports in 10g and statspack in 9i .
fal_client
fal_server
log_archive_dest_1
log_archive_dest_2
remote_archive_enable
local_listener
log_archive_dest_state_1
log_archive_dest_state_2
-Vinod
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 19, 2008 12:40:20 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Addition of above listed parameter set below parameter also
1. db_unique_name
2. service_name
3. remote_login_password
4. standby_file_managment
5. db_file_convert_name / log_file_convert_name
6. log_archive_dest_state_n
and for performance you can figure out
1. sql trace with tkprof utility
2. explain plan
3. autotrace
4. 10046 and 10053 trace event with tkprof utility
hope this helps
|
|
|
|
|
| Paul R |
| Posted: Jan 19, 2008 01:22:57 PM | |
|
Total Post: 2
Joined: Jan, 2008
|
Attn Taj
I had asked about the minimum configuration ... I know that there are n number of other parameters in standby/dataguard configurations.
-Vinod ,I really appreciate the way you answered my question .
Paul
+44 7799 2313 4342
|
|
|
|
|
| Murtuja |
| Posted: Jan 21, 2008 01:48:47 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Paul,
Are you looking Standby database performance related solutions or general database performance related solutions ?
Please also provide us your Database version and OS information.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
