Hi, I'm just wondering how you guys know so many undocumented Oracle parameters and what to do with them and things like that.
Please don't answer "because we're smart" ... that would be stating the obvious. Cheers, Sujatha PS: "undocumented Oracle parameters" makes it OnT rather than a philosophical musing. -----Original Message----- Sent: Wednesday, 13 March 2002 2:23 PM To: Multiple recipients of list ORACLE-L John, alter session set events 'immediate trace name ADJUST_SCN level 1' bumps the current SCN By one billion. I have used this event once while recovering a Tera Byte database where LGWR crashed and all the data files were inconsistent. And also there is an undocumented paramter something like _Max_Giga_SCN which starts (!!) the SCN at higher values. Have anyone used that? Best Regards, K Gopalakrishnan Bangalore, INDIA -----Original Message----- Kanagaraj Sent: Tuesday, March 12, 2002 3:00 PM To: Multiple recipients of list ORACLE-L > I think you can **artificially** force a database to reach the SCN to > 0xfffffff.ffff by using the event ADJUST_SCN. > This bumps the SCN to one billion if set at level 1. So > running them in a > loop will bump the SCN to the max value. > THis event generally used to bump the SCNs if there is a > mismatch between > file headers which is signaled by > ORA-00600 [2662]. > > Any volunteers? Gopal - how do you set or access this event? Volunteers: Just a word of warning - if you want to implement this on a Dev/Test database, make sure that it is not connected as a source or target to ANY other database via DBLinks. Otherwise you will find that these high SCNs migrate across to all others as if it were a cold virus. Such a database has to be absolutely quarantined... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).