All, I have a question in bitmap index. It would be great if any one could clarify this... I have two scenario's. In first scenario, it is locking. But the second scenario, it is not locking. I am not sure why it is...
Malay, I checked the alert log. I don't see any information. Are you sure that, it is working in your DB? I checked the same in different database. It is hanging...
Here is my db version.
Oracle9i Enterprise Edition Release 220.127.116.11.0 - Production
PL/SQL Release 18.104.22.168.0 - Production
CORE 22.214.171.124.0 Production
TNS for 32-bit Windows: Version 126.96.36.199.0 - Production
NLSRTL Version 188.8.131.52.0 - Production
Originally Posted by malay_biswal
May be the session is hanging due to some other reason. check alert log for any error..
I tried in my D/B. Did not get any hanging session..