This looks like the Novarg worm
What say people ?
If yes, then thank you Listguru for filtering out the binaries
[EMAIL PROTECTED] is a mass-mailing worm. The worm will arrive as an
attachment with a file extension of .bat, .cmd, .exe, .pif, .scr, or .zip.
When the machine gets infected, the
No,
It is mine!
Anjo.
-Original Message-
Rachel Carmichael
Sent: Friday, January 23, 2004 11:49 AM
To: Multiple recipients of list ORACLE-L
well, I can't get to the site at the moment to test it.. if I remember
correctly, Anjo said he had leased it to Veritas for a couple of
years,
Hi Roland,
Create the sequence before using it, e.g.:
create table system_change(ID number);
create sequence system_change_id;
Insert into system_change values(system_change_id.nextval);
select * from system_change;
Regards
Jesper Haure Nørrevang
-Oprindelig meddelelse-
Fra: [EMAIL
that's pretty definitive. :)
I did say retaining permanent ownership
Is Veritas hosting it for you?
--- Anjo Kolk [EMAIL PROTECTED] wrote:
No,
It is mine!
Anjo.
-Original Message-
Rachel Carmichael
Sent: Friday, January 23, 2004 11:49 AM
To: Multiple recipients of list
All,
i have this query:
SELECT count(1)
FROM ats.emktg_members t1
WHERE NOT EXISTS ( SELECT 'x'
FROM gcd_data_source_details t2
WHERE t2.universal_id = t1.universal_id
AND t2.data_source_id = 13 )
AND upper(t1.email) NOT LIKE '%TATA.COM';
This query finishes in about 5 minutes. The
It's a bad query that could probably be resolved throuh
an analytic function but I don't normally delve into things
like that before having finished my 2nd coffee. You can
use hints, in particular, there is a hint to force hash join.
On 01/27/2004 06:44:25 AM, S.Sarkar wrote:
All,
i have this
Is the sql really the same query is run from a stored procedure or is it
perhaps using in place of the '%TATA.COM' a plsql variable (which is set
to %TATA.COM)?
At 04:44 AM 1/27/2004, you wrote:
All,
i have this query:
SELECT count(1)
FROM ats.emktg_members t1
WHERE NOT EXISTS ( SELECT 'x'
I know when oracle uses a fast full scan. Its the full scan that does 1 I/O at a time.
I rarely see oracle using it and when it does, it generally means my table(s) aren't
properly analyzed.
From: David Hau [EMAIL PROTECTED]
Date: 2004/01/26 Mon PM 10:34:25 EST
To: Multiple recipients of
Does the OTN promo code for exams still exist?
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Title: Message
If you
have a way to work this out in shell then there is a simpler solution
...
$
export VAR='mystr1~mystr2~mystr3'$ echo $VARmystr1~mystr2~mystr3$
echo $VAR | tr '~'
'\012'mystr1mystr2mystr3$
HTH,
Nikhil
-Original Message-From: Stefick Ronald S Contr
ESC/HRIDA
No, the server is in my basement.
Anjo.
-Original Message-
Rachel Carmichael
Sent: Tuesday, January 27, 2004 11:44 AM
To: Multiple recipients of list ORACLE-L
that's pretty definitive. :)
I did say retaining permanent ownership
Is Veritas hosting it for you?
--- Anjo Kolk [EMAIL
- -Original Message-
- From: Anjo Kolk [mailto:[EMAIL PROTECTED]
- Sent: Tuesday, January 27, 2004 8:29 AM
- To: Multiple recipients of list ORACLE-L
- Subject: RE: What to look for in STATSPACK report
-
-
- No, the server is in my basement.
why? was it being a bad server?;-)
--
0kay, then the alcohol we were consuming fogged my brain :)
getting older is a pain in the butt... I do know I was getting emails
from Veritas about the oraperf site. That must be where the confusion
lies
--- Anjo Kolk [EMAIL PROTECTED] wrote:
No, the server is in my basement.
Anjo.
btw, in many cases range scan is faster than a fast full scan. Range scan recursively
hits the nodes that are needed and skips the ones that are not. So it reads less
blocks.
So if you are looking for a 'range' or a specific value, range scan beats fast full
scan most of the time. Less
no, but you can buy one on Ebay that is 40% off for $8. A friend of mine did it and it
works.
From: Boivin, Patrice J [EMAIL PROTECTED]
Date: 2004/01/27 Tue AM 08:09:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Exam promo code
Does the OTN promo code for
On 01/26/2004 06:29:26 PM, Stefick Ronald S Contr ESC/HRIDA wrote:
I'm trying to separate a string into 3 values:
The string is:
mystr1~mystr2~mystr3
There is trivial, non-PL/SQL solution based on the split
function. To see more, type perldoc -f split and you should
see the light.
--
Please see
Anjo
So what was the deal with oraperf.veritas.com if you don't mind my asking?
I subscribed to it sometime before Christmas, but when I went to use it a
week or so ago, it had disappeared and I had to (re)subscribe to
www.oraperf.com.
--
David Lord
-Original Message-
From: Anjo
Could you ask your Oracle rep. for a reference or two in your
industry? They're usually very quick to give those references.
You can contact the company in question and ask them for references.
HP-UX and terabyte sized oracle 9i database are rather frequent
combination, but you should contact
Title: String manipulation
select
substr(subject,1,instr(subject,'~')-1) first,
substr(subject,instr(subject,'~')+1,
instr(subject,'~',1,2)-(instr(subject,'~'))-1) second,
substr(subject,instr(subject,'~',1,2)+1,length(subject))
third
from
test_table
where
test_column=1700455
/
Ray
Title: String manipulation
I
wrote a PL/SQL package with functions you can use for this. Find it
athttp://www.smdi.com/employee/johnf/list.pks
andhttp://www.smdi.com/employee/johnf/list.pkb.
I wrote it so that only the first call parses the string. Subsequent
calls use the already parsed
Have you checked DBA_JOBS for the last/next execution times?
Is the job broken?
Please check DBA_JOBS.
Jared
On Mon, 2004-01-26 at 06:04, Mauricio Vlez wrote:
Hi,
This is the situation:
I'm woriking on NT and there are two 8i databases on it
One database can execute jobs normally,
One situation I can think of where a (non-fast) full index scan can be
helpful is when the index contains all the columns needed for the query,
the query requires all the rows of the table, and the query requires the
results to be sorted according to the index. This way, fast full index
scan
This is where the access time of your disks (or SAN) makes a difference.
If your disks have really fast access time, then a random-access
pattern would not cause much performance degradation and so a range scan
would not be slow at all, even though it's traversing the b-tree index
structure.
Another situation where index full scans might be handy, would be where hash
joins are disabled and sorted output can be used for fast sort-merge join.
Btw, multiblock reads are available for regular index range and full scan
under some specific conditions as well - I'm talking about readahead
Friends --
I seem to recall that there was some performance degradation using use_nl
when distinct was involved, but can't seem to find a source on google for
this. First, has anyone else run into this problem, and second, is there an
online source that references the whys and wherefores?
This is where the access time of your disks (or SAN) makes a difference.
If your disks have really fast access time, then a random-access
pattern would not cause much performance degradation and so a range scan
would not be slow at all, even though it's traversing the b-tree index
structure. If
i found numerous cases(I dont have them in front of me) when fast full scan incurred
far more logical I/Os than an index range scan.
I found this particularly for oltp type get 10 records transactions. However, I forced
an index_ffs once and it increased my logical I/Os by 30% but decreased my
my question pertains to regular 'index full scans' NOT index fast full scans.
any ideas? I rarely ever find this to be an optimal index access method for anything.
From: Tanel Poder [EMAIL PROTECTED]
Date: 2004/01/27 Tue AM 11:19:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL
Yes, and my reply was about regular index full scans, according to your
question.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 6:59 PM
my question pertains to regular 'index full scans' NOT index fast full
Of course you also need to consider the application.
Will there be large number of users?
Does this query run often, or just occasionally?
Scalability comes into play, and a method that
requires fewer oracle resources ( latches ) is
preferable, if possible.
Jared
David Hau [EMAIL
i normally go to the mount point (ie highest level dir for that disk) and issue:
du -k | sort -n
that way you see where the space is going in descending sequence
good luck,
steve
Naveen, Nahata (IE10) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/23/2004 03:44 AM
Please respond to
My following message did not seem to make it to oracle-l.freelists. Let me
try it again.
Guang
-
Hi,
I have the folliwng pl/sql code for oracle 8173. I am wondering if there is
a way to make it faster by not looping each array elements, but doing some
kind of forall opration to
Bruce,
Thank you for providing the service for as long as you did (and could).
Jared has found us a new home but we will miss Fatcity. Take care!
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Bruce A. Bergman
Sent: Thursday, January 22,
--- David Hau [EMAIL PROTECTED] wrote:
As long as you're not using any 9.2 feature, you
should be fine. IIRC,
according to Oracle's upgrade policy, the client and
the server are
compatible within one major version.
Even if upgrading to the 92 client is not an
emergency, you should at
Declare
type numTbl is table of number index by binary_integer;
refTbl numTbl;
i number;
str varchar2(30);
begin
refTbl (1) := 1;
refTbl (9) := 1;
refTbl(15) := 1;
refTbl(99) := 1;
forall i in refTbl.first..refTbllast
begin
dbms_output.put_line ('i=' ||
Couldn't the declarations be put into a package? We've done this in order
to maintain values for the life of the session.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent:
On 01/27/2004 02:09:25 PM, Jesse, Rich wrote:
Couldn't the declarations be put into a package? We've done this in
order
to maintain values for the life of the session.
Yes, they could, I didn't see it in this example.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Hi List,
I have a web application that allows users to type notes with paragraphs.
Is it possiable to load the string with paragraphs into Oracle (not save the
note as a file)? Later on the application has to display the same format
for the note when the user queries that record on the web.
If mypackage.function(i) is doing some DML operation on i, then the real
way to make it faster is to modify the signature of
mypackage.function(i) to take an array instead, and to do a forall ...
dml operation within mypackage.function(i).
forall is most useful when you want to minimize
Sorry I did not make it clear that the number I used here (1, 9, 15,99) are
just examples, the actual element index is a varible and they are not
continuous. Yes, refTbl can be defined into a package. I guess what I am
asking is if there is a way in pl/sql to do something like
-- FORALL array
ive found that index_ffs typically incur higher logical I/Os that index range scans.
so its not just access speeds.
From: David Hau [EMAIL PROTECTED]
Date: 2004/01/27 Tue AM 11:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: When does Oracle use 'Index
forall should be used as follows:
forall index in lower_bound..upper_bound
sql statement;
Putting anything other than a sql statement (e.g. a pl/sql block) in a
forall statement defeats its purpose.
If you think about it, forall achieves its performance improvement by
binding arrays to the
Mauricio,
Check the Oracle version. We had similar problems with 8.1.7.2.
They got disappeared after we upgraded to 8.1.7.4
--
Thanks,
Krishna
~~
NOTICE: This email message is for the sole use of the intended
recipient(s) and may
Hi All,
The following query is giving different results in each run. I assure that no
data modified between consecutive runs -
INSERT /* append parallel (z,8) */
INTO some_table
(SELECT /*parallel (a,8) */
a.item,
a.loc,
Thanks John and everyone for their suggestions.
Best Regards,
Prasad
John Kanagaraj
Q: What does different results mean?
Different row count?
Completely different data?
Partially different data?
Some columns have incorrect value?
What about doing it without the parallel hints? The tables aren't
so big that it would take a long time to find out.
Jared
Pillai, Rajesh
An index fast full scan and an index full scan both need to access all
the blocks of an index. The only difference between them is that the
index_ffs accesses the blocks in the order of the blocks (and uses
multiblock read), whereas the index_fs accesses the blocks in the order
of the b tree
i thought an index_fs only read 1 block per i/o? same with an index range
scan because they are using random access?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 5:29 PM
An index fast full scan and an index full scan
If you look up Logical I/O in the Master Glossary of the Oracle docs,
it's defined as:
A block read which may or may not be satisfied from the buffer cache.
So a logical I/O is always a *block* read. It does not take into acount
whether you're doing a multiblock read or not. One reason this
it is the same. '%TATA.COM' is not a variable.
sumant
--- Wolfgang Breitling [EMAIL PROTECTED] wrote:
Is the sql really the same query is run from a stored
procedure or is it
perhaps using in place of the '%TATA.COM' a plsql variable
(which is set
to %TATA.COM)?
At 04:44 AM
Okay, I know this is a cross-post but.
If you are attending the Hotsos Symposium, plan on attending the
Tuesday night Oracle-l get-together/dinner and have NOT already emailed
me off-list that you are coming, please do so by Friday.
Gary Goodman is going to make the reservation for us based
Title: Message
Thanks Mark Bobak
syed
- Original Message -
From:
Bobak, Mark
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 26, 2004 6:39
PM
Subject: RE: consistent read gets
(I'm
sending the reply to the freelists.org list as well. Hope
My following message did not seem to make it to oracle-l.freelists. Let me
try it again.
Guang
-
Hi,
I have the folliwng pl/sql code for oracle 8173. I am wondering if there is
a way to make it faster by not looping each array elements, but doing some
kind of forall opration to
53 matches
Mail list logo