RE: RAC on linux?

un is now going after the intel market too. Is this just a new version of their Solaris x86, or a completely new build? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

RE: windows application to show sql being executed by a client

Lindows?? -Original Message- how can I do it for unix processes ? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Skipping a table on import

ease see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web host

RE: Help with a truncate command in a procedure

any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMA

RE: Trolling for ideas

hope that solves the problem. Unfortunately we can only > upgrade to Oracle > 8.1.7.4. Does anyone have any other ideas? Thanks. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 8

RE: Oracle Training

Yet another choice: www.thinkspark.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: hw info on Tru64 system

psrinfo -v vmstat -P -Original Message- How do I find hardware info on Tru64 machine? Available RAM, number of CPUs...? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Windows 2000 Cluster on oracle

inux is cheaper than Windows. Try comparing prices for a large Dell Xeon box versus a Sun V880 box. The bigger you get, the more competitive the mainline Unix boys get. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Net

RE: Determine how many used and free blocks in an extent.

http://www.orafaq.net -- Author: Stephen Lee 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

RE: OT: Cron not working

about WHY it happened Why!? You want to know WHY!? There is only one answer to that. And it is ALWAYS that one answer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www

RE: awk and ksh question - solved

ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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 yoursel

RE: awk and ksh question - solved

gt; PAGER_PERSON=`echo "$PAGER_PERSON" | sed 's/[ ]*//g'` > PAGER_PERSON=`echo "$PAGER_PERSON" | sed 's/^,*//g'` > PAGER_PERSON=`echo "$PAGER_PERSON" | sed 's/,,*/,/g'` > if [ -n "$PAGER_PERSON"

RE: Re[2]: awk and ksh question - solved

o get into this file, the DBA would have a short career there. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

RE: OT: Cron not working

official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: awk and ksh question - solved

R_PERSON=`echo "$PAGER_PERSON" | sed 's/,,*/,/g'` if [ -n "$PAGER_PERSON" ]; then mailx -s "IT IS ALL OVER THE WALLS" "$PAGER_PERSON" < "$PAGE_FILE" fi fi -- Please see the official ORACLE-L FAQ: http://www.orafaq

RE: OT: unix script quetion: to replace $ with \$

PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > Stephen Lee > > Sent: Monday, February 03, 2003 3:54 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: OT: unix script quetion: to replace $ with \$ > > > > > > > > Would somethin

RE: awk and ksh question

that can help pull my head out of the sand... Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: ht

RE: OT: unix script quetion: to replace $ with \$

while read LINE; do echo "exec analyze_that_puppy BUBBA.$LINE real good;" | sed 's/\$/\\\$/g' done -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://w

RE: unix script quetion: to replace $ with \$

al ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOV

RE: Excessive library cache latch contention

age- > > I don't know about 9, but I am pretty sure that in 8, this > "feature" is > broken. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fat

RE: Excessive library cache latch contention

I don't know about 9, but I am pretty sure that in 8, this "feature" is broken. > -Original Message- > cursor_sharing=FORCE may be an option, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: Debate on rc commands Solaris and Oracle/"startup force"?

Startup force followed by shutdown immediate is what we use. We have not had any problems with it yet. > -Original Message- > > "startup force"? > > What is your experience about it? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: Debate on rc commands Solaris and Oracle

Any votes for "startup force"? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: Perl

ime is used by the backup process which doesn't care from whence its command line came. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: Base conversion

ee the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Perl - Was unix time conversion function

t milk too). Been taking lessons from Carrie (and dating her mom!). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Windows 2000 Cluster on oracle

FAQ: http://www.orafaq.net -- Author: Stephen Lee 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

RE: Base conversion

ginal Message- > > > Sounds like something the "bright spark" or Duhveloper should > fix. It's better > when they experience their own pain. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: Perl - Was unix time conversion function

. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: Perl - Was unix time conversion function

me, piece-of-crap version. Download and build the REAL ksh93.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Slow database, too MANY buffers???

which ones to free up. It's only 256 meg, but depending on load, it may be too much. SGA is 687 meg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: Sequences in 8.1.7 vs 9i

sed will fix that in a big hurry. PERL?! We don't need no stinkin' perl! > -Original Message- > > The problem is that there are over > 2000 lines of > code similar to the one I identified. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- A

RE: Slow SQL*Plus connect.

in2K machine, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web host

RE: from Non-Archive-Mode to Archive-Mode

u may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Maili

RE: Database Verification

cascade Any advice ? Thanks, PH -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: More RMAN Questions

al ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: More RMAN Questions

; 8.1.7 databases w/out using a catalog?  >From the documentation, it appears the RMAN executable must match the target database.   2) Is RMAN even required for use w/ the Legato Module for Oracle?  I know the MML is not required for RMAN, hence RMAN disk backups.   My prior plan was to upgr

