Re: Linking during instllations
I don't know if anyone has implied that it *was* unnecessary for Windows; it's just not done. But hard lessons have proved it necessary on UNIX; it's not only Oracle that does this... ...as Freud is reported to have said, "Sometimes a cigar is just a cigar"... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, August 17, 2002 8:53 PM > I do not understand? > > Why is this unecessary on the Windows platform? > > Thanks for any input. > > ltiu > > On Saturday 17 August 2002 18:43, Ray Stell wrote: > > Note:131321.1 > > > > Relinking Oracle > > > > > > Background: > > Applications for UNIX are generally not distributed as complete > > executables. Oracle, like many application vendors who create products for > > UNIX, distribute individual object files, library archives of object files, > > and some source files which then get relinked at the operating system > > level during installation to create usable executables. This guarantees a > > reliable integration with functions provided by the OS system libraries. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > 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: Tim Gorman 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).
Raw devices and redo
Hi, please give your opinion. I am reading Jonathan Lewis book Practical Oracle 8i. He says redo log definitly should be placed on raw devices. On the other hand I have a couple of years old document by Oracle stating redo logs definitly do not belong on raw devices. So who is right? Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Antje Sackwitz 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: DBA tools on NT - PERL
Title: RE: DBA tools on NT - PERL I am going to buy Jared book. He wrote to me that the book is currently available on Amazon. You can use www.perl.com to supplement tour needs. Yechiel AdarMehish - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Friday, August 16, 2002 7:53 PM Subject: RE: DBA tools on NT - PERL > -Original Message- > From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] > > I'm not responding to any single message here but a few general > comments about perl. All right already! I'll quit using C/gcc and start using Perl! Is this the first book I need? Learning Perl, 3rd Edition Making Easy Things Easy and Hard Things Possible By Randal L. Schwartz, Tom Phoenix 3rd Edition July 2001 0-596-00132-0, Order Number: 1320 http://www.oreilly.com/catalog/lperl3/
Re: Amount of redo
I sit corrected. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 4:43 PM > yechiel, > > I didn't miss the comment, it's not relevant. Archived logs are merely > copies of redo logs that have been filled. Whether or not archiving is > turned on, redo logs get filled and reused. Oracle tracks the log > switches no matter what mode you are in, it just doesn't make the copy > of the redo log if you aren't in archive log mode. > > So he can definitely track log switches in the alert log or in > v$log_history. Given the number of switches in a week (this is > approximately the number of archived logs that will be created), he can > multiply that by the size of his largest redo log (hopefully they are > all the same size but take the largest one if they are not). That will > give him the maximum amount of space his archived logs will take in a > normal week, barring any unusual load activity. > > Now archived logs generally are NOT the full size of the redo logs > so this will overestimate. But it's better to have too much space than > too little > > Rachel > --- Yechiel Adar <[EMAIL PROTECTED]> wrote: > > Hello > > > > I do not think that you can estimate the amount of disk space > > required for > > archive log without turning archive log on and checking each day to > > see how > > much space you already used. > > > > To all who replied: I think that you missed his comment that > > currently he is > > NOT working with archive log on. > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent: Wednesday, August 14, 2002 2:08 PM > > > > > > > > Hi List, > > > > I want to put my databse in archive mode(Presently it is non archive > > mode).I want to estimate > > space that will be required for archive log taking we will be keeping > > one week archive on disk. How can i find out amount of redo generated > > in > > a week. > > > > Regards > > Pawan Dalmia > > Extn -5259 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Pawan Dalmia > > 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: Yechiel Adar > > 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!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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: Data Warehouse on Windows
Hello Antje Pay close attention to the type of windows version they install on the server. I got into a situation where I wanted to use 3GB for Oracle and it turns out that we have the standard NT edition instead of Enterprise edition and a single process is limited to use 2GB memory. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 3:58 PM > Hi, > I was asked to give some hint for the hardware for a data warheouse running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large tables. Users <20. Probably > long running queries. > Which hardware would you use? How many processors? Which disks? > The os-system is set and cannot be Unix/Linux according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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: Yechiel Adar 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: init.ora processes ??
Another thing to consider is this: >From OraPerf: The LGWR needs to scan all processes to find each process that is waiting for the commit to be written. So when you have an excess of process LGWR works harder. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 8:43 PM > How about with Microsoft Windows NT ? > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > For each process 'reserved' by oracle, there is a > > small amount of space > > allocated in the SGA and a semaphore is reserved at > > the O/S level (assuming > > UNIX). A lesser number of processes will allocate a > > slightly smaller amount > > of SGA and fewer semaphores. Until a session is > > started, no other memory is > > allocated. > > > > Dan Fink > > > > -Original Message- > > Sent: Friday, August 16, 2002 10:44 AM > > To: Multiple recipients of list ORACLE-L > > > > > > All, > > > > What is the impact of "processes" init.ora parameter > > other than restricting number of user sessions ? I > > know it needs more memory (like stack size + sort > > area > > size + etc. ) whenever it gets new connection. > > > > My question is: > > Is there any additional resource (does it take more > > memory? ) usage if I start database with 100 > > processes > > versus 200 processes as init.ora parameter (assuming > > that I have same number of sessions in both cases). > > > > Thanks for your help. > > > > Bob > > > > __ > > Do You Yahoo!? > > HotJobs - Search Thousands of New Jobs > > http://www.hotjobs.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Bob Robert > > 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: Fink, Dan > > 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!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bob Robert > 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: Yechiel Adar 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: Raw devices and redo
I'm sure that each source is accompanied by some type of explanation? Surely neither would make such a bald sweeping statement without some substantiation? I would agree with your summarization of Mr. Lewis's position. The type of I/O activity associated with online redo log files (i.e. high volumes of sequential write I/O) suggests an unbuffered type of file. Storing the data written by LGWR in any form of a file-system buffer-cache (which is characteristic of most file-systems) would be a waste of time and processing. Caching is associated with things which you want to write once and then read many, many times. This is not the case with redo data written down by LGWR. At best, it will be read only once more (by the ARCH process), and certainly not in a timely-enough fashion as to justify buffering it... As the name suggests, "raw" devices (a.k.a "logical volumes") are just that -- an unmanaged, unbuffered, "raw" access to the underlying I/O subsystem. There are also file-systems with which the caching can be turned off (i.e. DEC/Compaq/HP AdvFS, etc), so like any simple sweeping statement, the real answer is more complicated, but in general Mr. Lewis's statements are certainly more correct than the other mystery document. Please consider the possibility also that you may have misunderstood the message in the "couple years old document by Oracle", because the interpretation you stated is so far from correct... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, August 18, 2002 2:23 AM > Hi, > please give your opinion. > I am reading Jonathan Lewis book Practical Oracle 8i. > He says redo log definitly should be placed on raw devices. > On the other hand I have a couple of years old document by Oracle > stating redo logs definitly do not belong on raw devices. > So who is right? > Antje Sackwitz > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Antje Sackwitz > 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: Tim Gorman 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: ORA-12500 TNS:listener failed -- Intermittent
Hello Bob We had the same thing an it was because the current connections + oracle SGA used up to 2GB limit of memory available for oracle on NT. The solution for us was to lower the size of the block_buffers so the SGA used less memory. The solution that Chaim talks about works only on NT Enterprise version. We are on standard version so it did not worked for us. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 11:58 PM > Gurus, > > Oracle Version: 8.0.4 (I know we are way behind) > OS: Windows NT (Service Pack 6) > Physical Memory: 1.5 GB > Virtual Memory: 1.5 GB > > Once in every week, we get "TNS-12500 TNS:listener > failed to start a dedicated server process". When I > check listener process, it was running. When I check > number of sessions, it was always below number > processes (setup by init.ora file). Whenever we get > this error message, one out of fifteen sessions get > successful connection. When we check system resources, > we had enough free memory in the system.If we try to > stop listener process and restart again, it works for > a while (may be 30 Min.). We couldn't find any error > messages both in alert log file as well as OS event > log. > > Only solution, we had right now is to reboot the NT > server in the middle of production time. Users are > getting frustrated whenever we reboot the server. > > I think upgrading database to 8i or 9i would help our > problem. But, we are not in a position to do so. > > I think there might be memory leakage which we could > not see from the OS Task Manager. > > Did any one come across similar kind of problem. I > would appreciate if you could share your experience > with me. > > Thanks, > Bob > > > > > > > > __ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bob Robert > 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: Yechiel Adar 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).
how to force a log switch
Dear gurus ! It's either a Sunday's dead brain or .. Is there an init.ora parameter to force redo logs switch every 3 minutes or so ? ( the reason is that I need frequent log switches in order for the standby database to pickup changes frequently , i.e. to be "almost" in sync with the primary DB. And, off course, issuing "alter system switch logfile" in the application is not feasible ) Now, i only found parameters related to the frequency of the CHECKPOINTs and not log switches. Any help , please ... DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- 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).
Re: SAN
The ADABAS/Natural/Predict list server that I know about: http://www.uark.edu/sag-l/faq.html You can also contact me directly and I will help if I can. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 6:03 PM > > So if I get a problem with my Mainframe Adabas databases Natural or Predict > environments where do I post? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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: how to force a log switch
Ron , thanks a lot ! I know this solution , but: there are certain pick-times when there are many activities going on against the DB. Therefore making the redo logs smaller will cause performance problems. So , i'd have this solution as a last resort, in case i will not find an init.ora solution. Thanks again ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Sunday, August 18, 2002 3:14 PM To: 'Andrey Bronfin'; 'LazyDBA.com Discussion' The answer pretty simple - change the size of your logs. Log switching is a function of transaction volume. The fewer the transactions, the fewer the log switches. Consider that logs only switch when they are filled (or manually). So ,if there are insufficient transactions to fill your logs in 3 minutes, make your logs smaller. If your logs are switching every 10 minutes now, then create new logs that are 1/3 the size. Having said all that, the other thing you could do is create a dbms_job that runs every three minutes and forces a log switch. It's not as pretty as right-sizing your logs, but it works. R/ Ron Gawer -Original Message- Sent: Sunday, August 18, 2002 10:03 AM To: LazyDBA.com Discussion Dear gurus ! It's either a Sunday's dead brain or .. Is there an init.ora parameter to force redo logs switch every 3 minutes or so ? ( the reason is that I need frequent log switches in order for the standby database to pickup changes frequently , i.e. to be "almost" in sync with the primary DB. And, off course, issuing "alter system switch logfile" in the application is not feasible ) Now, i only found parameters related to the frequency of the CHECKPOINTs and not log switches. Any help , please ... DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- 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).
Re: how to force a log switch
Andrey, I assume, version < 9.x of the database?(if i'm wrong let me know and we can talk about 9i features of data guard). How about a job(via dbms_job) to do what you want? joe Andrey Bronfin wrote: >Dear gurus ! >It's either a Sunday's dead brain or .. >Is there an init.ora parameter to force redo logs switch every 3 minutes or >so ? >( the reason is that I need frequent log switches in order for the standby >database to pickup changes frequently , i.e. to be "almost" in sync with the >primary DB. And, off course, issuing "alter system switch logfile" in the >application is not feasible ) >Now, i only found parameters related to the frequency of the CHECKPOINTs and >not log switches. >Any help , please ... > > >DBAndrey > >* 03-9254520 >* 058-548133 >* mailto:[EMAIL PROTECTED] > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: how to force a log switch
I am not sure if 9i has introduced any such parameter. Other than sizing smaller redo log files [but that still doesn't guarantee that you get a log-switch every X minutes], you'd have to write a DBMS_JOB or a CRON job to do an ALTER SYSTEM SWITCH LOGFILE. Hemant At 06:08 AM 18-08-02 -0800, you wrote: >Dear gurus ! >It's either a Sunday's dead brain or .. >Is there an init.ora parameter to force redo logs switch every 3 minutes or >so ? >( the reason is that I need frequent log switches in order for the standby >database to pickup changes frequently , i.e. to be "almost" in sync with the >primary DB. And, off course, issuing "alter system switch logfile" in the >application is not feasible ) >Now, i only found parameters related to the frequency of the CHECKPOINTs and >not log switches. >Any help , please ... > > >DBAndrey > >* 03-9254520 >* 058-548133 >* mailto:[EMAIL PROTECTED] > > > > >-- >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). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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).
Oracle Linking
There is apparently two stages to the Oracle installation on Unix. A file copying installation where all the required binaries are copied from cdrom to hard disk and a linking install where the binary/object files are linked. If the first stage succeeds but the second stage does not. How do I start the linking install without having to go through the first stage copying install again? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 Linking
If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, what could be the possible reasons for this? Thanks. ltiu On Sunday 18 August 2002 10:18, ltiu wrote: > There is apparently two stages to the Oracle installation on Unix. A file > copying installation where all the required binaries are copied from cdrom > to hard disk and a linking install where the binary/object files are > linked. > > If the first stage succeeds but the second stage does not. How do I start > the linking install without having to go through the first stage copying > install again? > > Thanks. > > ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: how to force a log switch
Oracle9i hasn't introduced such a parameter; the best way to achieve what you want below 9i is to resize redo logs to be smaller (which several replies have already mentioned)... With 9i Data Guard, you have options where you can set LGWR to ship redo log files to the standby, and there is even a mode where redo records (especially COMMIT markers) must be shipped and applied to the standby before LGWR considers a COMMIT on the primary to be complete. In all, there are four basic options with 9i Data Guard: * LGWR synchronously ships redo records to standby and standby applies redo before transaction considered complete * LGWR ships redo records to standby before transaction considered complete (standby can apply records at a later time) * ARCH ships redo log files to standby and standby applies redo immediately * ARCH ships redo log files to standby and standby applies redo at a later time The first two options come only with 9i Data Guard in 9i EE; the third option came available with 8i EE (i.e. automated standby management), and the fourth option has been around (unofficially) since Oracle v6 and officially as a supported product since v7.3 (i.e. original standby database option) and is still the only option for 8i/9i SE... As you can imagine, there are obvious advantages and disadvantages in cost, performance, availability, and complexity to each mode. But one cool thing about the first option is that 9i Data Guard can "switch identities" of the primary and standby (i.e. swap standby into primary role and primary into standby role) almost instantaneously using the ALTER DATABASE SWITCH IDENTITY commands. It's another way of achieving the same high-availability goals as RAC/OPS in an "active/passive" arrangement. In this sense, the 9i Data Guard product is very much in competition with the 9iRAC product. It will be interesting to see how this competition plays out, both within Oracle as well as amongst customers... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, August 18, 2002 9:43 AM > > I am not sure if 9i has introduced any such parameter. > Other than sizing smaller redo log files [but that still doesn't guarantee > that you get a log-switch every X minutes], you'd have to write > a DBMS_JOB or a CRON job to do an ALTER SYSTEM SWITCH LOGFILE. > > Hemant > At 06:08 AM 18-08-02 -0800, you wrote: > >Dear gurus ! > >It's either a Sunday's dead brain or .. > >Is there an init.ora parameter to force redo logs switch every 3 minutes or > >so ? > >( the reason is that I need frequent log switches in order for the standby > >database to pickup changes frequently , i.e. to be "almost" in sync with the > >primary DB. And, off course, issuing "alter system switch logfile" in the > >application is not feasible ) > >Now, i only found parameters related to the frequency of the CHECKPOINTs and > >not log switches. > >Any help , please ... > > > > > >DBAndrey > > > >* 03-9254520 > >* 058-548133 > >* mailto:[EMAIL PROTECTED] > > > > > > > > > >-- > >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). > > Hemant K Chitale > Now using Eudora Email. Try it ! > > My home page is : http://hkchital.tripod.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hemant K Chitale > 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: Tim Gorman 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
Re: Oracle Linking
The error message in the "install.log" or "make.log" files should narrow your choices down, but in general... Underneath "$ORACLE_HOME" there are several ".mk" files, which are scripts for the venerable UNIX "make" command. To find them, you can run the UNIX "find" command as follows: $ find $ORACLE_HOME -name "*.mk" -print Within each product subdirectory under "$ORACLE_HOME" where a "lib" subdirectory exists, there will usually be two ".mk" files: one prefixed with "env_" and another prefixed with "ins_". For example, under the "$ORACLE_HOME/rdbms" subdirectory, you'll find a "lib" subdirectory in which resides an "env_rdbms.mk" file and an "ins_rdbms.mk" file. The "ins_*.mk" script is the one you're interested in; it references "make" script settings in the "env_*.mk" script, so in the end you're using both scripts anyway, but the "ins_*.mk" script is the "top-level" one... Within a "make" script there are "targets" defined, which describe how to compile (if necessary! not always necessary) and link an executable. Generally, Oracle defines an overall target called "install" to compile/link/install all executed defined within, or it defines targets for each specific executable (i.e. target "ioracle" performs compiles, links, and file-movement for installation of the "oracle executable with the "ins_rdbms.mk" script, etc). To call make from the UNIX command-line to compile, link, and install a new "oracle" executable, you'd run the following commands: $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk ioracle If you were just going to "shotgun" both of the executables defined as part of the "network" product for the server-side, you'd run something like: $ cd $ORACLE_HOME/network/lib $ make -f ins_net_server.mk install ...and "make" would compile/link/install the "tnslsnr" and the "lsnrctl" executables... The error messages you see from the "link phase" of Oracle software installation in the "install.log" or "make.log" scripts come from these "make -f ..." commands. Check the log files to find out exactly what failed -- using the "shotgun" method can take a lot of time... :-) Hope this helps... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, August 18, 2002 11:18 AM > There is apparently two stages to the Oracle installation on Unix. A file > copying installation where all the required binaries are copied from cdrom to > hard disk and a linking install where the binary/object files are linked. > > If the first stage succeeds but the second stage does not. How do I start the > linking install without having to go through the first stage copying install > again? > > Thanks. > > ltiu > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > 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: Tim Gorman 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 Linking
"genclntsh" is a UNIX shell script run by the Oracle installer, so you can debug it like you would any shell script. It is located in "$ORACLE_HOME/bin", so go to that directory while logged in as the Oracle software owner in UNIX and simply run the script. Maybe it will duplicate the problem you're observing; maybe not... If you edit/view the script file, you'll see a "set -x" command near the top, which is commented out by default. Un-comment it and the shell will output each shell command as it executes -- should help pinpoint where the problem is occuring and may even pinpoint what the problem is... Hope this helps... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, August 18, 2002 12:18 PM > If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, > what could be the possible reasons for this? > > Thanks. > > ltiu > > On Sunday 18 August 2002 10:18, ltiu wrote: > > There is apparently two stages to the Oracle installation on Unix. A file > > copying installation where all the required binaries are copied from cdrom > > to hard disk and a linking install where the binary/object files are > > linked. > > > > If the first stage succeeds but the second stage does not. How do I start > > the linking install without having to go through the first stage copying > > install again? > > > > Thanks. > > > > ltiu > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > 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: Tim Gorman 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 Linking
Huge symbol tables, slow PCI 133 RAM, insufficient L2 cache, weak CPU, an enormous library that you're trying to produce. On 2002.08.18 14:18 ltiu wrote: > If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, > what could be the possible reasons for this? > > Thanks. > > ltiu > > On Sunday 18 August 2002 10:18, ltiu wrote: > > There is apparently two stages to the Oracle installation on Unix. A file > > copying installation where all the required binaries are copied from cdrom > > to hard disk and a linking install where the binary/object files are > > linked. > > > > If the first stage succeeds but the second stage does not. How do I start > > the linking install without having to go through the first stage copying > > install again? > > > > Thanks. > > > > ltiu > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > 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). > -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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 Linking
Thank you very much for your informative little tutorial. I appreciate it a lot. I will give it a shot. Thanks. ltiu On Sunday 18 August 2002 12:03, you wrote: > The error message in the "install.log" or "make.log" files should narrow > your choices down, but in general... > > Underneath "$ORACLE_HOME" there are several ".mk" files, which are scripts > for the venerable UNIX "make" command. To find them, you can run the UNIX > "find" command as follows: > > $ find $ORACLE_HOME -name "*.mk" -print > > Within each product subdirectory under "$ORACLE_HOME" where a "lib" > subdirectory exists, there will usually be two ".mk" files: one prefixed > with "env_" and another prefixed with "ins_". For example, under the > "$ORACLE_HOME/rdbms" subdirectory, you'll find a "lib" subdirectory in > which resides an "env_rdbms.mk" file and an "ins_rdbms.mk" file. The > "ins_*.mk" script is the one you're interested in; it references "make" > script settings in the "env_*.mk" script, so in the end you're using both > scripts anyway, but the "ins_*.mk" script is the "top-level" one... > > Within a "make" script there are "targets" defined, which describe how to > compile (if necessary! not always necessary) and link an executable. > Generally, Oracle defines an overall target called "install" to > compile/link/install all executed defined within, or it defines targets for > each specific executable (i.e. target "ioracle" performs compiles, links, > and file-movement for installation of the "oracle executable with the > "ins_rdbms.mk" script, etc). > > To call make from the UNIX command-line to compile, link, and install a new > "oracle" executable, you'd run the following commands: > > $ cd $ORACLE_HOME/rdbms/lib > $ make -f ins_rdbms.mk ioracle > > If you were just going to "shotgun" both of the executables defined as part > of the "network" product for the server-side, you'd run something like: > > $ cd $ORACLE_HOME/network/lib > $ make -f ins_net_server.mk install > > ...and "make" would compile/link/install the "tnslsnr" and the "lsnrctl" > executables... > > The error messages you see from the "link phase" of Oracle software > installation in the "install.log" or "make.log" scripts come from these > "make -f ..." commands. Check the log files to find out exactly what > failed -- using the "shotgun" method can take a lot of time... :-) > > Hope this helps... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, August 18, 2002 11:18 AM > > > There is apparently two stages to the Oracle installation on Unix. A file > > copying installation where all the required binaries are copied from > > cdrom > > to > > > hard disk and a linking install where the binary/object files are linked. > > > > If the first stage succeeds but the second stage does not. How do I start > > the > > > linking install without having to go through the first stage copying > > install > > > again? > > > > Thanks. > > > > ltiu > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: ltiu > > 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: ltiu 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 Linking
Thanks. On Sunday 18 August 2002 12:23, you wrote: > "genclntsh" is a UNIX shell script run by the Oracle installer, so you can > debug it like you would any shell script. It is located in > "$ORACLE_HOME/bin", so go to that directory while logged in as the Oracle > software owner in UNIX and simply run the script. Maybe it will duplicate > the problem you're observing; maybe not... > > If you edit/view the script file, you'll see a "set -x" command near the > top, which is commented out by default. Un-comment it and the shell will > output each shell command as it executes -- should help pinpoint where the > problem is occuring and may even pinpoint what the problem is... > > Hope this helps... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 Linking
Thanks. On Sunday 18 August 2002 12:03, you wrote: > Huge symbol tables, slow PCI 133 RAM, insufficient L2 cache, weak CPU, > an enormous library that you're trying to produce. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 Linking
Don't forget about the relink script in $ORACLE_HOME/bin. This is new starting with 8.1.7 (I think). >From the script... #!/bin/sh # #NAME # relink # #DESCRIPTION # performs manual relinking of Oracle product executables based # on what has been installed in the ORACLE_HOME. # script calls appropriate makefile targets for the following # accepted script parameters: # all -- everything which has been installed # oracle -- oracle database executable only # network -- net_client, net_server, cman, names # client -- net_client, otrace, plsql # client_sharedlib # interMedia -- ctx # precomp -- all precompilers which have been installed # utilities -- utilities # oemagent -- oemagent, odg # Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/18/02 11:18 AMcc: Please respond toSubject: Re: Oracle Linking ORACLE-L If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, what could be the possible reasons for this? Thanks. ltiu On Sunday 18 August 2002 10:18, ltiu wrote: > There is apparently two stages to the Oracle installation on Unix. A file > copying installation where all the required binaries are copied from cdrom > to hard disk and a linking install where the binary/object files are > linked. > > If the first stage succeeds but the second stage does not. How do I start > the linking install without having to go through the first stage copying > install again? > > Thanks. > > ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: Ron Thomas 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 Linking
Thanks. On Sunday 18 August 2002 13:43, you wrote: > Don't forget about the relink script in $ORACLE_HOME/bin. This is new > starting with 8.1.7 (I think). > > From the script... > #!/bin/sh > # > #NAME > # relink > # > #DESCRIPTION > # performs manual relinking of Oracle product executables based > # on what has been installed in the ORACLE_HOME. > # script calls appropriate makefile targets for the following > # accepted script parameters: > # all -- everything which has been installed > # oracle -- oracle database executable only > # network -- net_client, net_server, cman, names > # client -- net_client, otrace, plsql > # client_sharedlib > # interMedia -- ctx > # precomp -- all precompilers which have been installed > # utilities -- utilities > # oemagent -- oemagent, odg > # > > Ron Thomas > Hypercom, Inc > [EMAIL PROTECTED] > If A = B and B = C, then A = C, except where void or prohibited by law. -- > Roy Santoro > > > > [EMAIL PROTECTED] >To: > [EMAIL PROTECTED] 08/18/02 11:18 AMcc: > Please respond toSubject: Re: Oracle Linking > ORACLE-L > > > > > > > If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, > what could be the possible reasons for this? > > Thanks. > > ltiu > > On Sunday 18 August 2002 10:18, ltiu wrote: > > There is apparently two stages to the Oracle installation on Unix. A file > > copying installation where all the required binaries are copied from > > cdrom to hard disk and a linking install where the binary/object files > > are linked. > > > > If the first stage succeeds but the second stage does not. How do I start > > the linking install without having to go through the first stage copying > > install again? > > > > Thanks. > > > > ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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).
Tuning methodology (was T3's) and use of NetApp's
Hi Cary Thanks for the feedback, comments inline Cary Milsap wrote > > Some questions and a couple of comments regarding Dave's note: > > 1. RE the "tuning from a blue collar DBA perspective," is it accurate to > > paraphrase the described method as: "No matter what might be causing the > performance problem, check this List Of Things first, using tools that > vary significantly from one platform to the next." ? Well, I hoped I demonstrated how on at least one platform. My solution for another platform, if vocalized, will start another of these tedius OS religious battles I was trying to say that complex tools and traces such as tkprof and event 10046 are of no help if you don't understand the underlying system and SQL. Despite what is said there are uses for database ratios. Some such as disk vs memory sorts are vital to throughput. Ignore the fact that it is imperfect and use explain plan to look for inappropriate FTS. The payoff in quickly catching unecessary I/O, both physical and logical, overrides the need for detailed analysis Then is the time for tkprof, setting events, changing the optimizer and such > 2. Dave is multiplying Oracle's time statistics by 1/1000 (wrong) > instead of 1/100 (correct). Oracle is really reporting 'db file > sequential read' average latencies of .311cs = 0.003s (not 0.0003s), 'db > file scattered read' latencies of .506cs = 0.005s (not 0.0005s), 'db > file parallel write' latencies of 3.036cs = 0.030s (not 0.003s), and so > on. (Dave's I/O subsystem has consumed an average of 30ms for each 'db > file parallel write' call.) I don't know why but I seem to have alot of troubles with decimals on this list. Sure don't have the same problem with cheques :) > > 3. Note that it's only because the data are collected system-wide that > it is necessary to ignore the 'SQL*Net%' events. This is a waste, > though, because with properly time-scoped session-level data, the > 'SQL*Net%' events constitute probably the easiest way to detect when you > have bad applications code (not the SQL, but the stuff that calls the > SQL). I agree the data is a waste but many do not know this and worry needlessly. So at the session level the SQL Net events allow me to troubleshoot the applications server. Cool I continue to learn. > > 4. 'db file sequential read' does *not* typically indicate a full-table > scan, because 'db file sequential read' events, since Oracle8.0 are > almost always single-block read calls (before that, the event could > indicate multi-blocks reads of sort segment blocks into a PGA). Does this parameter measure anything then? > > 5. 'LGWR wait for redo copy' is *not* affected by the archiver not > keeping up. The alert log *is* a better way to detect this (because > 'LGWR wait for redo copy' doesn't detect it at all). An even better way > is to look for occurrences of 'log file switch (archiving needed)'. > > 6. 'latch free' -- Question: Does anybody know what "total_timeouts" > means for the 'latch free' event? I see nothing in v$latch that possibly > corresponds to something that could be called a "timeout." And nothing I notice that these numbers often climb when Oracle has to be aggressive in reclaiming shared pool memory because of literal SQL. I find that reducing the shared pool to as small as possible while storing the data dictionary optimizes performance (even if it's still bad) which are reflected in these numbers. The many bugs in the shared pool memory handling in many 8i versions often show up here too. Thanks once again Cary. On to other stuff At my current contract I am using a NetApp filer as an archive machine and I am extremely happy with how it has worked out. Archive logs are stored locally on a T3 and through NFS on the filer. MIN_SUCCEED_DESTINATION or whatever is set to one. If the NetApp disappears oracle keeps chugging along writing the archive logs to the local array. All hot backups are put on the filer. I would be extremely hesitant to use it for any other files. I do have to be careful with the timing of my backups as it is pretty easy to overwhelm the appliance when copying files in. Dave Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Moving to UK - what are Oracle contracts like?
[EMAIL PROTECTED] wrote: > >Grant, > >I agree with Lewis, things are tight here. Very hard to find work and you > >have to compete hard on rate to have a chance. > >You have to work as a ltd company - does not cost much to set up , or use > an > >umbrella company. > >I would recommend joing the Professional Contractors Group > >(http://www.pcgroup.org.uk/) if you are considering contracting. > >The insurance is worthwhile but the discussion forums (general, ir35 > >matters, technical, commercial, accounting) etc can be very useful. > > > >Conversely I am thinking about Australia (Sydney) long-term - why are > you > >leaving there and coming to sunny England? > > > >John > Thanks to everyone for the feedback - very useful. John, Sydney's pretty quiet right now - I've got friends on both sides; contractors and recruiters - and they are all feeling the pinch. As it stands, it looks like I'll be getting a permanent position wearing my "jack-of-all-dbs, master-of-none" hat in the M4 corridor - but all of the contracting info that's been provided will certainly help when I take the plunge. Hope to see some of you over there - you can spot me by the IV drip filled with coffee :-) Ciao Fuzzy :-) -- "Woo Hoo!" - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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: Tuning methodology (was T3's) and use of NetApp's
> > 4. 'db file sequential read' does *not* typically indicate a > full-table scan, because 'db file sequential read' events, since > Oracle8.0 are almost always single-block read calls (before that, the > event could indicate multi-blocks reads of sort segment blocks into a > PGA). [DM] Does this parameter measure anything then? It shows the number of blocks read from the OS via calls to read(). > 6. 'latch free' -- Question: Does anybody know what "total_timeouts" > means for the 'latch free' event? I see nothing in v$latch that > possibly corresponds to something that could be called a "timeout." > And nothing [DM] I notice that these numbers often climb when Oracle has to be aggressive in reclaiming shared pool memory because of literal SQL. I find that reducing the shared pool to as small as possible while storing the data dictionary optimizes performance (even if it's still bad) which are reflected in these numbers. [DM] The many bugs in the shared pool memory handling in many 8i versions often show up here too. I'm still trying to find a plausible definition for what "total_timeouts" means when the event is 'latch free'. When I think I have it straight in my mind, I'll let you know :). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: Miracle Database Forum, Sep 20-22 Middelfart Denmark -Original Message- Morgan Sent: Sunday, August 18, 2002 6:23 PM To: Multiple recipients of list ORACLE-L Hi Cary Thanks for the feedback, comments inline Cary Milsap wrote > > Some questions and a couple of comments regarding Dave's note: > > 1. RE the "tuning from a blue collar DBA perspective," is it accurate to > > paraphrase the described method as: "No matter what might be causing the > performance problem, check this List Of Things first, using tools that > vary significantly from one platform to the next." ? Well, I hoped I demonstrated how on at least one platform. My solution for another platform, if vocalized, will start another of these tedius OS religious battles I was trying to say that complex tools and traces such as tkprof and event 10046 are of no help if you don't understand the underlying system and SQL. Despite what is said there are uses for database ratios. Some such as disk vs memory sorts are vital to throughput. Ignore the fact that it is imperfect and use explain plan to look for inappropriate FTS. The payoff in quickly catching unecessary I/O, both physical and logical, overrides the need for detailed analysis Then is the time for tkprof, setting events, changing the optimizer and such > 2. Dave is multiplying Oracle's time statistics by 1/1000 (wrong) > instead of 1/100 (correct). Oracle is really reporting 'db file > sequential read' average latencies of .311cs = 0.003s (not 0.0003s), 'db > file scattered read' latencies of .506cs = 0.005s (not 0.0005s), 'db > file parallel write' latencies of 3.036cs = 0.030s (not 0.003s), and so > on. (Dave's I/O subsystem has consumed an average of 30ms for each 'db > file parallel write' call.) I don't know why but I seem to have alot of troubles with decimals on this list. Sure don't have the same problem with cheques :) > > 3. Note that it's only because the data are collected system-wide that > it is necessary to ignore the 'SQL*Net%' events. This is a waste, > though, because with properly time-scoped session-level data, the > 'SQL*Net%' events constitute probably the easiest way to detect when you > have bad applications code (not the SQL, but the stuff that calls the > SQL). I agree the data is a waste but many do not know this and worry needlessly. So at the session level the SQL Net events allow me to troubleshoot the applications server. Cool I continue to learn. > > 4. 'db file sequential read' does *not* typically indicate a full-table > scan, because 'db file sequential read' events, since Oracle8.0 are > almost always single-block read calls (before that, the event could > indicate multi-blocks reads of sort segment blocks into a PGA). Does this parameter measure anything then? > > 5. 'LGWR wait for redo copy' is *not* affected by the archiver not > keeping up. The alert log *is* a better way to detect this (because > 'LGWR wait for redo copy' doesn't detect it at all). An even better way > is to look for occurrences of 'log file switch (archiving needed)'. > > 6. 'latch free' -- Question: Does anybody know what "total_timeouts" > means for the 'latch free' event? I see nothing in v$latch that possibly > corresponds to something that could be called a "timeout." And nothing I notice that these numbers often climb when Oracle has to be aggressive in reclaiming shared pool memory because of literal SQL. I find that reducing the shared pool to as small as possible while storing the data d
Re: Tuning methodology (was T3's) and use of NetApp's
On 2002.08.18 23:48 Cary Millsap wrote: > > > > 4. 'db file sequential read' does *not* typically indicate a > > full-table scan, because 'db file sequential read' events, since > > Oracle8.0 are almost always single-block read calls (before that, the > > event could indicate multi-blocks reads of sort segment blocks into a > > PGA). > > [DM] Does this parameter measure anything then? > > It shows the number of blocks read from the OS via calls to read(). I was told, in a private communication, by a person who used to work for Oracle Support that oracle is reading indexes via "read" and tables via "readv" call, indicating that a "sequential" read really refers to to reading indexes and "scattered" refers to reading tables. Is that a correct interpretation? One more thing, oracle documentation claims that oracle, as of 8i, first reserves redo copy latch and then, after that, it reserves the allocation latch. After many hours of trying, I finally gave up trying to understand the algorithm. Can you, please, shed some light on that? Thanks! -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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: Tuning methodology (was T3's) and use of NetApp's
Mladen, Read http://www.hotsos.com/dnloads/1.Holt2000.02.01-Backwards.pdf (by Jeff Holt) for complete details about the difference between Oracle's "scattered" and "sequential" reads. Read http://www.ixora.com.au/tips/tuning/redo_latches.htm (by Steve Adams) for details on the redo latch question. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: Miracle Database Forum, Sep 20-22 Middelfart Denmark -Original Message- Gogala Sent: Sunday, August 18, 2002 11:33 PM To: Multiple recipients of list ORACLE-L On 2002.08.18 23:48 Cary Millsap wrote: > > > > 4. 'db file sequential read' does *not* typically indicate a > > full-table scan, because 'db file sequential read' events, since > > Oracle8.0 are almost always single-block read calls (before that, the > > event could indicate multi-blocks reads of sort segment blocks into a > > PGA). > > [DM] Does this parameter measure anything then? > > It shows the number of blocks read from the OS via calls to read(). I was told, in a private communication, by a person who used to work for Oracle Support that oracle is reading indexes via "read" and tables via "readv" call, indicating that a "sequential" read really refers to to reading indexes and "scattered" refers to reading tables. Is that a correct interpretation? One more thing, oracle documentation claims that oracle, as of 8i, first reserves redo copy latch and then, after that, it reserves the allocation latch. After many hours of trying, I finally gave up trying to understand the algorithm. Can you, please, shed some light on that? Thanks! -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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: Cary Millsap 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).
Materialized view selection.
Hi, All, Just wonder what's tool or methodology you are using to select materialized view in Oracle data warehouse environment? Many thanks in advance, Chuan Unless otherwise stated, this e-mail does not represent the views of TransACT Communications Pty Limited. This text and any attachments of this e-mail are confidential and may be legally privileged. This email is for the use of the intended recipient only. If you are not the intended recipient do not take any action in relation to this email, other than to notify TransACT Communications by replying to this e-mail and destroying the original communication. Except as required by law, TransACT Communications does not represent that this transmission is free of errors, viruses or interference.
Re: Materialized view selection.
Depends mostly on your users needs. If most of the time your users would want monthly sum of measures, you give them a materialized view for that. You can also use the summary advisor feature of oracle (dbms_olap) to find out which mviews oracle thinks is needed based on usage. =) Chuan Zhang wrote: > Hi, All, > >Just wonder what's tool or methodology you are using to select materialized view >in Oracle data warehouse environment? > > Many thanks in advance, > > Chuan > > >Name: InterScan_Disclaimer.txt >InterScan_Disclaimer.txtType: Plain Text (text/plain) >Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega 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).
