track ddl change (part 2) – Laurent Schneider

I wrote about tracking ddl changes with a trigger there : track ddl changes

Another option is to use auditing.

A new and cool alternative is to use enable_ddl_logging (11gR2). This will track all ddl’s in the alert log

ALTER SYSTEM SET enable_ddl_logging=TRUE

Then later you issue
create table t(x number)

and you see in the alertLSC01.log
Tue Apr 05 14:43:32 2011 create table t(x number)

Wait, that’s not really verbose !?

Remember the alert log is just there for backward compatibility, it is time you start looking in the xml file 🙂

create table t(x number)

There is not really much more there but the module, which indeed reveals someone is using TOAD to access my database !

11 thoughts on “track ddl change (part 2)”

Anonymous April 5, 2011 at 21:00

“which indeed reveals someone is using TOAD to access my database” – are you suggesting that using TOAD is wrong against database???

Laurent Schneider April 5, 2011 at 21:11

shhh, don’t tell anyone, it’s me 😉

joel garry April 6, 2011 at 01:01

exec dbms_application_info.set_module(‘Toadlicker’,’;-)’);

Asif Momen April 6, 2011 at 09:20

This feature comes with “Oracle Change Management Pack” and is available for EE only. You got pay extra to use this. 🙁

http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/editions.htm#CJACGHEB

Laurent Schneider Post authorApril 6, 2011 at 10:46

@Joel 😉 indeed you could fake your module !

@Asif Thanks for this info

Lutz Hartmann April 11, 2011 at 10:39

Hi Laurent
, this feature was already in 11gR1 available.
See here: http://sysdba.wordpress.com/2007/10/16/ddd-logging-in-the-alert-log-in-11g/
Cheers,
Lutz

Laurent Schneider Post authorApril 12, 2011 at 08:30

Indeed, any clue why it is not documented in the 11gR1 reference ?

Ebrahim June 6, 2011 at 18:33

So, please let us all know, what are, if any, are issues using Toad against a database? I have some DBAs talking about turning off access to clients using Toad, but I dont know what the reservations are?

Thanks

Pingback: Laurent Schneider » On using Toad against a database

Laurent Schneider Post authorJune 7, 2011 at 11:17

@Ebrahim : I like your question, I tried to answered it there : https://laurentschneider.com/2011/06/on-using-toad-against-a-database.html

Pingback: On using Toad against a database « Ukrainian Oracle User Group

Comments are closed.