RE: Caching a huge table's data in memory

ata set reflects production volumes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Ma

RE: Caching a huge table's data in memory

Hey, if they want to spend the money > -Original Message- > What are the pros and cons of caching a table's data? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-

RE: Database/system Crashing

nd with no activity and they got some sort of i-nodes error. Thanks for all your replies. Any ideas are helpful and I will relay them to our SA's... Val -----Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To: Mult

RE: Automatic backup on Oracle 9i -- For Jared

. --.- .-. -- > -Original Message- > > Yea but I never see a "what's your QTH" > > joe > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

RE: Database/system Crashing

its rebooted. Is it possible that I need to beef up my init.ora parameters? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Automatic backup on Oracle 9i -- For Jared

you will ever see QRP used (reduce your power). > -Original Message- > With more people start to use wireless phones, PDAs, we will see more > messages like this. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROT

RE: Re: Free Shared pool memory

are at it! QRO! QRO! > -Original Message- > can you give your opinion? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-

RE: Automatic backup on Oracle 9i

he 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: Stephen Lee INET: [EM

RE: Rebuilding Indexes...

Title: Rebuilding Indexes... Here is the index rebuilding part of a ksh script I use.  Prior to this, I some variable setting, check the existence and permissions on some files, check the existence of tablespaces, check that the script is not already running, etc.  In this script, all the in

RE: Migrate table data to CSV file - Urgent help !!!

ork 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

RE: RMAN and cron

I suppose I should add that you can also have the backup script "dot" the env script. For example: - backup_script.ksh - #!/usr/bin/ksh . /path/to/env_script etc. etc. etc. --- > -Original Message- > From: Stephen Lee [mailto:[EMAIL PR

RE: RMAN and cron

-- > 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 m

RE: 8i OCP DBA Exams

They are trying to catch up with Sybase. Larry feels bad about falling behind. > -Original Message- > Not to mention 10i is coming out soon. Too fast man. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED]

RE: Disable Database Startup While COLD Backup is in Progress

Rename the init.ora? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RMAN, recatalog backup set

When you are not using a catalog database, the control file is your only catalog.  If you destroy all copies of it, then you have destroyed your catalog.  It's gone.  It is a late catalog.  It is no more.  (I wish I could remember the Monty Python dead parrot bit.)  That's why you must backu

RE: Backup DB files to the Tape

rsday, December 19, 2002 10:15 AM > To: Multiple recipients of list ORACLE-L > > > > It's one of those Unix things. It goes with the beard and > the bad-fitting > trousers held up by suspenders. > > > -- Please see the official ORACLE-L FAQ: http://www.oraf

RE: Backup DB files to the Tape

x27;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: Footprint of 9i

-- > 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 maili

RE: RMAN scripts - archived logs

Attached (If the list supports attachments) are one for tape (Legato Networker) and one for disk which later gets backed up by OS. These are generated by a ksh backup script every time the script runs. The disk backup does not use a catalog server; so you have the line at the end that backs up t

RE: Backup DB files to the Tape

> 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

RE: RMAN Reporting?

CLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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

RE: Recovery Scenarios

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: archiving redo logs

t (although, when I was thinking about this, one solution for doing that would be to create a soft link to point to last file you copied in the previous invocation). You will need to have a .rhosts file set up on the other box to use rdist. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: archiving redo logs

a .netrc file in the home directory on the source box. -Original Message- If UNIX script is the only option, I appreciate if you can share it here. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL

RE: archiving redo logs

Oh yeah. I forgot to say, if you create a script with a password in it, be sure to change the permissions so nobody but you can read it. For example chmod 700 (or 500) script_name -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED

RE: trapping errors from assignment of SQL*Plus Input Variables

ter > is specified (e.g., a letter). > > I had hoped the WHEN OTHERS exception would handle it but it does not. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fat

RE: imp table by table

Most likely, you will have to run the imports to get the data and the primary keys. Then run them again with ignore=y and rows=n to get the foreign keys. > > My problem is with referential > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen L

RE: Implementing Continuous Managed Recovery on a Standby Databas

://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 '

RE: To_Number

f '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

RE: DB corruption question

g list and web hosting services > --------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of '

RE: Are Oracle courses required for Oracle Certification now?

s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web ho

RE: Something that might be of use

ere one does work from a collection of xterm command line interfaces. (Pick up mouse: "Computer Oh Computer? A keyboard? How quaint!") -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Servi

RE: Something that might be of use

> -Original Message- > > GUI's are evil. > > Sure, blinking LEDs are much more better. Especially when the admins are epileptic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephe

RE: DB corruption question

cial ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMO

RE: Archived logs backup

