Transient Journal (TJ) is an area of space in the DBC database which is used primarily for storing of roll-back/undo information during inserts/deletes/updates on a tables.
TJ require perm space and is stored in "dbc.transientjournal". This special type of table can grow beyond dbc's perm space limit until the whole system runs out of perm space.
It is good practice to backup Transient Journal regularly and delete to enhance query and load performance.
Hello,
ReplyDeleteHow can we identify the session which is taking up more TJ at the database end?
Thanks,
Vivek Battu