Showing posts with label Database Issues. Show all posts
Showing posts with label Database Issues. Show all posts

SYSAUX tablespace is growing erratically due to growth of WRI$_OPTSTAT_HISTHEAD_HISTORY table

This is a bug of oracle. If gather schema takes much time it doesn't complete the full operation and  WRI$_OPTSTAT_HISTHEAD_HISTORY keeps up growing. It exhausts the SYSAUX tablespace. Oracle recommends a patch to be applied to resolve the above problem. But, in our case there is some

ORA-27123 error during oracle database start

Issue
While starting the oracle database 10g [10.1.0.5.0], we get the following error.

ORA-27123: unable to attach to shared memory segment

opidcl aborting process unknown ospid (xxxx_xxxxxxx) due to error ORA-28

In oracle database version 11.1.0.7, we have encountered the following error message.
opidcl aborting process unknown ospid (12874_47230856307152) due to error ORA-28

ORA-10173 Dynamic Sampling time out error

In the alert log file, we have encountered the following error.
ORA-10173 Dynamic Sampling time-out error