Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Oracle 10g Extra Attributes in LCR and procedures and functions for LCR types

Oracle Database 10g now allows you to include some extra attributes in the LCR. This optional method is facilitated by the include_extra_attribute procedure in the dbms_capture_adm package. When you use this procedure, the following extra attributes are added to LCR.

  • row_id - The rowid of the row changed in a row LCR. However, this attribute is not included in DDL LCRs, nor in the row LCRs for index-organized tables.

  • serial# - The serial number of the session that performed the change captured in the LCR.

  • session# - The identifier of the session that performed the change captured in the LCR.

  • thread# - The thread number of the instance in which the change captured in the LCR was performed. The thread number is relevant only in a Real Application Clusters environment.

  • tx_name - The name of the transaction that includes the LCR.

  • username - The name of the user who performed the change captured in the LCR.

Oracle Database 10g also introduced new procedures and functions to help handle the LCR types. They are as follows:


To get access to the commit SCN of LCRs, you can use the get_commit_scn member function. This function returns the commit system change number (SCN) of the transaction to which the current LCR belongs. This allows you to implement record-keeping procedures that are invoked before committing the LCR.

Let us see an example showing how to extract Commit SCN, object owner, object name, and Command type, and then insert it into an audit table.

(evt IN SYS.AnyData) IS
lcr        SYS.LCR$_ROW_RECORD;
tno        PLS_INTEGER;
cscn NUMBER;
-- Extract the LCR type
tno          := evt.getObject(lcr);
action        := lcr.get_command_type();
tab_name        := lcr.get_object_name();

Get the complete story:

The above text is an excerpt from "Oracle Database 10g New Features: Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.