Write fast and efficient PLSQL - DBMS_PROFILER
This article shows how can we use DBMS_PROFILER to monitor statements insides a PL/SQL program and see how are they performing individually.
Fix physically corrupt data blocks using PLSQL - DBMS_REPAIR
This article demonstrate how to repair a physically corrupt data block using DBMS_REPAIR in oracle 10g when you don't have a sufficient data file backup.
Encrypt or Decrypt sensitive data using PLSQL - DBMS_CRYPTO
The tutorial focuses on how to encrypt or decrypt sesitive data for application using DBMS_CRYPTO package which is a replacement of DBMS_OBFUSCATION_KIT in 10g.
ORA-24248 XMLDB extensible security not installed
ACLs in Oracle 11g are stored in the XML Database repository inside the database itself. This article demonstrate how to install Oracle XML Database.
Upgrade Oracle 10g Release 2 to Oracle 11g Release 1
This article is a step by step guide to upgrade Oracle 10g Release 2 (10.2.0.4) to 11g Release 1 (18.104.22.168) on Red Hat Enterprise Linux 5.5 x86_64.
Oracle 11g Release 1 Pre Upgrade tool utlu111i sql
This article shows what to do for different warnings and cautions reported by Oracle 11g Release 1 Pre-Upgrade tool that is utlu111i.sql during 11gR1 upgrade.
Oracle 11g Case Sensitive Passwords
Oracle 11g by default force case sensitivity of user passwords. This post shows how to turn off and on this feature for user passwords and password file.
Oracle 11g Access Control List for External Network Services
In oracle 11g packages like UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, and UTL_INADDR can't be used without configuring an ACL. This post shows how to configure ACL
Install Oracle 11g Release 1 on RHEL 5
This is a quick step by step guide, which I usually use to install Oracle 11g Release 1 on Red Hat Enterprise Linux 5.
Upgrade Oracle 10g Release 2 to Oracle 11g Release 2
This article is a step by step guide to upgrade Oracle 10g Release 2 (10.2.0.4) to 11g Release 2 (22.214.171.124) on Red Hat Enterprise Linux 5.4.