RE: 32-bit RMAN Catalog and networker interoperating with 64-bit
Title: RE: Purely for your amusement Anyone done this before? Seems like it should work.
RE: 32 bit and 64 bit memory
Lyndon - How about more memory than you can afford. On most Unix systems, and I assume Linux is roughly similar, there is a kernel setting that is effectively the per process limit. If you have 4 gig real memory, you would set the per process limit much lower because all processes must share that total real memory. On a server you don't dare set this too high or you get to learn about swapping and how much swap space you must allocate for swapping. Like Oracle, set something really wild and you can get some fireworks. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 28, 2003 3:24 PM To: Multiple recipients of list ORACLE-L That 3g limit only applies to Windows (2g w/o the boot.ini /3g switch). Linux is a whole other bowl of wax. Having never run Oracle in Linux I'm afraid I can't answer your question. My best guess would be the per process limit is 4g, but on most unix platforms the SGA (which the OP was about) is outside of the session processes. It's a chunk of shared memory. I don't know what limits Linux places on shared memory segments. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 28, 2003 3:23 PM Hey, I just remembered that Oracle on Linux runs as multiple processes , unlike Oracle on Windows which runs as one big process. Does this mean each Oracle process on Linux can access 3GB of memory? So that in the end the whole of Oracle can actually use greater than 3GB of memory? -- Lyndon Tiu Quoting Chuck Hamilton [EMAIL PROTECTED]: By default, Windows imposes a 2g per process limit on all processes including the OS itself. Oracle runs as a process with each session running as a thread within that process so the entire Oracle process including SGA, sessions, DLLs, executables, etc. must all fit within 2g. There is a boot.ini switch that raises the limit to 3g while reducing the OS's addressable memory to 1g. I can't speak to other 32 or 64 bit platforms from experience as I've never tried to push any of them to the limit.You need to remember though that X-bit processor doesn't necessarily mean X-bit addressability. Unless I'm mistaken the bit size of a processor represents the size of the registers, instructions and internal busses, but not the memory addressability which is limited by other things in the hardware. Having said that, current 32 bit platforms can usually addresses 4g. -- Chuck - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 28, 2003 12:34 PM Hello, 1) How big (max) can an Oracle SGA be in a 32bit platform (Windows and Linux on ia32)? 2) How big (max) can an Oracle SGA be on a 64bit platform (Sparc Solaris, AIX PowerPC)? Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Re: 32 bit and 64 bit memory
Windows is a mess. Everything (all foreground and background processes) has to cram inside 2Gb (default) or 3Gb (boot.ini option for certain Windows versions). Also, by default, each database session thread allocates 1Mb for stack space by default, and that takes away from the process's total of 2-3Gb memory. That default can be adjusted downward (no lower than 512Kb recommended) using an Oracle-supplied program called ORASTACK. Also, there is some capability to exceed the 2-3Gb limit for the Buffer Cache only (not the whole SGA, just the Buffer Cache) to extend into AWE (forget exactly what the acronym means - something like advanced windows extensions) memory, but the extended AWE memory involves some indirection so it is slower to access or manipulate than regular memory. Just a kludge all round, because Windows can't/won't support shared memory or semaphore constructs... ...believe me all you Windows folks -- it is nothing personal. But Windows should be far better than this, with only one vendor calling the shots... 32-bit UNIXs can accomodate 2-4Gb per process. Each foreground and background Oracle server process gets its own allocation of 2-4Gb, so you can pretty much go nuts and chew up as much memory as you please. The sticking point behind the 2-4Gb limit is the shared-memory used for the SGA, which counts toward each processes' total. So, if you have a 1.6Gb SGA and the UNIX variant you are using is limited to 2Gb, then everything else (i.e. stack, PGA, UGA) has to fit into 0.4Gb. Luckily, that's usually not a problem. But sometimes a larger SGA is a legitimate need... The 64-bit UNIXs can accomodate something like 64Pb of data. That's peta-bytes, a.k.a. 1,024 tera-bytes, a.k.a. 1,048,576 giga-bytes. I'm not aware of any server on the planet (or off the planet but nearby) with even 1Tb of physical RAM (though that doesn't mean there aren't), so 64-bit OSs should eliminate any restrictions on virtual memory, at least for the next couple years... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 28, 2003 10:34 AM Hello, 1) How big (max) can an Oracle SGA be in a 32bit platform (Windows and Linux on ia32)? 2) How big (max) can an Oracle SGA be on a 64bit platform (Sparc Solaris, AIX PowerPC)? Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DSS tools?
Binley, Thanks for the feedback! The company, TargetRx near Philadelphia on the east coast of the US, will go forward with Brio. Their business users loved it and the IT team has decided they'd rather fight the many technical problems with the ODS server than fight any longer with the business users. Good choice, I think... Thanks again! -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 4:56 PM None of the comments is correct - did they get that from a competitor? ;-) Having said that however... 1. The Brio client does have the full suite of functions - very similar to that found in Oracle. Beware though they may not behave exactly like Oracle and does not complain if you get the parameters wrong, eg date format. It simply returns rubbish. 2. Multiple data source can be connected, and the joins across sources is done on the client. This is the irritating bit - if you have multiple queries against the same source, you have to be connected once for each query! 3. The client-processing is actually done on the PC, not the middle tier. First time you access ODS, it downloads and installs plugins on the PC. The application however, ie reports etc are served by the ODS. Since it is a DB independent tool, it reduces a lot of things down to a very low common denominator. In particular, it does not handle error messages from Oracle very well at all. My personal opinion is - look at other options if you can. [EMAIL PROTECTED] 02/20/03 01:48a.m. A customer of mine has recently decided to purchase BRIO but the process of checking references on the product has been(ahem!)pretty discouraging. Specifically, they have gathered the following comments: 1. There are no aggregate functions available on the BRIO client. For example, if we pull some product pricing from Oracle and some from SQL Server, we will not be able to calculate an average price on the client (local PC) where we build the report. 2. Only one data source can be connected at a time. This forces a user to save result sets from different cubes locally first and then compare them also locally. 3. On Demand server (web-based middle-tier) is single-threaded; only one client at a time is working. My guess is that this is changed in v8, but it would be nice to get a confirmation. Has anyone had experience with this? What are your experiences? Also, what other DSS tools are you using and how do you like them? Thanks in advance... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: multiple oracle homes
Better yet, have one single generic .profile with aliases defined for each instance running on the server. Want to change env for another instance? Just type it's name. It is that simple. We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w. The .profile file sources the alias' file as .local.aliases. This file has entries as below: #Add Database name here using the following format alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK=NO;. oraenv;' alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK=NO;. oraenv;' alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK=NO;. oraenv; cd /u01/home/oracle/admin/VP1D;' alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK=NO;. oraenv;' alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK=NO;. oraenv;' alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK=NO;. oraenv;' alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK=NO;. oraenv;' alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK=NO;. oraenv;' alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK=NO;. oraenv;' PRMT -- IWVT are the instances running on the server. And finally, do change the UNIX prompt to include current ORACLE_SID, among other things !! HTH, - Kirti -Original Message- Sent: Friday, February 28, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Using something other than oracle makes it more complicated - I think. Have a different .profile - can name it something that makes sense. -Original Message- Sent: Friday, February 07, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 8:24 AM To: Multiple recipients of list ORACLE-L On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? -- Thanks for you replies. I've never tried this before and it seems like there are two different approaches on the surface: 1. use two different userids, ora817 and ora920, to do the install. This seems stupid, since it replicates the product directory structure and oraInventory stuff under different ownership. This might be safer since it is like running one version in that everything is seperate, but maybe there are operational issues to not using the oracle userid. Seems like there may be a gotcha waiting in the wings. Like maybe you can't run the same listener for both, or worse. 2. use the same oracle userid for both installs and change the environment vars as needed. Seems like you could damage the first install if you made a mistake. Also, it seems like in a stressful failure situation you don't want to have to think about who's on first? I don't know, third base. Are both paths valid? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER
Hi, I need to do some sorts with Scandinavian characters and I need to setthese parameters NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER Where do I put these because I am using and application and WebLogic iscalling some programns which are actually using that sorts... Any ideas would be apreciated... TIAKalleGå före i kön och få din sajt värderad på nolltid med Yahoo! Express