RE: any way to tell when an extent was added?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 17 Mar 2004 13:35:44 +1100
Message-ID: <008101c40bc8$8c4e1a30$ae8735cb@ixora.com.au>

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_at_freelists.org; 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 16 2004 - 20:32:26 CST