orasql.org
Oracle SQL | Tag Archives: 12c
http://orasql.org/tag/12c
12c: New SQL PLAN OPERATIONS and HINTS. July 8, 2015. This post is just a compilation of the links to other people’s articles and short descriptions about new SQL PLAN OPERATIONS and HINTS with a couple little additions from me. Continue reading →. 12c: Little test of “TABLE ACCESS INMEMORY FULL” with count stopkey. March 17, 2015. The table has 9M rows:. Oracle 12c: behavior tests of the Inline functions, “Identities” and “defaults”. July 13, 2013. I have done several minitests:. 3 How IDENTITY works?
orasql.org
Oracle SQL | Tag Archives: result_cache
http://orasql.org/tag/result_cache
Tag Archives: result cache. RESULT CACHE: run-time dependency tracking. July 5, 2015. As you know, since 11.2. 8220;relies on”. Clause was deprecated and oracle tracks dependencies at runtime now. Test function and tables. And it works fine with normal tables:. But don’t forget that the result cache also caches such functions with the objects, that usually should not be cached, and such objects will not be listed in the result cache dependencies list:. Note that there is no “RESULT CACHE” line. Recently ...
orasql.org
Oracle SQL | RESULT_CACHE: run-time dependency tracking
http://orasql.org/2015/07/05/result_cache-run-time-dependency-tracking
RESULT CACHE: run-time dependency tracking. July 5, 2015. As you know, since 11.2. 8220;relies on”. Clause was deprecated and oracle tracks dependencies at runtime now. Test function and tables. And it works fine with normal tables:. But don’t forget that the result cache also caches such functions with the objects, that usually should not be cached, and such objects will not be listed in the result cache dependencies list:. The results were cached and the dependencies do not include system objects.
orasql.org
Oracle SQL | Category Archives: CBO
http://orasql.org/category/oracle/cbo-oracle
WINDOW NOSORT STOPKEY RANK(). March 12, 2016. Recently I found that WINDOW NOSORT STOPKEY with RANK()OVER() works very inefficiently: http:/ www.freelists.org/post/oracle-l/RANKWINDOW-NOSORT-STOPKEY-stopkey-doesnt-work. The root cause of this behaviour is that Oracle optimizes WINDOW NOSORT STOPKEY with RANK the same way as with DENSE RANK:. As you can see, A-Rows in plan step 2 = 30 – ie, that is the number of rows where DENSE RANK. 12c: New SQL PLAN OPERATIONS and HINTS. July 8, 2015. February 9, 2015.
orasql.org
Oracle SQL | SQL*Plus tips #7: How to find the current script directory
http://orasql.org/2015/06/26/sqlplus-tips-7-how-to-find-current-script-directory
SQL*Plus tips #7: How to find the current script directory. June 26, 2015. You know that if we want to execute another script from the current script directory, we can call it through @. But sometimes we want to know the current path exactly, for example if we want to spool something into the file in the same directory. So we can simply get this path from the error text:. I used here the reading file content into variable, that I already showed in the “SQL*Plus tips. #1”. Also I did it with. Differences ...
orasql.org
Oracle SQL | Author Archives
http://orasql.org/author/xtender
Author Archives: Sayan Malakshinov. WINDOW NOSORT STOPKEY RANK(). March 12, 2016. Recently I found that WINDOW NOSORT STOPKEY with RANK()OVER() works very inefficiently: http:/ www.freelists.org/post/oracle-l/RANKWINDOW-NOSORT-STOPKEY-stopkey-doesnt-work. The root cause of this behaviour is that Oracle optimizes WINDOW NOSORT STOPKEY with RANK the same way as with DENSE RANK:. As you can see, A-Rows in plan step 2 = 30 – ie, that is the number of rows where DENSE RANK. Thanks to all #odevchoice voters!
orasql.org
Oracle SQL | Category Archives: PL/SQL
http://orasql.org/category/oracle/plsql
Oracle package for HTTPS/HTTP[version 0.2]. October 12, 2015. Posted in java stored procedures. Oracle database developer choice award. A couple days ago i created simple package for HTTPS/HTTP. But I’ve decided now to improve it:. 8211; it would be better to control connection time;. Simple page parsing with PCRE regular expressions. 8211; the tool for automatically generating documentation in HTML format.( javadoc. Parameter – so you can choose POST. Added function get last response. October 9, 2015.
orasql.org
Oracle SQL | Category Archives: curious
http://orasql.org/category/curious
A function gets called twice if the result cache is used. July 5, 2015. Recently I showed simple example how result cache works with non-deterministic functions and observed strange behaviour: a function gets fired once in the normal query, but twice with the result cache hint. Moreover, only third and subsequent query executions return same cached results as second query execution. But later I was asked to explain this, so this post is just a short description with test case. With result cache statistics.
SOCIAL ENGAGEMENT