nologging in Oracle

Long time ago when i was still an apprentice doing my fist ETL for one i learned about the good and common practice that specific tables in data warehouse should be loaded in NOLOGGING mode. Reasoning for doing this were sound, we did it for the tables that can always be repopulated with ETL. It won’t … Read more

Audit oracle connections only for specific users

I have seen on few places in the net questions about how to disable logon and logoff audit for only one specific user (usually DBSNMP). This would really come in handy since some applications can have really excessive number of connections to the database. This should of course be addressed in other manner like creating … Read more