Ryan
NetApp is in another class of devices labeled NAS for Network Attached
Storage. Because its connection with your server runs over a network
connection, the performance is very much dependent on the speed and
configuration of the network connection.
As has been explained to me, and I
: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of DENNIS WILLIAMS
Sent: Friday, September 19, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Ryan
NetApp
://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of DENNIS WILLIAMS
Sent: Friday, September 19, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Ryan
NetApp is in another class
:
.com Subject: RE: Re: max parallel query
PROTECTED]cc:
.com Subject: RE: Re: max
parallel query
09/19/2003 11:49
AM
Please respond
-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Friday, September 19, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Friday, September 19, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: max parallel query
Matt,
Question: What else do you have running on your
Hrrrmmthe on-topic-ness of this has strayed far from Oracle. My
apologies.
Not sure I agree with the last statement... I think it is on topic... Many
of us DBA types are often involved in these kinds of discussions internally
and the more informed we are the better off we are... It
one caution:
there is no unwrap cmd/exe
Regards
On Sat, 20 Sep 2003 Pete Finnigan wrote :
Hi
Research the wrap command, the binary is located in
$ORACLE_HOME/bin and
running it for example would be like this for instance:
$ wrap iname=./test.sql
You raise an interesting idea in my mind...
How useful would it be for us if Oracle created an INFINITE_DUAL table -
One where you could select as many rows as you wished. I guess it might
be
dangerous but it would at least be very efficient if Oracle coded it as a
special table. Then you
i know there are no magic formulas, but im hoping for something better than trial and
error. i would assume that parallel query helps most when:
1. are doing work off of multiple mount points.
2. Have alot more LIOs to perform than PIOs(such as sorts).
am i close on this?
From: M Rafiq
If you want rules of thumb, then take CPU_COUNT+1 up to CPU_COUNT *2.
I think LIO PIO ratio is irrelevant, the most important is whether you are
able to construct optimal parallel execution plan, e.g. avoid excessive
parallel slave messaging waiting. This is mostly design and SQL issue.
The
hmmm... when i run statspack during a big load. most of my waits are from
redo log waits and read from a staging datafile. we have all of our
datafiles on the same I/O mount. We are using a Network Appliance back end
with asynch I/O.
are you telling me that putting these files on seperate mount
Ryan
You are probably bottlenecking on the NetApp. Probably your network link
to it. If you have some regular (a.k.a. direct attached) disk available,
consider using it for your redo logs.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
If different mount point means different disk spindle group or different
disk array, then of course, your performance will be improved, but if we
talk about the same box, same number of disks just split to two or three,
you probably won't get any performance increase. One disk spindle still
i dont manage the netapp and am not a hardware person. could you explain a
little better? Is netapp similiar to SAN?
what is asynch I/O?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 6:24 PM
Ryan
You are probably
Netapp is NAS afaik, that means a bunch of disks used over fast network.
SAN is a bunch of disks used over SCSI or Fibre interface (EMC Clariion for
example). I tend to trust and appreciate SAN more than NAS, but NAS can be
more cost effective in small-to medium environments.
What I meant, is
I was thinking along the same lines minus the outer query which is totally
unnecessary, but it is the beginning of my day here :-).
SF
- --- Original Message --- -
From: Wolfgang Breitling [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue,
- --- Original Message --- -
From: Mark Richard [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 16 Sep 2003 19:59:41
I guess I should have added some criteria like:
1) user_objects must have enough rows in it to
cover the range (if not
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL
Hi Stephane,
I commiserate with you 8-)
Regards,
Guido
[EMAIL PROTECTED] 17.09.2003 10.44 Uhr
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Please
Hi!
This one is a very interesting consideration. The use of 'pivot' tables,
as in this case, without being something you meet daily is fairly frequent
(completing series like here is one usage, otherwise I commonly use them to
generate test data). It should be some standard feature, a kind of
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: RE: Oracle Press OCP exam guide frustrations
Not really, most of DBA on this list did their OCP without any Oracle
formal
training. Use your experience on that version, study relevant material or
available books/docs, do practice of STS test
Ruth,
Set you ORACLE_SID which will be the target and try again.
c: set ORACLE_SID=AUX92
AUX92 is the name of my auxiliary instance on Host A ( target host ).
c: rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys
trace=c:\tspitr.log
where PE92 is the target on same Host A
:
Subject: RE: RE: Oracle Press OCP exam guide frustrations
Not really, most of DBA on this list did their OCP without any
Oracle formal
training. Use your experience on that version, study relevant
material or
available books/docs, do practice of STS test
it a requirement.
Otherwise, who would ever take a course?
-Original Message-
From: M Rafiq [mailto:[EMAIL PROTECTED]
Sent: Tue 9/16/2003 11:54 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: RE: Oracle Press OCP exam guide
you dont need to hawk your book... of course ill buy it. yeah. i think im screwed. I
dont have mount points to multi-plex my redo logs. :(
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/09/17 Wed AM 11:09:50 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: wait
i explain planned it and it was much worse than not exists.
my understanding is hash_aj is faster when the table in the sub-query returns results
that are significantly less than the one in the outer table.
ill try it, but i think exists is faster. we dont want to do an index scan here and my
Ryan - One solution that is often suggested would be to copy the rows you
wish to retain to another table, then truncate the table. Oracle is
relatively slow at deletes compared to inserts. Would this method work for
you?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
When tuning queries, ignore the fact that explain plan shows a cost. The
optimizer finds the lowest cost it can. If you mess with hints you will
almost certainly get a higher cost. I've tuned queries that ran for hours
with a cost of less than 10 -- the tuned versions had costs in the
Syntactically incorrect (one 'replace' too much). IMHO translate() is the one to use
here. Probably a negligible performance benefit but I find a single function call
easier to read than a function taking another function call as argument. The fewer
characters the better (I type slowly and
Roy,
NOT EXISTS is to be avoided when it is the only criterion - the subquery is
executed for each row in the outer query. The way the CBO behaves varies wildly
between 8.1.7 and 9.x. Richard's suggestion is quite correct and a fairly safe way to
get a 'right' behaviour with most versions
i tested the minus in the explain plan and the estimate was very large. dont i need a
large sort_area_size for that?
bitmap index on all columns right? not just one?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/17 Wed PM 12:59:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
16 million of the 18 million records in the staging table have delete records. how
would indexing help there? wouldnt a full table scan be better?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/17 Wed PM 12:59:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
] On
Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: tuning a massive delete
i tested the minus in the explain plan and the estimate was
very large. dont i need a large sort_area_size for that?
bitmap index on all
I got an email last night from
bookpool that my copy of Cary's
book had shipped.
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/09/17 Wed PM 02:14:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Is Cary's new book shipping now?
Tom has a NEW,
: [EMAIL PROTECTED]Subject: RE: RE: tuning a massive deleteRyan - One solution that is often suggested would be to copy the rows you wish to retain to another table, then truncate the table. Oracle is relatively slow at deletes compared to inserts. Would this method work for you? Dennis Williams DBA, 80
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: tuning a massive delete
Well, large sort area size would certainly help, as well as the parallel
hints.
As for the bitmap index, I din't know what was the percentage. It probably
wouldn't
help much.
--
Mladen
]
[EMAIL PROTECTED]cc:
orp.com Subject: RE: Re: SQL help needed
i figured it out a while ago. thanks guys.
From: Govindan K [EMAIL PROTECTED]
Date: 2003/09/16 Tue AM 10:24:38 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: how to do a variable in-list of numbers?
Ryan
Will this link help you?. Let me know.
they are not outstanding. they are ok? They are also expensive. I have found the
Coriolis books to be better than the Osborne books in quality. They dont have 9i ones.
you can get the 8.0/8i ones for $9/each at maryland-merchant.com
Im using those myself, then the docs. I didnt like the osborne
if you need to 'rollback' everything, then you should make it one transaction. You can
add savepoints and rollback to: if you want to limit it that way.
commit means complete. You should not commit unless you are sure you may not want to
rollback.
why are you committing in the inner
the big question is when will the .pdf be available for download on kazaa?
(Im kidding and Im buying a copy).
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/09/16 Tue PM 01:44:35 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Is Cary's new book shipping now?
Thanks guys for your inputs,
I just want include a procedure (which include commit)
into my package testing.
Have nice a day,
Kader
--- [EMAIL PROTECTED] wrote:
if you need to 'rollback' everything, then you
should make it one transaction. You can add
savepoints and rollback to: if you
Will there be an MP3 version, with Cary singing?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE
]
Sent: Tuesday, September 16, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Is Cary's new book shipping now?
the big question is when will the .pdf be available for
download on kazaa?
(Im kidding and Im buying a copy).
From: Jesse, Rich [EMAIL PROTECTED]
Date
One may as well get used to putting forth some extra expenditure when
getting certified now.
The publisher, Coriolis, went under.
And now Oracle is requiring that you complete at least one of their prep
courses (irrespective of whether you believe you need it or not) in
order to become
you can do the 8i cert and upgrade without paying for the course.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 6:49 PM
One may as well get used to putting forth some extra expenditure when
getting certified now.
True. You can save yourself $115 if you do it this way.
8i cert + upgrade - $750
9i cert (with required class, using Self-Study CD-ROM) - $865
It's up to you ...
-Original Message-
Ryan
Sent: Tuesday, September 16, 2003 7:15 PM
To: Multiple recipients of list ORACLE-L
you can do the
all you have to do is buy the self study CD? are you sure? I thought you had
to get a class? which are atleast $1500 online?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 7:39 PM
True. You can save yourself $115 if
Well, if you take the Introduction to Oracle9i: SQL course. (BTW, I
was wrong about the price differential - I was looking at the wrong CD -
the price differential is actually $200, not $115, sorry about that) so
that ups the original figure I wrote from $865 to $950. Still not bad,
though,
Does anyone other than Oracle truely believe that a course is necessary if
you can pass the exam?
-Original Message-
Sent: Wednesday, 17 September 2003 8:50 AM
To: Multiple recipients of list ORACLE-L
One may as well get used to putting forth some extra expenditure when
getting
Not really, most of DBA on this list did their OCP without any Oracle formal
training. Use your experience on that version, study relevant material or
available books/docs, do practice of STS test questions and then you are
pretty much ready for exam.
I did my OCP from 7. to 9i without
:
Subject: RE: RE: Oracle Press OCP exam guide frustrations
Not really, most of DBA on this list did their OCP without any Oracle formal
training. Use your experience on that version, study relevant material or
available books/docs, do practice
?
-Original Message-
From: M Rafiq [mailto:[EMAIL PROTECTED]
Sent: Tue 9/16/2003 11:54 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: RE: Oracle Press OCP exam guide frustrations
Not really, most of DBA on this list did
Hi Mladen,
please excuse me. Since I try to improve my knowledge
about the English: what do youmean with muave? Some
kind of wood?
Please enlighten me.
Greetings,
Guido
[EMAIL PROTECTED] 11.09.2003 20.49 Uhr
And the database must be muave.
--
Mladen Gogala
Oracle DBA
--
Please see
LOL, Mauve is a shade of the colour Purple.
And of course, everybody knows that purple databases run faster! ;)
Personally, I've always preferred Electric Blue databases, funky, fast, and
FAR easier to manage!
-Original Message-
Guido Konsolke
Sent: 12 September 2003 08:54
To:
Hmm, applied Feng Shui for Oracle Performance.
For optimum throughput storage should be coloured red and white in
alternating bands of colour.
It's called disk-striping.
Badummp-k !!
I'll get me coat ... and back on topic.
Mike
-Original Message-
Sent: 12 September 2003 11:14
USA
-Original Message-
From: Guido Konsolke
[mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L
Subject: OT Re: RE: What is a large database?
Hi Mladen,
please excuse me. Since I try to improve my knowledge
about
fastest and easiest way to do it is the following. create another tablespace with
another user. Set it to nologging.
alter session enable parallel dml;
create table /*+ parallel(max#,s) */ as
select *
from old_tablespace.table
where -- your filter.
export this new tablespace so you have a
Selling
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jesse, Rich
Sent: Friday, September 12, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT Re: RE: What is a large database?
It's
both client and server on Sun OS 5.8
ORACLE_HOME and ORACLE_SID in .profile
tnsnames.ora
TRADEDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = trade-db1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TRADEDB1)
)
)
While running tnsping and sqlplus i am getting this:
WW_WS tnsping TRADEDB1
Bus Error (core dumped)
WW_WS sqlplus rubix/[EMAIL PROTECTED]
Bus Error (core dumped)
WW_WS /usr/sbin/ping 10.10.8.44
10.10.8.44 is alive
WW_WS echo $ORACLE_HOME
/export/home/oracle/product/8.1.7
WW_WS echo $ORACLE_SID
listener is running okay
it has refused some connections:
WW_DB lsnrctl stat
LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003
14:49:01
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of
Subject: Re: RE: RE: RE: Bus Error (Urgent)
its a 2gig memory
shmsys:shminfo_shmmax=4294967295
shmsys:shminfo_shmmin=1
parameter processes = 150
and v$process returns 25
---
On Sat, 13 Sep 2003 Mladen Gogala wrote :
You don't have enough
. The
investigation should continue on the server.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 5:46 PM
To: Mladen Gogala
Subject: Re: RE: RE: RE: Bus Error (Urgent)
its a 2gig memory
:46 PM
To: Mladen Gogala
Subject: Re: RE: RE: RE: Bus Error (Urgent)
its a 2gig memory
shmsys:shminfo_shmmax=4294967295
shmsys:shminfo_shmmin=1
parameter processes = 150
and v$process returns 25
---
On Sat, 13 Sep 2003
Faan,
the Doc. below has the reference of 52576.1.
-- Note:1069019.6 Subject: HOW TO GET A CLEAN RMAN CATALOG
so, i was looking for that too.
i read the doc. 1058332.6 already.
You are the only one who responded to my question.
Thanx Faan.
Jp.
13-9-2003 04:49:27, Faan DeSwardt [EMAIL
Didn't know this one ! Diem non perdidi.
But it seems to be the same as select global_name from global_name (on the database on
which I have tried, both are suffixed with a .WORLD); for what I remember from my
numerous databases cloning, the global name is something which is distinct from the
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Nuno Pinto do Souto
Sent: Wednesday, September 10, 2003 6:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: RE: DB2 has a foot in the door
Boivin, Patrice J [EMAIL
Pinto do Souto
Sent: Wednesday, September 10, 2003 6:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: RE: DB2 has a foot in the door
Boivin, Patrice J [EMAIL PROTECTED] wrote:
Something like that at the bottom of this article:
http://www.computerworld.com/news/2003
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Thursday, September 11, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: RE: DB2 has a foot in the door
I believe Mr. Ellison is responding to a lot of market
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Thursday, September 11, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: RE: DB2 has a foot in the door
I believe Mr. Ellison is responding to a lot of market
pressure, and failing
That same mentality applies to organizations with 100-200 users! After the
latest meeting with the Oracle rep, damagement is seriously considering
alternate database systems.
Abey.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: RE: DB2 has a foot in the door
I believe Mr. Ellison is responding to a lot of market
pressure, and failing DB sales. I know it would be a relief
here to see this inplace soon, but as always the DEVIL is in
the details.
Dick Goulet
: RE: RE: RE: DB2 has a foot in the door
I used to work for a large but non profit organisation (.org)
and we were using Oracle, the sales rep never send us
Christmas card for sure
Stephane
-Original Message-
Mladen Gogala
Sent: Thursday, September 11, 2003 11:30 AM
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Thursday, September 11, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: RE: DB2 has a foot in the door
I believe Mr. Ellison is responding to a lot of market
pressure, and failing
Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Stephane Paquette
Sent: Thursday, September 11, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: RE: DB2 has a foot in the door
I used to work for a large
: Boivin, Patrice J [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 11 de septiembre de 2003 12:54
Para: Multiple recipients of list ORACLE-L
Asunto: RE: RE: RE: DB2 has a foot in the door
Speaking of non-profit organisations, what is Oracle's policy on that?
Do they sell Oracle software to non
I have written in the past a small C program which does the same as oerr only faster,
especially for 'high' error numbers (using binary searches on the files); it is
written for Unix but can easily be adapted to Windows - for those who don't have perl
installed ...
how many of those trace events have people written papers on? other than hotsos, where
can i find some articles on them?
From: Boivin, Patrice J [EMAIL PROTECTED]
Date: 2003/09/10 Wed AM 08:12:23 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: overloading and =
is SE alot more affordable than EE? CAn you un-bundle Oracle software and just buy the
pieces you want to use or do you always have to buy the whole bundle?
what about 9iAS? do you have to buy the whole bundle or can you just get pieces?
From: Hitchman, Peter [EMAIL PROTECTED]
Date:
Ryan
Yes, MUCH more affordable, assuming you can live with the limitations.
Check Oracle Store for current prices. I understand the 4-CPU limit still
remains. There aren't too many unbundling options.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
]
Sent: Wednesday, September 10, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: DB2 has a foot in the door
is SE alot more affordable than EE? CAn you un-bundle Oracle
software and just buy the pieces you want to use or do you
always have to buy the whole bundle
how restrictive are db2 and sql server on bundling licenses? and CPU limitations?
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/09/10 Wed AM 10:29:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: DB2 has a foot in the door
Ryan
Yes, MUCH more
]
Sent: Wednesday, September 10, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: DB2 has a foot in the door
is SE alot more affordable than EE? CAn you un-bundle Oracle
software and just buy the pieces you want to use or do you
always have to buy the whole bundle
recipients of list ORACLE-L
Subject: Re: RE: DB2 has a foot in the door
is SE alot more affordable than EE? CAn you un-bundle Oracle
software and just buy the pieces you want to use or do you
always have to buy the whole bundle?
what about 9iAS? do you have to buy the whole bundle or can
you
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: DB2 has a foot in the door
is SE alot more affordable than EE? CAn you un-bundle Oracle
software and just buy the pieces you want to use or do you
always have to buy the whole bundle?
what about 9iAS? do you have to buy the whole
with 9iAS.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: DB2 has a foot in the door
is SE alot more
enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: DB2 has a foot
: Wednesday, September 10, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: DB2 has a foot in the door
is SE alot more affordable than EE? CAn you un-bundle Oracle
software and just buy the pieces you want to use or do you
always have to buy the whole bundle?
what about
Boivin, Patrice J [EMAIL PROTECTED] wrote:
Something like that at the bottom of this article:
http://www.computerworld.com/news/2003/story/0,11280,84773,00.html
Counting processors is very hard. It's very hard to count users
I thought that's what count(*) was invented for?
Larry can
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: RE: DB2 has a foot in the door
Boivin, Patrice J [EMAIL PROTECTED] wrote:
Something like that at the bottom of this article:
http://www.computerworld.com/news/2003/story/0,11280,84773,00.html
Counting processors is very
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, September 08, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re: Oracle Masters exam
how many ocms are there world wide?
Note
there are some semi-technical articles on otn about 10g. Im less than impressed with
the pl/sql enhancements.
anyone look at the HTML DB stuff? is that considerably better than the htp package or
pl/sql server pages?
From: Wolfgang Breitling [EMAIL PROTECTED]
Date: 2003/09/09 Tue AM
I am really happy to see such responses for my test !!
BTW, I was just checking whether I have successfully been un-subscribed for
my old mail-id and subscribed with new one.
But disappointed to see that un-subscription mail reached much later than test
Mail (which actually I sent before).
oracle is still the only one out there that has multi-version read consistency? I
thought postre-gre sql had it? anyone else? everyone has row level locking right?
From: Mogens Nørgaard [EMAIL PROTECTED]
Date: 2003/09/08 Mon AM 01:09:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
what do they have you do? you set up a database where everything that can go wrong
does go wrong with no access to documentation right?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/09/08 Mon AM 09:44:27 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle
Not quite. Have a look at
http://www.oracle.com/education/certification/objectives/index.html?dba9
iocm_practobj.html. And you have access to the doc, but can't use the
search functionality (that requires network access and every box is
standalone so you can't log into another student's
testing..
-Original Message-
Pete Sharman
Sent: Monday, September 08, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
Not quite. Have a look at
http://www.oracle.com/education/certification/objectives/index.html?dba9
iocm_practobj.html. And you have access to the doc, but
801 - 900 of 2727 matches
Mail list logo