RE: Deadlocks

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Thu, 27 Apr 2000 09:14:26 +0500
Message-Id: <10479.104252@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_000_01BFAFFF.133BEAC0

Content-Type: text/plain;

        charset="iso-8859-1"

Tom,
Which monitoring tool are you using?
TIA
Aleem

		-----Original Message-----
		From:	blair_at_pjm.com [mailto:blair_at_pjm.com]
		Sent:	26 April, 2000 9:56 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Deadlocks

		A monitoring tool that we use here is reporting that our
database has a
		deadlock.  We have not noticed it and there are no

complaints.

                I challenged the company to tell me how they determine this. They are checking

                the v$sysstat for the value of "enqueue deadlocks" which in this case is 1.

                Is this correct? Is there a change from V7.x to 8.1.5 in how you would

                determine a deadlock condition?

                thanks,

                ..tom

		-- 
		Author: 
		  INET: blair_at_pjm.com

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists         

---

                To REMOVE yourself from this mailing list, send an E-Mail message

                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).
You may
		also send the HELP command for other information (like

subscribing).

------_=_NextPart_000_01BFAFFF.133BEAC0

Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IhsEAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0AcEABsACQAOABoABAArAQEggAMADgAAANAHBAAb AAkADgAaAAQAKwEBCYABACEAAABFNTQ0N0QyNDE0MUNENDExOTE3NzAwNTBCQTAxNjkwNADKBgEE gAEADgAAAFJFOiBEZWFkbG9ja3MAewQBDYAEAAIAAAACAAIAAQOQBgCYDgAAMQAAAAsAAgABAAAA CwArAAAAAAADAC4AAAAAAAIBMQABAAAA4AAAAFBDREZFQjA5AAEAAgBtAAAAAAAAADihuxAF5RAa obsIACsqVsIAAG1zcHN0LmRsbAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxXSU5ET1dTXEFwcGxp Y2F0aW9uIERhdGFcTWljcm9zb2Z0XE91dGxvb2tcYWxlZW0ucHN0ABgAAAAAAAAAfPKIhWPr0hGX EACAyHssAuKBAAAAAAAAGAAAAAAAAAB88oiFY+vSEZcQAIDIeywCAoIAABAAAADlRH0kFBzUEZF3 AFC6AWkEDgAAAFJFOiBEZWFkbG9ja3MAQAA5AJAOLhP/r78BHgBwAAEAAAAKAAAARGVhZGxvY2tz AAAAAgFxAAEAAAAbAAAAAb+vrIVoG+WRvhqlEdSyeABQugFnPAAUW62gAB4AMUABAAAADAAAAEFC Q0hBVURIQVJZAAMAGkAAAAAAHgAwQAEAAAAMAAAAQUJDSEFVREhBUlkAAwAZQAAAAAACAQkQAQAA AMEIAAC9CAAAYBQAAExaRnVKBDEnAwAKAHJjcGcxMjVyMgxgYzEDMAEHC2BukQ4QMDMzDxZmZQ+S TwH3AqQDYwIAY2gKwHOEZXQC0XBycTIAAJIqCqFubxJQIDAB0IUB0DYPoDA1MDQUIfMB0BQQNH0H bQKDAFAD1PsR/xMLYhPhFFATshj0FNCLBxMV5DYRjjIzOBdUoiAHbSBDRRXkNxp/pxRAG68ctXly FeQ5EY6vGlAWMR7/A4JHCdFrAoPfDAEg/w5QIi8Dc1QIcCPUuxYxIQ04GmElnwOCQgdA/nQN4CPU JWEWbBt4BxMdBv8bcCr/HrcslSBVDjAWTiHo/yyUI4kaYTBOJWYslCbnHZG/ME0olyyUKiYCkQjm Owlv6jA4v2UOMDU56jsBOr//O8k51DvyOl8+Lz3tPW87n/M57xBgMjhDukTRRI9Fmf851EXCRC9H /0e9Rz9Fb0k0fjkOUEyETeFGA03gAoJzqHR5bAeQaAngdAAAQxNQA/BkY3RsCrFcYVA4YWRqdU9Q BRBn7mgFQhYyDAFjCcBQQAMw8HNuZXgXMAewBbAAwMUCc3MAUHNiMhRQT0DSYRPwXGsJ4HALkFAf r1CDCGBQcAuAZU+AdldA/wFAUXsMMFJEG5BVIASgC4CmZ0XRUsZiYRcQZAIgn1OAUyZPsFFwWXEg MU8T/w5QVH9Vj1afAFFX3ACgUk7/Wl9bZk8ED8Bcb11/Xo8OUG9Xz2DvYf9bkzMCghMQYz9UQGmB UXBbkCpQV3AgREkBEGF1KkAgUArAYcEJwGFwaCBGAiFUBOkwEWktD5A4AUBXEG4T62TvUINiCyBy CVBwMhag2XAydzRDIRcAcAHQa1J/UZ9of2mGbbBscAUQAjAtK20QA2E6KRBvdZBTdRRiagWQdHWQ RGF0/GU6VAQaYW3/bw9wH3Ev/3I3T6Bbgw4haYFYlg5Qc0/NdF5SV2EXASBIW3EEkP9UBB2Rd294 f3mPeptW73uflw+Qh1AI0GIKsHQ4Z9p/D1Rj8H2ffqaH4H+wC1B53i9tIHqQCxGAJXNUBBuR/4Ev gj+DT3qfcj+JT4pfi2R/dbJ1VHaJINCNr1Evh4Q5h5F/ko+YgERvY3UHgP8CMAXQbOA34ZaylhCW UI8x/QGAbnYQAGAJ8GuAmuACAbtTwHwyZQDwmuBPYHA8YKRcdgiQd2sLgGQewP+eggTwB0AQYQFA DgCPAltie5/lAhBvBUIXIRLydqBtRwtRdqAdADpcXHTgb71swW1tEAMQB5CikE0N4MkDYHNvAYAg TwEgDeC1ndBcpEZFAMADEC5pUL50m7AXEJZQUwGFUngBQL2c4W5PsDjQpeRsFGMDIOcS8wCABZBs

