Oracle Database 12c Certified Implementation Specialist 1z0-497 Book

The average active sessions were more than three times the number of CPU cores.

Active sessions were more than 10% of total load and CPU utilization was more than 50%.

Memory allocations were more than 95% of physical memory.

Hung sessions were more than 10% of total sessions.

A deadlock was detected.

The session limit was close to 100%.

It is ignored by the query optimizer.

It is not used while the index is being rebuilt.

The index cannot be rebuilt, and has to be re-created.

The index is automatically rebuilt when used the next time.

There is only one SYSTEM tablespace per CDB.

There is only one instance per PDB.

There is a set of redo log files per PDB.

There is only one UNDO tablespace per CDB.

There is one SYSAUXtablespace per PDB.

The database advances a checkpoint.

A client process commits a transaction.

The redo log buffer becomes full.

A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

A tablespace is changed to read-only status.

The database is shut down in immediate mode.