Oracle DBA, How To, Error, Cause and Action

ORA-02474: Fixed hash area extents used (string) exceeds maximumallowed (string)

ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)




Cause: The number of extents required for creating the fixed hash area exceeds the maximum number allowed.




Action: Reduce the number of extents required by increasing the extent allocation sizes within the STORAGE clause.