Q: remote_dependencies_mode Time/SIGNATURE ?

  • From: "Amihay Gonen" <AmihayG@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 2 Oct 2005 08:53:05 +0300

 
Hi all , 
 
I wander which mode is better ? 
I know that the  default in oracle is timestamp , which is more suitable
for development where table structures are happing , but I production
I'm under impression the using signature may reduce overhead in
recompilation , especially when the code is related to partitions tables
the maybe be change from time to time. 
 
What do you say ? If anyone has experience in when using signature ? 

Amihay Gonen
DBA,
972-3-90021678

 

 

Other related posts: