Blog: Marko Sutic


208 blogs updated: 4 min. ago
Enable SSL-encryption for MariaDB Galera Cluster
Imagine you have MariaDB Galera cluster with nodes running in different data centers. Data centers are not connected via secured VPN tunnel....
0
17-10-2017 13:32:37 Marko Sutic Oracle
Delete large amounts of data on Galera Cluster using pt-archiver
Galera Cluster is excellent virtually synchronous multi-master database cluster. It has many benefits which you can check on GaleraCluster. ...
0
28-09-2017 13:13:26 Marko Sutic Oracle
Beware of ORA-19721 on 12c using Transportable Tablespace (Oracle changed behavior)
Almost every big database has it's hot data which is used often, and cold data which is rarely touched. From version 9i I have used transpor...
0
16-09-2017 19:52:42 Marko Sutic Oracle
Using In-Memory Option with SQL Plan Baselines, SQL Profiles and SQL Hints
Oracle database In-Memory option was introduced in 12.1.0.2 patchset. It is great feature to improve performance of analytic queries. For mi...
0
06-03-2017 10:30:34 Marko Sutic Oracle
Reduce Hard Parse time using SQL Profile
Few days ago we had concurrency problem with "cursor: pin S wait on X" wait event. This wait event is mostly associated with parsing in some...
0
03-11-2016 22:44:46 Marko Sutic Oracle
Using Adaptive Cursors Sharing with SQL Plan Baselines
We have several databases where automatic capturing of sql plan baselines is enabled for a few schemas. Execution of some queries deeply dep...
7
28-06-2016 10:35:09 Marko Sutic Oracle
Slow full table scan due to row chaining
Few days ago I've received complaint that simple count on 2 million rows table is running forever. This was the statement: select count(1) f...
0
24-02-2016 15:34:53 Marko Sutic Oracle
Detecting Soft Corruption on 12c - V$NONLOGGED_BLOCK, ORA-01578/ORA-26040
Last week we have created standby database in our dev environment and performed some ETL actions on primary side. Loading data or rebuilding...
0
20-02-2016 11:20:44 Marko Sutic Oracle
Unindexed Foreign Keys on empty/unused table and locks
It is widely known that unindexed foreign keys can be performance issue. Unindexed foreign keys on child tables can cause table locks or per...
19
17-12-2015 05:21:03 Marko Sutic Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.