Wait Event – Batched allocate scn lock request

A session is waiting on another process to allocate a system change number (SCN). If the foreground timed out waiting on a process to get the SCN, the foreground will get the SCN.

Wait Event – ARCH Remote Write

Used to track the time (in centiseconds) that ARCn background processes spend blocked waiting for network write operations to complete.

Wait Event – alter system set dispatcher

A session has issued a statement ALTER SYSTEM SET DISPATCHER = string and is waiting for the dispatchers to get started. Wait Time: The session will wait 1 / 100 of a second and verify if the new dispatchers have started, else the session will wait again

ORA-00059 Maximum number of DB_FILES exceeded

Cause: The value of the DB_FILES initialization parameter was exceeded. Action: Increase the value of the DB_FILES parameter and warm start.

ORA-00058 DB_BLOCK_SIZE must be %s to mount this database (not %s)

Cause: DB_BLOCK_SIZE initialization parameter is wrong for the database being mounted. It does not match the value used to create the database. Action: Fix the value of the DB_BLOCK_SIZE parameter or mount a database that matches the value.

ORA-00057 Maximum number of temporary table locks exceeded

Cause: The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts. Action: Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.

ORA-00056 DDL lock on object ‘%s.%s’ is already held in an incompatible mode

Cause: An attempt was made to acquire a DDL lock that is already locked. Action: This happens if you attempt to drop a table that has parse locks on it.

ORA-00055 Maximum number of DML locks exceeded

Cause: Ran out of DML lock state objects. Action: Increase the value of the DML_LOCKS initialization parameter and warm start.

ORA-00054 Resource busy and acquire with NOWAIT specified or timeout expired

Cause: Interested resource is busy. Action: Retry if necessary or increase timeout.

ORA-00053 Maximum number of enqueues exceeded

Cause: Ran out of enqueue state objects. Action: Increase the value of the ENQUEUES initialization parameter.