Blog Posts

  • Why is Swapping Bad for oracle?

    Linux OS is a virtual memory system like any other modern operating system. The Virtual Memory Management system of Linux includes: Paging Swapping HugePages Slab allocator Shared memory When almost all of the available physical memory (RAM) is started to be used in Linux, the kernel will start to swap out pages to the swap…

  • ORACLE GOLDEN GATE INSTALLATION

    will start the post soon with all installation steps & snapshots ………

  • script to get all table and system privileges granted to a user

    Description This script all table and system privileges granted to a user.  The scripts also takes into acount those privileges assigned via  roles granted via roles Parameters username – The username to display privileges for SQL Source REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. set echo offset verify offset pages 200col granted_role…

  • Oracle Password Verification function

    Password Verification : Enforcing Password Complexity Password complexity is enforced using a verification function. Oracle provide an example password verification function in the “$ORACLE_HOME/rdbms/admin/utlpwdmg.sql” file, but you can code a custom one if you prefer. The function must accept three parameters (username, password and old_password) and return a boolean value, where the value TRUE signifies…

  • FLASHBACK STANDBY DATABASE

    FLASHBACK STANDBY SQLPLUS commands to turn off DATA GUARD temporarily in order to activate the physical standby for testing purposes.  Notice commands are indicated by PRMY or STBY designation for which database they need to executed on.  11g reduces these steps making this a feature they call the “SNAPSHOT DATABASE”. PRMY> ALTER SYSTEM ARCHIVE LOG…