Memory Leak During Parsing
Memory leak during parsing in Oracle 12c Continue Reading
Memory leak during parsing in Oracle 12c Continue Reading
Analyzing checkpoint information in alert log with SQL analytic functions Continue Reading
Large TCHK allocations in shared pool caused by create table as select Continue Reading
Invoke root.sh with -bindir option to prevent overwriting of Oracle scripts in /usr/local/bin. Continue Reading
Analyzing Emulex HBA driver performance with DTrace Continue Reading
Some JDBC drivers use lower, less secure authentication protocols than the regular clients of the same version. Continue Reading
Comparison of bind variable peeking in Oracle with parameter sniffing in SQL Server Continue Reading
This blog post is a short observation on assumptions that Oracle and SQL server optimizers make for estimating cardinality of a rowset obtained after applying an equality predicate which contains different columns of the same table. Continue Reading
The mission critical Google platforms are maintained teams consisting of Google Site Reliability Engineers (SREs). SREs distinguish themselves from common system administrators by applying engineering and scientific methods for solving operational problems. Fundamentally, SRE is what you get when you treat operations as if it’s a software problem. In this blog post I distilled several key points that proved most relevant for my team which has the mission of designing and operating private database cloud for Oracle and Microsoft SQL Server databases. Operating on these principles over the last years not only has helped us achieve a high level of customer satisfaction with our service, but it also facilitated the creation of a very attractive working environment. Continue Reading
Troubleshooting high PGA memory allocations which escalated in ORA-04036 error. High memory consuption was related to a parsing problem. Continue Reading