Category: Oracle Database

Oracle Database & database related technologies including Oracle Real Application Cluster (RAC), Oracle Database Appliance, Oracle Exadata, Oracle DataGuard, Oracle GoldenGate, Oracle Security, Oracle Grid Infrastructure, Oracle Could, Oracle Cloud Control and many others.

Oracle Database XE 18c – System Requirements

System Requirements for Oracle Database Express Edition (XE) 18c. For Linux x86-64 Operating System Linux x86-64 operating system requirements The following Linux x86-64 kernels are supported: Oracle Linux 7 with the Unbreakable Enterprise Kernel 3: 3.8.13-35.3.1.el7uek.x86_64 or later Oracle Linux 7.2 with the Unbreakable Enterprise Kernel 4: 4.1.12-32.2.3.el7uek.x86_64 or later Oracle Linux 7 with the Read More …

Load Testing Dbvisit Replicate

Clients running high available Oracle databases must be able to minimize the downtime associated to many different critical maintenance tasks such as database upgrades, hardware refreshes, migrations from single instance to RAC, etc. The Swingbench database stressing tool provides a couple of out of the box benchmarks that we use to stress the database and demonstrate the effectiveness of Dbvisit Replicate.

Oracle Database – Sequence Enhancement in PL/SQL

Oracle Database 11g – Sequence use in PL/SQL – One of the language enhancements that was introduced in 11g is the use of sequence pseudocolumns, NEXTVAL and CURRVAL, in any PL/SQL context when an expression of NUMBER datatype may appear. This is now the preferred method of calling sequences in PL/SQL.

Oracle Application Express – APEX

Oracle Application Express (APEX) Oracle Application Express is the hidden gem in your Oracle database which allows for full application development right from within your Oracle database. eSolution provides expert consulting services on this simple and yet comprehensive platform from Oracle.  Oracle Application Express or APEX has not made a very big splash, not for lack of functionalities, Read More …

Oracle Data Guard

High Availability, Data Protection and Disaster Recovery Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these Read More …

Oracle Database Security Audits

Oracle Database Security Audits, A World of threats, regulations and myths: A database security audit is the systematic, non-intrusive analysis of the database and directly associated components, from a security perspective, to detect issues that may lead to different types of security breaches and/or lack of compliance with the corporate security policy or security mandates.