t to see it. One thing that might be of interest is a C (not PERL!) frontend I wrote to make SUID oracle so a non-oracle operator can start a backup by hand if needed without us opening the permissions on any of our security-sensitiv

RE: Archived logs backup

) if [ $COUNT -gt 2 ]; then SEND $i TO TAPE if [ $? -ne 0 ]; then print "SOMETHING BROKE" else rm $i (or maybe safer to move it to a pre-delete filesystem, then delete it later) fi fi done -- Please see the official ORACLE-L FAQ: http://www.o

RE: Something that might be of use

> -Original Message- > it has GUI interface and a lot finer control over the GUI's are evil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-53

Something that might be of use

written by Stephen Lee because we've ** ** been needing something like this real bad for a while. ** ** If you leave the section that opens the files commented, ** ** then the syntax would be something like: ** ** modify_extents < dumpfile > modifie

RE:

ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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 yo

RE:

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 c

RE: redo log file setup with mirrored drives

is what will snag things. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: patches

: cd /path/path/product/8.1.7 find . -print | cpio -pvmud /some/backup/directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Oracle 8.1.6 Installation error

pletely a different installation location, the installer would not find the other inventory file and, consequently, have no idea what was on the box in the other location. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: is it possible ?

as long as you had separate environments, it should work ... we're talking Unix here right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: redo log file setup with mirrored drives

ily offended and survive in these environments. You have your debates; break a few chairs in the ensuing fight; then go out for lunch. It's all a nice break from the daily routine. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECT

RE: Oracle OS level security

AQ: http://www.orafaq.com -- Author: Stephen Lee 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 yourse

RE: redo log file setup with mirrored drives

ed patch that Compaq released for Tru64 actually caused disk writes to be unreliable (OH MY GOD!!). And we wound up with a G.D. mess in spite of the redos being duplexed all nice and official. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROT

RE: redo log file setup with mirrored drives

I was amazed at the non-security that seems to be rampant out there, with mischievous people running around deleting files. I kept reading about it and thinking you've got to be kidding. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL P

RE: OSF11 in TRU64 Unix

THING)/oracle/app/oracle> uname -a OSF1 box.domain.com V5.1 732 alpha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: redo log file setup with mirrored drives

could think of, while the database and application were running full blast. It never failed once (except for early Veritas on Motorola 88K which was a mess). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Service

RE: redo log file setup with mirrored drives

y between a 30HP air conditioning blower moter and a spot welder, and run a couple of paint shakers on top of the array to boot. What will your vaunted Oracle multiplexing do for you then? Huh? Well, smarty pants, I'm waiting! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- A

RE: Imp of all users tables

en it will default to all the tables of that user. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: LGWR using lots of CPU time, low CPU usage

this extra writing will definitely incur overhead. Now, the part about it all being on "the local drive": That still is BOOM!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 h

RE: redo log file setup with mirrored drives

n't take a bunch of 5000 and 6000 level math courses and come away entirely untrained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: SQL tuning help

; and h.mode_held != 'Null' and w.mode_requested != 'None' and w.lock_type = h.lock_type and w.lock_id1 = h.lock_id1 and w.lock_id2 = h.lock_id2 and w.session_id in (select sid from v$session where last_call_et > 100 and sid > 10 and osuser is not null) and w.session_id = a.sid

RE: LGWR using lots of CPU time, low CPU usage

>I don't think changing the logmembers will do much good I agree. > 4 groups, they are on the local drive. BOOM!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-53

RE: redo log file setup with mirrored drives

> -Original Message- > Stephen, > Nothing is gained by personal attacks in this forum. Please enlighten me. Exactly what personal attack was made? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat Cit

RE: redo log file setup with mirrored drives

ently, must be happening an awful lot to somebody out there. And we can hardware mirror the Oracle mirrors. So why not recommend that we just go mirror crazy? While the scenarios of gloom and doom that have been painted by some seem to be credible, I've have yet to witness, in my years of p

RE: Oracle 9i installation - Basic Qs

on to client refused "" > Xlib : cannot set display to "" > NOTE - Installation being initiated from a laptop using > Exceed Hummingbird > software to simulate Xwindows Console -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee

RE: redo log file setup with mirrored drives

r those too rather than rely on RAIDing for fault tolerance? Why would we expect the OS to reliably write data files and detect hardware errors when it can't reliably maintain redo logs? Pending further evidence to the contrary, I'll take mirroring external to Oracle as the better choice. --

RE:

nvince this guy the table is > not there. What else can I do? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list a

RE: how do I calculate the Oracle's usage

. ps -eo %cpu -o args | awk '$2 ~ /ABCD/ {sum = sum + $1}; END {print sum}' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: A way to restore a DB

database, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

<    1   2   3   4   >