Home » Server Options » Data Guard » Performance problem on Data Guard
Performance problem on Data Guard [message #475547] Wed, 15 September 2010 09:45 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

I have migrated one schema of my database from 10gR2 to 11gR2. On this new database i have configured data Guard on maximum performance mode.

The problem my external users are facing is that while try to save a record on the page it is taking too much time to save the record.

since the old schema was on 10g database, the users were not getting the problem. even in my test 10g, it is not taking time, 20 to 30 sec.

But on 11g with data guard, users are waiting for 4 to 5 minutes even more.


Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/password
Connected.
DGMGRL> show configuration

Configuration - pup2

Protection Mode: MaxPerformance
Databases:
pup2 - Primary database
pup2stdby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL>

-----------------------------------



Please help?

sailesh
Re: Performance problem on Data Guard [message #475550 is a reply to message #475547] Wed, 15 September 2010 09:48 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please help?
Enable SQL_TRACE & post results from tkprof

What clues exist with alert_SID.log file for both Primary & Standby?
Previous Topic: Need help with dataguard installation
Next Topic: redo apply
Goto Forum:
  


Current Time: Thu Mar 28 23:41:00 CDT 2024