有相应的trace文件吗？
先确认下是不是这个bug。

Error in the Alert Log: ORA-7445[qeshrGetUHash_Fast()+480] Generated by EMAgent (Doc ID 2488212.1)

The following error occurred in the alert log:

ORA-07445: exception encountered: core dump [qeshrGetUHash_Fast()+480] [SIGSEGV] [ADDR:0x7F61BEBB4AD6] [PC:0x10C2BC60] [Address not mapped to object] []

The Current SQL Statement in the associated incident trace file shows a query generated by the EMAgent (*** MODULE NAME:(emagent_SQL_rac_database) 2018-12-15T02:27:49.156290+00:00):

with latest_run as
(
SELECT all_runs.CON_ID,
all_runs.OWNER,
all_runs.JOB_NAME,
all_runs.STATUS
FROM CDB_SCHEDULER_JOB_RUN_DETAILS all_runs,
(SELECT CON_ID,
OWNER,
JOB_NAME,
MAX(ACTUAL_START_DATE) AS START_DATE
FROM CDB_SCHEDULER_JOB_RUN_DETAILS
GROUP BY CON_ID,OWNER,JOB_NAME) latest_runs
WHERE latest_runs.CON_ID =all_runs.CON_ID
AND latest_runs.OWNER=all_runs.OWNER
AND latest_runs.JOB_NAME=all_runs.JOB_NAME
AND all_runs.ACTUAL_START_DATE= latest_runs.START_DATE
)
SELECT pdb_name, SUM(broken), SUM(failed)
FROM (SELECT c.name pdb_name,
DECODE(broken, 'N', 0, 1) broken,
DECODE(NVL(failures,0), 0, 0, 1) failed
FROM cdb_jobs j, v$containers c
WHERE j.con_id = TO_NUMBER(c.con_id)
UNION ALL
SELECT c.name pdb_name,
DECODE(failed_details.STATE, 'BROKEN', 1, 0) broken,
DECODE(failed_details.STATUS , 'FAILED', DECODE(failed_details.STATE,'BROKEN',0,'DISABLED',0,1), 0) failed
FROM v$containers c,
(SELECT all_jobs.CON_ID,
all_jobs.OWNER,
all_jobs.JOB_NAME,
latest_run.STATUS,
all_jobs.STATE
FROM CDB_SCHEDULER_JOBS all_jobs,latest_run
WHERE latest_run.CON_ID=all_jobs.CON_ID
AND latest_run.OWNER=all_jobs.OWNER
AND latest_run.JOB_NAME=all_jobs.JOB_NAME
) failed_details
WHERE failed_details.con_id = TO_NUMBER(c.con_id)
)
GROUP BY pdb_name
 

The Call Stack Trace in the same incident trace file shows:

qeshrGetUHash_Fast <- qeshLoadRowForGBY0 <- qerghRowPRowsetsFastAggs
 <- kpdbcvFetchCbkCon <- kpdbcvFetch <- qerfxFetch <- qergiFetch <- qerghFetch
  <- qertqoFetch <- qerpxSlaveFetch <- qerpxFetch <- opiexe <- kpoal8 <- opiodr <- kpoodr
   <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- kxfxsStmtExecute <- kxfxsExecute
    <- kxfxsp <- kxfxmai <- kxfprdp_int <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain
     <- main
复制

CAUSE
The cause for this issue is undetermined.

It’s currently being investigated in:

 Bug 29004070 - ORA-07445 CORE DUMP [QESHRGETUHASH_FAST()+880] GENERATED BY EM METRIC.
复制

SOLUTION
Workarounds:

1.  Set _px_cdb_view_enabled to false:

SQL> alter system set "_px_cdb_view_enabled"=FALSE scope=both sid='*';
-OR-

2.  Set _rowsets_cdb_view_enabled to false:

SQL> alter system set "_rowsets_cdb_view_enabled"=false;
 
复制

However, this settings should be carefully tested before implementing them at the system level (CDB or CDB/PDB both).

需要重启吗

这个不需要重启，但是你要先确认是不是这个bug