Author: Gleb Otochkin

HCC compression on Oracle Live SQL

I’ve written previously about “Oracle Live SQL”, a free service from Oracle where you can try your coding skills and learn using its vast code library. Today I want to mention one of its other features which may not be…

Read More >

Oracle Live SQL revised

If you’re not familiar with the Oracle Live SQL environment, then you should definitely try it. I wrote a blog some time ago on what it is and how to work with execution plans there. Here I will provide an…

Read More >

Oracle autonomous transaction processing – a good start

It has been almost a year since the last Open World where Oracle CTO and founder Larry Ellison proclaimed the new upcoming fully autonomous cloud database service. It created a lot of attention and almost everybody in the Oracle community…

Read More >

Installing Oracle 18c using command line

Just three days ago Oracle released Oracle 18c for general installation on-premises. We’ve had a taste of the new Oracle release on Oracle Cloud for quite some time, but now we can download and install it for in-house testing. I…

Read More >

HugePages for Oracle database in Oracle Cloud

I recently published a blog post about large pages support in AWS RDS for Oracle and someone asked me if and how it works on Oracle cloud. I didn’t actually know the answer and decided to look it up. Documentation…

Read More >

Optimizing CPU cores and threads for Oracle on AWS

About a couple of weeks ago, AWS introduced a new option to manage CPU cores and threads on EC2 or RDS instances. So now you can reduce the number of cores or threads per core for your AWS instances. It…

Read More >

Hugepages support for Oracle RDS

Recently, working with some performance problems on AWS RDS, I noticed that the customers had Oracle RDS instances that didn’t use the “Hugepages” memory. They had several Oracle RDS instances of different types and all of them had more than…

Read More >

Oracle SQL Developer – now in web!

For some time, I was trying to use a Google Pixelbook for my work. It was kind of a challenge and among other things, I struggled to work without a good web-based SQL client or tool. I used a jump…

Read More >

Working “with” remote technical support

When we talk about working with remote technical support, even the word with is a useful starting point. It’s a word with several meanings, some of which contradict each other. In the Merriam-Webster dictionary, the first definition is “in opposition”…

Read More >

First touch penalty on AWS cloud

A couple of weeks ago I had a discussion about AWS RDS with one of my colleagues and he mentioned some unexpected IO problem during migration. It was during production cutover when they switched from the old environment on-prem to…

Read More >
Page 1 of 41234