As I had already mentioned in a previous post this new type has a NOT NULL constraint (cannot have null value) and wraps (does not give an overflow error).
What I was not expecting was that I needed to change the compilation type to native to see that speed improvement (in the default compilation mode (INTERPRETED) the improvement is not that great :-( ).
ALTER SESSION SET PLSQL_CODE_TYPE = 'NATIVE'; (default is INTERPRETED).Of course that (changing to native compilation) is the first thing a person should do in 11g (specially in prodution)!
Why?
Without the need of an external C compiler and filesystem storage area and a faster than 10g native compilation this is the natural way to have a production system and even a developement and test system. (Ok it can make a very small delay when compiling but I did not notice it).
Do great coding with this two tips :-)!
No comments:
Post a Comment
Os comentários são moderados.
The comments are moderated.