Hello List, I have following two questions: 1. Is it possible that the hash table which contains the linked list of all the buffer in the memory can get locked and can cause all the session to wait on latch free? 2. Is it possible/benefit to create reverse index on a column which data type is varchar. Thanks for your precious time. -- Best Regards, Syed Jaffar Hussain 8i,9i & 10g, OCP DBA Banque Saudi Fransi, Saudi Arabia http://jaffardba.blogspot.com/ ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l