Toad World® Forums

REDO LOG SWITCHES

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.