Oracle Database
Installing Oracle Database 12c R1 on Linux 6 with ASM
In previous article we covered operating system installation:Â Installing Oracle Linux 6 and preparing for Oracle Software installations. It is a prerequisite…
Data Masking with Oracle Enterprise Manager 12c Cloud Control
Data Masking in Oracle Enterprise Manager 12c Cloud Control This tutorial shows you how to identify sensitive data, create Application Data…
Installing Oracle Database 11g R2 on Linux with ASM
In this guide we are going to cover Oracle Database 11g R2 installation on Linux with ASM. Automatic Storage Management (ASM)…
Installing Oracle Database 11g R2 on Linux
In article Installing Oracle Linux in VMware virtual machine we covered installation of Oracle Linux 5U8 including oracle-validated package. Now, our…
DBMS_STATS in an Oracle Database
DBMS_STATS in an Oracle Database Using DBMS_STATS package to gather Oracle dictionary statistics. 1. To gather table statistics with DBMS_STATS SQL>…
Creating an online Phone Book with Oracle Database and SQLDeveloper
This tutorial shows how to create an Online Phone Book with search feature using Oracle Database and SQLDeveloper. What’s needed? Oracle…
Orcle APEX Manage HTTP remote access
Manage HTTP Access in Application Express 3.0 After default installation of Oracle APEX 3.0, remote users are not allowed to access…
Problem when creating the SQL Profile
Scenario: UserX tries to run SQL Tuning Advisor on a long running SELECT query in the database. The SQL Tuning Advisor…
How to uninstall Oracle Database 11g
Oracle Installer 11g doesn’t provide “uninstall database” option… In order to uninstall Oracle Database 11g go to “deinstall” directory in $ORACLE_HOME:…
Passwords in Oracle Database
Fact sheet about Oracle database passwords Oracle Password Algorithm (7-10g Rel.2) (Designed by Bob Baldwin) Up to 30 characters long. All…