Home » Server Options » Data Guard » how to get sql plan in standby database (10.2.0.1)
how to get sql plan in standby database [message #547485] Wed, 14 March 2012 07:33 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I want to get the execute plan of a sql in standby database(read only),but failed,how can i do?

SQL> explain plan for select count(1) from hxl.tb_objects;
explain plan for select count(1) from hxl.tb_objects
                        *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-16000: database open for read-only access


SQL> select count(1) from hxl.tb_objects;

  COUNT(1)
----------
  22238018

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ ONLY

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Advantage of having Standby redo logs
Next Topic: PING[ARCX]: Heartbeat failed to connect to standby 'XXX'. Error is 1034
Goto Forum:
  


Current Time: Wed Jan 22 20:41:49 CST 2020