select sysdate from dual;select sysdate+1 from dual;select sysdate+2 from dual;

Maybe I will rewrite some of my older posts to use this for better readability. - Maybe ;-)

UPDATE1: there is something going wrong, I don't know where the <br> come from. But I will check.UPDATE2: solution: I must NOT put a newline at the beginning and end of the statements.UPDATE3: I have to switch to draft blogger for editiong to make it work. strange thing. but the code formatting is worth the change.UPDATE4: A solution is posted in syntaxhighlighters wiki.

Mittwoch, 8. Oktober 2008

I just stumbled across one sentence about Server Result Cache in Christian Antogninis Troubleshooting Oracle Performance: " ... To guarantee the consistency of the results ... every time that something changes on the objects reference by a query, the cache entries dependent on it are invalidated ..." (p484).

This made me a little bit curious, as other caches can deal with different versions of cached objects.

Ouch. Even the ISOLATION LEVEL serializable works fine for the Result itselve (75003 all the time), and the SCN of the result is stored somewhere, the result is global invalidated. I guess this is an area for improvement for Oracle.