dl+BZLAOcP9TwKhyAZAAIKkCntGbIQHBf6hxFuAPcAAAZLAM0AGQIP4uN/KoaA5QqSIqQJagqZ//
qq+rvw/AZLAFga1frm+vf3ZsHsBksGytH7HfsuUpH6vsMBCwv7WfstRiICj/ApG2v6izGmC0b7kv
uj+7T/+o4B2QvJKpb73/vw+r7BuQ/7yfwh/DL8Q/qOAg0MEfxq9/x7/IxAr5AzCWD5cfmK17yXWw

bSwKhVdoDeBtAHsEYAMAdAWwW6LS0AbwIGsKwBOAeQhgIM/wWXE/0QqFVElBCoVBT4Ch8N8Khc2E zk/PXwVAewqF1d3/hVDLgtbP198IwVLSU4AS8pBia21rypMgX5tgowMQdoFhfS3e4k/QIZsLgCzB

TQeQZDBnZd7j/9XbzeaA3Y0A2p+On4+vhR9/hi+HP4hP0STc5nVTDIIgAwJgC3ByQHBqbS5bBaCj
EFulUtLQOuvbXf/gj+GUjJviz+Pf5O+Qn9Cs/wwh3PUGYAIw63Q4At0EMsA3LIAXcAMQLGNA6FEg
OeQ6NfdgUE3V1vVpdbFd9m1NbEEFIE+AIDjQY98FIAiQAjAEIKQAIOZQT1ABpDBSQUNMRS1Mf/i/

