Ora Error Stack 60 Logged
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers ora-00060 deadlock detected while waiting for resource oracle 11g or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Oracle Deadlock Resolution
Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only ora 00060 solution takes a minute: Sign up ORA-00060: deadlock detected while waiting for resource up vote 14 down vote favorite 5 I have a series of scripts running in parallel as a nohup on an AIX server hosting oracle 10g. These scripts
Ora 00060 Deadlock Detected More Info In File
are written by somebody else and are meant to be executed concurrently. All the scripts are performing updates on a table. I am getting the error, ORA-00060: deadlock detected while waiting for resource As I googled for this, I found, http://www.dba-oracle.com/t_deadly_perpetual_embrace_locks.htm Even though the scripts are performing updation on the same table concurrently, they are performing updates on different records of the table determined by the WHERE clause with no overlaps of records between them. So would this have caused how to check deadlock in oracle the error?. Will this error happen regardless of where the updates are performed on a table?. Should I avoid concurrent updates on a table at all times?. Strangely I also found on the nohup.out log, PL/SQL successfully completed after the above quoted error. Does this mean that oracle has recovered from the deadlock and completed the updates successfully or Should I rerun those scripts serially? Any help would be welcome. Thanks in advance. database oracle unix plsql aix share|improve this question edited Dec 15 '14 at 21:20 Lajos Veres 10.8k72446 asked Jun 19 '10 at 8:00 wowrt 242238 add a comment| 3 Answers 3 active oldest votes up vote 7 down vote accepted You can get deadlocks on more than just row locks, e.g. see this. The scripts may be competing for other resources, such as index blocks. I've gotten around this in the past by engineering the parallelism in such a way that different instances are working on portions of the workload that are less likely to affect blocks that are close to each other; for example, for an update of a large table, instead of setting up the parallel slaves using something like MOD(n,10), I'd use TRUNC(n/10) which mean that each slave worked on a contiguous set of data. There are, of course, much better ways of splitting up a job for parallelism, e.g. DBMS_PARALLEL_EXECUTE. Not sure why you're getting "PL/SQL successfully completed", perhaps your scripts are handli
January 15, 2014 - 9:12 pm UTC Category: Database � Version: 11.2 Whilst you are here, check out some content from the AskTom team: The PL/SQL Whisperer Latest Followup
Ora-00060 Deadlock Detected While Waiting For Resource In Informatica
You Asked *** 2011-09-20 14:29:09.745 DEADLOCK DETECTED ( ORA-00060 ) [Transaction Deadlock] The
How To Fix Ora 00060 Deadlock Detected
following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of how to remove deadlock in oracle an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock: Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)--------- Resource Name process session holds waits process session holds waits http://stackoverflow.com/questions/3074827/ora-00060-deadlock-detected-while-waiting-for-resource TM-0000f4bc-00000000 42 575 SX SSX 48 5 SX SSX TM-0000f4bc-00000000 48 5 SX SSX 42 575 SX SSX session 575: DID 0001-002A-000002F0 session 5: DID 0001-0030-00000831 session 5: DID 0001-0030-00000831 session 575: DID 0001-002A-000002F0 Rows waited on: Session 575: no row Session 5: obj - rowid = 0000F38C - AAAPOMACrAABodTAAA (dictionary objn - 62348, file - 171, block - 427859, slot - https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3932525800346405986 0) ----- Information for the OTHER waiting sessions ----- Session 5: sid: 5 ser: 13809 audsid: 4295982 user: 63/MI520SAASPERFT1_APP flags: 0x41 pid: 48 O/S info: user: oracle, term: UNKNOWN, ospid: 14422 image: oracle@aedbperf01 client details: O/S info: user: Administrator, term: AEBL009, ospid: 1680:2480 machine: DIUS\AEBL009 program: DrteFrameworkServer.exe application name: DrteFrameworkServer.exe, hash value=3560566261 current SQL: DELETE FROM event WHERE event_id = &0 ========================= Tom, This is my first ever question on this website. I have heard a lot about u. We are getting deadlock when running our benchmark on table EVENT. Table EVENT has 9 FK constraints and no indexes on FK constraints. What should I look to get more information regarding: a) What is causing deadlocks? It is being no indexes on FK or INITTRANS. Table has default settings: PCTFREE 10 INITRANS 1 MAXTRANS 255 b) We noticed that deadlocks happen mostly during start of load and not towards the end c) will it still cause a deadlock if there are no rows in those referenced tables for the event that is being deleted? d) I ran a script to identify the missing FK indexes: ========
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language https://www.techonthenet.com/oracle/errors/ora00060.php More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP http://mohamedelazab.blogspot.com/2014/01/workaround-and-fix-for-ora-error-stack.html BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION deadlock detected ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions Oracle / PLSQL: ORA-00060 Error Message Learn the cause and how to resolve the ORA-00060 error message in Oracle. Description 00060 deadlock detected When you encounter an ORA-00060 error, the following error message will appear: ORA-00060: deadlock detected while waiting for resource Cause You tried to execute a statement, but your session was deadlocked because another session had the same resource locked. The statement(s) that you tried to execute have been rolled back. Resolution The option(s) to resolve this Oracle error are: Option #1 You can wait a few minutes and try to re-execute the statement(s) that were rolled back. Option #2 You can execute a ROLLBACK and re-execute all statements since the last COMMIT was executed. Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2016 TechOnTheNet.com. All rights reserved.
fix for ORA-error stack (00600[ktt_check_thershold-1]) I have got the below issue from the grid control as shown below: Message: Message=ORA-error stack (00600[ktt_check_thershold-1]) logged in D:\ORACLE\PRODUCT\10.2.0\ADMIN\ISPNTDDB\BDUMP\alert_ISPNTDDB.log. Metric=Generic Alert Log Error Metric value=Errors in file d:\oracle\product\10.2.0\admin\ispntddb\bdump\ispntddb_mmon_9296.trc:~ORA-00600: internal error code, arguments: [ktt_check_thershold-1], [524288], [524288], [1048576], [], [], [], []~ The issue was occurring on database10.2.0.4.0 on windows 64bit 2003. after investigating the below trace: Name -------- d:\oracle\product\10.2.0\admin\ispntddb\bdump\ispntddb_mmon_9676.trc Sun Jan 05 12:37:20 2014 ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0 vsnsql=14 vsnxtr=3 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options Windows Server 2003 Version V5.2 Service Pack 2 CPU : 8 - type 8664, 2 Physical Cores Process Affinity : 0x0000000000000000 Memory (Avail/Total): Ph:5577M/16381M, Ph+PgF:7222M/17821M Instance name: ispntddb Redo thread mounted by this instance: 1 Oracle process number: 27 Windows thread id: 9676, image: ORACLE.EXE (MMON) *** SERVICE NAME:(SYS$BACKGROUND) 2014-01-05 12:37:20.062 *** SESSION ID:(462.42118) 2014-01-05 12:37:20.062 *** 2014-01-05 12:37:20.062 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ktt_check_thershold-1], [524288], [524288], [1048576], [], [], [], [] check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\ispntddb_ora_0.trc for preloading .sym file messages ----- Call Stack Trace ----- ksedmp <- ksfdmp <- kgerinv <- kgeasnmierr <- ktte_check_threshol <- ktte_check_undo_tbs <- ktte_monitor_tsth <- 833 <- ktte_monitor_ts <- ksbcti <- ksbabs <- kebm_mmon_main <- ksbrdp <- opirip <- opidrv <- sou2o <- opimai_real <- opimai <- BackgroundThreadSta <- 0000000077D6B71A --------- SO: 000000027255EC50, type: 4, owner: 000000026F3B9508, flag: INIT/-/-/0x00 (session) sid: 462 trans: 0000000000000000, creator: 000000026F3B9508, flag: (51) USR/- BSY/-/-/-/-/- DID: 0001-001B-00003047, short-term DID: 0000-0000-00000000 txn branch: 0000000000000000 oct: 0, prv: 0, sql: 000000