Using SQLTXPLAIN with Data Guard Physical Standby Databases

  • Stelios Charalambides


SQLTXPLAIN is a great tool designed to help with SQL tuning problems, but its effectiveness is limited when the database is a read-only Data Guard physical standby database. Read only databases like a Data Guard physical standby databases cannot be written to by utilities such as SQLTXPLAIN. In this chapter we explore the special tools created just to deal with Data Guard.


Execution Plan Trace File Secure Location Primary Database Database Link 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Stelios Charalambides 2013

Authors and Affiliations

  • Stelios Charalambides

There are no affiliations available

Personalised recommendations