9fF2BfZtbACgcAkAY//d0O4fziLaX9tv9B/RM9lv1wHvAv/Yo0HSj3QW4KEw3ncTgNQQE4CnEiAW gPuBvnA4YdMDCfLmINTAZN6hf2kSW1BpINOABUUPIAAELv4g0iAMwmvRE1ChMA7RpHH/UwBroNOA nPAJ0Qqy05ITUK4g7HHN8/wQLtj8SRDA/RbgbE+AfIAPYRABEMMVwP550zHTMOaA03CbEFtQBqD/ D/IT0MtAdqBTwOZhCdEwYH0OIVQU8tOSMLB2MJ7BZ8MFRRMydiRzeTBw3fC/oTCdURe0n4A5sPwy IjlQznE5sBlRDaZzIgog0kPfAYEV0hDADKIK8TERfvwg5xuE0uD7kXQ/DjAdUxAjDxJyEuEYkCEB IFY3LvJ4E+I4LhxQdMABgRSi5dPSd+YgbGQNNxVWszD/DaYQwZzwa6FpYNRmF1cn0Ofd0NG2BUUu LtLQ1cYmr7fZKd7g2VZB5jAUoHJ1kOMFRR5RTkVUdZDr29j82kYKAUNroBPQTqFwIXD2ciNg9hBy noCkgPwgKlEBKNEoODU4KSA1SDM4LXzANTEOMEbcQVh1kC6cBUVTD8B2cKmekGdv99BDn4BpnVFv yxCzMDKFKNFQdgDmUGPfElDNAFlBoXDTgGMt8fwg7i+bUfewW6JM/IEAZt7jPzZPN184bzk61HYQ sFJFsE1PVkXTwn/xbPxQ/x+TG4OlUlui/HL30IAAD9H/MUH9EN5SFGHf4xdWdcE1QvJHDCB1QGwg qAAs4exjpigO0aJQRVj84FQ9UK+eQBKwW6L8QSc/dicu0A8PwgGAF1k+VSBCT0TuWffQAYCoEHXL QB7x5lIfI3Ld8AGAWXF1kFVOU/RVQvy+KBi134AUcfxB3zyKISQPwKEwE/Fi+3LSkNfmsFMAH5Ip DiFZ0+GlUD55BUWfgKPwPVQTMkhF/ExQEMKlUA/RGKKhIKcR/xtBnVJ2kCPhyDDmUGSAPVD3dgCf YGeAYllxS3DMwN1mJz1y3kgFRn0AUvAAAAAeAEIQAQAAACsAAAA8RjAwMS4wMDE1MTZDRC4yMDAw MDQyNjA4NTYyN0BmYXRjaXR5LmNvbT4AAAMA3j+vbwAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAA UoUAAPATAAAeAASACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA4LjUACwAIgAggBgAA AAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAAmACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsA AYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAACwAKgAggBgAAAAAAwAAAAAAAAEYAAAAADoUA AAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAC4AIIAYAAAAAAMAAAAAAAABG AAAAABGFAAAAAAAAAwAMgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAAWACCAGAAAAAADA AAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgAGgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEA AAABAAAAAAAAAB4AB4AIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALAA+ACyAG AAAAAADAAAAAAAAARgAAAAAAiAAAAAAAAAMAJgAAAAAAAwA2AAAAAAALABCACyAGAAAAAADAAAAA AAAARgAAAAAFiAAAAAAAAAMA8T8JBAAAAwD9P+QEAAADAIAQ/////wIBRwABAAAAPgAAAGM9VVM7 YT0gO3A9QmVhY29uaG91c2UgU2NobztsPUJTUy1FWENIQU5HRS0wMDA0MjcwNDE0MjZaLTE4NzcA AAAeADhAAQAAAAwAAABBQkNIQVVESEFSWQAeADlAAQAAAAwAAABBQkNIQVVESEFSWQBAAAcwECou E/+vvwFAAAgwwOo7E/+vvwEeAD0AAQAAAAUAAABSRTogAAAAAB4AHQ4BAAAACgAAAERlYWRsb2Nr cwAAAB4ANRABAAAANgAAADxFMTU3OEIzQzU3NUFEMzExQjIxMjAwNTBCQTAxNjczQzE3OTU2Q0BC U1MtRVhDSEFOR0U+AAAACwApAAEAAAALACMAAQAAAAMABhDjpFHjAwAHENADAAADABAQAAAAAAMA ERABAAAAHgAIEAEAAABlAAAAVE9NLFdISUNITU9OSVRPUklOR1RPT0xBUkVZT1VVU0lORz9USUFB TEVFTS0tLS0tT1JJR0lOQUxNRVNTQUdFLS0tLS1GUk9NOkJMQUlSQFBKTUNPTU1BSUxUTzpCTEFJ UkBQSgAAAAACAX8AAQAAADYAAAA8RTE1NzhCM0M1NzVBRDMxMUIyMTIwMDUwQkEwMTY3M0MxNzk1 Received on Wed Apr 26 2000 - 23:14:26 CDT