Re: switchover_status in v$database

emdproduction_at_hotmail.com schrieb:
> I am learning dataguard, it is 9206 on linux.
>
> When I do
> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
> on my primary site, I see "session active", but when I search against
> v$session, I did not see anybody except myself, which is "sys", and I
> am the only person who is playing with the box.
>
> What is going on here?
>
> Thanks for your help.
>

Try to
alter system set aq_tm_processes=0;
alter system set job_queue_processes=0;

(if you are using spfile, then probably scope=memory) and then select again.

Best regards

Maxim Received on Fri Aug 11 2006 - 09:19:17 CDT