Hi Tanel, The short answer is "experiment". I do still have a BMC SQL*Trax manual published in July '96 that names 29 of the most common opcodes and their layers on pages 4-27 to 4-29, but some of the names are misleading and things have changed a lot since then anyway. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -----Original Message----- From: Tanel Poder Sent: Wednesday, 17 March 2004 12:36 PM To: oracle-l@xxxxxxxxxxxxx; Fedock, John (KAM.RHQ) Subject: Re: any way to tell when an extent was added? > If you know which logfile to look in, the following command should do > it. > > alter system dump logfile > '/some/logfile' layer 14 opcode 4; Btw, is there a list of redolog layers and opcodes anywhere available by chance or should one "experiment" them out from oracle? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------