What is ORA-00060?
What is ORA-00060?
While masking an Oracle database, you can sometimes encounter an ORA-00060 error which will cause your masking job to fail. The error specifically means that we attempted to write (a masked value) and Oracle encountered a deadlock situation which caused it to rollback the existing transaction.
How do I fix ORA-00060 deadlock detected?
Too high activity – Re-running the job during a less busy period can fix this ORA-00060 deadlock error. Poor application design – As noted in the trace file: “The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL.”
How to resolve deadlock error in ORAcle?
Resolving Oracle deadlocks
- Tune the application – Single-threading related updates and other application changes can often remove deadlocks.
- Add INITRANS – In certain conditions, increasing INITRANS for the target tables and indexes(adding slots to the ITL) can relieve deadlocks.
How can deadlock be removed?
One way is preemption by the help of which a resource held by one process is provided to another process. The second way is to roll back, as the operating system keeps a record of the process state and it can easily make a process roll back to its previous state due to which deadlock situation can be easily eliminate.
What is the maximum line size that Dbms_output can handle?
32767 bytes
Rules and Limits The maximum line size is 32767 bytes. The default buffer size is 20000 bytes.
What is table lock in SQL?
The LOCK TABLE statement allows you to explicitly acquire a shared or exclusive table lock on the specified table. The table lock lasts until the end of the current transaction. To lock a table, you must either be the database owner or the table owner.
What is the drawback of Banker’s algorithm?
Disadvantages of the Banker’s Algorithm It requires the number of processes to be fixed; no additional processes can start while it is executing. It requires that the number of resources remain fixed; no resource may go down for any reason without the possibility of deadlock occurring.