Oracle Database Discussions

Hi,


I am new to database, I suppose to see the performance of database,

so i use to execute the below query for wait events.

I have created the scenario by creating only one lock in one table in my testing database which has nobody can access except myself. And executing the query ...

Select Event, Total_waits,Time_waited from v$system_event;

EVENT TOTAL_WAITS TIME_WAITED
---------------------------------------- ----------- -----------
enq: TX - row lock contention 1381 414157
row cache lock 13 0
library cache lock 2 178
library cache load lock 17 407
enq: JS - queue lock 1 116

i am tracking the "enq: TX - row lock contention" wait event which i have created by lock. Continuously i executing the above query 4 or 5 times.

I understand the value of TIME_WAITED is increasing because i haven't release the lock, but the TOTAL_WAITS column value also increasing by few seconds which i cant understand.

Can anybody explain in what TIME_WAITED column mean and why it is increasing for a single lock and what time interval it use to increase for single lock.

Thanks in advance.