hi
while i query
select session_id,LOCK_TYPE from dba_locks;
Result:
SESSION_ID LOCK_TYPE
---------- --------------------------
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
2 Media Recovery
3 Redo Thread
4 XR
5 Temp Segment
What is this "Media Recovery" means?Is that means that db performs media recoverey ??
Please clear my doubt.

Thanks
Raaj

Oracle LazyDBA home page