Ganesh, Your comment is bit inaccurate. THis is because of the ITL Entry shortage (no-row) and bumping PCTFREE for the respective tables will solve the problem.
Best Regards, K Gopalakrishnan Bangalore, INDIA -----Original Message----- Sent: Monday, March 11, 2002 5:38 AM To: LazyDBA.com Discussion Comments Embedded... Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -----Original Message----- Sent: Monday, March 11, 2002 5:08 PM To: LazyDBA.com Discussion Qs Transaction 1 Transaction 2 (Runs CONCURRENTLY) Statement 1 on Row A Statement 3 on Row B Statement 2 on Row B Statement 4 on Row A On Occurence of a Deadlock Error ORA-60 Which of the Statements 1,2,3,4 Will Fail ? The Session that Dedected the deadlock will be Killed it will left to Oracle. Qs Will the Contentious SQL Queries Still be Present in v$session , v$sqlarea , v$process even after the Occurence of Deadlock ? V$session - Contains No Query Information. v$SQLAREA - May Have the Query. v$Process - Contains No Query info. Qs Can Insufficient Values of PCTFREE for respective Tables Cause a Deadlock ? AFAIK... No Qs Any Other Advice on How to approach Deadlocks Handling ? Do Proper Locking inside u'r Application. Following part of Trace File Coming with a Deadlock Dump file /oracle/OraHome1/rdbms/log/abnprod_ora_10495.trc Unix process pid: 10495, image: oracle@fin-db-1 (TNS V1-V3) Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)--------- Resource Name process session holds waits process session holds waits TX-000a0052-0000bbac 16 38 X 51 625 S TX-0013001f-0000b1f9 51 625 X 16 38 X session 38: DID 0001-0010-00000002 session 625: DID 0001-0033-00000002 session 625: DID 0001-0033-00000002 session 38: DID 0001-0010-00000002 Rows waited on: Session 625: no row Session 38: obj - rowid = 00001044 - AAAEfaAALAAAD89AAD SQL> select acid ,sol_id from gam 2 where rowid='AAAEfaAALAAAD89AAD'; ACID SOL_ID ----------- -------- AB640163 282 THANKS -------- Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -------- Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).