Tag: Oracle

Log Buffer #547: A Carnival of the Vanities for DBAs

This Log Buffer edition covers Oracle, SQL Server and MySQL.

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 >

Log Buffer #546: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Cloud, Oracle, and PostgreSQL.

Read More >

Datascape Podcast Episode 27 – Oracle Cloud vs. the World

On today’s episode, we are going to take a closer look at the Oracle Cloud and see how Oracle’s cloud strategy stacks up against other cloud offerings. We will also dig deeper and try to understand some of the key…

Read More >

RDP Issue – CredSSP Encryption Oracle Remediation

Introduction We have recently had some issues accessing a few client servers and found it is related to a Windows security update that was released earlier in May 2018. The problem is when you try to RDP to a server…

Read More >

Fun with Oracle Data Guard Broker

Issues during the switchover to standby database The beginning So, there we were attending to our jobs and tending to our customers when an emergency alert came in: a production server had gone down. All bells and whistles were sounded…

Read More >

Debugging CBQT OR Expansion with 10053 trace

I had been working with a client to add a little bit of functionality to an analytical view that we had been running queries against for a while. The functionality was easy to implement but during testing we found that…

Read More >

Oracle 18c Non-CDB Databases in the Oracle Database Cloud Service (ODBCS)

Oracle is implementing a cloud first approach and hence the newest releases such as Oracle Database 18c first appear in the Oracle Database Cloud Service (ODBCS).  But only in the Container DB architecture for this PaaS offering.  However, that doesn’t mean…

Read More >

Mysterious rollback and replay with partitions

Recently I had a situation where I was loading a partitioned table and during the load, which was going to take hours, I realised that I wanted to add DEFAULT and NULL partitions to help with the robustness of future…

Read More >

Cost Management (Expenditure Alerts) in the Oracle Cloud

Background As an Oracle Cloud user using it for my own purposes (mostly just testing), I’m very careful to always shut down services when not required so I don’t incur unnecessary charges. However, I’m always just a little bit worried…

Read More >
Page 1 of 15012345...10...Last Page »