Hcheck Script is running Long in oracle database 12.2.0.1 for upgrade Precheck.
Hi,
We are performing upgrade 12.2.0.1 to 19c, before upgrade we perform precheck activity like running Hcheck script to find the potential issue like data dictionary problems.
The hcheck log is running continuously for a long time, as shown below.
*** 2025-04-28T08:16:01.613373-04:00
^ TAB$ has 2 rows
MULTI DICT REF: TS=6 RFILE/BLOCK=19/3376522 cnt=2
*** 2025-04-28T08:16:05.207715-04:00
^ TAB$ has 2 rows
MULTI DICT REF: TS=6 RFILE/BLOCK=18/2821154 cnt=3
*** 2025-04-28T08:16:08.808426-04:00
^ TAB$ has 3 rows
MULTI DICT REF: TS=6 RFILE/BLOCK=18/2699090 cnt=4
Kindly provide a solution for the issue if you are already encountering the situation described above.
Thanks,