Tags » 19C

Oracle binaries download from Linux command line

By Brian Fitzgerald

Introduction

Our objective is to download Oracle binaries directly to Linux using the bash shell. We will log in to Oracle and accept the license agreement in a Windows browser, and then perform the download in Linux. 374 more words

Database Administration

Some quick facts about sequence caches and gaps in IDs

  1. Oracle sequences generate key values without gaps (minor exception from the rule: scalable sequences).
  2. Surrogate keys can and will have gaps.
  3. Gaps exist because it is not worth the huge effort to avoid them.
  4. 760 more words
Development

Oracle 19c Automatic Indexing: My First Auto Index (Absolute Beginners)

I am SOOOO struggling with this nightmare block editor but here goes. Please excuse any formatting issues below:

I thought it was time to show the new Oracle 19c Automatic Indexing feature in action and what better way than to go through how I created my first ever Automatic Index. 1,584 more words

Oracle Indexes

No more stale statistics in 19c

There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the business day. Here is how that contradiction comes to be – it is in the way that we obtain and use optimizer  statistics on those databases. 1,937 more words

Install Oracle on Red Hat 8 attempt

Introduction

Here are a few issues you can run across if you attempt to install Oracle 19c on Red Hat Linux 8.

Issues

No python… 241 more words

AWS

Fashion Gossip, 1878

Newry Reporter, 24 October 1878 page 4

Fashion Gossip

Bridesmaids in France are now replaced by two tiny pages, who are chosen from the prettiest of the boy relatives of the bride or bridegroom, and are dressed in velvet of the bride’s favourite colour. 195 more words

19C

X windows for AWS Oracle DBAs

By Brian Fitzgerald

Introduction

This is for DBAs on AWS EC2 who want to use Oracle X-windows based installation tools such as OUI or DBCA. Techniques described here can lead to a smooth installation experience. 2,548 more words

Database Administration