Tag: Oracle 12c

Mind your rdbms/audit on 12c

Stefan Knecht, Pythian Solutions Architect, discusses rdbms/audit on 12c.

Read More >

Oracle 12c – Adaptive Query Optimization

Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time than expected. As a DBA you quickly check and identify the sql statement that is running, compare the current execution…

Read More >

Slimming Down Oracle RAC 12c’s Resource Footprint

Oracle Grid Infrastructure 12c uses a considerable amount of RAM and CPU resources; here are a few tips to shoehorn it into a 2GB virtual machine.

Read More >

12c: How to Restore/Recover a Small Table in a Large Database

As a DBA, you will receive requests from developers or users, indicating that they deleted some data in a small table in a large database a few hours prior. They will probably want you to recover the data as soon as possible, and it…

Read More >

12c: Fun with WITH!

Last night I couldn’t sleep and what else you’re going to do? I was thinking about Oracle stuff. In Oracle version 12, Oracle has enhanced the WITH clause – traditionally used for sub-query factoring – to allow the declaration of functions and…

Read More >

Should AUD$ Table Exist on System Tablespace During DB Upgrade?

I see this following message on all My Oracle Support notes, which talks about database Oracle manual upgrade steps. 4.16 Verify the existence of the AUD$ tables Ensure that if the aud$ table exists that it is in the SYS…

Read More >

Batched Table Access

When I first saw the suffix BATCHED in an Oracle execution plan from 12c, I was curious to see what is hidden behind and how it works. I had some spare time for testing and wanted to share my findings…

Read More >

Oracle RAC on the Cloud, Part 3

This is part 3 of a multipart series of getting oracle RAC running on a cloud environment. In part 1, we set up a NFS server for shared storage. In part 2, we set up OS components for each RAC server. Now we finish up the OS configuration and move to Oracle grid infrastructure.

Read More >

Oracle RAC on the Cloud, Part 2

In part 1 of this series, we talked about some of the challenges of setting up Oracle RAC on a public cloud provider, and went on to order some VMs from provider Gandi, and finally configuring a NFS server for shared storage. In this post, we move on to configuring the rac servers themselves, rac01 and rac02.

Read More >

Oracle RAC on the Cloud, Part 1

I’ve been working on moving a lot of the testing and R&D work I do away from local virtual machines and onto cloud environments, for a few reasons: I can avoid carrying around a laptop all the time, and rather…

Read More >
Page 1 of 212