RE: hw info on Tru64 system

2003-02-06 Thread Stephen Lee
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: Oracle Training

2003-02-06 Thread Stephen Lee
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: Trolling for ideas

2003-02-06 Thread Stephen Lee
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-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Help with a truncate command in a procedure

2003-02-06 Thread Stephen Lee
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: [EMAIL PROTECTED] Fat City Network Services

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

2003-02-05 Thread Stephen Lee
: 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 mailing list, send an E

RE: Windows 2000 Cluster on oracle

2003-02-05 Thread Stephen Lee
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 Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

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

2003-02-04 Thread Stephen Lee
://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

RE: awk and ksh question - solved

2003-02-04 Thread Stephen Lee
THE WALLS $PAGER_PERSON $PAGE_FILE fi fi -- 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

RE: OT: Cron not working

2003-02-04 Thread Stephen Lee
://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

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

2003-02-04 Thread Stephen Lee
, 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 hosting services

RE: awk and ksh question - solved

2003-02-04 Thread Stephen Lee
$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.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services

RE: awk and ksh question - solved

2003-02-04 Thread Stephen Lee
://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 mailing

RE: OT: Cron not working

2003-02-04 Thread Stephen Lee
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.fatcity.com San Diego

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

2003-02-03 Thread Stephen Lee
echo '123$456$789' | sed 's/\$/\\\$/g' 123\$456\$789 Why? The $ means end of line to sed; so you have to quote it too. -Original Message- Maybe there is another syntax that I should use? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

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

2003-02-03 Thread Stephen Lee
; 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://www.fatcity.com San Diego, California

RE: awk and ksh question

2003-02-03 Thread Stephen Lee
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: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

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

2003-01-31 Thread Stephen Lee
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 -- Author: Stephen Lee INET: [EMAIL

RE: Excessive library cache latch contention

2003-01-31 Thread Stephen Lee
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 City Network Services-- 858

RE: Excessive library cache latch contention

2003-01-31 Thread Stephen Lee
- 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.fatcity.com San Diego, California

RE: Debate on rc commands Solaris and Oracle

2003-01-30 Thread Stephen Lee
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 hosting services

RE: Perl

2003-01-29 Thread Stephen Lee
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, California-- Mailing

RE: Perl - Was unix time conversion function

2003-01-28 Thread Stephen Lee
. 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 and web hosting services

RE: Perl - Was unix time conversion function

2003-01-28 Thread Stephen Lee
. -Original Message- I've started writing some perl and it is hard to learn, but once you learn, it can do some great things. And if you learned it from the Larry Wall book like I did, then it's even harder. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen

RE: Base conversion

2003-01-28 Thread Stephen Lee
- 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 City Network Services-- 858-538-5051 http

RE: Windows 2000 Cluster on oracle

2003-01-28 Thread Stephen Lee
://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

RE: Perl - Was unix time conversion function

2003-01-28 Thread Stephen Lee
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 and web hosting services

RE: Base conversion

2003-01-28 Thread Stephen Lee
://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

RE: Sequences in 8.1.7 vs 9i

2003-01-23 Thread Stephen Lee
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 -- Author: Stephen Lee INET

RE: Slow database, too MANY buffers???

2003-01-23 Thread Stephen Lee
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, California-- Mailing list

RE: Slow SQL*Plus connect.

2003-01-22 Thread Stephen Lee
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: Database Verification

2003-01-17 Thread Stephen Lee
structure 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: from Non-Archive-Mode to Archive-Mode

2003-01-17 Thread Stephen Lee
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-- Mailing list and web

RE: More RMAN Questions

2003-01-16 Thread Stephen Lee
backups.   My prior plan was to upgrade the databases to 9iR2 then implement RMAN, no time to do both.  Can I use RMAN 9i w/ older database versions?   -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services

RE: More RMAN Questions

2003-01-16 Thread Stephen Lee
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

RE: Caching a huge table's data in memory

2003-01-07 Thread Stephen Lee
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-5051 http://www.fatcity.com San Diego

RE: Caching a huge table's data in memory

2003-01-07 Thread Stephen Lee
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: Automatic backup on Oracle 9i -- For Jared

2003-01-06 Thread Stephen Lee
. --.- .-. -- -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 Diego, California-- Mailing list

RE: Database/system Crashing

2003-01-06 Thread Stephen Lee
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: Multiple recipients of list ORACLE-L Subject: RE

RE: Database/system Crashing

2003-01-03 Thread Stephen Lee
. 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 list and web hosting

RE: Re: Free Shared pool memory

2003-01-02 Thread Stephen Lee
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-- Mailing

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

2003-01-02 Thread Stephen Lee
). -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 PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Automatic backup on Oracle 9i

2002-12-27 Thread Stephen Lee
://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

RE: Rebuilding Indexes...

2002-12-26 Thread Stephen Lee
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

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

2002-12-24 Thread Stephen Lee
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-- Mailing list and web hosting services

RE: RMAN and cron

2002-12-23 Thread Stephen Lee
). -- 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 and cron

