Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2017 Stelios Charalambides
About this chapter
Cite this chapter
Charalambides, S. (2017). Using SQLTXPLAIN with an Active Data Guard Environment. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2436-6_15
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2436-6_15
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2435-9
Online ISBN: 978-1-4842-2436-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books