This tutorial shows how to create an Online Phone Book with search feature using Oracle Database and SQLDeveloper. What’s needed? Oracle…
Oracle WebLogic Server 10.3 comes with default configuration of the JVM memory distribution between the managed servers. Assuming we have the…
Common error: ORA-00054: resource busy and acquire with NOWAIT specified To identify all locked sessions in an Oracle database: Query 1:…
Manage HTTP Access in Application Express 3.0 After default installation of Oracle APEX 3.0, remote users are not allowed to access…
Installation of Oracle Application Intergration Architecture Foundation Pack (AIA) 11g including Oracle SOA Suite 11g with Oracle BAM 11g on Oracle…
This short demo demonstrates how to uninstall Oracle SOA Suite 11g including WebLogic platform and database schemas. Go to uninstall directory…
View Also: Oracle DBA Interview Questions Answered: Technical 1. Q: How do you automate starting and shutting down of databases in…
Scenario: To drop, truncate multiple or all tables from user’s schema. Let’s suppose we’ve got the following tables in user’s schema…
Scenario: UserX tries to run SQL Tuning Advisor on a long running SELECT query in the database. The SQL Tuning Advisor…
Oracle Installer 11g doesn’t provide “uninstall database” option… In order to uninstall Oracle Database 11g go to “deinstall” directory in $ORACLE_HOME:…