Hi all,
DB version is 10.2.0.4
In db had a row lock contention on a table JA_IN_LOCATOR and when i saw the sql it is
DELETE FROM JA_IN_LOCATOR WHERE PADDR = (SELECT PADDR FROM
V$SESSION WHERE AUDSID = USERENV('SESSIONID') ) AND FORM_ID =
'JAINEORD'
On taking the explain plan it shows
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 3082116799
----------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 1 | 16 | 12 (0)| 00:00:01 |
| 1 | DELETE | JA_IN_LOCATOR | | | | |
|* 2 | TABLE ACCESS FULL | JA_IN_LOCATOR | 1 | 16 | 12 (0)| 00:00:01 |
| 3 | NESTED LOOPS | | 1 | 26 | 0 (0)| 00:00:01 |
|* 4 | FIXED TABLE FULL | X$KSUSE | 1 | 22 | 0 (0)| 00:00:01 |
|* 5 | FIXED TABLE FIXED INDEX| X$KSLED (ind:2) | 1 | 4 | 0 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------
What does the Fixed table full and Fixed table fixed index mean??
Googled and read few where the fixed table fixed index were shown on x$ tables. But here its a product table ja_in_locator..
thanks,
baskar.l
Edited by: baskar.l on Aug 20, 2010 6:46 AM