Oracle 18c Impact on DBAs
Larry Ellison has launched Oracle 18c which is fully autonomous database we can call it as future database has lot of automotive features.Different kind of rumors are spreading in the… Read more »
ORA-08104 after a session has been killed during an online index creation/rebuild
Killing a session that is creating/rebuilding an index online rebuild your session was killed and you trying to drop the index or re-creat/rebuild you get ORA-08104: this index object #####… Read more »
Index Usage Tracking in Oracle Database 12c Release 2 (12.2)
Index usage tracking in Oracle 12.2 replaces the old index monitoring functionality of previous versions. The database maintains all indexes defined against a table regardless of their usage. Index maintenance… Read more »
ROWNUM vs ROW_NUMBER() and Oracle 12c fetch first
Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required… Read more »
Purging Unified Audit Trail in Oracle 12c R1
The Unified Audit Trail has become too big, you cannot directly delete or truncate the table. You must call the dbms_audit_mgmt.clean_audit_trail. But then you want to know if it will… Read more »
Galera Cluster Performance Tips
Galera Cluster is a synchronous multi-master replication plug-in for InnoDB. It is very different from the regular MySQL Replication, and addresses a number of issues including write conflicts when writing… Read more »
Deploy a Highly-Available MongoDB Replica Set on AWS
MongoDB arguably the leading NoSQL database available today, it makes it super easy to start hacking away on projects without having to worry about table schemas, while delivering extremely fast… Read more »
Oracle 12.2 New Features
I just finished reading the Oracle database 12.2 new features manual. I have postponed looking at 12.2 until now because for a long time 12.2 was not available for download… Read more »
New Driver Features for MongoDB 3.6
At MongoDB World this week, we announced the big features in our upcoming 3.6 release. I’ll cover six new features—the first two are performance improvements with no driver API changes…. Read more »
MariaDB 10.2 GA released with several advanced features
MariaDB 10.2.6 GA is now released. It’s a release where we have concentrated on adding new advanced features to MariaDB The most noteworthy ones are: Windows Functions gives you the… Read more »