Re: Exact table count for all tables in a schema.
Think about it---if any transactions are active, there can be no exact answer to your question.
About replication lag ...
- do master & slave status show the same log file name?
- what is master log position - Read_Master_Log_Pos
- what is master Position - Exec_Master_Log_Pos
- what is slave Read_Master_Log_Pos - Exec_Master_Log_Pos
- if using GTIDs see
https://blogs.oracle.com/jsmyth/what-causes-replication-lag
Subject
Views
Written By
Posted
478
September 13, 2019 01:53AM
127
September 13, 2019 09:43AM
114
September 16, 2019 11:15PM
113
September 17, 2019 10:07AM
108
September 19, 2019 12:24AM
Re: Exact table count for all tables in a schema.
110
September 19, 2019 09:38AM
108
September 20, 2019 04:04AM
114
September 20, 2019 09:50AM
101
September 20, 2019 10:03AM
108
September 20, 2019 12:45PM
112
September 22, 2019 11:51PM
97
September 23, 2019 10:21AM
116
September 24, 2019 10:45PM
113
September 25, 2019 11:01AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.