Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

September 2018

Datatype conversion laziness … yet another reason

Submitted by connor_mc_d on Mon, 2018-09-24 08:03

I’ve got two words to describe my thoughts on being lazy with data types …. JUST DON’T! Smile

There’s been many blog posts, videos, AskTOM questions etc over the years with numerous examples of how the optimizer gets confused, how the SQL engine gets confused…and even how developers will ultimately get confused if you do not spend that little tiny bit of extra effort in ensuring data type consistency.

Another little 12c improvement

Submitted by connor_mc_d on Fri, 2018-09-21 07:19

You’ve got a huge table right? Massive! Immense! And then something bad happens. You get asked to remove one of the columns from that table.

“No problem” you think. “I won’t run the ‘drop column’ command because that will visit every block and take forever!”

So you settle on the perfect tool for such a scenario – simply mark the column as unused so that it is no longer available to application code and the developers that write that code.

Oaktable World 2018

Event date: 
Mon, 2018-10-22 - Tue, 2018-10-23
OTW2018 MORE INFO

 
 

Submitted by oakroot on Wed, 2018-09-19 15:53

#Exasol Database whoami

Submitted by Uwe Hesse on Wed, 2018-09-19 08:03

This little script displays some useful meta-information:

Configuring Firewall Access for SQL Database on Azure

Submitted by dbakevlar on Tue, 2018-09-18 19:32

Its quite common that the first time you work with a feature in a cloud interface, it can appear so foreign until you’ve done it a few times.  If it’s a task that you may not do often or only once, it can be downright painful.  It doesn’t matter who the cloud provider is or the application, we all have felt the pain of this type of situation and why some of us even started blogging…:)  Until its familiar, it may not feel comfortable and you may not even like how it works.

Aurora MySQL synch/mutex/innodb/aurora_lock_thread_slot_futex wait

Submitted by khailey on Tue, 2018-09-18 17:26

Thanks to Jeremiah Wilton for the following info:

This wait event indicates that there is a thread which is waiting on an InnoDB record lock. Check your database for conflicting workloads. More information on InnoDB locking can be found here: https://dev.mysql.com/doc/refman/5.6/en/innodb-locking.html

 

Start/Stop your Autonomous Databases

Submitted by Franck Pachot on Tue, 2018-09-18 07:57

The ATLAS experiment in LEGO®

Here are two blog posts on the Databases at CERN blog:

Revisiting Embedded InnoDB

Submitted by jonah.harris on Tue, 2018-09-18 05:14

Many people these days don’t know InnoDB was originally developed as an independent database engine apart from MySQL. Its author, Heikki Tuuri, modeled InnoDB after Transaction Processing: Concepts and Techniques, the seminal transaction processing book authored by Turing Award laureate James “Jim” Gray and Andreas Reuter. It wasn’t until later InnoDB was integrated with MySQL. While InnoDB […]

The post Revisiting Embedded InnoDB appeared first on Oracle Internals.

Revisiting Embedded InnoDB

Submitted by jonah.harris on Tue, 2018-09-18 05:14

Many people these days don’t know InnoDB was originally developed as an independent database engine apart from MySQL. Its author, Heikki Tuuri, modeled InnoDB after Transaction Processing: Concepts and Techniques, the seminal transaction processing book authored by Turing Award laureate James “Jim” Gray and Andreas Reuter. It wasn’t until later InnoDB was integrated with MySQL. While InnoDB […]

The post Revisiting Embedded InnoDB appeared first on Oracle Internals.

Open Source ODBC Drivers for Oracle

Submitted by jonah.harris on Mon, 2018-09-17 22:10

In the good old days, database-agnostic applications were written using drivers that implemented the Microsoft Open Database Connectivity (ODBC) API, especially on Windows. Much like JDBC, ODBC provided developers with a single, interoperable, C-based programming language interface that made it possible for applications to access data from a variety of database management systems. When developing an […]

The post Open Source ODBC Drivers for Oracle appeared first on Oracle Internals.