(1): OOW presentations
Well, I have to admit, I was a bit disappointed. My "audit" paper is pretty popular at the local user group meetings. I also had an abstract detailing what we are doing to prep our clients for 9i. I thought both would be good candidates. I was surprised that neither was picked. Oh well ... Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Wed, 08 Aug 2001 07:05:56 Rachel Carmichael wrote: >To those on the list who submitted abstracts to OOW and were either rejected >or placed on the alternates list: > >I have learned that there are only 75 non-Oracle personnel slots for >presentations at the conference. So it had nothing to do with the quality of >your abstract and much to do with Oracle trying to own the conference. > >Rachel > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: IMP 8.1.6 to 8.1.7 DB
I thought the question was taking an 816 .dmp files into 817. If that is the question, the answer is yes. You can usually/always go from older into "newer". Its one of the 3 upgrade/migration methods - even in 9i. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Wed, 08 Aug 2001 06:16:09 Kevin Kostyszyn wrote: >Yes you can, you have to use the exp utility from 8.1.7 to export the db, >then you use the exp from 8.1.7 to the 8.1.6. >KK > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh >Sharma > Sent: Wednesday, August 08, 2001 4:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: IMP 8.1.6 to 8.1.7 DB > > > wanna get my lunch first , then i must say u ..YES. > > Saurabh Sharma > > [EMAIL PROTECTED] > http://www.geocities.com/saurabh00pc/stride.html > >- Original Message - >From: Bunyamin K. Karadeniz >To: Multiple recipients of list ORACLE-L >Sent: Wednesday, August 08, 2001 1:25 PM >Subject: IMP 8.1.6 to 8.1.7 DB > > >I have an export(full) of 8.1.6 and I wonder if it is ok to import it to >8.1.7 ? > >Thakn you > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Is Oracle8.1.7 certified for NT4.0 ?
It is certified, but there are some VERY important patches to apply. I am up to 8.1.7.1.5. Now if 9i would just come out for NT! :-) Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Wed, 08 Aug 2001 16:50:46 Jared.Still wrote: > > >Dear Andrey, > >As I have the 8.1.7 CD's for NT 4.0 in my desk drawer, I'm guessing >that it is indeed certified for use on NT. > >Sincerely, > >The List > > > > > > >Andrey Bronfin > >ORACLE-L <[EMAIL PROTECTED]> >esoft.com> cc: > >Sent by:Subject: Is Oracle8.1.7 certified for >NT4.0 ? >[EMAIL PROTECTED] > > > > > >08/08/01 04:26 AM > >Please respond to > >ORACLE-L > > > > > > > > > >dear list ! >Is Oracle8.1.7 certified for NT4.0 ? >Thanks a lot in advance. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Andrey Bronfin > 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: > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Oracle 8.1.7 client install on Win2K.
Mark, Check "colors" in the display setting (right button over the wallpaper). Make sure it is 256 colors or higher. I remember a Java display bug that you may be hitting. Otherwise, create a run a simple java graphics program. If that fails too, then I think your display trick may be the cause. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 09 Aug 2001 12:26:37 Mark Leith wrote: >List, > >I have just got my hands on a shiny new P4 1.3 gig box with Win2K pro. I >installed the Java 1.3.0_01 JRE, and tried to start up the 8.1.7 for NT >Oracle install to install the client software (this was downloaded from >technet BTW). The splash screen runs - but when going for the install (the >java one) nothing happens, I get an hourglass cursor for all of 3-4 seconds >then nothing.. > >There is nothing else installed on this box apart from Office 2000, as it >was totally empty apart from the OS when we got it.. Has anybody else had >these problems? I seem to remember somebody (I think it may have been >Kevin?) had a problem installing on a P4 box - was your problem similar to >this one? > >All help is appreciated! > >Regards > >Mark > >BTW - you may remember I had an OT problem a while back now - where I had a >brand new Geoforce 3 Gfx card, that wouldn't run. I slipped it in to this >new beast and you should see the thing run now!! > >This PC now runs games in OpenGL and Direct3D modes with 1280*960 resolution >at roughly 65-70 frames per second!! With NO glitches!! Oh yeah I also have >one game installed on the system :) > >Cheers > >=== > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] >=== > http://www.cool-tools.co.uk > Maximising throughput & performance > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mark Leith > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Redo Generation - Excessive ?
(106*21953)+(92*104989)+(387*219 >> > 53)= 93,035,246 Bytes >> > >> > NOTE Thus There Seems to be a VAST Gap Between the Number of Log >> > Switches = 16 Corresponding to (16 * 175M) = 2.8 GB & 93MB of >> > Calculated for Inserts Size >> > >> > Type & Number of Bank A/cs :- >> > >> > Types COUNT(*) >> > -- >> > CAA 9780 >> > LAA 29489 >> > ODA899 >> > SBA 42868 >> > TDA 21953 >> > >> > Total Number of A/cs = 104,989 >> > >> > List of Tables on which DMLs Happen :- >> > >> > TABLE_NAME AVG_ROW_LEN >> > -- --- >> > Tables COMMON to ALL Types of A/cs ( CAA , LAA , ODA , SBA , TDA ) :- >> > DAILY_TRAN_DETAIL_TABLE231 >> > DAILY_TRAN_HEADER_TABLE 95 >> > TEMP_DAILY_TRAN_TABLE 92 >> > ENTITY_INTEREST_TABLE 209 >> > EOD_ACCT_BAL_TABLE 79 >> > GENERAL_ACCT_MAST_TABLE387 >> > INTEREST_DETAILS_TABLE 136 >> > >> > Only Updates Happen to these 2 Tables :- >> > INTEREST_SUMMARY_MOD_TABLE 74 >> > INTEREST_SUMMARY_TABLE 85 >> > >> > Tables Additionally Existing in LAA Type :- >> > LA_ACCT_MAST_TABLE 194 >> > LA_DMD_ADJ_TABLE81 >> > LA_DMD_TABLE98 >> > >> > Tables Additionaly Existing in TDA Type >> > TD_ACCT_MASTER_TABLE 180 >> > TD_DEFN_TABLE 106 >> > TAX_DED_AT_SOURCE_TABLE144 >> > TDS_INTERFACE_TABLE 53 >> > >> > 16 rows selected. >> > >> >On Friday 03 August 2001 14:28, VIVEK_SHARMA wrote: >> >> While Running a Set of BATCH Processing JOBs , Archived Redo >> > >> > of 11 GB is >> > >> >> being Generated over a 6 Hours Run on a E6500 Server . >> >> NOTE - The batch jobs are DML intensive in nature indeed . >> >> >> >> Online Redo Logfile Size = 175 MB >> >> LOG_CHECKPOINT_INTERVAL= 40 >> >> >> >> Qs Is there any way to know whether this Redo Generation is >> > >> > NORMAL or >> > >> >> ABNORMALLY High in some manner ? >> >> >> >> Oracle 8.1.7 on Solaris 8 >> >> >> >> Prima facie it seems Exceedingly High >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: database upgrade policy?
In the case of 816, it is desupported in October, so get to 817 ASAP. In the case of patches, try to watch for problems noted in MetaLink. Things like SQL*Net Demial Of Service fixes, I like to get them in right away. Otherwise, most client make me implement "if it is not broken, do not patch it". And remember: the patch and even the README file may have errors too. In the case of 9i, I beleive you should have a test instance up now to test and learn. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Wed, 22 Aug 2001 08:02:56 Christopher Spence wrote: >Highly depends. > >I tend to stay back from the latest versions for some time. >I also tend to upgrade for functionality, and upgrade when I have existing >problems that are told to be fixed. > >Sometimes if I start falling back versions and have no reason either way, I >will upgrade my development database and slowly trickle them to production >if things work well. > >A lot of it depends on the environment, if it is a 24/7 very large system, >then you only really want to upgrade when you have a good reason to. Or a >good maintenance window. > > >"Do not criticize someone until you walked a mile in their shoes, that way >when you criticize them, you are a mile a way and have their shoes." > >Christopher R. Spence >Oracle DBA >Phone: (978) 322-5744 >Fax:(707) 885-2275 > >Fuelspot >73 Princeton Street >North, Chelmsford 01863 > > > > >-Original Message- >Sent: Wednesday, August 22, 2001 11:45 AM >To: Multiple recipients of list ORACLE-L > > >Hi Listers > >I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?) as I get the >occasional ORA-600/ORA-7445. > >Do you upgrade to the latest subversion as a matter of policy (and not test >very much) to prevent possible errors >or only upgrade if you have problems? > >Do you upgrade to major versions (7 to 8.0 to 8.1) for increased >functionality, cos Oracle are desupporting (the main reason we upgrade) or >to improve the CV ;-) with the possible downside of instability. > >Mark. > > > > >Hyde Housing Association - Email Disclaimer > >The information in this email is strictly confidential and may be legally >privileged. > >It is intended solely for the addressee only. Access to this email by anyone >else is unauthorised. >If you are not the intended recipient and you have recieved this email in >error you must take no action on its contents, nor must you copy or show >them to anyone, or make use of the information therein. Please reply to the >email immediately, or forward to [EMAIL PROTECTED], highlighting >the error and confirming that it has been deleted from your system. > >SECURITY WARNING: Please note that this email has been created with the >knowledge that the Internet >is not a 100% secure communications medium. We advise that you understand >and observe this lack of security when e-mailing us. >VIRUSES: Although we have taken steps to ensure that this email and >attachments are free >from any virus, we advise that in keeping with good computing practise the >recipient should ensure that they are actually virus free. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mark Marsden > 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: Christopher Spence > 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).
Re: 8.1.7 on W2K
Who created the DBs on NT? How? When you created the 817 DBs, did you use the GUI or did you use the command line and a script? did you use autostart? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 30 Aug 2001 09:03:47 Uma Mohoni wrote: >Guys, >I have an just finished upgrading to 8.1.7 on all my boxes some of which are >Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0. >But on Windows2000, every time the box is rebooted the instance does not >come up automatically. However the service shows as running. I checked the >registry to make sure I had ORACLE_SID set right. > >I have to manually start the instance every time and its a pain in the 'you >know what'. If anyone has had this problem and solved it please let me know >the solution. > >Thanks, >Uma Mohoni >Consultant, CDI Corporation >@ iKimbo Inc. >500-A Huntmar Park Drive >Herndon, VA 20170 >(703) 904-4150 Ext:237 >[EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Uma Mohoni > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: Duhvelopers and DB-ehs?
- >>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). >> >> >>The information contained in this communication is >>confidential, is intended only for the use of the recipient >>named above, and may be legally privileged. If the reader >>of this message is not the intended recipient, you are >>hereby notified that any dissemination, distribution or >>copying of this communication is strictly prohibited. >>If you have received this communication in error, please >>re-send this communication to the sender and delete the >>original message or any copy of it from your computer >>system. >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Robertson Lee - lerobe >> 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: Thomas, Kevin >> 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). > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: 9i NT
: [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: Mercadante, Thomas F > 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: Kevin Kostyszyn > 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: Mercadante, Thomas F > 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: Kevin Kostyszyn > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: [RE: 9i NT]
t; > -- >> > > > Please see the official ORACLE-L FAQ: >> > > > http://www.orafaq.com >> > > > -- >> > > > Author: Scott >> > > > 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: Mercadante, Thomas F >> > > > 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 email alerts & NEW webcam video instant >> > > messaging with Yahoo! Messenger >> > > http://im.yahoo.com >> > > -- >> > > Please see the official ORACLE-L FAQ: >> > > http://www.orafaq.com >> > > -- >> > > Author: Scott >> > > 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 email alerts & NEW webcam video instant messaging with Yahoo! >>Messenger >> > http://im.yahoo.com >> > -- >> > Please see the official ORACLE-L FAQ: http://www.orafaq.com >> > -- >> > Author: A. Bardeen >> > 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). >> >> >> >>Get free email and a permanent address at http://www.amexmail.com/?A=1 >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Yigal Ran >> 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). > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: 81721 upgrade and event 10520
I applied 81721 patch to 817 on NT. Unlike the other 'move these files here and those there' patches, this was thru the Installer. So far, no problems. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Wed, 05 Sep 2001 08:51:55 Hillman, Alex wrote: >It is for avoiding of firing DDL triggers when running upgrade scripts. > >Alex Hillman > >-Original Message- >[mailto:[EMAIL PROTECTED]] >Sent: Wednesday, September 05, 2001 2:15 AM >To: Multiple recipients of list ORACLE-L > > >Hi, > >In the release notes for 8.1.7.2.1 there is a requirement to turn event >10520 on before running catalog.sql / catproc.sql and then turning the event >off afterwards. > >What does this event actually do (Ixora nor Metalink explain it)? >Does anyone know if this event required if you are creating a brand new >8.1.7.2.1 database? > >Thanks, >Bruce Reardon > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Reardon, Bruce (CALBBAY) > 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: Hillman, Alex > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: OT: Possible virus and/or mail bomb
I got a message like that a week or two ago. I just deleted it. I am not sure from who, but it was about 2m. --- TheOracleDBA [EMAIL PROTECTED] On Fri, 07 Sep 2001 13:28:26 dgoulet wrote: >To All, > >Just about two minutes ago I received a mail message from >"jacharya"<[EMAIL PROTECTED]>. The subject was California2 and the text >was the infamous "I sent this file to you for your opinion". You can imagine >what was included, so beware. > >Dick Goulet >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: Multiple Oracle Instances on NT
I support a client with 10 instances on 1 NT server. Did I choose that, no. And it is a bear to admin. However, after a lot of work, it is VERY stable. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Mon, 25 Jun 2001 23:51:07 TAG DBA wrote: >Hello Lisa... >I have been handling Oracle on NT last 6 months - and I much prefer UNIX. Here are >some things I learnt the hard way... > >>> - can you run multiple instances of Oracle on one NT machine > >yes u can. Another lister has replied to u about this - how one uses "oradim80" to >create "instances"/SID's >Note that the default SID can be set in the registry - so that u dont have to do "set >ORACLE_SID=" everytime >Note that there is no "oraenv" in NT >For every SID there will be 2 services in NT - one called OracleServiceURSID and >another OracleStartURSID. If u keep the latter as "start automatically" - ur db will >come up auto when NT boots up. The former is always required. U can alter the >settings by recreating the instance using oradim > >>> - if so, what do I need to look out for (ie. what things are differentthat a >Unix installation) >>> - are any of the processes, etc. drastically different - ie. >security,networking, logging > >Dont foreget to create the oradba group. Also Oracle runs as a single process - >there are no different shadow processes. So everything is clumped in one. The >TaskManager might show u how many threads are running in one process (it does not >break up for each app on the machine - so if only the Oracle server is running - the >figure u see should correspond to the number of Oracle related processes) >Further note that Oracle runs as user "system" - thats an internal hidden system mode >in NT. So there might be occassions when u change permissions on some orcale related >directory and then find that oracle cant access the files - thats cause u removed >"systems" access. Just give required permission to "system" on those files/directory > >>> - what type of system requirements (ie. memory, CPU) are needed on NT > >Well that depends on ur requirements. Try to configure ur NT box so that its >"dedicated" to the job of being a database server. U can find some notes on metalink >on this. Ensure that ur NT box does not double as a PDC (primary domain controller). > >Finally reboot machine as often as u can - I have found memory being allocated and >not being released. Keep LOTS of memory - I have seen the NT box freezing and >refusing connections when it no longer had memory to create a shadown process. (only >soln - crash boot the machine) >Further dont use "copy" command to do ur hotbackups - use the "ocopy" command instead. >Thats all I can think of now.. >regards, >~aslam >(PS: I had enough of NT - migrating to Solaris in a months time) > > >-Original Message- >From: Yttri, Lisa [SMTP:[EMAIL PROTECTED]] >Sent: Tuesday, June 26, 2001 1:46 AM >To:Multiple recipients of list ORACLE-L >Subject: Multiple Oracle Instances on NT > >Hi everyone - > >I have worked exclusively with Oracle on Unix, but not at all with Oracle on >NT. Our users have come to us with a requirement to run an application with >their database on NT. They want to build both a test and production >environment on the same NT box. > >I would like to know some "basics" about running Oracle on NT > - can you run multiple instances of Oracle on one NT machine > - if so, what do I need to look out for (ie. what things are different >that a Unix installation) > - are any of the processes, etc. drastically different - ie. security, >networking, logging > - what type of system requirements (ie. memory, CPU) are needed on NT > >Thanks for any help you can give me! >Lisa > << File: ATT00326.html >> Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
*1*: Where is RemoteORADBA?
Hi Don. This is Earl. Have we met? --- TheOracleDBA [EMAIL PROTECTED] On Sun, 01 Jul 2001 07:50:20 Don Dealy II wrote: >Anybody know the current web page or email address for Earl Shaffer and the company >RemoteOraDba? > >Thx - Don > > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.
And sub-partitioning --- TheOracleDBA [EMAIL PROTECTED] On Mon, 02 Jul 2001 11:40:23 Koivu, Lisa wrote: >Bunyamin, >Download Toad (www.toadsoft.com). It does it for you. THe only thing it >doesn't handle (from what I remember) is partitioning. > >HTH >Lisa Koivu >Data Bored Administrator >Ft. Lauderdale, FL, > >> -Original Message- >> From:Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]] >> Sent:Monday, July 02, 2001 1:46 PM >> To: Multiple recipients of list ORACLE-L >> Subject: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA. >> >> Hi Gurus, >> I do not have time to write it. >> IF you have a script creating >>the create table scripts of a schema, I will be so happy . >> Thanks >> Bunyamin > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: sys.aud$ info
Like editing SQL.BSQ or playing with a .dmp file. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Tue, 03 Jul 2001 11:23:07 JOE TESTA wrote: >for those of you haven't read the docs on auditing, oracle know says DONT move the >aud$ table to another other tablespace, it must remain in system so >upgrades/migrations, etc will work. they at least put a maxextents of 99 on it. I'm >not so sure that helps much. :) > > >joe > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: Locally managed tablespaces
I was pretty sure you could use it for any TS but SYSTEM. Is this documented? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Jul 2001 09:32:27 Hillman, Alex wrote: >You canuse any storage parameters you like but oracle will ignore them exept >for initial for LMT with autoallocate. I would personally do not use >autoallocate. Also you cannot use autoallocate for temporary tablespace and >shouldn't use it for rollback. > >Alex Hillman > >-Original Message- >Sent: Thursday, July 19, 2001 12:43 PM >To: Multiple recipients of list ORACLE-L > > >HPUX 11i 64 bit >Oracle 8.1.7.1 32 bit > >I am creating a new database and decided to go with locally managed >tablespaces. I was going to go with autoallocate because the best I can >tell the only possible drawback with this is a little wasted space. >However, I was under the impression that you could not specify a next in the >storage clause of a table creation. Yet you can. So what happens if I have >a next defined? Do they pretty much just throw that away or should I really >not define it? > > > > >Kimberly Smith >Database Administrator >IT Dept. - Fujitsu/GMD >Phone: (503) 669-6050 >Fax: (503) 669-5705 >Email : [EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kimberly Smith > 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: Hillman, Alex > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: The DBA in the IS organization
>>Author: O'Neill, Sean >> 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). > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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). > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
REP: writing to renamed Listener.log file
Actually, I just talked to Worldwide Support about this issue. They recommend using the set log_file command to rename the file to another file name ("templisten.log" for example)- for the life of the listener session. After that, you can reset/delete/purge the listener.log file safely. Then bounce the listener and it will begin writing to listener.log file again. LSNRCTL> help set log_file set|show log_{ } []: set|show log parameters of current listener On Tue, 29 May 2001 07:35:27 Christopher Spence wrote: >You should bounce the listener. > > >"Walking on water and developing software from a specification are easy if >both are frozen." > >Christopher R. Spence >Oracle DBA >Fuelspot > >-Original Message- >Sent: Thursday, May 24, 2001 2:58 PM >To: Multiple recipients of list ORACLE-L > > > >May I know how to clear the content of listener.log without restart listener >on NT platform ? > >thanks. >Li > > -Original Message- >Sent: Thursday, May 24, 2001 1:42 PM >To: Multiple recipients of list ORACLE-L > > Reload doesn't close/reopen the file. Here is a couple solutions > > How's about a fast cat/clear solution: > > #!/bin/ksh >cat listener.log >>listener.log.hist >ex listener.log <1,\$d >wq >EOF > > Or if you wish to purge 90% of the file: > > #!/bin/ksh >wc -l listener.log | read v_lines junk >v_keep=$(($((${v_lines} * 10)) / 100)) >v_purge=$((${v_lines} - ${v_keep})) >ex listener.log <1,${v_purge}d >wq >EOF > > > -Original Message- ><mailto:[EMAIL PROTECTED]> >] >Sent: Thursday, May 24, 2001 7:15 AM >To: Multiple recipients of list ORACLE-L > > > On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in >glitter crayon: > > ->Hi List, >->As a regular maintainance work,I have moved the listener.log file to >->listener.log.old >->and 'touch'ed the listener.log, expecting the logging into this new file. >->But I am observing the logging being done to listener.log.old, instead. >->I could not recall any such previous experience. >->FYI, I cannot do any 'experiments' as far as this system is concerned as I >->have to deal with >->desupported HP-UX(10.01), Oracle (7.2.2.3). >->I have my logging being done to default path($ORACLE_HOME/network/log), as >->no parameter settings in listener.ora. >->Has anybody experienced this? >-> >->TIA, >-> >->Suren >->Oracle DBA >->Sony Electronics Ltd. >-> >-> >The file handle listener is using is still pointed at the old file. To fix >this you need to stop and start the listener. This will not affect anybody >who is already connected. I'm not sure if a reload will do the same thing. > > -- >Bill Thater Certifiable ORACLE DBA >Telergy, Inc.[EMAIL PROTECTED] Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Rebuilding indexes
However, if you rebuild all the indexes for schema SALES on PRIMARY, what happens on STANDBY? Are they rebuilt? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 31 May 2001 08:16:06 Rachel Carmichael wrote: >there IS no way to do that with a standby database. Once you open it for >anything other than read-only (8i) you invalidate the standby status. > > > > >>From: Richard Huntley <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >>Subject: Rebuilding indexes >>Date: Thu, 31 May 2001 06:00:56 -0800 >> >>For those of you that have implemented a standby database, what method do >>you use to rebuild your indexes tablespace. >>My plan was to create a new tablespace and rebuild the indexes into the new >>tablespace and then reverse the process to move >>back to the original tablespace after I drop and recreate it in order to >>get >>rid of fragmentation in the originally indexes tablespace. >>However, creating the new datafile associated with the new tablespace, >>cancels media recovery associated with the standby database...just wondered >>if anyone has a better method of defragging an index tablespace when there >>is a standby database catching the redo it generates. >> >>TIA, >>Richard Huntley >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Richard Huntley >> 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). > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: Fire your DBA's you don't need them anymore...
I need to find the article I had saved about Oracle 6.0 (as we were preparing to upgrade from 5.1). It was something about how the 6.0 DBA would be bored and would now be able to help appdev. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Fri, 25 May 2001 09:28:53 Vergara, Michael (TEM) wrote: >I can remember as far back as version 7.3 where Oracle was touting that >"you won't need a DBA for our new database". It hasn't happened yet, >has it? Oh yes, it's easier, but we're still here! > >And besides, what were they offering in the cold call? Replacing your >DBAs with their DBAs. At (probably) twice the price. Outsourcing Lives! > >Just my $0.02 worth. > >Mike > >--- >=== >Michael P. Vergara | I've got a PBS mind in an MTV world >Oracle DBA | >Guidant Corporation | > >-Original Message- >Sent: Friday, May 25, 2001 9:27 AM >To: Multiple recipients of list ORACLE-L > > >Very stupid thing to do by Oracle, considering the fact that many Oracle >purchasing decisions are made by Oracle DBAs. To shut us out like that will >most certainly have an effect on Oracle Sales. Hell, you don't need me >anymore? I'll switch political sides and jump the ship to IBM, or >Microsoft... > >Far as their "superior" i-dba team, I sure hope those are different people >from the ones you get on first line of Support... > >Gary Weber > >PS. Or maybe we should all become Oracle salesmen (saleswomen) > >-Original Message- >Sent: Friday, May 25, 2001 12:02 PM >To: Multiple recipients of list ORACLE-L > > > >My boss just received a cold call from Oracle that he let me listen in on. >They have a new push on for their i-dba support package. For just a little >more money (they did not define little), "we will replace your dba's with >our superior support team that will monitor your database 24x7 and >proactively eliminate problems. This will allow you to redesign you office >to offload these cumbersome DBA tasks and allow your workers to do other >things. You will never have another database problem." I felt good when >my boss indicated that we had no base problems but based on this, I guess we >will have to become sqlserver DBAs or developers...:) > >Ahh, Friday, wonderful Friday, it seems like you've been away all week... > >--Chris >[EMAIL PROTECTED] > > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
1 - Anyone see corruption after a TRUNCATE PARTITION?
My client truncates large partitions in 816 and 805 Solaris. Sometimes they get PL/SQL block corruption reported errors after this. Dropping and re-creating the partition does not have any problems. The partitions are 2 to 10G. Anyone see this? Cheers, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Hey MetaLink... Got RAM?
fixed as of 10:23am EST. --- TheOracleDBA [EMAIL PROTECTED] On Thu, 14 Jun 2001 07:23:17 Orr, Steve wrote: >Here's what I just got logging in to MetaLink... > >Thu, 14 Jun 2001 14:12:33 GMT > >ORA-04031: unable to allocate 2550012 bytes of shared memory ("large >pool","unknown object","session heap","bind var buf") > > DAD name: plsql > PROCEDURE : per_hom.startup > USER : mrorracle > URL: http://metalink.oracle.com:80/metalink/plsql/per_hom.startup > PARAMETERS : > > > ENVIRONMENT: > >PLSQL_GATEWAY=WebDb >GATEWAY_IVERSION=2 >SERVER_SOFTWARE=Oracle HTTP Server Powered by Apache/1.3.12 (Unix) >ApacheJServ/1.1 mod_perl/1.24 >GATEWAY_INTERFACE=CGI/1.1 >SERVER_PORT=80 >SERVER_NAME=metalink.oracle.com >REQUEST_METHOD=GET >QUERY_STRING= >PATH_INFO=/metalink/plsql/per_hom.startup >SCRIPT_NAME=/metalink >REMOTE_HOST= >REMOTE_ADDR=12.110.24.85 >SERVER_PROTOCOL=HTTP/1.1 >REQUEST_PROTOCOL=HTTP >REMOTE_USER= >HTTP_CONTENT_LENGTH= >HTTP_CONTENT_TYPE= >HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) >HTTP_HOST=metalink.oracle.com >HTTP_ACCEPT=*/* >HTTP_ACCEPT_ENCODING=gzip, deflate >HTTP_ACCEPT_LANGUAGE=en-us >HTTP_ACCEPT_CHARSET= >HTTP_IF_MODIFIED_SINCE= >HTTP_REFERER=http://metalink.oracle.com/metalink/plsql/ml2_gui.startup > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Orr, Steve > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
RE: Space Manager vs. Live ReOrg vs TS ReOrg
I agree with Kevin. I always use hand-made scripts. There is a risk with any 3rd party tool. There are version issues, patches, OS issues, etc. Scripts, on the other hand, can be customized to do the exact amount of work at the exact time you want it done. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Fri, 15 Jun 2001 09:46:06 Kevin Lange wrote: >I agree with Jesse. > >Although Live Reorg would be a great tool, it was extremely COST INTENSIVE. >I would love to be able to reorg tables with essentially no down time but, >so far, the cost does not outweigh the benefit. > >The nice thing with Space Manager is that it will create your DB scripts for >you and then you can save them and re-use them the next itme those >tables needed reorg. Even if you no longer have Space Manager. Either >that, or you can let Space Manager schedule and run them for you in off >hours. > >Of course, my personal favorite is the standard DBA Set of Scripts that you >run on your scheduled maintenance days. We get what we can done ... and the >rest, until such time as the on-line reorg software is cost effective, waits >for the next window. > >Kevin > >>>Bottom Line: >>> Space Manager: Cheap, but needs downtime. >>> Live Reorg: Expensive, but no real downtime. >>> TS Reorg: Now owned by CA, so I probably won't even look at it. :) > > >-Original Message- >Sent: Friday, June 15, 2001 12:33 PM >To: Multiple recipients of list ORACLE-L > > >Space Manager is an "offline" tool -- It creates a script that will create a >new table, populate it, and replace the old table with it, and during this >time the table is not accessible. > >Live Reorg only has a "very short" window where the table is locked -- Quest >says a few seconds -- while the table is reorg'd. And, while I haven't used >it, I'm guessing that Live Reorg will not invalidate objects (like triggers) >that have a dependency on the table being reorg'd, unlike Space Manager's >brute force method. > >Space Manager 3 is OK. v4 should be much nicer once it's out of beta (read: >more stable). There are enough major bugs in v4 (easy to reorg a 500K index >to a 500M index) that I'm going to wait for an "official" version. :) > >Bottom Line: > Space Manager: Cheap, but needs downtime. > Live Reorg: Expensive, but no real downtime. > TS Reorg: Now owned by CA, so I probably won't even look at it. :) > >Good luck! >Rich Jesse System/Database Administrator >[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > >-Original Message- >Sent: Friday, June 15, 2001 12:11 >To: Multiple recipients of list ORACLE-L > > >Sun Sparc Solaris 2.6/8 >Oracle DB 8.0.6, 8.0.5 >Oracle Apps 11.0.3 > >My client and I are currently planning on re-orging some of our database - >say about 90G out of a 120G database (2 schemas). We've identified 3 >tools and are seeking feedback on the pros/cons of each option. > > > >anyone? > >Also, can anyone explain the difference between Space Manager and Live >ReOrg? Both are marketed by Quest, making me wonder what, if anything, is >the difference... > >TIA > >J >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jesse, Rich > 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: Kevin Lange > 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). > Get 250 color business cards for FREE! http
RE: Oracle training vs IOUG-A vs ECO
Last time I went to the ECO site, it looked closed. Are they still around? --- TheOracleDBA [EMAIL PROTECTED] On Thu, 29 Mar 2001 10:16:14 Jefferson, Dean wrote: >Check the IOUG-A sessions again. The presenters from Oracle were added >later, after IOUG and Oracle Corp. reached a new "understanding". I looked >at the sessions this morning and there are now Oracle presenters in the mix. > >Dean Jefferson >Database Administrator >State of Wisconsin >Office of Commissioner of Insurance >[EMAIL PROTECTED] > >> -Original Message- >> From: Sarah Satterthwaite [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, March 29, 2001 10:06 AM >> To: Multiple recipients of list ORACLE-L >> Subject: Oracle training vs IOUG-A vs ECO >> >> (snip) >> Which was the better conference--ECO or IOUG-A--and why? >> Perhaps I should be including Oracle Open World in the list >> also. In the past I have heard complaints about overcrowding >> at IOUG-A, is this still a big problem? >> >> In reading the IOUG-A program that came the other day, I >> could not find a single presenter from Oracle Corporation. >> Does Oracle no longer permit its people to present or is >> IOUG-A now excluding them? Where are the Oracle people >> presenting these days? I have been to some dynamite >> presentations by Oracle people in the past. >> >> Thanks, >> >> Sarah Satterthwaite >> Oracle DBA >> Case Shiller Weiss, Inc >> Cambridge, MA >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jefferson, Dean > 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). > Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Rollback segments not shrinking
What are the sizes init/next and what is OPTIMAL set at? --- TheOracleDBA [EMAIL PROTECTED] On Thu, 05 Apr 2001 09:16:17 Nicoll, Iain (metering) wrote: >Can anyone tell me why we would get "unable to extend" errors in rollback >but the segments will shrink when done manually - I thought that rollback >segments would shrink when not used if another rollback segment needed the >extents. > >We're way back on 7.3.4 on Solaris. > >Cheers > >Iain Nicoll >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Nicoll, Iain (metering) > 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). > Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
REP: Locally Managed Tablespaces
Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Thanks, --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Apr 2001 15:25:31 Peter Barnett wrote: >We are using LMTs with several of our databases. No problems. With these >databases we are also running large file systems. Although our OS imposes >a theoretical limit of 31.G, we have kept our datafiles to 20G or >less. Again, no problems. > > >Pete Barnett >Oracle Database Administrator >Regence BlueCross BlueShield >[EMAIL PROTECTED] > > >On Tue, 17 Apr 2001, Patricia Ashe wrote: > >> >> I am interested in some statistics on Oracle locally managed tablespaces. I >> have been looking for any bugs or negative info about them. Are they in use >> at alot of sites? Seems like all the information I have come across is >> positive. Which is great! But maybe they aren't being used at alot of >> sites. Can I hear about experiences from others on this list? how many >> sites are actually using them? >> I have several databases that I am getting ready to go production soon and >> would like to create the tablespaces as locally managed, but need more >> statistics. >> >> PA >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Patricia Ashe >> 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: Peter Barnett > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
News flash - IBM buys Informix
It has been announced today that IBM has purchased Informix. See your local tech news service later today for details. H. Wonder what Larry thinks about this? Cheers, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: REP: Locally Managed Tablespaces
A couple of threads here and in other lists have mentioned this. A person puts LMTSs up and sets uniform extents on and sets it to, say 1M. Later they notice that not all extents are 1M. Thanks, Earl --- TheOracleDBA [EMAIL PROTECTED] On Mon, 23 Apr 2001 11:01:37 Jared Still wrote: >On Monday 23 April 2001 11:40, The Oracle DBA wrote: >> Are you using uniform extents? We are told they are not really = and >> actually are not the same at all over time. >> > >Do you have a source for this information? A number of us have been >using LMT's with uniform extents, and have not seen that. > >Jared >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Anyone at Live 2001 - is 9i available?
Just wondering if they announced 9i. Hoping they are giving out CDs too :-) Cheers, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Need oracle patch 8.1.7.1.1
I guess you are not on NT because the .1.1 patch is there. The std procedure for 817 is to install 817, patch it to .1.1 then .1.2. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Fri, 04 May 2001 10:31:23 Shaw, John B wrote: >I just downloaded patch 8.1.7.1.2 from metalink - >in the readme (yes I actually read it before installing ) it states that >the earliest version that this patch may be applied to is >8.1.7.1.1 - I can't find this patch on metalink >anybody know where I can get it? > > > . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. >John B. Shaw >Intergraph Public Safety >mailstop LR24A4 >[EMAIL PROTECTED] >256-730-8038 >All the usual disclaimers and some of the certifications > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Shaw, John B > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Real-life Stand-by DB implementation stories?
Anyone implemented SBDBs recenetly? A client is comparing them to a cluster solution involving Fail-Safe. We are recommending SBDB and trying to go to 817 also (on 80521 now). Also this is NT if that makes a difference. Thanks, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Re: Locally managed tablespaces
Has anyone taken a PROD DB and changed it to using LMTSs and then noticed a perf change + or -? --- TheOracleDBA [EMAIL PROTECTED] On Tue, 30 Jan 2001 10:30:29 Bunyamin K.Karadeniz wrote: > But some had claimed that Locally managed tablespaces are slower. I do >not know if it is correct but you must consider it . > And I wonder the performance results too. >- Original Message - >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Sent: Tuesday, January 30, 2001 3:35 PM > > >> I have always been concerned with fragmentation of tablespaces, whether it >> be lots of extents, honeycomb or >> bubble fragmentation. Now I am reading that in Oracle 8i with the use of >> locally-managed table spaces, >> these concerns are a thing of the past as Oracle now uses bit maps within >> the tablespaces themselves to >> do space management. This seems foreign to me that even though Oracle will >> use up all the space in >> the tablespaces with no coalescing, it is OK that extents will go into >the >> thousands with no performance degradation. >> Could folks who are currently using locally managed tablespaces please >> comment on how well it >> is working for them and if they have experienced any problems in using >them. >> Thanks >> Skip >> Here is a good white paper on the subject. >> http://www.embarcadero.com/news/white_papers.htm >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Malkuns, Skip >> 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: Bunyamin K.Karadeniz > 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). > Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
(F) Any way to tell if a DB is OPS?
Is there a query that will say if a DB is an Oracle Parallel Server instance? I have never, but if you install OPS during install, does that make a 'mark' for DBs re: OPS? Thanks. Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).
Anyone used Fail Safe for NT?
Anyone use Oracle Fail Safe for NT? Compaq just finished a tech/mkt presentation and made it seem oh so easy (for the right $). I am wondering if anyone has done it and in a multi DB env. Cheers, Earl Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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).