What would be the easiest way to monitor the SQL’s currently executing in your Autonomous service? Or, as a matter of fact, in any Oracle database?
Setup a VirtualBox based Database Lab Environment
Oracle provides a lot of useful Oracle VirtualBox Pre-built Appliances.
In this blog post, I will describe the few extra steps I take after download in order to setup my lab environment on my work MacBook Pro.
Continue reading “Setup a VirtualBox based Database Lab Environment”
Is Oracle Autonomous Database the answer to the many database security issues? (II)
In the previous article, I discussed the main differentiating capabilities of the Autonomous, what makes it special on the market. In this post, I will discuss how are those capabilities implemented.
Continue reading “Is Oracle Autonomous Database the answer to the many database security issues? (II)”
Is Oracle Autonomous Database the answer to the many database security issues? (I)
There is no surprise that typical Database setups are the main target of the hacking attacks worldwide. The reason is obvious: cracking a database will result in access to the data which is the main ‘merchandise’ to be shared or sold on the dark corners of the World Wide Web.
Continue reading “Is Oracle Autonomous Database the answer to the many database security issues? (I)”
Column Level Collation Example
The feature was first introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled.
Continue reading “Column Level Collation Example”
SQL*Plus Client connections to several Oracle Autonomous (Always-Free)
Oracle Autonomous is a great service and Always-Free is a nice offering launched at OpenWorld 2019.
But what happens if I need to connect via SQL*Plus to two or more ADB from the same machine/terminal? The Oracle documentation provides good reference usable when connectiong to one autonomous database but if we need to use several ADB’s, the instructions provided by Oracle will be usable only if we keep changing the local TNS_ADMIN environment variable! That would not be possible for some of my Clients that have single TNS_ADMIN location and content that is managed at entreprise level!
Continue reading “SQL*Plus Client connections to several Oracle Autonomous (Always-Free)”
Overview: SELECT SAMPLE
One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle.
It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works.
Continue reading “Overview: SELECT SAMPLE”Estimate Defragmentaton Benefits for a Bigfile Tablespace
Database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.3.0.0.0
I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a way to estimate the space benefits of defragmenting the tablespace. I will use two methods.
Continue reading “Estimate Defragmentaton Benefits for a Bigfile Tablespace”
Starting Oracle SQL Developer with Custom Parameters
I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I could not change the sqldeveloper.conf SQL Developer config file which was stored in a ‘protected’ location.
Continue reading “Starting Oracle SQL Developer with Custom Parameters”
It is now possible to clone a database in Autonomous Cloud
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud.
Continue reading “It is now possible to clone a database in Autonomous Cloud”