Using SQLTXPLAIN with an Active Data Guard Environment

  • 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 Data Guard physical standby databases cannot be written to 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 

Copyright information

© Stelios Charalambides  2017

Authors and Affiliations

  • Stelios Charalambides
    • 1
  1. 1.New HamptonUSA

Personalised recommendations