You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

slowness in query execution in Active Dataguard (readonly) OCI - DBCS (12.1.0.2.0)

Accepted answer
191
Views
13
Comments
in Database 13 comments

Summary:

We have ADG for our Production environment and reports are running very slow in this environment, kindly advice how to tune the performance

DB Role: PHYSICAL STANDBY (READ ONLY WITH APPLY)

DB Version: 12.1.0.2.0 (OCI - DBCS)

Content (required):

ADG (readonly) environment query performance is very slow and same query was executed in Standalone DBCS environment is very smooth and fast

Version (include the version you are using, if applicable):

Active Dataguard - DB Version: 12.1.0.2.0 (OCI - DBCS)

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!