RE: any way to tell when an extent was added?
- From: "Steve Adams" <steve.adams@xxxxxxxxxxxx>
- To: "'Tanel Poder'" <tanel.poder.003@xxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2004 13:35:44 +1100
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
-----------------------------------------------------------------
Other related posts:
