RE: Application Server Caching

2004-01-23 Thread Rich Holland
with technology, but the idea is that memory is faster than database buffers, which are in turn faster than going clear to disk for something… Cheers! Rich -- Rich Holland    (913) 645-1950    SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -- Please

RE: full recovery

2004-01-21 Thread Rich Holland
Sorry it took so long to get back to you; I've been caching the list for awhile and am just starting to catch up. :-) Page 43, in the grey box with title 'Re-Creating the Controlfile: RMAN Users Beware!' Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u

RE: rman backup

2004-01-19 Thread Rich Holland
if I need to roll forward. Does RMAN try and cram 'em all in at once, or will it roll through them? That sure would be a nice feature. ;-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original

RE: Convert to Locally-Managed Tablespaces

2004-01-15 Thread Rich Holland
based on WAS 6.20 and higher use PSAPSCHEMAREL instead (e.g. PSAPDEV620 or PSAPPRD620 for a DEV or PRD db running 6.20). Upgrades are done the same way, e.g. PSAPDEV620 - PSAPDEV630 and you can free up PSAPDEV620's segments afterward. Rich -- Rich Holland(913) 645-1950SAP Technical

RE: full recovery

2003-11-07 Thread Rich Holland
autobackup on'). We dump these disk copies via filesystem backups as a safety measure. We also do a backup database, archivelogs, and then control (but all in one step; I'm not sure I'm clear on the reason for separating them into three backup sets) Rich -- Rich Holland(913) 645-1950

RE: UNIX and Oracle

2003-08-29 Thread Rich Holland
things like mutex locks, etc. -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Veeraraju_Mareddi Sent: Friday

Oracle Utilities book?

2003-08-19 Thread Rich Holland
Has anyone read this yet? http://tinyurl.com/kis0 It looks like a useful reference, but I thought I'd get other opinions before I purchase it -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED

RE: Export direct=Y|N

2003-07-18 Thread Rich Holland
incremental time, but over the course of a 20G export all those round trips between kernel and user space can really add up -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message

RE: LISTENER ON LINUX

2003-07-11 Thread Rich Holland
Try 'lsof -i |egrep (TCP|UDP) to see what's got the address bound. Lsof is a freely available tool that should be installed on all unix boxes, IMHO. :-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED

RE: Do Not Call

2003-07-11 Thread Rich Holland
... -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Those installing Oracle 9i on AIX 5.2L

2003-06-30 Thread Rich Holland
) IY19744(security - xntpd buffer overflow) IY23041(security - lpd buffer overflow) If you install ML 04 it'll include these automagically for you. I think that's IY44478, but search the APARs for Maintenance and it should jump right out at you -- Rich Holland [EMAIL PROTECTED] SAP

RE: Those installing Oracle 9i on AIX 5.2L

2003-06-30 Thread Rich Holland
founded CD-ROM that we coudn't read on a PC or Sun workstation! :( At least now they're HTMLifying it all, but they still insist on being "different" and not including nroff man pages. *sigh* I think that's my BIGGEST complaint about AIX ("Ain't Unix")... --Rich Hollan

RE: oraInst.loc question

2003-06-30 Thread Rich Holland
in the morning if I didn't trip over the laces. :-) --Rich Holland (913) 645-1950 SAP Technical Consultantprint unpack("u","92G5S\=\"!A;F]T:5R(\'!EFP\@:%C:V5R\"[EMAIL PROTECTED]"); -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

oraInst.loc question

2003-06-05 Thread Rich Holland
a single oraInst.loc file for multiple inventories? I'm strongly considering hiding opatch and replacing it with a wrapper script that rewrites the oraInst.loc files prior to calling the 'real' opatch executable, but thought I'd see if there's an easier way first. :-) Thanks! Rich Holland SAP

RE: AIX 5L - what is it?

2003-03-31 Thread Rich Holland
Title: Message 5L is the designation for "Linux affinity". The output of 'oslevel -r' will tell you your release and maintenance level. For example, 5100-02 means you're running AIX 5L 5.1 maint level 02. The reason there are two different downloads is that 64-bit code is OS dependant;

RE: Statspack recomendations.

2003-03-14 Thread Rich Holland
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: JDK directory home

2003-02-20 Thread Rich Holland
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: help meeeee please - related with c 5.1 in aix

2003-02-20 Thread Rich Holland
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: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: investigating database lockup

2003-02-20 Thread Rich Holland
(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: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: HPUX SCSI Performance

2003-02-20 Thread Rich Holland
Title: RE: HPUX SCSI Performance Have you checked the queue depths? There are several parameters your admin can use to tune SCSI performance, but this is typically the first place to start with OLTP systems. You might also look at your buffer cache settings (HP-UX ships with these set at

RE: AIX Oracle 9.2

2003-02-16 Thread Rich Holland
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Do user processes apply against shmmax limit?

2002-11-29 Thread Rich Holland
send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: 1M STRIPE SIZE BEST?

2002-11-23 Thread Rich Holland
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: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: AIX vs Solaris

2002-11-20 Thread Rich Holland
Could you give Some Detail of Tuning the Depth Queue ? Our Configuration :- Solaris Box Connected to XP512 HP Storage(Hitachi packaged)with VXFS Filesystems Thanks -Original Message- From: Rich Holland [mailto:[EMAIL PROTECTED]] Sent: Sunday

RE: AIX vs Solaris

2002-11-17 Thread Rich Holland
if they didn't think they could do it Rich Holland Guidance Technologies, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of DENNIS WILLIAMS Sent: Wednesday, November 13, 2002 4:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: AIX vs

RE: AIX vs Solaris

2002-11-17 Thread Rich Holland
), which is a big win in an Oracle environment. Rich Holland Guidance Technologies, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of John Shaw Sent: Wednesday, November 13, 2002 3:06 PM To: Multiple recipients of list ORACLE-L Subject: Re: AIX vs

RE: RE: Changing dump destinations in init.ora

2002-02-24 Thread Rich Holland
'; When starting the instance, you can also specify an alternate SPFILE: SQL startup pfile=filename There's also some new syntax for the ALTER SYSTEM command to specify the scope of the change: ALTER SYSTEM set parameter = value SCOPE = MEMORY | SPFILE | BOTH; Rich Holland Guidance

RE: DBA-Database Storage using Net Appliance

2002-02-14 Thread Rich Holland
://www.orafaq.com -- Author: Rich Holland 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