#session level

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Error Transaction is aborted and we need to restart the transaction. Some other transaction is blocking the transaction. ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Solution We have two solutions for this 1. Increase the database parameter value “innodb_lock_wait_timeout”. 2. Check the…

Temporary Table in Oracle

Temporary Table in Oracle

Temporary table is the table exists in memory for the duration of session or transaction as declared. Data in temporary table is private to the session

You can create temporary table as 1. Global temporary table 2. Private temporary table

Difference between Global And Private temporary table 1. Global name same as permanent table V/S Private table have prefix “ORA$PTT_”.