All Posts |
Write fast and efficient PLSQL - DBMS_PROFILERThis 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_REPAIRThis 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_CRYPTOThe 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 installedACLs 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 1This article is a step by step guide to upgrade Oracle 10g Release 2 (10.2.0.4) to 11g Release 1 (11.1.0.6) on Red Hat Enterprise Linux 5.5 x86_64. |
Oracle 11g Release 1 Pre Upgrade tool utlu111i sqlThis 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 PasswordsOracle 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 ServicesIn 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 5This 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 2This article is a step by step guide to upgrade Oracle 10g Release 2 (10.2.0.4) to 11g Release 2 (11.2.0.1) on Red Hat Enterprise Linux 5.4. |