SQL Performance (MOSC)

MOSC Banner

enq: TM - contention observed for delete statement

edited Apr 11, 2017 4:06PM in SQL Performance (MOSC) 6 commentsAnswered ✓

Hello experts,

                       I am trying to understand below scenario

SQL> CREATE TABLE supplier
( supplier_id number(10) not null,
supplier_name varchar2(50) not null,
contact_name varchar2(50),
CONSTRAINT supplier_pk PRIMARY KEY (supplier_id)
);
  2    3    4    5    6
Table created.

SQL> INSERT INTO supplier VALUES (1, 'Supplier 1', 'Contact 1');
INSERT INTO supplier VALUES (2, 'Supplier 2', 'Contact 2');
COMMIT;

1 row created.

SQL>
1 row created.

SQL>
Commit complete.

SQL> CREATE TABLE product
( product_id number(10) not null,
product_name varchar2(50) not null,
supplier_id number(10) not null,
CONSTRAINT fk_supplier
FOREIGN KEY (supplier_id)
REFERENCES supplier(supplier_id));
  2    3    4    5    6    7
Table created.

SQL> INSERT INTO product VALUES (1, 'Product 1', 1);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center