In Oracle 9i&10G, in order to use function based indexes, you have to set :
QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
http://www.akadia.com/services/ora_function_based_index_2.html
Cross-Instance Deadlock in RAC
-
I've created a *video demonstration of a Cross-Instance Deadlock in a
2-node RAC* environment and how to read the trace file.
Note : Only the SQL that h...
Acum 3 zile
Niciun comentariu:
Trimiteți un comentariu