(Lucas Jellema) In a recent article I described how to provision an instance of Oracle Cloud Autonomous Data Warehouse in the recently launched Always Free Tier of OCI. This article shows how to connect from SQL Developer (desktop tool) to this instance.
Tag: Oracle
What’s Taking So Long For Autoupgrade
(mdinh) Directory for autoupgrade/log: $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log, where $ORACLE_UNQNAME=db_unique_name
So you want to learn Oracle APEX?
(Scott Wesley) Are you involved with Oracle? Perhaps your a DBA, or a PL/SQL data master, possibly know a bit about Oracle Forms, and you want to learn what all the fuss is about regarding Oracle Application Express (APEX)?
What’s new with Oracle database 12.2.0.1.190416 versus 12.2.0.1.190716
(Frits Hoogland) There are a couple of underscore parameters changed from spare to named ones. It’s interesting to see that in sysstat, ‘spare statistic 2’ changed to ‘cell XT granule IO bytes saved by HDFS tbs extent map scan’.
AutoUpgrade Tips: Running two (or more) sessions in parallel
(Mike.Dietrich) Our intention with the AutoUpgrade as the single tool to upgrade your databases was initially: You have one big config file for your databases.
Oracle Cloud Always Free Autonomous Data Warehouse – steps to get going
(Lucas Jellema) Last month, Oracle announced it’s Cloud Free Tier on Oracle Cloud Infrastructure (OCI). This free tier offers several services (compute, storage, network, monitoring & notifications, serverless functions and Autonomous Database. Two autonomous database instance can be provisioned and
How to rename an oracle scheduler job
(Flavio Casetta) If you ever wondered if it is possible to rename a job, be advised that you can execute:
Getting started with #Exasol on #AWS
(Uwe Hesse) It’s amazingly easy to run an Exasol Cluster on Amazon Web Services (AWS).
What’s new with Oracle database 12.1.0.2.190416 versus 12.1.0.2.190716
(Frits Hoogland) There are a couple of undocumented spare parameters changed to named undocumented parameters, this is quite normal to see.
The definition of proof
(Connor McDonald) One of the pieces of advice that I often see on the ‘net is that undo space is somehow this incredibly precious thing, and as a consequence, one should always keep the amount of uncommitted changes in the database to a small size.