If you want to filter and analyze your audit data from AUD$ table you need to scan data using ACTION# column. It keeps information about audit actions but is NUMERIC columns. To find out meaning of the column check AUDIT_ACTIONS table

So using simple join between AUD# and AUDIT_ACTIONS tables filter data as you want

SELECT *
  FROM sys.aud$
 WHERE ntimestamp# > SYSDATE - 7
  AND action# IN (
        SELECT action 
          FROM audit_actions
        WHERE name IN 
          ('ALTER USER',
           'CREATE USER',
           'DROP USER'));

List of all audit actions

SELECT action, name 
  FROM audit_actions
ORDER BY 1;

Continue reading →

This article in short explain patch terminology used by Oracle.

Have a fun 🙂
Tomasz

Finding source code written by a developer is typical task executed by a DBA or a developer.

Generally there are two basic methods to get source code:

• select code from dictionary views – quick, simple, can return part of code, complicated to generate properly DDL
• generate code using DBMS_METADATA package – very powerful, returns full code, easy to generate DDL code

Continue reading →

In Oracle Database NOLOGGING option used together with DIRECT mode speeds up transactions executed in a database because it limits information that Oracle writes about such transactions into redo logs and finally impacts size of generated archivelogs.

That’s because Oracle just writes basic information about executed transaction without modified data to redo logs. Such transactions are called UNRECOVERABLE because in case of database recovery archivelogs don’t have real data only informations about executed transactions.

It can impact later restores and this article shows it.

Continue reading →

This article presents proxy connections that enables to login to other schema using own user authentication.

CONNECT user[schema to connect]/user password

Before 11G it was quite complicated yet possible using ALTER USER .. IDENTIFIED BY VALUES . Read following article: Oracle password reset

Continue reading →