You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
With "select max(thread#) from v$log" we get the number of threads.
Yes, it can be different than "select count(*) from v$log", which is the total of the members and it is expected.
For example, in this case:
SQL> select GROUP#,THREAD#,MEMBERS from v$log;
GROUP# THREAD# MEMBERS
1 1 1
2 1 1
3 1 1
SQL> select max(thread#) from v$log;
MAX(THREAD#)
1
SQL> select count() from v$log;
COUNT()
3
Are you speaking about "select max(group#) from v$log;" instead?
The script assumes
"select max(group#) from v$log"
is the same as
"select count(*) from v$log"
This is not guaranteed to be true.
The text was updated successfully, but these errors were encountered: