Dear All,
I have a table with 108 billion rows and migrating this database from
Oracle 11g on Solaris to Oracle 12c on Linux.
After the migration I need to compare the row count of this table in both
the source DB and the destination DB. It takes almost two hours to get the
row count from this table.
SQL> select to_char(count(*), '999,999,999,999') from test_data;
TO_CHAR(COUNT(*)
----------------
108,424,262,144
Elapsed: 02:22:46.18
Could you please suggest some tips to get the row count faster so that it
reduces the cut-over downtime.
Thanks,
Ashoke