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

  • From: "The Human Fly" <sjaffarhussain@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Feb 2006 17:52:44 +0300

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


Other related posts:

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