Zahid Karim
Recent Posts
1.Write fast and efficient PLSQL - DBMS_PROFILER
2.Fix physically corrupt data blocks using PLSQL - DBMS_REPAIR
3.Encrypt or Decrypt sensitive data using PLSQL - DBMS_CRYPTO
4.ORA-24248 XMLDB extensible security not installed
5.Upgrade Oracle 10g Release 2 to Oracle 11g Release 1
Find me on

All Posts

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 (11.1.0.6) 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 (11.2.0.1) on Red Hat Enterprise Linux 5.4.


[First]    [Prev]   [1..10]