Re: Wow, Man, Flashbacks!
Hi! It was only the SCN - time mapping informatin which is aged out after 5 days, but you still can use SCN-based flashback back to your oldest undo record. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 07, 2003 10:04 PM Others have mentioned it, but I just wanted to chime in to warn you to warn your developers, that they will only have five days to use their frozen moment in time. This is the limitation imposed by the scn table mentioned in Dan's post. The reason I decided to chime in is that AFAIK, no official Oracle documentation refers to this limitation. This is just one of those odd things I wouldn't know, if it weren't for my association to this list. -Original Message- Bellow, Bambi Sent: Friday, November 07, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Melanie -- What's happening is that, in a write-intensive environment, the developers want to freeze a moment in time which can be used across developers and applications for testing to ensure consistent results. The functionality may be expanded, in time, depending on how it works. But from what I'm seeing, this seems to be the right tool for the job. Thanks, everyone, for your feedback. In my book, this goes down as Oracle's coolest feature since DECODE. Bambi. -Original Message- Sent: Thursday, November 06, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Hi Bambi, I hate to sound repetitive, but, it depends. :-) It depends on how far you want to flash back to. One of my clients was being audited last year by their parent company. I put in a retention period of about a week at a time. Without divulging much from my confidentiality agreement with them, we were really trying to figure out what certain users were doing within the company, and we provided proof of such. Using the flashback query feature made this incredibly easy to do! Of course, you have to be careful with your UNDO segments, as you know. I didn't try going backwards for more than a week. That was all we needed at the time. I also turned this feature off once we were done. Other than UNDO segment growth, which I planned for in advance, I didn't have any problems with it. And it made the task at hand incredibly easy. But, I wouldn't recommend putting it in place unless you really need it. My $0.02, Melanie --- Bellow, Bambi [EMAIL PROTECTED] wrote: Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: Wow, Man, Flashbacks!
Jonathan Lewis has found out that even 8i has flashback capabilities internally http://www.jlcomp.demon.co.uk/ch_01.html Btw, in 10g there is a guaranteed retention option as well, that undo_retention time is forced instead of attempted. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:39 PM Actually, flashback is available regardless of the undo management configuration. Flashback requires use of the smon_scn_time table, which is populated with an scn - time relationship every five minutes the instance is up. The table is restricted to a certain size (14400 entries IIRC) by the update logic, so the 5 days of flashback time is a result of the old records being 'aged' off the table. Using AUM increases the likelihood that a flashback query will succeed, but it is not a guarantee. The logic of block reuse in AUM should increase the retention of undo. Daniel Fink Melanie Caffrey wrote: Yes, this is correct. Rollback segments cannot be used. --- Stephen Andert [EMAIL PROTECTED] wrote: Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen [EMAIL PROTECTED] 11/06/03 10:04AM Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Re: Wow, Man, Flashbacks!
Undo normally occupies a sizeable portion of your buffer cache - a good thing too, because they're hammered for consistent read and the like. Of course, if your undo segments are massive, then the percentage of any given undo segment being the cache drops...Massive undo segments *might* be setting you up for a big physical IO hit on your undo datafiles. (so its the familiar mantra of benchmark, benchmark, etc etc) hth connor --- Bellow, Bambi [EMAIL PROTECTED] wrote: Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wow, Man, Flashbacks!
Melanie -- What's happening is that, in a write-intensive environment, the developers want to freeze a moment in time which can be used across developers and applications for testing to ensure consistent results. The functionality may be expanded, in time, depending on how it works. But from what I'm seeing, this seems to be the right tool for the job. Thanks, everyone, for your feedback. In my book, this goes down as Oracle's coolest feature since DECODE. Bambi. -Original Message- Sent: Thursday, November 06, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Hi Bambi, I hate to sound repetitive, but, it depends. :-) It depends on how far you want to flash back to. One of my clients was being audited last year by their parent company. I put in a retention period of about a week at a time. Without divulging much from my confidentiality agreement with them, we were really trying to figure out what certain users were doing within the company, and we provided proof of such. Using the flashback query feature made this incredibly easy to do! Of course, you have to be careful with your UNDO segments, as you know. I didn't try going backwards for more than a week. That was all we needed at the time. I also turned this feature off once we were done. Other than UNDO segment growth, which I planned for in advance, I didn't have any problems with it. And it made the task at hand incredibly easy. But, I wouldn't recommend putting it in place unless you really need it. My $0.02, Melanie --- Bellow, Bambi [EMAIL PROTECTED] wrote: Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wow, Man, Flashbacks!
Others have mentioned it, but I just wanted to chime in to warn you to warn your developers, that they will only have five days to use their frozen moment in time. This is the limitation imposed by the scn table mentioned in Dan's post. The reason I decided to chime in is that AFAIK, no official Oracle documentation refers to this limitation. This is just one of those odd things I wouldn't know, if it weren't for my association to this list. -Original Message- Bellow, Bambi Sent: Friday, November 07, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Melanie -- What's happening is that, in a write-intensive environment, the developers want to freeze a moment in time which can be used across developers and applications for testing to ensure consistent results. The functionality may be expanded, in time, depending on how it works. But from what I'm seeing, this seems to be the right tool for the job. Thanks, everyone, for your feedback. In my book, this goes down as Oracle's coolest feature since DECODE. Bambi. -Original Message- Sent: Thursday, November 06, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Hi Bambi, I hate to sound repetitive, but, it depends. :-) It depends on how far you want to flash back to. One of my clients was being audited last year by their parent company. I put in a retention period of about a week at a time. Without divulging much from my confidentiality agreement with them, we were really trying to figure out what certain users were doing within the company, and we provided proof of such. Using the flashback query feature made this incredibly easy to do! Of course, you have to be careful with your UNDO segments, as you know. I didn't try going backwards for more than a week. That was all we needed at the time. I also turned this feature off once we were done. Other than UNDO segment growth, which I planned for in advance, I didn't have any problems with it. And it made the task at hand incredibly easy. But, I wouldn't recommend putting it in place unless you really need it. My $0.02, Melanie --- Bellow, Bambi [EMAIL PROTECTED] wrote: Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
Re: Wow, Man, Flashbacks!
Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen [EMAIL PROTECTED] 11/06/03 10:04AM Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wow, Man, Flashbacks!
Hi Bambi, I hate to sound repetitive, but, it depends. :-) It depends on how far you want to flash back to. One of my clients was being audited last year by their parent company. I put in a retention period of about a week at a time. Without divulging much from my confidentiality agreement with them, we were really trying to figure out what certain users were doing within the company, and we provided proof of such. Using the flashback query feature made this incredibly easy to do! Of course, you have to be careful with your UNDO segments, as you know. I didn't try going backwards for more than a week. That was all we needed at the time. I also turned this feature off once we were done. Other than UNDO segment growth, which I planned for in advance, I didn't have any problems with it. And it made the task at hand incredibly easy. But, I wouldn't recommend putting it in place unless you really need it. My $0.02, Melanie --- Bellow, Bambi [EMAIL PROTECTED] wrote: Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wow, Man, Flashbacks!
Yes, this is correct. Rollback segments cannot be used. --- Stephen Andert [EMAIL PROTECTED] wrote: Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen [EMAIL PROTECTED] 11/06/03 10:04AM Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wow, Man, Flashbacks!
Actually, flashback is available regardless of the undo management configuration. Flashback requires use of the smon_scn_time table, which is populated with an scn - time relationship every five minutes the instance is up. The table is restricted to a certain size (14400 entries IIRC) by the update logic, so the 5 days of flashback time is a result of the old records being 'aged' off the table. Using AUM increases the likelihood that a flashback query will succeed, but it is not a guarantee. The logic of block reuse in AUM should increase the retention of undo. Daniel Fink Melanie Caffrey wrote: Yes, this is correct. Rollback segments cannot be used. --- Stephen Andert [EMAIL PROTECTED] wrote: Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen [EMAIL PROTECTED] 11/06/03 10:04AM Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wow, Man, Flashbacks!
There are several errors in this article. 1) AUM is not a requirement for Flashback Query (FBQ) 2) UNDO_RETENTION is not the max age for an FBQ, it is a guideline for how long to retain undo before reusing blocks (note...this is NOT a guarantee). Max age for an FBQ is coverned by the entries in the smon_scn_time table. If the instance is shutdown for a period of time and enough UNDO is available, you can flashback more than 5 days (which is documented). If you are an IOUG member, download his paper/presentations from IOUG-A Live 2003. They are excellent. Daniel Fink Bellow, Bambi wrote: Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Wow, Man, Flashbacks!
Just spoke with someone off the list. Let me clarify something. It is recommended that rollback segments not be used. But I didn't actually try to use them, so I'm not sure. I used the recommended AUM. --- Melanie Caffrey [EMAIL PROTECTED] wrote: Yes, this is correct. Rollback segments cannot be used. --- Stephen Andert [EMAIL PROTECTED] wrote: Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen [EMAIL PROTECTED] 11/06/03 10:04AM Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes! Let's just chill on this for a couple of minutes. So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking well, we've got sufficiently large undo segments for this, I don't see a problem with it but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).