Oracle Data Redaction
Oracle Data Redaction
Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods: Full redaction. You re...
Using Toad Data Point with Oracle Database on AWS RDS
Using Toad Data Point with Oracle Database on AWS RDS
Introduction Toad Data Point is a relational data source access, query, and analytics tool that may be used to create a table, add table data, query a table, and prepare reports; all from a graphica...
Do you want to be a Database Administrator? Four DBA experts tell us their story
Do you want to be a Database Administrator? Four DBA experts tell us their story
What does it really mean to be a database administrator? In an increasingly technologically globalized world, this specialty has taken on a very important role. When I started working in Oracle techno...
¿Quieres ser un Administrador de Bases de Datos? Cuatro Expertos DBA nos cuentan su historia
¿Quieres ser un Administrador de Bases de Datos? Cuatro Expertos DBA nos cuentan su historia
¿Sabemos lo que realmente significa ser un Administrador de Bases de Datos? En un mundo globalizado cada vez más tecnológico, esta especialidad ha cobrado un rol muy importante. Recuerdo que cuando me...
How to install IBM Db2 Developer Edition on Centos 7 using Docker
How to install IBM Db2 Developer Edition on Centos 7 using Docker
In this post, I would like to show you how to install IBM Db2 Developer Community edition. IBM Db2 Developer Community Edition is a full-featured free version for non-production environments. Primaril...
Need the Right Toolset for Your MySQL Database? There’s a Toad for That.
Need the Right Toolset for Your MySQL Database? There’s a Toad for That.
“We’re transitioning to an open source database platform, and we’d really like to be able to develop and run our databases using our Toad software.” Toad Edge Lets You Get the Full Value from MySQL...
Logging and analyzing slow queries in MySQL
Logging and analyzing slow queries in MySQL
Introduction Slow queries can negatively impact database performance. If you don't analyze, optimize, and tune the slow queries as early as possible, the overall performance of your system will eventu...
Oracle Coding Best Practices – Part 2
Oracle Coding Best Practices – Part 2
Hi, This month I’ll focus on a couple of PL/SQL performance tips that will include how to utilize collections to radically increase row processing and a simple but useful coding tip on the benefits an...
Using LVM for adding two LUNS/Disks as one mount point
Using LVM for adding two LUNS/Disks as one mount point
There may be situation where required capacity cannot be allocated from single volume group from storage, in such situation storage teams will provide multiple luns with different capacities. In this ...
Deinstall Oracle grid Infrastructure 12.2 – Failed Installation
Deinstall Oracle grid Infrastructure 12.2 – Failed Installation
Oracle grid infrastructure 12.2 installation and deinstallation process is similar to prior releases. Its very common that the installation of software may fail due to many reasons. It could be a hard...
Auto enabling APPROX_* function in the Oracle Database
Auto enabling APPROX_* function in the Oracle Database
With the releases of 12.1 and 12.2 of Oracle Database we have seen some new functions that perform approximate calculations. These include: APPROX_COUNT_DISTINCT APPROX_COUNT_DISTINCT_DETAIL APPROX_...
Using Toad Data Point with RDBMS Data Sources
Using Toad Data Point with RDBMS Data Sources
Toad Data Point is a data preparation, analysis, and reporting tool with data access to several of the commonly used data sources. RDBMS databases is just one of the categories of data sources that ma...