CHAPTER 9
Using SQLTXPLAIN with Data Guard Physical Standby Databases
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.
Data Guard Physical Standby Database
Data Guard is a piece of technology, developed by Oracle in response to a “what if” scenario. What if my data center is completely wiped out by flooding? What if a fire ...
Get Oracle SQL Tuning with Oracle SQLTXPLAIN now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
