RE: MIcrosoft Blackmail
> Remember, sales-dweebs can say anything they want. If your > sales-dweeb-conversation person rolls-over for this MS sales-dweeb, then > it's your companies fault. > And remember, it's a two-way street. The sales-dweeb can say anything he > wants to you, but you can call also - including telling him to stick the > .NET where the sun don't shine. > It's like what Dr. Phil says - you can't be taken advatage of unless you > let it happen. The sales-dweebs push, and you are supposed to push back > if it is not in your companies best interest. > Hope this helps. Remember also that M$ is used to being the only person you can deal with. They are very, very unhappy that now you have alternatives that run the same products (e.g., Oracle, DB2 on linux) and have a well-known, preferred desktop (e.g., OS/X). This makes their sales reps exciteable and prone to playing hardball as they watch their sales bonuses go up in smoke. The recent spate of high-profile licensing clashes hasn't helped any, so they are in an even fouler mood. If you want them to shut up and play nice(r) then I'd strongly suggest having a few prominent G3's around on desktops and at least one server (say file + print running Samba) with an RH or SuSE sitcker on it next to the NT boxes on your rack. See if that helps them understand your point of view... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: OT: MIcrosoft Blackmail
-- Thomas Jeff <[EMAIL PROTECTED]> > This came to our DBA team today.I'd appreciate your thoughts. I'm > not a business guy, just a plain old Apps DBA, but this really pisses me > off. Is it common practice by MS? Common to any number of vendors -- including Oracle. They want "partners" to buy into their technology wholesale. Depending on how much you need the vendor and how much they need you the degree of buyin varies. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: rebuilding an instance from a cpio file?
> I have a huge cpio file that a sys admin created when it was decided to > remove an instance (8i) from a test server. I don't know for certain what > to do with this file, but I'd like to get that instance back up and > running long enough to do an export of the db. > > Can somebody help with the syntax to list out the contents of the cpio > file? man 1 cpio; cpio -it < $inputfile; # short listing (like ls) or cpio -itv < $inputfile; # verbose listing (like ls -l) -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Here we go again!!
> MS will make XML part of the OS... But will it really be XML? They have a history of bending the standards to the point that anyone else's products break with M$. I'd wait to see how well they conform to buy-the-book XML before depending on it for anything. For a good example of this look at the "HTML" they generate today. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: OT: Here we go again!!
-- [EMAIL PROTECTED] on 09/09/02 11:58:25 -0800 > http://www.cw360.com/article&rd=&i=&ard=115584&fv=1 As a long time *NIX user I can only hope they never do. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: No space left on device - but I have lots left.
-- ltiu <[EMAIL PROTECTED]> > The error messages are very informative don't you think? Error messages in most products stink. If you don't learn to outsmart the developers and find what's wrong you will never be able to manage databases or operating systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: off-topic ->UNIX question
-- Santosh Varma <[EMAIL PROTECTED]> > Hello all, > > I get a process id by calling getProcessId()..I want to know from > program whether that processId exists. > Any way to find out how ? Depends on the O/s. Simplest way is to grep the output of ps. On systems with a /proc file system (e.g., linux, Solaris) you can look for /proc/$id. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: arg list too long in unix
-- kommareddy sreenivasa <[EMAIL PROTECTED]> > Hi all, > > Is there something like, > > unix is unable to use commands like ls -ltr (sort etc) > when there are huge number of files in a directory(may > be thousands/millions). > > If yes, what is the limit and how to know it on sun > solaris 2.8. This is not an issue with the command, but the buffer used by the O/S to store the comman line arguments. Standard sizes are 4KB or 8KB (i.e., on page). If the command line arg's exceed this size then the command cannot be started. Classic case is a directory with too many files in it; "ls" may work fine but "ls *" will blow up because the shell's expanding "*" overflows the buffer. If the file names are 500 char's long then you may have problems with only 10 files in the directory [don't laugh, I've seen it]. ls is partcularly bad about dealing with over-populated dir's becuse it sorts the result, which can be expensive in a 10 000 file diredtory; find does not sort anything and is better suited to dealing with huge file lists. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Unix Question
-- Pawan Dalmia <[EMAIL PROTECTED]> > > > My var partition is 99% full of which there are lot of files in /var/tmp > directory. > Can i delete this files ? Probably. Older ones are a better bet: cd /var/tmp; find . -atime +7 -type f | xargs rm -f; Question is what job leaves files behind in /var/tmp because that needs to be changed. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: arg list too long in unix
> > If the arg list is too long, one way to shorten it is with 'head'. > > find /dir_2_clean -name "cz*" -print | head -1000 | xargs rm -f The whole point of xargs is that it doesn't get overlong arguments -- unless one of the file paths is > 4KB by itself. This leaves the "head" extraneous: cd $someplace; find . -type f -name 'cz*' | xargs rm -f; will happily do the deed. Advantage to cd is that a naked '.' won't blow off the entire system via something like '/ dir_2_clean'. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: arg list too long in unix
-- "Markham, Richard" <[EMAIL PROTECTED]> > find . -name "cz-session-*" | xargs rm -f This will handle files in 8K chunks; find .. -e will fork for each file. Net result is that xargs is a much better way to go. On a multi-cpu system you can also use xargs -P to run jobs in parallel (at the expense of more forks). Aside: be quite sure to run this on local storage only; running this on networked storage can saturate the network during the erase cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: arg list too long in unix
-- Philip Douglass <[EMAIL PROTECTED]>
> I'm not sure xargs will work -- it seems to me that since xargs is
> typically invoked as: 'ls cz* | xargs rm', Nuno is likely to get the same
> arg list too long error. I think the best way to delete the files would
> be: 'find . -name cz\* -exec rm -f {} \;'
Anyone who invokes xargs from "ls *" needs to learn how to use
xargs: feed it with things that ae not affected by the arg
list. For example:
find . -type f -name 'cz*' | xargs rm -f;
is one nice way: the '*' is not expanded on the command line
but used with an internal glob call in find.
Other problem with using ls for large file op's is that it
attempts to sort the output, which is expensive and a memory
hog. Find simply spits out matching files as they are found.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: arg list too long in unix
> I cant list them using ls -ltr *session* as this > string may change. I have to identify the files that > srart with cz only. > > can somebody through somelight on this. man xargs; -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Unix question: how to display SID and path in prompt
-- STEVE OLLIG <[EMAIL PROTECTED]> on 08/27/02 12:23:30 -0800 > but the syntax IS annoying and tedious at best. speaking as a *NIX bigot > who landed a job with a fair share of legacy VMS work that needs doing. > > it really pisses me off when i type SHOW SYSTEM/FULL instead of ps -efl on > my sun box ;) type "sho sys/ful" instead. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix question: how to display SID and path in prompt
-- "Jesse, Rich" <[EMAIL PROTECTED]> > Starting in VMS 7.0 or 7.1 (I forget which), you *can* use pipes: > > $ GREP := SEARCH SYS$PIPE > $ PIPE SHOW SYSTEM | GREP ora_ > > And it gets even better with "SET PROCESS/PARSE=EXTENDED" on the Alphas... > > :) Uncle Kenny's ghost can enjoy them; the rest of us are on *NIX :-) -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Unix question: how to display SID and path in prompt
-- [EMAIL PROTECTED] > Obviously. If you had worked on VMS, why would you want to emulate it? Actually the platform had a number of virtues -- file versions not the least, along with separate system access. DCL itself had some nice features, if they'd only added pipes it would've been equivalent to most *NIX shells w/ the added benefit of lexical var's. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Unix question: how to display SID and path in prompt
-- John Kanagaraj <[EMAIL PROTECTED]>
> Mladen,
>
> Are you confusing this on account of your new-found attraction to the 'go'
> command in MS SQL Server (formerly Sybase and T-SQL)? :-)
>
> I though that 'SET DEFAULT [Dir-name]' was the equivalent of 'cd' in
> VMS...
They have nothing whatsoever to do with each other, mainly
becuase VMS doesn't really have the same notion of "working
directory" that *NIX does.
set def can accept a partial path (e.g., 'dka0:',
'[sys.foobar]', or 'dka0:[sys.foobar].exe'). It takes
whatever you give it as a default for commands which
require a filename and uses them as the default portion
of the name if one is not given (e.g., "del myfile" would
take the device, dir & extension from the default).
You can be working on dka100: and perform a set def dka0:
without effecting the O/S treatment of dka0: -- the
items given to set def needn't even exist since they are
not used until the next time a path is given without that
portion (e.g., you can put in a bogus device w/ valid
directory and not know it until you forget to type the
device).
cd actually changes the O/S' view of your process and
the destination path you give it. Performing a cd across
file systems, for example, will leave the new one unable
to umount; on VMS it wouldn't effect anything. You also
cannot cd to a nonexistant directory.
The two commands feel the same syntatically because you
normally use relative paths after performing them; but the
O/S' treatments are entirely different.
enjoi.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: Unix question: how to display SID and path in prompt
-- "Curiel, David" <[EMAIL PROTECTED]> on 08/26/02 12:03:20 -0800 > Jared Writes: >>> Also be aware that when using backticks in your PS1 variable, you are >>> influencing $? as a result. > >> I don't find that to be true with pdksh - PD KSH v5.2.14 99/07/13.2 And, what's more, you don't need to backtick the stuff during normal operation: the host and username won't normally change and PWD is a reasonable approximation of where you are. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix question: how to display SID and path in prompt
-- Philip Douglass <[EMAIL PROTECTED]> > The substring extraction of $PWD is ksh specific. You could do it other > ways, but this way it uses ksh builtins, so it is _fast_ bash and most recent sh imlementations also support the ksh-style variable munging. bash makes it even simpler by adding escape sequences for PS1: \u = user \h = host \W = basename( $PWD ) \$ = '#' if SU else '$'. so: PS1='\u@\h:\W \$ '; gives username@hostname:dirname $ for normal users or ending with '#' if you are SU. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Unix question: how to display SID and path in prompt
-- "Daiminger, Helmut" <[EMAIL PROTECTED]>
> Hi!
>
> In my .profile of the oracle user (we're mostly using ksh here), I have
> set up the prompt that it gives me the host name and database SID.
>
># always displays host name and Oracle SID as prompt
> PS1="`hostname`;`echo $ORACLE_SID`$ "
>
> How can I extend this prompt to also include the current directory that
> I'm in?
>
> e.g. prod1;PCLDB1; u010/app/oracle/admin/PCLDB1
Back-ticks can be a pain to track, the $() notation in
ksh makes things a bit less error prone. Also, no need
to echo a variable via shell execution if it is available
in the current proc:
PS1="$(hostname):$ORACLE_SID:\$PWD \$ ";
will give you the full path or
PS1="$(hostname:$ORACLE_SID:./\${PWD##*/} \$ ";
will give you the relative path (i.e., $PWD stripped of
any text leading to a '/').
This is equivalent to bash's:
PS1='\h:$ORACLE_SID:\W \$ ';
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: Unix scripting need help
> For example, my files are like these
>
> mylogfile001.log
> mylogfile002.log
>
> I want to initialize my variables with those number, like this
>
> i=1
> for all_file in `ls -1 /tmp`
> do
>
> file$i=all_file
> i=i+1
> done
>
> file_tag1=`unix_command $file1 ` <--- help me here
>
> when I do
>
> echo $file_tag1
>
> it should give me 001
Is your purpose to simply display the numbers or to
generate the maximum in order to start naming new files?
If the latter seriously consider using a timestamp:
i=$(date +%Y%m%d%H%M%S);
this solves all of the math for you automaticlly. A one-
second sleep at the start of your program guarantees that
you will not re-use the names.
To get the digit strings out you could use sed or perl:
i=$( echo $file | sed -e 's/[^0-9]*//g' )
or use perl for the code instead of shell:
for( @ARGV )
{
my ($i ) = /(\d+)/;
Print "File and number: $_, $i\n";
}
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: Unix scripting need help
-- [EMAIL PROTECTED] > echo "$all_file" | sed 's/mylogfile//g' | sed 's/\.log//g echo $file | sed 's/[^0-9]//g' avoids problems if someone decides to add a dash or sometning into the name. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 -more
-- Abdul Aleem <[EMAIL PROTECTED]> > Where can I find the more information on this boundary? Is there any such > limit for Oracle/Linux? Corruption, not that I've seen. Unless you compile the kernel w/ extended memory translation turned on. The default looks something like: CONFIG_NOHIGHMEM=y # CONFIG_HIGHMEM4G is not set # CONFIG_HIGHMEM64G is not set -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Hot Backup using EMC /BCV splits
-- "Ji, Richard" <[EMAIL PROTECTED]> > Maybe my knowledge on EMC/BCV is outdated. But as I remember, for > Hotbackup you don't split BCV for control files and online redo logs as > they are not useable. You have to use the live system's redo's. Because they are opened read+write (this was a bug in Oracle, probably still is) I had to copy them onto the local system and then feed a local filename into svrmgrl. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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:Hot Backup using EMC /BCV splits
-- [EMAIL PROTECTED]
> Nate,
>
> We are using EMC and BCV's each night to create both backups and a
> reporting database. Your SA has it WRONG.
>
> 1) Put all tablespaces in hot backup mode
> 2) sleep 5
> 3) split the bcv
> 4) return tablespaces to normal
>
> The reason that this is important has nothing in the world to do with EMC
> and everything to do with Oracle. Since switching the database files
> into and out of hot backup causes an immediate write to the file headers
> locking or unlocking the SCN. Consequently your backups are inconsistent
> and consequently worthless. The reason is that when you enter hotbackup
> mode all of the file SCN's are frozen giving Oracle a known starting
> point for recovery's sake. By switching back to normal mode the RDBMS
> has no idea of which transactions are in the files and which are not. It
> assumes that it is seeing an instance crash and will only use the on-line
> redo. Your DB will come up, but don't expect it to stay that way, ours
> crashed with "block corruption" 45 minutes later. Believe me, we tried
> it due to a misinformed EMC person(that doesn't happen does it?) & failed.
Problem there is that to get the oracle database that handles
the export back online you have automate a recover until current
(or check the current numbers and do a recover until the number).
Especially if the existing database is running parallel server
and the new one isn't it's a pain.
Also: don't know if it's been cleared up in 9, but we used
go through some gyrations to make the split off copy of the
database use a different network name so that the backup server
didn't come up answering the production database's queries.
Another luvly thing about the recover is that Oracle8 (may have
changed) opens the redo's w/ O_READ | O_WRITE. If the production
system exports them NFS read only (which makes sense to them)
you have to copy the files locally in order to replay them.
Doesn't sound like much but if you are trying to catch up to
a heavily loaded database it can make a big difference.
The attached aren't the prettiest code in the universe but
at least worked.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
##
#
# $Author: lems1 $
# $Date: 1998/11/12 07:06:53 $
# $Revision: 1.8 $
# $Name: $
#
##
package Substandard;
#use strict;
use vars qw( $VERSION @ISA @EXPORT );
require Exporter;
@ISA = qw( Exporter );
# Items to export into callers namespace by default. Note: do not export
# names by default without a very good reason. Use EXPORT_OK instead.
# Do not simply export all your public functions/methods/constants.
@EXPORT = qw();
@EXPORT_OK = qw( send recv chat flush timeout clear_error );
$VERSION = '0.01';
##
use Carp;
use Symbol;
use IPC::Open3;
# dealing with sub-processes requires some kind of boilerplate
# for defunct children. callers can munge this to whatever
# they like. this is pretty minimal but avoids major nasties.
$SIG{PIPE} = sub { print STDERR 'SIGPIPE handled' };
# create a new svrmgrl object
sub new
{
# create anon hash and bless it into the package requested.
my $self = bless {}, shift;
$self->{isopen} = 0;
$self->{usable} = 0;
$self->{error} = 1;
$self->{command} = shift;
return $self unless $self->{command};
# use file descriptors with open3. open3 requires existing symbol table
# entries for the file descriptors.
$self->{fd_write} = gensym();
$self->{fd_read} = gensym();
$self->{fd_err} = gensym();
# fork off the command, opening its stdout, stdin & stderr into the
# file descriptors we hand it. if the pid isn't returned then
# give up.
$self->{error} = 2;
$self->{pid} = open3( $self->{fd_write}, $self->{fd_read}, $self->{fd_err},
$self->{command} );
return $self unless $self->{pid};
$self->{timeout} = 30; # standard timeout for selects
# select requires bit masks for the file descriptors to check. this
# sets up the bit masks for each of the file descriptors returned
# by open3.
$self->{select_write} = $self->{select_read} = $self->{select_err} = '';
vec( $self->{select_write}, fileno($self->{fd_write}), 1 ) = 1;
vec( $self->{select_read}, fileno($self->{fd_read}), 1 ) = 1;
ve
Re: Why use a Unix Pipe to uncompress a file?
-- Pat Howe <[EMAIL PROTECTED]> > I am trying to work thru the one of the scripts that I inherited and I was > wondering if someone could shed some light on why the author used a UNIX > PIPE to uncompress a file. Few reasons: (1) Many file systems blow up w/ files > 2GB, they are a mess in any case. Dumping the output to a pipe avoids the issue, so long as the sqished output is < 2GB. (2) If you dump the output to a flat file then you need the dump space + zip output space. Dumping to a named pipe puts only the squished stuff on media. (3) Saving Truly Large (tm) files to the disk causes much more kernel overhead than spitting the data into a pipe; savings there is time and overhead (leaves more cycles and I/O bandwidth avilable for other proc's running on the box). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 Arm Twisting?
-- Naveen Nahata <[EMAIL PROTECTED]> > Now they say, that this can't be done and the product license will be > terminated if we want this. The thing is that Oracle support is useless(I > get more help from this forum :) ), but we still want it, just in case. Ever heard of "FUD"? That's what Oracle is selling you if you think their support is that bad: fear of not having support that you don't want because you think it's bad. Q: Does anyone know of any reliable 3rd party support for Oracle? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 Arm Twisting?
-- John Weatherman <[EMAIL PROTECTED]> > Keep in mind, you end up having to pay the purchase price again. So > yes, the maint cost goes down, after paying the new inflated setup > cost. We looked at the "let it expire" approach carefully... Let me guess: it worked out nearly even because the jacked up licensing fee just about matched the restart fee? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 Arm Twisting?
-- Naveen Nahata <[EMAIL PROTECTED]> > Maintenance cost is much less to the purchase cost, but how can a company > force us to renew the support contract? I'm ready to live without the > support because I have not implemented a few modules. Does that mean that > either we have to pay the support price till the time we decide to start > using the modules(and every year thereafter too), or will have to buy it > again? Because you have a contract to use the product which states that Oracle can turn off the license if you do not purchase support or a given number of seats. They're Oracle, you're not. You can tell them to get lost and see if they decide to sue you for illegal use of their product; short of that you are stuck with the contract terms unless Oracle is willing to change them for you. That or dump Oracle for another product whose vendor gives you better licensing terms. One reason Open Source software has been catching on is that people get sick of licensing issues. I am not advocating that you dump Oracle for Postgress, but this is a good example of what makes people think twice about using OS when it does meet their needs. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: what is wrong with this idea ...
-- Gurelei <[EMAIL PROTECTED]> > Hi. We have a table in our data warehouse which keeps > info about calls made. This table has a child table > with some detailed information about parts of the > call. There may be any number of "parts" within a call > (1 to many) and every part has a status. > > MY developer wants to add a string field to the parent > table which will concatinate all the statuses for > all the parts within this call. For example if > a call has 4 parts and their statuses are "A","B","A" > and "F", the value of that field will be "ABFA". Then > the developer will be able to query smalle parent > table instead of a large child table in order to see > how many calls had at least one part with status "A" > or statuses "A" and "F" etc by using a INSTR (or > SUBSTR) command. > > Would it be better (from performance/CPU standpoint) > to add several separate fields: STATUS_A_CNT, > STATUS_B_CNT (the list of status codes is fairly > static) instead? There is something about this string > that rubs me the wrong way, but I can't put my finger > on it. I would avoid composite fields at all costs. Performance is one reason: you have to perform a substr to get at the foreign key value. Function indexes can help there but properly normalizing the data will do a better job. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 Arm Twisting?
-- John Weatherman <[EMAIL PROTECTED]> > Naveen, > > I can't say if it's a global policy or not. However in my last life, > we initially purchased ALL modules assuming about 2000 users. We ended > up with only a handful being implemented and closer to 600 users. Oracle > pulled the same "you can't reduce licensing" stunt with us. Of course > I'm sure they will be happy to sell you more licenses the second they > think you have 1 extra user. In general, its probably best to always > get the absolute minimum number of licenses you think you can get by > with. > > Sorry I can't be more encouraging, Cancel the contract and renew it with a different number of users. Once the old contract has expired and is no longer in force you are not "changing" the number of users since it is a new contract. It may be that playing hardball is the only way to get their attention. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Perl and Oracle
> though the only browser that appears to > be a problem is IE. Any known fixes (before I have Windophiles complain to me that the stuff is useless)? If not I'll just tell them to use Opera. > If you download the toolkit, be *sure* to read the README files. Egads you ARE a dreamer! -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: It took more than an hour to update 10,000 records
-- "Nguyen, David M" <[EMAIL PROTECTED]> > Hi all, > > I write a script to update 10,000 records in my database and noticed it > took more than an hour to update 10,000 records. The script just > includes 10,000 SQL update commands as shown below. Is the time too long > to update 10,000 records? Is it a way to improve the update task to run > faster. Please advise. > > *** A portion of my update script is shown below: > > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = > 201 and lata_id = 224; > > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = > 201 and lata_id = 224; If the table is 15TB it might actually be rather fast; might also be really good if the database were being restored at the time. Lacking any other info there is no way to tell. Have you tried generating an explain plan for one of them? Does the seem reasonable to you? How about using a language that supports place holders (e.g., DBI) or turning on cursor sharing so that the optimizer isn't called for each iteration? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 vs. DB2
One thing that seems different to me: DBA's at the sites we work in with DB2 seem to swear by it more than at it. This is the reverse ratio I find at Oracle houses. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 vs. DB2
-- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> on 08/12/02 14:38:19 -0800 > Hi Everyone! > > Well, there's been a lot of Oracle vs. Microsoft traffic on the > list, but now my Manglement wants a similar comparison to IBM's > DB2. > > Does anyone know of web sites or locations where there are > documented objective comparisons between Oracle and DB2? I'm > faced with answering buzzwords like 'Future Market Position', > 'T.C.O. - Cost Effectiveness', 'Demonstrated Technology', and > 'Platform Compatibility'. www.ibm.com -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 a Directory Across File Systems -- Unix
-- Debra Ruggerie <[EMAIL PROTECTED]> on 08/09/02 15:23:19 -0800 > I need to free about 600 MB of space on a Unix file system so that I can > create an export dump file of a database. Our sys admin is out of the > office and I am trying to move a directory (it contains sub-directories) > across file systems. According to the manual I have, mvdir only works > within a file system; and I cannot find a command to copy a directory. Is > there a way to do this?? kwikhak: cd $srcdir; ls -ld $destdir; # convince yourself it exists. find . | cpio -pdv $destdir; . -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix Script Quest : Urgent
> Is there a way to capture all files hit by a process/user in unix (Sun > Solaris 9, ksh)? I am seeing an OCI file not found on my production box. > I can't resovle it. > So, I want to run the same process on my development box (where it works) > and get a list of files that it is hitting (I can grep by username) for > comparison in production. Only I am definitely NOT the Unix guru and as > this is for a prod issue, so my time is very limited. > Thanks in advance, touch BEFORE; ... find $wherever -newer ./BEFORE; will give you a list of files that have changed since the BEFORE file. If you are sure that the files are being created (vs. modified or accessed) by one specific userid then: find / -newer BEFORE -user will work also. If you are going to run the thing regularly then take a look at "find2p", which will spit out a perl script to match your find command. The perly code will give you finer control and better sanity checks (e.g., comparing to a list in memory of what has already been found to avoid dup's) than find can. enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: LINUX and Oracle Corp.
-- "Cabansay, Yoyong" <[EMAIL PROTECTED]> on 08/01/02 02:19:10 -0800 > regarding the above topic but on a different note, anyone here on the > list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux > on the middle tier? problems encountered? gotchas? stories to tell. we > are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: UNIX Q: How do I delete files beginning with #
-- Ross Collado <[EMAIL PROTECTED]> on 07/31/02 20:33:22 -0800 > Hi, > I have files like: ># Column ># This ># > > How do I get rid of these 3? escape/quote the char's: rm -f "./# Column"; or, if you use bash, the tab key is rather helpful for this. simplest fix may be to: cd $somedir/..; mkdir _$somedir; mv $somedir/[a-zA-Z0-9_]* _$somedir; rm -rf $somedir; mv _$someidr $somedir; that is: make a scratch directory, fry the original one, and then move the scratch directory in place. This also helps to shrink an over-large directory that may have been populated with large numbers of junk files. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix Q: ksh scripting
># !/bin/ksh ># set -x > sqlplus / < select sysdate from dual; > exit > EOF | tail -1 The close needs to be on a line by itself: ( foo <<- BAR stuff here BAR ) | tail -1; will do what you want. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 on Linux ..... Red Hat vs. Suse
-- Christopher Royce <[EMAIL PROTECTED]> on 07/22/02 08:53:32 -0800 > Have been unable to arrive at a definitive position There isn't one. There are tradeoffs between the two distro's. Most of it comes down to which one you are more comfortable with or which one does more things (including the installation) that you cannot fathom. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Your password! It's S New Worm W32/Frethem.K@mm
-- "Eric D. Pierce" <[EMAIL PROTECTED]> on 07/16/02 09:38:38 -0800 > MS security Oxymoron? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OT - unix vs linux vs windows - the future
-- "Orr, Steve" <[EMAIL PROTECTED]> on 07/16/02 08:09:23 -0800 > I'm impressed because I'm of the same persuasion but I'm not quite so > pious/zealous and am still somewhat enslaved to the M$ beast/devil because > of the company usage of Exchange with MS Outlook for Calendar and workflow. > I run Linux on the laptop via VMWare but because of the Outlook dependency, > running Pine, Mozilla or whatever is not a viable email solution for me. > Sigh... Try it the other way around and you get better performance: run VMWare on linux w/ W2K on the VM. Linux does a better job at multi-tasking and samba works wonderfully for file sharing. Add in a touch of portforwarding and a dash of NAT and it comes out fairly tasty.. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OT - unix vs linux vs windows - the future
-- Andrey Bronfin <[EMAIL PROTECTED]> on 07/15/02 07:33:33 -0800 > "Good bet that smaller Unix vendors will run to Linux before vendors like > Sun do." > Not exactly , just look at homepages of sun , ibm , oracle . > There are more appearences of the word "linux" there than any word in > Britannica ;-) Sun doesn't like Linux all that much, they want folks to use Solaris. HP and IBM's *nix are hacks of API calls over older proprietary operating systems and both of them would be happy to dump HP-UX and AIX forever. Net result: HP and IBM are on the bandwagon, Sun is recitent about horking linux too hard for fear of making Solaris look less than perfect. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 on Linux ... Production Strength ???
-- Ray Stell <[EMAIL PROTECTED]> on 07/15/02 06:38:28 -0800 > The support matrix at metalink includes other distributions, > and does not include RH7.2, only the antique 7.1. I have > to conclude that the ora/rh honeymoon is over. They did > just add Red Hat 2.1 Advanced Server to the 9i matrix, so > maybe it's back on again. Sure wish they would pick up > RH7.2. Not a "honeymoon" issue, just that Linux progresses much faster than most product vendors are used to. If you look at the number of O/S and distro releases on Linux systems compared to, say, Solaris or HP-UX it's about 5-10x higher. The folks are Oracle simply aren't used to qualifying their product that often -- and may consider RH 7.X to be a generic platform. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 on Linux ... Production Strength ???
-- "James J. Morrow" <[EMAIL PROTECTED]> on 07/13/02 21:08:18 -0800 > By thw way, my preferred Distro is Mandrake. (Bear in mind that RedHat was > [and may still be] compiled to run on an 80386. Most modern CPU's have > additional features that you have to compile your software to use. Mandrake, > on the other hand, is pre-compiled for a Pentium.) [NOTE: you can always > re-compile the operating system binaries to run on a different type of CPU > with either Distro.] One of the reasons that RH now tkaes up 3 CD's is the collection of x86 platforms it supports. If Oracle doesn't claim to not support Mandrake then you might be able to get away with it; otherwise you're likley to get the Not Certified Here response and told to back off to RH 7.X. Upgrading the kernel is always a good idea since the RH distro's are multpiple rev's behind and you don't need every one of the modules they build for every system on the planet. That will give you most of the speed advantage, since you're stuck with whatever compilation Oracle gives you on its binaries anyway. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 on Linux ... Production Strength ???
> We are considering both Red Hat and Suse distributions. We have discovered > that regardless of the Linux distribution support is generally > expensive. That is not a particularly 'deal breaker' determining factor .. > BUT .. I question the quality of support, the expediency of response and the > 'sense of urgency' experienced in the event of a critical application being > down. I am familiar with limited Oracle-Linux implementations but not to the > 'industrial strength' degree that has been proposed (but already > implemented) by our requesting user community. The prices for 7x24 support are roughly the same for linux and Solaris, HP-UX, or AIX. One other option is to buy the linux from IBM, with support. IBM seriously wants linux to succeed on thier platforms and has good support. Linux Care and Cygnus (now part of Red Hat) have been dealing with mission-critical systems for some time and are capable of fixing things. Obviously, setting up the system in a supportable fashion (e.g., supported hardware, up to date drivers) will get you better response times. > Is there a preferred distribution Sure: Red Hat preferrs that you buy theirs, SuSE wants your money also. Beyond that the kernel -- a.k.a., "linux" -- is something you download from the net and compile locally. It has relatively little effect on the difference between distributions. The real distinctions are in SysAdmin tools and the installation. Most of it is a purely religious issue, all you can really do is set up a few machines and try them. So far as I know HP and IBM are both going with Red Hat as their base distro's and Oracle only supports Red Hat so that is probably what you'll end up with. Eyeball the available support contracts to be sure. The net result will depend heavily on the hardware you're running. For serious databases X86 platforms don't work well because of hardware limitations. You are probably better off looking at the hardware first and then finding out which software vendor is supported (probably Red Hat for HP or IBM systems). > My initial implementation is Suse 7.2 Enterprise on an IBM NetFinity, 4 cpu, > 2 Gbyte (memory) server using a Net Appliance Filer. There are six instances > currently up and running. Thus far there have been no occurrences of > swapping or i/o bottlenecks but then the system has yet to be fully > 'stressed' and there are scalability concerns. The USER also wants to put > Oracle 9iAS on the same box - I have managed to delay that for now, pending > further research. I have had a couple of worrying episodes where a file > system 'filled up' (on the Filer) that completely 'hung' the system > requiring a full system re-boot. Incidentally the aforementioned NetFinity > implementation is 'a given' as the six instances have already been migrated > from an aged and de-commissioned HP system. I have inherited the results and > there is no going back at this juncture. What file system are you running? Are you using LVM? devfs? A full system lockup in this case seems suspicious. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Looking for a few good...
Have you read An Introduction to Database Systems, C.J. Date Nth edition (I lost track around #8)? Best place to start that I know of. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Perl Question - Split using |
-- Celine John <[EMAIL PROTECTED]> on 07/05/02 06:43:25 -0800 > After seeing the e-mails about "Perl for Oracle-DBAs", > I presume, my question wouldn't be completely > inappropriate for this list. > So if you Oracle Gurus, can help me with this Perl > problem, I would greatly appreciate it. > I have a problem with "split" when my delimiter is > "|". > I know that if I escape the pipe, split should work, > that is only when it is a literal like > split(/\|/, "abc|def|123) > > But when my delimiter is to be dynamically read from a > file, I have it in a variable. Then this escaping > stuff doesn't work.. > eg: > my $HeaderAttributes = "abc|defgh|123"; > print "$HeaderAttributes\n"; > my $Delimiter = "\|"; > (@Fields) = split(/$Delimiter/, $HeaderAttributes); > print "Delimiter = $Delimiter Field[0] = > $Fields[0]\n"; Look up the '\Q' metachar (e.g., perldoc perlre and search for \Q). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix - scheduling - I know this, it's a UNIX system
-- [EMAIL PROTECTED] on 07/03/02 14:13:30 -0800 > > This will run the job every 28 daze at 1am. If that's not exactly the > definition of every 4th week let me know and I'll work something out. Also > note that you will have an anomaly at the end of leap years. > > > 0 1 * * * /usr/bin/ksh -c '[ $(($(date '+\%j') \% 28)) -eq 0 ] && > /path/to/my/job/the_job' %j day of year (001..366) Two problems are not adjusting the initial start date (simple enough, adding a constant) and 365 % 28 != 0. The last will give you an extended period once per year. The only reliable way to handle this requries gnu date, which has %s == system time in GMT: [ $(( ($(date +%s) + $INITIAL_DATE_OFFSET) % 2419200 )) -eq 0 ] && /blah; Is a bit grimy but works. The wallclock time may shift slightly during the DST correction but the basic interval works. The one-second resolution can cause problems if crond doesn't run exactly on the minute; this can be corrected by taking the integer portion after dividing by 60 and comparing that. At which point it's better to give up on cron entirely and use at, which does all of this mess for you and handles cron outages also (which the above doesn't). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix - scheduling
> > It does not work on Solaris 8. SunOS (a.k.a. BSD) used vixiecron; they dumped it when "Solaris" went SVR4. You can still find workable copies of Paul's original work (pretty ancient by now). Alternative it to use perl with Schedule::Cron to process the lines. It understands */X notation and passes the entire line to whatever dispatcher you choose -- which can interpret the rest of your cron line as whatever it likes. For example: * */24 * * * */28 /path/to/code Would check for the 28th day ever 24 hours :-) Probably the best bet for something like this is at, however, since it remembers the date + time that the event was scheduled for. This allows re-starting cron any number of times w/o resetting the start date used by at. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix - scheduling
-- "Hand, Michael T" <[EMAIL PROTECTED]> on 07/02/02 08:13:32 -0800 > Roland, > crontab alone will not meet your needs. Hint: check the date command and > MOD type fuctionality in a shell script. The at command will normally take "number of days from now" as the when to run argument. Simply have the job re-submit itself and output an error message if at returns non-zero. This will give you one-minute resolution on the start times with arbitrary re-run intervals as required for you program (in this case, 14 or 28 days). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix - scheduling
-- Ron Thomas <[EMAIL PROTECTED]> on 07/02/02 09:03:26 -0800 > >> 0 */4 * * * your_command > > The */4 must be linux. This is not available on HP-UX 11.0. Introduced by Paul Vixie into vixiecron, subsequently adopted by a number of cron implementations. HP's is, unfortunately, not one of them. Sun's might, AIX doesn't. The Schedule::Cron module does support this notation, along with adding any other extenders you like since you can have your own dispatcher. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix - scheduling
-- Nils Höglund <[EMAIL PROTECTED]> on 07/02/02 03:28:20 -0800 > 0 */4 * * * your_command $ man 5 cronttab; The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 1-31 month 1-12 (or names, see below) day of week0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. Ranges of numbers are allowed. Ranges are two numbers separated with a hyphen. The specified range is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11. Lists are allowed. A list is a set of numbers (or ranges) separated by commas. Examples: ``1,2,5,9'', ``0-4,8-12''. : Question: how does "0 */4 * * *" cause something to run every 4 weeks? Unless your version has a different field order. It might work to try "* */628 * * *" but I'm not sure that cron allows n>24 for the hourly divisor. The combination of date and weekday can approximate the 4-week cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix - scheduling
-- [EMAIL PROTECTED] on 07/02/02 00:43:19 -0800 > Hallo, > > anyone who has a good example on how to write in the crontab if you want to > schedule a job to run every four week. Is it possible to do that in unix cron > job schedule. "Monthly" is doable. "Every 28 days" requires using at, or a more flexable scheduling tool. That or cron the job daily and have it decide whether 28 days have passed since it last ran (e.g., based on a time string stored in a file). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Establishing policies, standard operating procedures, and
-- "Browning, Alan" <[EMAIL PROTECTED]> >> Can someone please point me to in the right direction? >> >> We need to establish policies, standard operating procedures, >> and responsibilities for our Oracle DBA and Sun Unix Admin. >> >> Is there any literature that outline typical practices on how to divide >> systems and database administration responsibilities? >> SAGE has some useful guidelines for these things. Also might want to check the UNIX Sys. Admin. Handbook (Nemeth, et al), 3rd Ed. under "Politics" at the end for good examples. <http://opamp.com/cf/title.cfm?SRow=1&Title=Unix+System+Administration+Hand book&Author=Nemeth> -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: MySQL versus Oracle
-- "Orr, Steve" <[EMAIL PROTECTED]> on 05/31/02 14:14:20 -0800 > fastest growing database so someday they may be standards compliant. h... people used to say that about Oracle. Fat lot of good it did us... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: MySQL versus Oracle
-- "Weaver, Walt" <[EMAIL PROTECTED]> on 05/31/02 13:59:22 -0800 > If there's only one user accessing it, yes. > > --Walt > > -Original Message- > Sent: Friday, May 31, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > a) It's blindingly fast as a single user database, faster then oracle. > > Really? Even with a 30 million record table? Depends on what they are doing. MySQL doesn't claim to be ACID, just fast. If multiple users are reading a table that isn't configured for locks then it could be faster than Oracle. The overhead and complexity introducted into Oracle by rollback handling is a major slowdown for anythng the database does. This is mainly a matter of applying a tool in the way it was designed to be used. MySQL is intended for primarily read- access databases or smaller ones where the less granular locking is not so much of a problem. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: partition tables
-- paquette stephane <[EMAIL PROTECTED]> > You can use insert select , export/import, create as > select to move data from a non-partitionned to a > partitionned table. > > Partitionning helps in the management of large tables > more than in speeding the queries. > Will you delete data from that table one day ? > Choose the partition key carefully. > > A partition with only 100 000 rows is pretty small. > Since you have 10 000 000 rows in your table, you will > have 100 partitions of 100 000 rows, it's way too many > small partitions. Depends on the use. If they have many queries for which indexes don't help then locally managed part's w/ table scans in parallel server might help. It also depends on their unit of rolloff. In a near-realtime system being able to offline/truncate a small partition every 3 minutes can be a big help. I've dealt with databases that had houly partitions for 7 days (though with more rows than this, the count of partitions helped). A lot of it comes down to how the primary key breaks down and how granular the rolloff needs to be. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: joining word/ lines in a file
-- Suhen Pather <[EMAIL PROTECTED]> > Hey this is a not a trick question, without buying the books > listed below is there a way using the std awk, sed, tr *nix > utilities. Perl is going to be the simplest since it has a regex for whitespace and you can easily change the input record specifier (undef $/ for slurp mode). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: joining word/ lines in a file
-- Jared Still <[EMAIL PROTECTED]> > If isn't perfect. An 'and' at the end of the line will be joined with > the beginning of the next line, which is not right. Don't strip the newlines, replace them with white space: perl -e 'undef $/; ($a=) =~ s/\n+/ /g; print $a' \ [file [file...]] [) =~ s/\n+/ /g;s/ +/ /g;print $a' ... will convert nearly anything you can give it into a nice, clean, single line. If you want to get things neater than this see the examples in Parse::RecDescent. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: joining word/ lines in a file
oops, wrong direction -- you wanted to take out the newlines.
use chomp and print the resulting array with $, left at the
default value:
$ perl -e 'chomp (my @a = <>); print @a' myfile [anotherfile ...];
i.e., read from ARGV, put it all in an array, slice off the
input record separators; print the array.
-- Suhen Pather <[EMAIL PROTECTED]>
> List, slightly off topic but
>
> Unix OS
>
> I need to join lines/ words in a file.
> So that it must be in a readable Oracle format.
>
> They are seperated by a newline.
>
> Here is a snippet of what the file looks like.
>
> FILE1
>
> delete from JDAPROD.HBI_LOST_SALES where SKU_TECHNICAL_KEY = 1410 and
> STORE_TECH
> NICAL_KEY = 276 and STORE_NO = 315 and STORE_NAME = 'Glenfield SB 315
> ' and SKU = '1516803' and SKU_NAME = 'WMERE ORGAN
> ISER Black ' and DEPT = '052' and DEPT_N
> AME = 'Travel Bags' and CLASS = '05211
> ' and CLASS_NAME = 'Travel Bags' a
> nd FORMAT_EXISTS = 'Y' and STOCK_ON_HAND = 2 and STOCK_IN_WAREHOUSE = 433
> and RE
> QUESTED_UNITS = 0 and ALLOCATED_UNITS = 0 and UNIT_SALES_CURRENT_DAY = 0
> and UNI
> T_SALES_LAST_7_DAYS = 0 and UNIT_SALES_LAST_6_WEEKS = 2 and ON_HAND_COST =
> 41.23
> 7 and ON_HAND_RETL = 167.333 and GROUP_NO = '05 ' and GROUP_NAME = '
> Travel' and EST_STOCK = 0 and INTRANSIT = 2 and DATE_RUN =
> TO_DATE('27MAY2002
> 00:00:00', 'DDMON HH24:MI:SS') and ON_ORDER = 150;
>
> I am trying using sed but cant seem to work it out.
>
> Any Ideas?
>
> Regards
> Suhen
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suhen Pather
> 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).
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: joining word/ lines in a file
$ perl -e 'print join "\n", <>' myfile;
-- Suhen Pather <[EMAIL PROTECTED]>
> List, slightly off topic but
>
> Unix OS
>
> I need to join lines/ words in a file.
> So that it must be in a readable Oracle format.
>
> They are seperated by a newline.
>
> Here is a snippet of what the file looks like.
>
> FILE1
>
> delete from JDAPROD.HBI_LOST_SALES where SKU_TECHNICAL_KEY = 1410 and
> STORE_TECH
> NICAL_KEY = 276 and STORE_NO = 315 and STORE_NAME = 'Glenfield SB 315
> ' and SKU = '1516803' and SKU_NAME = 'WMERE ORGAN
> ISER Black ' and DEPT = '052' and DEPT_N
> AME = 'Travel Bags' and CLASS = '05211
> ' and CLASS_NAME = 'Travel Bags' a
> nd FORMAT_EXISTS = 'Y' and STOCK_ON_HAND = 2 and STOCK_IN_WAREHOUSE = 433
> and RE
> QUESTED_UNITS = 0 and ALLOCATED_UNITS = 0 and UNIT_SALES_CURRENT_DAY = 0
> and UNI
> T_SALES_LAST_7_DAYS = 0 and UNIT_SALES_LAST_6_WEEKS = 2 and ON_HAND_COST =
> 41.23
> 7 and ON_HAND_RETL = 167.333 and GROUP_NO = '05 ' and GROUP_NAME = '
> Travel' and EST_STOCK = 0 and INTRANSIT = 2 and DATE_RUN =
> TO_DATE('27MAY2002
> 00:00:00', 'DDMON HH24:MI:SS') and ON_ORDER = 150;
>
> I am trying using sed but cant seem to work it out.
>
> Any Ideas?
>
> Regards
> Suhen
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suhen Pather
> 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).
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: so when did you switch from NT to unix for oracle
> Should a company be willing to spend a comparable amount annually with > their Linux provider and their hardware provider that they would give to > (for instance) Sun Support, I believe they could easily achieve > comparable levels of hardware and software reliability than any other > commercial unix. Perhaps an extreme example, but the NIH/CDC's recently signed the papers on a supercomputer for the Seattle lab. The box has 1000+ Intel It. procssors, 1.8Tb of core (no typo: Tera) and runs linux. For $23M you can have one too :-) The fact that people are using linux for something this heavy duty is interesting. The main reasons for choosing the O/S were scaleability, reliability, and support. Similar results came up from the DoD's recent software audit: they got better results for many app's from open source code than proprietary -- Billy wan't pleased in the least. Regardless of *NIX debates, linux is proving out as a nice, stable platform for cheap, reliable federated systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: RedHat
-- Santosh Varma <[EMAIL PROTECTED]> > I wanted to know what is this RedHat, its significance and its features. > Any links/doc's on that ??? It is the most common "corporate" Linux distribution out there. The people at RH worked with Oracle, IBM, Sybase, and other package vendors to help them port their various products to linux. Net result is that RH is the "standard" distro for most packages to be vetted on for linux. The distribution has some tradeoffs. It is generally easier to manage than the others but doesn't match Mandrake for capacity to locate and correctly configure new equipment. If you need speed, Mandrake is probably a better bet. Information on linux in general and the varous distro's are available at www.linux.org, www.redhat.com, www.tummy.com, or under varous points on your favorite search engine. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Storing phone info...
-- Suzy Vordos <[EMAIL PROTECTED]> > > > Curious how people are storing phone info in their database, eg., > separate columns for country code, city code, area code, etc. Any > references about this would be appreciated! Useful for fast scans by a/c or prefix. Depends on the use. Indexes on these are usually a waste (not specific enough) but for a count(*) by a/c it beats having to substr the entire thing. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Do you ever have days where you dont want to think ?
-- "Kirsh, Gary" <[EMAIL PROTECTED]> > It's not using the index because of the NOT IN - it doesn't help to search > an index to see what's NOT in it. Did you try rewriting it to use a NOT > EXISTS instead? Which can quickly degenerate into a tablescan also... even if the index exists if the entropy isn't high enough oracle will skip it anyway. Try an analyze table first on the exists (or a sub-query) and see how that works. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: offtopic - unix command
-- [EMAIL PROTECTED]
>
> Haven't used rsh in many many moons (ssh is the correct way these daze),
> and I have no way to test this but maybe it will work.
>
> RTN=$(rsh otherbox "mycmd parm1 parm2 ; [ ${?} -eq 0 ] && echo OKAY ||
> echo FAILED")
> if echo ${RTN} | grep OKAY 1>/dev/null 2>&1
> then
> echo GOOD
> else
> echo BAD
> fi
>
> Another option for the first line might be:
>
> RTN=$(rsh otherbox "if mycmd parm1 parm2
> then
> echo OKAY
> else
> echo FAILED
> fi
> )
>
> And even another option for the first line is:
>
> RTN=$(rsh otherbox "[ mycmd parm1 parm2 ] && echo OKAY || echo FAILED")
These will work but depend on shell-specific syntax. Using
a #! file on the remote end is a bit safer and allows for
comments in the code.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: offtopic - unix command
-- Bill Becker <[EMAIL PROTECTED]> > But what if command blah does not output anything? In this > case, $a is null, as it is when the command fails. Either: Look for a success message and change the sense of the test. Run the remote command in verbose mode. Wrap the remote command in something that does output a reasonable message (or re-write it to do so if you have any control). If the command has neither verbose mode nor any useful messages by default then give its programmer 30 lashes w/ a wet noodle for designing undecipherable code. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Need Script to Trigger Archive Log Cleanups
> I need a routine which removes archive logs via RMAN tape backups if the
> archive log destination exceeds half full. I already have the RMAN part
> which we can kick off manually but I'm looking for something like a basic
> cron job monitoring script which triggers this based on the half full
> condition. Before I get started on this, does anyone have a script like
> this which they'd be willing to share? I figured I'd do a df with awk or
> Perl... but I'd rather just piggyback on someone else' fine script. :-)
>
> Other ideas?
Simple enough to do in perl with a regex:
my $mountpoint = "/some/dir";
my $cutoff = 50;
my ($used) = qx( df $mountpoint ) =~ /(\d+)%/;
if( $used > $cutoff )
{
print "$$: Disk use on $mountpoint: $used > $cutoff";
# whatever you want down here
}
else
{
print "$$: $mountpoint below $cutoff";
}
For multiple mountpoints iterate on df:
my @mountz = qw( /foo /bar /bletch );
my $cutoff = 50;
my @overz =
map
{
my ($used, $dir) = /(\d+)%\s+(.+)/;
$used > $cutoff ? $dir : ()
}
qx( df @mountz );
for my $dir ( @overz )
{
print "$$: Cleaning up $dir...";
# whatever
}
the map combines the extraction with a grep to remove
items that are blow the threshold. @overz is syntatic
sugar, since the map could have cleaned everything up
for itself:
my @roadkill =
map
{
my( $u, $d ) = /(\d+)%\s+(.+)/;
if( $u > $cutoff )
{
# cleanup $d...
eval{ blah blah };
$@ ? $@ : ()
}
}
qx( df @mountz );
print STDERR "$$: Bad news, boss, cleanups failed:", @roadkill
if( @roadkill );
The eval leaves any messages from "die" in $@, which then
get passed up to @roadkill. That or pass on a "was clean"
message and change the array to "@results" or something.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
diskfrie
Description: Binary data
Re: offtopic - unix command
> Is there a way to check for the success/failure of the actual remote > command when using rsh? $a=$(rsh blah); and parse $a for output for an indication of the blah command succeeding or failing. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Compressing Export Dumps
>> If you are on Unix, you can pipe the export into a "split" command and >> break the file into multiples and compress on the fly. There's a note on >> metalink about it (note 30528.1) Easier of you split the zipped result: mknod /tmp/dump p; gzip --fast < /tmp/dump | split -b $((1024*1024*1024)) date +"dump-%Y%m%d"; Gives a set of 1GB files as output. Simpler to manage since they all have the same size (whatever you set -b to) w/ a runt file at the end. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: News.
>> So how big a market share does DB2 itself command? They don't say.
>> Big
>> deal, so IBM-Informix have slightly more market share than Oracle.
>> If
>> Oracle had bought Informix the shoe would be on the other foot.
>> Again, big
>> deal!
What's news is that a few years ago many pundits had written
DB2 off for dead and decided that Oracle was The Thing. If
IBM is creeping up on Oracle it generally means that IBM has
reversed a significant trend -- and probably that Oracle has
blown a good thing.
The numbers are also interesting because new license revenue
is a good indicator of who is switching over or starting up
new systems with the product. Oracle's being behind in new
licensing bodes ill for them in the next few years as they
loose the ongoing licensing and support fees. It also hurts
when selling to suits because the product has less "momentum"
and IBM will certianly be telling everyone about how well they
have turned DB2 around.
It's also vindication of sorts for commercial linux vendors,
since IBM is now doing their best to hork linux on anyone
that'll listen and is doing a rather nice job of integrating
DB2 into linux platforms. This helps give the suits something
solid that runs on linux, backed by Big Blue and does their
jobs well. Uncle Larry, on the other hand, is mercurical
enough that noone really trusts his "vision" of linux taking
over the corporation; IBM the suits are willing to trust on
this one.
It's also good news for data warehousing in general, since
Red Brick may become a product again; which would be good for
linux since it tends to make a nice data warehousing platform
(on the right hardware). This will give people a choice, at
least, and save us from having Oracle shoved up our snoots
for tasks it does poorly just becuase it's Oracle.
I'm certianly not going to run around in the streets naked
celebrating over the news [for which my neighbors are lucky]
but it is worth noting and is probably pleasant news for most
of us.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: Telephone Alerts
-- "FOX, Simon" <[EMAIL PROTECTED]>
> We have some UNIX batch processes that send us e-mails when they have
> finished.
>
> Does anyone have any experience of sending a SMS message to a mobile
> phone?
See the last issue of The Perl Journal ("TPJ") for a good
article on using the SMS module for sending things.
Other approach is to use an email account and MIME::Lite to
send the messages. Given the addresses you can phone, page,
or just mail people. Trick is to keep the message short
(e.g., "Call Jow Bloe +1 234 567 8900\n\nfoobar database has blah\n").
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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 warehousing desing - to denormalize or not to denormaliz
-- Henry Poras <[EMAIL PROTECTED]> >> From what I remember, one of the main advantages of a normalized >> database is > a certain level of data integrity and flexibility. The integrity comes > from foreign keys, lack of duplicate data, and generally a data design > based on characteristics of the data. The flexibility comes from the > ablility to query in many different ways (you are not restricted as you > are in a heirarchical db). Though I have never designed a data warehouse, > I always thought that the integrety piece would be less of an issue. > Since there are very few writes to a warehouse, there is less chance to > fowl up the data integrity as long as there are good controls on the > load. Flexibility on querying a warehouse seems to also be possible using > other design methods (fact tables, snowflake, ...) Basic warehouse operations use an offline update with read-only access to users. The offline update allows for complete validation before the data is used (in theory at least), which makes foreign keys less important for maintaing consistency. The normal ETL cycle is usually designed to reject data with missing keys in the transform cycle anyway -- usually by placing the offending items in a reject que for later analysis. Avoiding snowflakes makes any foreign key issues moot in the dimensions: the ETL cycle will either merge the data successfully or reject it. The fact table is mostly key in the first place, with a small amount of data hung off the side. Inserting the record requires pre-merging all of the key information also, so at insert time the records should be valid (or the ETL code reworked). An RDBMS allows the same queries in both a star or 3rd (or BCD) normal form. The difference is that a star schema is much simpler to query since the joins are only 1-2 levels deep (dims:fact or dim:fact:dim is as far as it goes). The joins tend to be faster also since indexes are 1:1, the dim's are shorter tables and the fact is "narrow" enough that they don't require excessive I/O to process down their length. In most cases a synthetic integer key is used for the dim's also. This is partly done to keep the fact table narrow, since most of it is the composite key for each fact. This tends to help indexes also. Depending on the database, joining dimensions across the fact table is also more effecient. Red Brick was the first with their "star index", which basically pre-joins the dimension and fact records at load time. Informix and DB2 picked up the technology by purchasing RB and Informix; Oracle is currently working on a similar concept (I think). This basically trades off a fairly expensive operation done once at load time for read effeciency. This works in a warehousing environment where the ETL cycle can pre-sort records for better load speed and the loads happen offline on basically a dedicated system. After that read effeciency is the only thing going, noone cares about update speed until tomorrows load -- at which point they don't really care about user effeciency for a while. The cycle works pretty well in most cases, the biggest problem being the management of rollof. If the data can be segmented in "rollof units" (e.g., time buckets) then the process is simple. In Oracle, for example, with locally managed partitions you can offline, truncate and drop them without any real pain. If the unit of partitioning isn't the unit of rollof -- not hard since the primary key has to start with the partitioning field in nearly all cases -- then you end up having to perform deletes. THAT can be a Real, True Pain (tm) on a 3-4 TByte warehouse. It's even worse in cases where the rollof units are not uniformly distributed, in which case Oracle will have to perform a table scan to find the records. In most cases the simplest fix it to force the rollof value into the primary key and be done with it, hopefully that doesn't screw up the database. Data marting helps this in some ways, since the ETL process can pre-generate the aggregates required for marting. In that case a smaller database gets updated with a smaller load each cycle and can usually be placed online quicker. The marts can also hold data longer without degrading performance, so their rollof cycles tend to be longer. Many databases will have pre-aggregated data prepared for drilldowns already loaded into the fact table (this is a requirement of some querying tools). In that case the "rollof" procedure consists of deleting the more detailed period records (say daily totals) on a monthly basis, leving monthly aggregate values online for perhaps 24 months. The delete cycle is less painful in a -- much smaller -- data mart than the whole warehouse and leaves users able to make the buisness-cycle queries they need. -- Steven Lembark 2930 W. Palmer Workhorse Computing
Re: data warehousing desing - to denormalize or not to denormalize -
-- Gurelei <[EMAIL PROTECTED]> on 05/10/02 12:13:27 -0800 > Jared, > > Thanks for the answer. I must admit my ignorance in > terminology as for me data warehouse and data mart a > pretty much the same thing except for size. I > understand that data mart is smaller. The database I'm > referring to could probably be described as data mart > as it is going to be rather small - a gig or so maybe. "Data Mart" == summarized data from a Warehouse used to speed up query times. Main point to a mart is that by pre-aggregating the data the volume (and keyspace) are reduced. Mart's acutally increase total storage becuase they store the data more than once (Warehouse + agg'd into the Mart). Advantage is speed for the 90% of all queries that use agg'd data in the first place. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 warehousing desing - to denormalize or not to denormalize -
-- Gurelei <[EMAIL PROTECTED]> on 05/10/02 10:43:23 -0800 > Hi. > > We are designing a small database using a data > warehousing desing. We have created a 3rd normal form > and are now debating whether and how to denormalize > it. I see the pluses of denormalization - easier > queries creation and tuning. What are the > disadvantages that we should be aware of? Wasted space > is not an issue because the tables a pretty small. > What else should we consider as a potential issue? Oracle was designed (and still is) an OLTP tool. It doesn't do very well with fully denormalized data. Wasted space is only one problem, bloated indexes are another. You can also end up with indexes that lack enough entropy for general use due to repatition, leaving you better off with table scans in most cases. For a small(ish) database there may not be any real difference between a snowflake and star schema, but databases tend to grow. Every time I've dealt with any denormalized schemas in Oracle they have performed poorly (or crashed). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix questions - Please advice
-- Tim Gorman <[EMAIL PROTECTED]>
> find -name "MATERIAL.*" -mtime +30 -exec rm -f {} \;
Main problem with this is forkatosis if there are too many
files. Using xargs breaks the rm's up into fewer proc's
and tends to run faster since the rm command can access
top-level dir's a single time for authentication -- a big
timesaver on networked file systems or ones with advanced
security hacks.
You can also run xargs w/ multiple proc's, which allows the
latency of one proc's to be used up on another (see the
--max-proc option to gnu xargs for an example).
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: Unix questions - Please advice
> In my unix system (hp ux 10.20) I have one particular > file will be generated from some applications every > day. > > File name "MATERIAL.20020508225043" > > I usually deleted one month old files with *200203*> command ( I need to keep last month files 04 > and delete all older than that). Can any one please > help me writing a script to delete the files every > month first date. so that I can put the script in cron > job on every month 1st to delete more than one month > old jobs. If you have gnu date then: glob=$(date --date='yesterday' +'MATERIAL.%Y%m*'); will work. Why not just use find : $datadir -mtime +30 | xargs rm -f; to get rid of anything older than 30 days? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 device backup script
> but I need a script that backups over 20 raw devices
> datafiles to a TAPE without using a FS to store these
> datafiles first.
To a single tape or multiple ones? If it's a single tape
then you are in for a real fun time trying to restore the
stuff...
This is skeletal but should give you a reasonable starting
point for a working backup:
#!/usr/bin/perl -w
$\ = "\n";
$, = "\n\t";
use Carp;
my @rawvolz =
qw(
/dev/foo
/dev/bar
);
sub run
{
for my $cmd ( @_ )
{
print "$$: system($cmd)";
if( my $exit = system($cmd) )
{
print "STDERR: coredump" if $exit & 128;
if( $exit < 0 )
{
croak "$$: failed system call: $!";
}
elsif( my $status = $exit >> 8 )
{
croak "$$: Nonzero exit: $exit";
}
elsif( my $signal = $exit & 0xFF )
{
croak "$$: Zapped by SIG-$signal";
}
}
}
}
sub mt
{
for my $cmd ( @_ )
{
if( system "mt $cmd" < 0 )
{
croak "$$: Failed system call: $!";
}
elsif( $? == 1 )
{
croak "$$: Invalid tape device: $ENV{TAPE}";
}
elsif( $? == 2 )
{
croak "$$: Tape operation failed: $!";
}
else
{
croak "$$: Flaky exit from mt: $!";
}
}
}
print "$$: Checking tape: $ENV{TAPE}";
# if these don't work there's little chance the backups will.
mt 'erase', 'status';
# ok., some hope, start the fireworks...
print "$$: Backing up:", @rawvolz;
my $blocksize = 1024 * 1024 * 80; # whatever
my $file = 0;
for my $raw ( @rawvolz )
{
# keep track of the file order for later restore.
print "$$: $raw :" . ++$file;
run qq{dd if='$raw' of='$ENV{TAPE}' obs='$blocksize'};
mt 'eof';
}
# avoid cinches in the tape and make sure not to overwrite
# a valid backup with a new one if someone forgets to change
# the tape.
mt 'retension', 'rewoffl';
# this isn't a module
0
__END__
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
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: Cronjob
-- [EMAIL PROTECTED] > Dear Tom, > Would you send me example of the script. Because I'm new with VMS > environment. > > thanks in advance, This is gonna be living hell to deal with in DCL. Suggestion: grab a copy of perl5 and use Schedule::Cron to cycle the jobs with the vms-ish file system to handle lookups. Main advantage is giving you a single point to track the results -- instead of having to deal with all of the /after options and separate jobs. With Schedule::Cron you can feed in a "crontab" file or use $cron->add( $schedule ) to generate the jobs w/in your code. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 simulate Block Corruption?
-- Sandeep Kurliye <[EMAIL PROTECTED]> > > Hello Gurus, > > I am in the process of testing recovery options from block corruptions. > So, my setup requires a db which is having block corruption problem. > > How to simulate block corruption in db? dd if=/vmunix of=$yourdbf bs=8k count=5; you now have 40KBytes of corruption. If your dd has offset capability then use it to simulate corruption at various points in the file. to simulate corruption in expanding the file use: dd if=/dev/urandom bs=8k count=$howevermany >> $yourdbf; -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Prod problem, please help!!!
> The database hangs, and no user is able to connect to the instance, except > locally through srvmgrl. Even within svrmgrl, we are unable to select > anything from the > database without the query hanging. However, we can abort the instance > (shutdown abort) and start it up again just fine. This has happened on 4-22, > 4-29 & 4-30 in the > early afternoon. Usually, this is also our peak busy rate for the week. We > are executing MTS for 4 applications, all other applications connect through > dedicated server. > The alert log contains a message unable to start a shared server process. > This week it was #41 and last week it was #25. Normally, we do not exceed 5 > shared servers. Another thing I noticed is that there is no time allocated > to any of the newly created shared servers. It is as if, it can not process > any work through existing shared > servers and decides to allocate another one, until finally it freezes. I am > not sure if this is a MTS problem because I would suspect that I should be > able to establish > a dedicated server connection. And I can not. I think that this is just a > symptom of the underlying problem. It would appear to me that we are running > out of a resource, > however our sysadms do not see any resource problems. Does anybody have any > ideas how to debug this? Thanks If you watch the number of avilable proc, shared memory and sempaphore slots in use/available what happens? Might be that or something inside of oracle is running out of resources. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Root Cause Analysis White Papers
-- Peter Barnett <[EMAIL PROTECTED]> > We have been having some heavy discussions about > system failures, root cause analysis and developing > some proactive metrics. Generally, our problems > revolve around frequently late nights for the On Call > DBA because something out of our control goes wrong. > The damagement folks want to fix the immediate problem > and consider the job done. The DBAs are asking for an > approach that will allow us to identify potential > problems before something breaks at 3:00 a.m. > > Does anyone know of a source of white papers or other > data that has been generated for systems, storage or > databases? We can always roll out own, but why > recreate someone else's work. See the Usenix doc's on Auditing, sys-admin skills for examples. LISA papers also have covered audit procedures. What you are really asking for is a system audit. The results from a full audit would be a good place to start looking at what is done on the systems, what goes wrong with them and where to look further for root causes. Audit results also give you the facts you'll need in convincing the manglement that something really is wrong and it needs fixing. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 Oracle screwed California
-- "Boivin, Patrice J" <[EMAIL PROTECTED]> > I don't know if Microsoft negotiates -- do they negotiate? Quite. They make Norton Simon look like a pushover. See coverage of the recent trial for examples. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: OT - Linux question
-- "Farnsworth, Dave" <[EMAIL PROTECTED]> on 04/23/02 05:23:29
-0800
> I am going to start playing with RedHat Linux on a spare PC I have at home.
> Does anyone know of a good user group like this one where I will be able to
> post(and someday answer) questions on Linux?
Go to www.linux.org, check out existing Linux Users' Groups
("LUG"). There will be one nearby you somewhere. That will
probably be the best place to look for help.
Where are you?
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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: VAX float to IEEE float
> Did any one of u faced the problem of migrating VAX/VMS files having - float > datat(8-bytes) to > > oracle8i(windows NT) platform. Export the data to text and re-import it. Or create a scratch table with the floats as varchar's and use DBI to read/write the data as text before unloading it, read it back in and re-convert it. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Number of CPUs vs. Speed of CPUs
-- "MacGregor, Ian A." <[EMAIL PROTECTED]> > In general, for Oracle, it is better to have four 500 MHz CPU's than two > 1000 MHz CPU's. Please keep in mind if your system is I/O bound then > more/faster CPU's won't help. Oracle can easily make things worse for itself due to I/O overhead for rollback and lock management. It isn't very hard to get constipated disk systems w/ SPM and Oracle. You also end up with a major bottleneck at the bus controller on most systems. Paged I/O and disk commands can easily strangle the system. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: MySQL vs. Oracle database
-- "Weaver, Walt" <[EMAIL PROTECTED]> > I don't think you're wrong. MySQL gets dissed frequently on this list, but > it's really a nice little product. IMHO it's much closer to Oracle than > Access. > > It works well for us. Doesn't scale like Oracle, but works well. In some ways it scales better than Oracle. For load+query (a.k.a., "warehouse") operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many "instances" it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Developer access in test database
> To answer your question: > We define schema owner for each application and only the DBA knows > the password. the user gets i, u, d, s grants on the objects but have NO > grants to do DLL's. All DDL is done by the DBA. > > This role was implemented after tables began to disappear from the schema > due to the use of tools that did things on their own. > > Sure, it is more work for the DBA but it is better the restoring DB or > restoring > tables from export while the entire team sits around drinking coffee. We use a similar process in development cycles, where the scratch db and production DB are identical but have different passwords and rights. Makes it hard[er] to accidentally point DDL-code at the production database during testing. One thing that helps in this situation is to have some automated tool for modifying the database. When someone wants a change they can either pass on an updated config file or some standard notation for the alteration to the DBA's. Otherwise you just get a barrage if semi-cohereint emails asking for minor changes. enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Connecting to Oracle via Perl
-- [EMAIL PROTECTED] > Environment is Oracle 8.1.6 NT 4.0 > > What is the best way to connect to Oracle using Perl? I do not want to > hard-code password in script if not necessary. I could not find a way to > embed > in dsn creation. Any suggestions/working examples on how to achieve this > is appreciated? I do not have any kind of password server. If you use shell-based authentication then you can connect via DBI and DBD::Oracle with: my $dbh = DBI->connect( "dbi:Oracle:$db", '', '' ); (i.e., empty string for both user and pass). $db would be the tns name for whatever you're connecting to (see the DBD::Oracle manpages for examples). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Slightly OT: Perl Q.
-- Jack van Zanen <[EMAIL PROTECTED]> > Hi All (Jared in particular), > > > OS: AIX > We are trying the following: > > We have a script that executes and sets all sorts of environment > variables. Than after this we execute a perl script that reads the > environment variables, however the environment variables set in the first > script are not picked up. > We tried executing the variables script with [ . script] (dot space > scriptname) as well but still no luck. > > How can we make the perl script pick up these variables? > > > TIA and sorry for the OT but I am not using perl so much as to join > another mailing list Not very descriptinve, but obvious things to check are that the variables are exported and the perl code is forked w/in the shell that set the var's. You'll generally find it less effort to set %ENV in the perl code that then shell. Puts all the issues in one place, and you have better logic in perl anyway. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 Tools
-- [EMAIL PROTECTED] on 04/02/02 12:03:27 -0800 > Hi All - > This is for DBAs who have participated in a DW project: what kind of tools > did you use for design, ETL, Query etc. I know Oracle has a data warehouse > builder but it doesn't seem to be widely used. What is the most popular > tools out there for DW construction and what is the trend? Most of the ETL I design is done with Ab Initio, less often Informatica. Ab Initio is the best tool going for scaleable parallel processing and distribution across multiple nodes; Informatica has some advantages with lower throughput and messier metadata; its licensing is also simpler. I tend to use Red Brick for data warehousing. Main reasons are offline loading of data, star and target indexes and much simpler data management -- mainly due to lack of rollback processing and ability to add phyisical storage without effecting data access. Now that Oracle at least has partitioning it gets more usable for warehousing but still needs too much care and feeding, and doesn't support offline loads. For clickstream processing Oracle with partitioning is a nice combination. In either case, DBI seems to be the most portable way to talk to various databases, especially for combining data from multiple sources (e.g., feeding selection criteria back from a Red Brick warehouse to an Oracle OLTP system). enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Seeking opinions
-- Paul Baumgartel <[EMAIL PROTECTED]> on 04/01/02 14:48:23 -0800 > Hi everyone. > > I'm currently working at a client where the OFA standard has been (as > they put it) "taken to the next level". I disagree with their > approach, and I'd be interested to see what list members think. > > The client believes that any DBA (there are about 16 on staff) should > be able to locate data files in any database without querying the data. > To this end, mount points are named both /unnn (e.g., /u001) and /annn > (e.g., /a001). "System" datafiles (system, temp, rollback tablespaces) > go only on the /unnn mount points, and in particular, datafiles for > certain tablespaces must go on certain mount points--for instance > rollback tablespace files always go on /u004. > > "User" datafiles are allowed on /a001 and /a002, tables and indexes, > respectively. > > To my mind, this standard changes the Optimal Flexible Architecture to > the Sub-optimal Inflexible Architecture, and all just to avoid a data > dictionary query. What do you think? Well, since Oracle's suggested "u01" is so COMPLETELY descriptive, I can't imagine changing it. Using anything so confusing as the name of a database, instance or project as the mount point or including things like "index", "rollback", "tablespace" or "log" is also pretty meaningless (unless of course someone does an "ls" to see them). If you're willing to dump Oracle's suggested confusion, separating the files out by mount point makes sense on most systems since it allows better control over the locatioin of data files and less hassle growing logical volumes [unless, of course, you use Oracle's suggested hardware raw volumes for all storage]. If the direcories fit under some heirarchy that reflects the overall database orginization that certianly helps. If the layout looks like /instancename/general_use or /oracle/general_use/instance_specific_use.dbf you can figure out most of it rather quickly: a single instance can be clocked via ls -Rl /instancename in one or the overall health of a multi-instance server can be clocked via ls -Rl /oracle/ or ls -Rl /oracle/index (for example). Trick is naming things in ways that reflect what's under the directory and giving the flat files names that have something to do with what they're used for. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 Wants Users to Hand over Apps Management
-- "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Not to mention the nightmare of coordinating all the users into software > releases. > How about local customization and add-ons? > > Seriously, I initially thought that it was a good idea - I know some small > manufacturing companies locally who might truly benefit from this. But > once the technical people start thinking about all of the restrictions, I > think the number to "take advantage" of this will be small. Remember that Oracle is selling this service to the people who buy it, not those who use or maintain the product. To a manager it looks like a nice, complete solution. Most IT veeps don't know all that much about what goes into running the database -- if they do the Oracle sales reps go high enough in the food chain to find someone who doesn't. At that point you may have any number of large companies switching over to the service before it's too late. They will end up ignoring their DBA staff in favor of whatever promises the sales rep gives them (and the contract seems to offer). The main thing to do at this point is assemble your own nice, simple, non-technical explanation of why you think it's a bad idea for your company and systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Convertion from Figures to Words
-- Ahmed Gholam Hussain <[EMAIL PROTECTED]> > Dear Listers , > > I need to convert Figures to Words ...EX : 123 to One Hundred Twenty > Three > Currently I am using a writen function to do that ..But it has > limitations ... > > Any suggestions regarding that ? There are moduled which do this already in the Lingua:: group on CPAN. Hit up www.cpan.org, choose module search and look under that heading. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: .dbf is a valid name for a datafile name?
-- Hamid Alavi <[EMAIL PROTECTED]> > I have added a datafile to a the temp tablespace with the name of .dbf > only is ithis a valid name?, is there any way to rename it without > shutdown the database,if yes HOW? You can "ln .dbf name_you_wanted" any time you like. Unlink the ".dbf" basename whenever you're done with it. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Linux for Big(ish) Databases
-- "Jesse, Rich" <[EMAIL PROTECTED]> on 03/04/02 09:03:28 -0800 > The problem with Linux on Sparc or Alpha is that Oracle doesn't have > binaries for them. I've requested Alpha binaries, but haven't had any > response, despite the "1-2 business days" response. Remember: They're Oracle, you're not. Be glad they take their precious time to not answer your questions! The main problem with Intel boxes is a narrow I/O bus and latency issues with the chipsets. The VIA set tends to be faster so far as I've seen. Combined with good SCSI boards and LVM striping you can get decent throughput, but it'll never match something like a V-box or 6500 for full-bore speed. The "real" alpha motherboards (not "NT compatable" toys) use wide I/O channels to keep the chip fed. If you're considering linux look carefully at clusters. They can be an immense help dealing with large databases. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Linux for Big(ish) Databases
> We've got a new database to put together. OLTP, 100-200 users, ~250Gb > data. We haven't decided on a platform for this yet. Is Intel/Linux > worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Unix shell Question
-- Yuval Arnon <[EMAIL PROTECTED]> on 02/28/02 13:37:59 -0800 > > Hi, > Need help in Unix shell. > Is there a way to compute the previous date (similar to sysdate - 1 in SQL) > using the date expression?? With gnu date use "date --date='yesterday'", with Perl Date::Manip will handle "$count days before", $otherdate. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
