In this article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud – including the setup of such a cloud. In ...
A concatenated index, also known as multi-column, composite or combined index, is one index across multiple columns. In case of queries with multiple equality conditions, even though multiple single c...
Oracle Database 12c introduced the unified audit trail feature, which allows the capture of audit information from several sources, such as audit records (including SYS audit records) from unified aud...
I'm pleased to announce the second release of Toad for Oracle this year which went GA on October 18. This is a brand new feature that addresses the needs of DBAs concerned about data privacy with the...
Before Oracle Database 18c, the only way to encrypt data (all types of data) was using the parameters ENCRYPTION_PASSWORD or ENCRYPTION_PWD_PROMPT. The data is exported in clear text in an export oper...
Do you need to encrypt sensitive credential data? Here’s how you can do so in the Oracle 18c data dictionary. Oracle Database has two main tables where credential data is stored: SYS.LINK$ and SYS.SC...
Toad Data Modeler is a design and modeling tool for data with support for forward- and reverse-engineering to most of the commonly used relational database management systems (RDBMS). In the first of ...
Toad DevOps Toolkit has been on the market now for 12 months and has created a huge amount of interest with companies trying to figure out how to integrate their Oracle database change management into...
In this tutorial we shall discuss using Toad Data Modeler with Oracle Database running on AWS RDS. We shall create an Oracle Database instance on AWS RDS and reverse engineer the database to a model i...
Performance of a query having multiple equality type predicates improves as it switches from using the index on an unselective column to a selective one. It is very common to issue queries with multi...
Hybrid cloud management is an interestingly hot topic for today’s cloud world, since not all companies want to move everything to the cloud. In this article series, we are looking at the detailed step...
In this article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database-as-a-Service (DBaaS) cloud – including the setup of such a cloud. In ...
