sejustloveit.com
12.1.0.2 Standard Edition R2 is planned for Q3 CY2015 | Oracle Standard Edition – Just love it!
http://www.sejustloveit.com/2015/07/12-1-0-2-standard-edition-r2-is-planned-for-q3-cy2015
Oracle Standard Edition – Just love it! Consult as a Services. 12102 Standard Edition R2 is planned for Q3 CY2015. Finland 2:30 am – Summer The Best Time to Visit. 3rd of July 2015 SE Day. 12102 Standard Edition R2 is planned for Q3 CY2015. NOTE – UPDATE – 8th of July 2015. Changes has been announced today, so PLEASE CHECK these new documents! By updates in Doc1905806.1 and Doc742060.1. What an amazing day of turbulence on twitter! NOTE – 3rd July 2015 Breaking News. And besides facts, of cause also lots...
svenweller.wordpress.com
adaptive cursor sharing and DBMS_SQL – svenweller
https://svenweller.wordpress.com/2016/10/28/adaptive-cursor-sharing-and-dbms_sql
Notes about Oracle SQL, PLSQL and APEX. Adaptive cursor sharing and DBMS SQL. October 28, 2016. October 28, 2016. A recent post in the OTN mentioned that DBMS SQL does not use bind peeking for binded variables. I couldn’t believe that, so I decided to do some tests for myself. The findings are strange…. This is potentially relevant for Apex developers, since the Apex engine uses DBMS SQL. I still have to do further testing to check the behaviour in Apex. STATUS COUNT(*) INVALID 999900 VALID 100 1000000.
nenadnoveljic.com
SPN for SSRS - All-round Database Topics
http://nenadnoveljic.com/blog/spn-for-ssrs
September 26, 2016. After configuring a SQL Server Reporting Services (SSRS) instance for the Kerberos authentication I was not able to connect any more. In particular, I was prompted for the credentials over and over again when trying to access SSRS with a browser. Typically, this is an indication that the Kerberos authentication is not working properly. In the Security Event log I found a corresponding entry. The value of its property. Looked like a Service Principal Name (SPN):. On Gathering Statistic...
nenadnoveljic.com
Statistics Archives - All-round Database Topics
http://nenadnoveljic.com/blog/category/statistics
Gathering Statistics with Option ‘gather auto’. September 18, 2016. In 12c the parameter options was introduced in gather table stats. Unfortunately, it doesn’t work as expected. Continue Reading →. October 25, 2015. The gathering of empty schema statistics might cause index statistics to be marked as stale. Continue Reading →. Large Memory Allocations due to Query Parsing. Index Organized Table vs. Clustered Index. Rescuing Data from Corrupted Tables. On ZFS ARC Resizing (user reserve hint pct).
nenadnoveljic.com
Tables Containing "Current" and "Historical" Rows - All-round Database Topics
http://nenadnoveljic.com/blog/tables-current-historical-rows
Tables Containing “Current” and “Historical” Rows. November 27, 2016. I’ve seen quite a few applications with tables containing both “current” and “historical” rows. In this blog post I’m going to demonstrate how devastating this pattern to cardinality estimates can be. To illustrate this point, I’m going to create a table which stores. Create table prices (product id number, price number, is current number) ;. Is 1 for current prices and 0 for the historical rows. Any given. Insert into prices select mo...
nenadnoveljic.com
Anomaly in Cost Calculation of Anti Semi Join With Nullable Columns - All-round Database Topics
http://nenadnoveljic.com/blog/anti-semi-join-null-cost-calculation
Anomaly in Cost Calculation of Anti Semi Join With Nullable Columns. August 14, 2016. While analyzing a long running query on a SQL Server database I discovered a boundary condition which revealed a flaw in the cost calculation of Anti Semi Join. Consequently, the wrong cost led to a bad execution plan that caused the query to run “forever”. In this blog post I’ll provide a test case, an analysis and a possible workaround. The test case is a simplified version of the mentioned real world scenario:. SET S...
nenadnoveljic.com
12c Archives - All-round Database Topics
http://nenadnoveljic.com/blog/category/oracle/12c
Large Memory Allocations due to Query Parsing. February 14, 2017. Troubleshooting high PGA memory allocations which escalated in ORA-04036 error. High memory consuption was related to a parsing problem. Continue Reading →. Tables Containing “Current” and “Historical” Rows. November 27, 2016. Density Calculation with Hybrid Histograms. November 22, 2016. Gathering Statistics with Option ‘gather auto’. September 18, 2016. September 13, 2016. Continue Reading →. January 21, 2016. Excessive query parsing tim...
nenadnoveljic.com
Rescuing Data from Corrupted Tables - All-round Database Topics
http://nenadnoveljic.com/blog/rescuing-data-corrupted-tables
Rescuing Data from Corrupted Tables. December 6, 2016. This blog post describes how to partially rescue data from corrupted table segments if you find yourself in a miserable position of not having a valid backup at your disposal. At the risk of sounding trivial, you can use. Alter index rebuild online. Command for recovering from an index block corruption. These are the error messages I got when trying to retrieve the corrupted data:. Set autotrace traceonly select * from APP TABLE ; ERROR: ORA-01115: I...
nenadnoveljic.com
Table Spool Performance Problem - All-round Database Topics
http://nenadnoveljic.com/blog/table-spool-performance-problem
Table Spool Performance Problem. September 5, 2016. While exploring Nested Loop Join Heuristics. I noticed that the SQL Server Query Opimizer had introduced a Lazy Table Spool. Operator in a Nested Loop Join (NLJ). In particular, the Lazy Table Spool appeared in the inner table of a simple NLJ which didn’t have any additional predicates. Furthermore, the number of logical reads exploded due to the Table Spool operator. The query to populate the large table with numbers. StmtText TotalSubtreeCost select a...
SOCIAL ENGAGEMENT