2002-12-23 Thread Stephen Lee
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 PROTECTED]] Sent

RE: RMAN, recatalog backup set

2002-12-20 Thread Stephen Lee
When you are not using a catalog database, the control file is your only catalog. If you destroy all copies ofit, 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 backup the

RE: Disable Database Startup While COLD Backup is in Progress

2002-12-20 Thread Stephen Lee
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: 8i OCP DBA Exams

2002-12-20 Thread Stephen Lee
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] Fat City Network

RE: RMAN scripts - archived logs

2002-12-19 Thread Stephen Lee
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

RE: Footprint of 9i

2002-12-19 Thread Stephen Lee
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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Backup DB files to the Tape

2002-12-19 Thread Stephen Lee
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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Backup DB files to the Tape

2002-12-19 Thread Stephen Lee
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.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Backup DB files to the Tape

2002-12-18 Thread Stephen Lee
(like subscribing). -- 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

RE: archiving redo logs

2002-12-11 Thread Stephen Lee
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 -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: Recovery Scenarios

2002-12-11 Thread Stephen Lee
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: RMAN Reporting?

2002-12-11 Thread Stephen Lee
://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 yourself from

RE: imp table by table

2002-12-10 Thread Stephen Lee
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 Lee INET: [EMAIL

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

2002-12-10 Thread Stephen Lee
., 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.fatcity.com San Diego, California

RE: archiving redo logs

2002-12-10 Thread Stephen Lee
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: archiving redo logs

2002-12-10 Thread Stephen Lee
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 PROTECTED] Fat City

RE: DB corruption question

2002-12-06 Thread Stephen Lee
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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: To_Number

2002-12-06 Thread Stephen Lee
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: Implementing Continuous Managed Recovery on a Standby Databas

2002-12-06 Thread Stephen Lee
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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Something that might be of use

2002-12-05 Thread Stephen Lee
-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-538-5051 http

RE: Archived logs backup

2002-12-05 Thread Stephen Lee
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.orafaq.com -- Author: Stephen Lee INET: [EMAIL

RE: Archived logs backup

2002-12-05 Thread Stephen Lee
://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 yourself from

RE: DB corruption question

2002-12-05 Thread Stephen Lee
-- 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 mailing list, send

RE: Something that might be of use

2002-12-05 Thread Stephen Lee
-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: Stephen Lee INET: [EMAIL PROTECTED

RE: Something that might be of use

2002-12-05 Thread Stephen Lee
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 Services-- 858-538-5051 http

RE: Are Oracle courses required for Oracle Certification now?

2002-12-05 Thread Stephen Lee
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:

2002-12-04 Thread Stephen Lee
-- 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 mailing list, send

Something that might be of use

2002-12-04 Thread Stephen Lee
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 modified_dump_file

RE:

2002-12-03 Thread Stephen Lee
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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: redo log file setup with mirrored drives

2002-11-30 Thread Stephen Lee
. -- 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

RE: OSF11 in TRU64 Unix

2002-11-27 Thread Stephen Lee
)/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 and web

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
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 PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
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 PROTECTED] Fat City Network Services-- 858

RE: Oracle OS level security

2002-11-27 Thread Stephen Lee
-- 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 mailing list

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
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 PROTECTED] Fat City Network

RE: is it possible ?

2002-11-27 Thread Stephen Lee
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-- Mailing list

RE: Oracle 8.1.6 Installation error

2002-11-27 Thread Stephen Lee
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 Services

RE: patches

2002-11-27 Thread Stephen Lee
: 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: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: Oracle 9i installation - Basic Qs

2002-11-26 Thread Stephen Lee
PC Client IP Address Xlib : cannot set display to PC Client IP Address 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 INET: [EMAIL

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
to exist. That being the case, I must go with the arrangement that I think offers fault tolerance with the best performance. -- 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

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
-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 City Network

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

2002-11-26 Thread Stephen Lee
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-538-5051 http

RE: SQL tuning help

2002-11-26 Thread Stephen Lee
sid from v$session where last_call_et 100 and sid 10 and osuser is not null) and w.session_id = a.sid and h.session_id = b.sid; -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
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-- Mailing list and web hosting services

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

2002-11-26 Thread Stephen Lee
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 http://www.fatcity.com San

RE: Imp of all users tables

2002-11-26 Thread Stephen Lee
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 hosting services

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
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 -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
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 Services-- 858-538-5051 http

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Stephen Lee
it has the same database id as the original. Is this true or not? If so, how to get around it? --- -- 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

RE: A way to restore a DB

2002-11-25 Thread Stephen Lee
://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 yourself from

RE: how do I calculate the Oracle's usage

2002-11-25 Thread Stephen Lee
/ {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-- Mailing list and web hosting services

RE:

2002-11-25 Thread Stephen Lee
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 and web hosting services

RE: Password Generator...

2002-11-21 Thread Stephen Lee
time; and it's free. -- 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

RE: AIX vs Solaris

2002-11-19 Thread Stephen Lee
for easier Solaris syatems admin? -- 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   >