Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stats collection on DG affects standby database

Status
Not open for further replies.
billo102

billo102

Technical User
Mar 2, 2009
31
0
0
GB
HI
We implemented active dataguard on an 11.2.0.2 database. We have a weekly stats collection job that runs against the primary node and gathers stats on select schemas

dbms_stats.gather_schema_stats

There are certain queries that subsequently hang when running against the read-only standby database (the whole database then hangs). To fix it we restart the standby database and the queries run fine. The queries will be fine until the next time the stats collection job runs and the same issue occurs.

any ideas as to what is happening here ? Why do we need to restart the standby database after stats collection in order to fix the issue?
 
  have a weekly stats collection job that gathers stats on several schemas dbms_stats.gather_schema_stats
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
141
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
96
Livia8
Livia8
kernal
  • Locked
  • Question
If there is a Fee on Class Level then that fee overrides Fee on Course Level 1
Replies
3
Views
55
kernal
kernal
Aung Thurein Tun
  • Locked
  • Question
opera_mail.AuthenticateCredential error ORA-20001 in Oracle Database
Replies
0
Views
78
Aung Thurein Tun
Aung Thurein Tun
BJoy
  • Locked
  • Question
Bulk insert from C# into Oracle Database
Replies
4
Views
126
karluk
karluk

Part and Inventory Search

Sponsor

Back
Top