Monday, August 8, 2011

List of Database users about to expire in 'n' days.

select * from dba_users where expiry_date  > sysdate - 10 and expiry_date < sysdate + 10
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle E-business suite logs clean up

 Oracle E-business suite logs clean up #!/bin/bash cd $EBS_DOMAIN_HOME find $EBS_DOMAIN_HOME -type f -path "*/logs/*.log?*" -mtime...

  • (no title)
     FIND LOW LEVEL DEBUG ON E-BUSINESSS SUITE  PRODUCTION DATABASES SHOULD NOT HAVE DEBUG ENABLED  1. Query to find if debug is enabled in EBS ...
  • All About Oracle Database Latches
    All About Latches 1. What are Oracle latches? Latches are Oracle-internal low-level locks that protect the memory structures of the sy...