Oracle deadlocks: the what and the how

http://www.oratechinfo.co.uk/deadlocks.html

http://blog.hardeep.name/computer/programming/20090622/oracle-deadlocks/

http://docs.oracle.com/javadb/10.8.2.2/devguide/cdevconcepts28436.html

http://www.dba-oracle.com/t_deadlock.htm

SQL> show parameter %lock%

NAME                                 TYPE        VALUE
———————————— ———– ——————————
db_block_buffers                     integer     0
db_block_checking                    string      FALSE
db_block_checksum                    string      TYPICAL
db_block_size                        integer     8192
db_file_multiblock_read_count        integer     114
ddl_lock_timeout                     integer     0
distributed_lock_timeout             integer     60
dml_locks                            integer     8024
lock_name_space                      string
lock_sga                             boolean     FALSE

DISTRIBUTED_LOCK_TIMEOUT
http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams063.htm

DML_LOCKS
http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams075.htm#REFRN10051

DDL_LOCK_TIMEOUT
http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams068.htm

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s