RE: flashback query vs. log miner

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Mon, 26 Jul 2004 11:41:51 -0400
Message-ID: <80D4A99A2715674EB2D256DAD89219F6044E8AE7@dohsmail02.doh.ad.state.fl.us>

Thanks Kirti,

That was a very concise description and along the lines of what I was = telling a junior dba I am training. =20

However, is it a hard limit for FBQ - 5 days - or is it solely based on = undo tablespace size and undo tablespace retention parameter? =20

Also, is there any downside with allocating a great deal of space to the = undo tablespace in a database other than static allocation?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kirtikumar Deshpande Sent: Saturday, July 24, 2004 10:50 AM
To: oracle-l_at_freelists.org
Subject: RE: flashback query vs. log miner

Paula,
 One must use LogMiner if one needs to access data that is more than 5 = days old (instance
uptime wise). FBQ does not help you. Of course, this changes with Oracle = 10g ( and what
doesn't? ;).=20

 Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy = to use FBQ to
access past data (if it is still available in the undo segments). = Accessing the same
information via LogMiner is a bit more involved process. With proper = privileges, you can
let your developers use FBQ, but I doubt if DBAs will allow Developers = to play with
LogMiner. =20

 So, I would not use one versus the other all the time, but may be = required to use both,
depending on the requirement.=20

Regards,
- Kirti
=20
--- Paula_Stankus_at_doh.state.fl.us wrote:
> Guys,

>=20
> I know you can reconstruct data in a table (given your undo segments =
in =3D
> your undo tablespace is not overwritten)
> with flashback query. However, you should be able to do the same =
using =3D
> log_minor.

>=20
>=20

> So flashback is easier to work but probably couldn't restore as much =
as =3D
> you could using log_minor. =3D20

>=20
> Why would you use one versus the other?

        =09

---

Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail=20

---

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
-----------------------------------------------------------------


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 5416553) is spam:
Spam:        =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5416553&m=3D3e3a8=
d0f45c8
Not spam:    =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5416553&m=3D3e3a8=
d0f45c8
Forget vote: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5416553&m=3D3e3a8=
d0f45c8
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

----------------------------------------------------------------
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 Mon Jul 26 2004 - 10:38:24 CDT