Hi, I am using Toad for Oracle 12.6.0.53. My database is a RAC database, 10.2.0.5 with a physical standby. I use standby redo logs for real time redo apply. The “log switch frequency map” is counting both the redo log switches and the standby redo log switches. Is this a bug? I have an 11g database, not RAC, but it uses standby redo logs for data guard and the log switch frequency map shows correctly, i.e, only the redo log switches, not the standby logs.
Additionally toad does not show standby redo logs.
Thank you in advance
Sam
When you are connected to RAC, look for a dropdown at the top of the screen that says “Thread” Set it to “Thread = Instance ID”.
Ok, Thanks.
From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Sent: Friday, February 06, 2015 3:03 PM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] REDO LOG SWITCHES
RE: REDO LOG SWITCHES
Reply by John Dorlon
When you are connected to RAC, look for a dropdown at the top of the screen that says “Thread” Set it to “Thread = Instance ID”.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error, you may not disseminate, distribute or copy this e-mail or any attached files. Please
notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are not the intended recipient or if you received this e-mail in error, you are hereby notified
that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.
How about showing standby redo logs?
sam
That information comes from v$log_history. I was looking for a version of that view which deals with standby log history, but I don’t see one. I don’t have a database like this to test on, so it’s tough to tell - does V_$STANDBY_LOG look like it has that info?
Yes, that is what I use if I need to query for standby log information.
From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Sent: Friday, February 06, 2015 3:15 PM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] REDO LOG SWITCHES
RE: REDO LOG SWITCHES
Reply by John Dorlon
That information comes from v$log_history. I was looking for a version of that view which deals with standby log history, but I don’t see one. I don’t have a database like this to test
on, so it’s tough to tell - does V_$STANDBY_LOG look like it has that info?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error, you may not disseminate, distribute or copy this e-mail or any attached files. Please
notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are not the intended recipient or if you received this e-mail in error, you are hereby notified
that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.