Alex Lima

Tag: trigger

January 7, 2012

|

trace

Example of using tracefile_identifier

Using “tracefile_identifier” Oracle will add that to the name of the user’s trace filename so the file can easily be… READ MORE
September 10, 2010

|

SQL Server, Table

How to list triggers on a database in SQLServer?

Using the following SQL statement, it will list triggers on database. It also prints trigger name, table the trigger is… READ MORE
June 17, 2008

|

General DBA, Scripts

Trigger to monitor successful logins in the database

By having a logon trigger in a database one can monitor or audit OS user, programs, DB users, time users… READ MORE

Recent posts

March 24, 2026

How to consolidate Classic PUMP filtering and transformation logic into one Extract
March 4, 2026

Is the DBA Career Dead?
February 10, 2026

Converting GoldenGate Classic PUMP to Dist Path with complex filtering

Quote of the week

“Control what I can control”
~ Alex Lima

Alex Lima

About

Taking one day at a time.

Follow Us

Blog at WordPress.com.