Couple of question (memory hash table + reverse key on varchar datatype)

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Tue, 21 Feb 2006 17:52:44 +0300
Message-ID: <97b7fd2f0602210652k33ff2b6eoc57c48037adecd3b@mail.gmail.com>

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."
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 21 2006 - 08:52:44 CST