[snip]
120 col. punch cards?
You had a high-density model. Mine only had 80 cols, of which 72 were usable for my
goto-happy Fortran statements.
SF
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
The old IBM System3 machines used 120 col. punch cards. And initially they
had no HD's. Everything was done with cards and a reader/sorter. To
compile a program you took the code you wrote, punched it into cards and
then put it behind a stack of cards that was the compiler. The machine read
Thanks.
Regards,
B S Pradhan
-
On Fri, 26 Dec 2003 zhu chao wrote :
Hi,
To see why oracle choose FTS, alter session set events '10053 trace name context
forever,level 2';
You can do alter session to change index_adj and optimizer_index_caching to
change only
:)
I admit, that I don't know either, which processes are affected by this parameter.
If foreground ones are, that should mean that after posting lgwr, they won't wait on
semaphore and continue their work.
If it affects lgwr, it means that lgwr posts the waiting processes immediately back
Hi!
Yup, I was bold enough to use this parameter during production upgrade only because it
worked well in several tests and simulations.
Cheers,
Tanel.
Well,
some disk writes need to wait for the LGWR to flush the corresponding
redo
to disk. So now you can have a situation that the
Tanel,
Did you observe better performance? By how much? Do please let us
know!
Oracle Apps upgrade between major releases involves running hundreds of thousands
scripts in bigger cases. Some of there scripts execute bigger transactions, but
majority execute lots of small transactions and
The foreground process is affected. Instead of waiting for the LGWR, it will
return right away.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 4:24 PM
in parallel
:)
I admit, that I don't know either, which
Nope, TRU64
Tanel.
Was this on AIX by any chance ??
Raj
--
--
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an
Facetious, but correct. What you need
is auditing. Not clipping userids.
Achieves nothing.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
What I was saying is that having a different username for each DBA helps you
identify the WHOM. Of course a hacker
could always cut
-Original Message-
Sent: Thursday, November 13, 2003 10:49 PM
To: Multiple recipients of list ORACLE-L
SNIP
Stopping someone from using a given set of accounts achieves preciously
nothing in terms of security (or auditing) IF the functionality of those accounts
is then replicated to
-Original Message-
Nuno Pinto do Souto
I don't want to know that SYSTEM or SOUTON with a subset
of its rights stuffed up my database or exported my main accounts
and clients tables. What I want to know is WHY, WHEN, HOW and
by WHOM.
What I was saying is that having a different
I tried it on 9.2.0.3.0 running on two Linux machines. I doubt all bugs were fixed in
9.2.0.4. I currently consider LSB to be a prototype, an interesting foretaste of
things to come, but hardly more.
It of course depends on the size of the database, but couldn't you consider doing
reporting on
Nuno Pinto do Souto [EMAIL PROTECTED] wrote:
And that's why I feel disabling SYS or SYSTEM purely on
security grounds makes no sense whatsoever
I'm not sure that's what the OP wanted. He wanted to know if stopping use of
SYS and SYSTEM on a regular basis will be acceptable, not disable them. It
Arup Nanda [EMAIL PROTECTED] wrote:
I'm not sure that's what the OP wanted. He wanted to know if stopping
use of
SYS and SYSTEM on a regular basis will be acceptable, not disable
them. It
sure is.
Besides, how does one disable the account? Lock it? SYSTEM can be
locked but
SYS can't be;
Jacques Kilchoer [EMAIL PROTECTED] wrote:
In my case I also enforce the don't sign on as SYS/SYSTEM rule. The
reasons I do that:
- The default tablespace for SYS is SYSTEM, and I don't like to
change that. There are probably reasons why you wouldn't want to
change that. But when I sign on to
Tanel,
Any idea about speed and temporary storage requirements? Especially for 32G+
datafiles ;-) ?
Wondering if it will really be useful in practice, compared to what is available
today. Well, it may do for simpler operations, but not necessarily faster.
SF
- --- Original Message
Well, I don't know about it's performance, but I think this conversion
doesn't require any temporary space, because the byte values of some
structures in blocks have to be swapped, and this a trivial operation.
I think it may still be faster, especially if we are dealing with huge
amounts of
Hi Wolfgang
Thanks for your valuable information. But still I could not understand how the
cardinality will be calculated in EXPLAIN PLAN?
In my query
(1)AB% returns (220 rows selected) but (card=2)
(2)ABC% returns (207 rows selected) but (card=12607 )
Could someone please explain to me?
Thanks for the information. The thumb rule and all will definitely help me in
modelling.
Thanks a Lot
Best Regards
B S Pradhan
On Wed, 22 Oct 2003 Michael Milligan wrote :
Hi Again,
What I do when a model is going to change is try to make it
Some people have requested this code, so I thought
you might as well all
have the chance to pick it to bits... Its a
function called BAD_ASCII, and
it hunts out for any ascii characters with an ascii
value of less than 32 in
a specified field. (Acknowledgments to my colleague
Keith Holmes for help
in the WHERE clause in 10g will be nice.
Jared
Stephane Faroult [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/10/2003 07:09 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: RE: Find an unprintable
Stephane Faroult
[EMAIL PROTECTED]
Sent by:
[EMAIL PROTECTED]
10/10/2003 07:09 AM
Please respond to
ORACLE-L
To:
Multiple recipients of
list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:
RE: RE: RE: Find an
unprintable
PROTECTED]
cc:
Subject:RE: RE: RE: Find an unprintable character inside a column
Actually, I was toying with the idea of writing an external
procedure that would allow me to call pcre library
(PCRE=Perl Compatible Regular Expressions) which would be nice,
but then again
I just ordered from Bookpool. It's in stock according to their website.
Glad I took a few minutes to start cleaning up the listserv email, didn't
realize it was out yet. Really looking forward to this one...
Jay Miller
Sr. Oracle DBA
-Original Message-
Sent: Wednesday, September 24,
24-09-2003 00:19:47, Mercadante, Thomas F [EMAIL PROTECTED] wrote:
I just read the first chapter on-line. Now I gotta order the book.
Where Tom ? is it on Amazon or bookpool or BN ... ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL
http://www.oreilly.com/catalog/optoraclep/chapter/index.html
At 07:34 PM 9/23/2003 -0800, you wrote:
24-09-2003 00:19:47, Mercadante, Thomas F [EMAIL PROTECTED] wrote:
I just read the first chapter on-line. Now I gotta order the book.
Where Tom ? is it on Amazon or bookpool or BN ... ?
--
I believe this should answer your question:
Barnes Noble.com Your Order Has Been Shipped
Dear MLADEN GOGALA:
Your order has been shipped, and the details appear below. Within 24
hours of receiving this email, you may track the delivery status of your
order at
Robert,
are u the author of 9i RMAN Book by Oracle Press ?
sorry for my ignorance.
If YES:
I have got a doubt in your book.
can i mail it to u ?
Jp.
23-9-2003 11:44:41, Freeman Robert - IL [EMAIL PROTECTED] wrote:
I got my book... I got my book! From Amazon, delivered today!
Woo Hoo looks
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
Jp,
No idea as never used. Pretty much happy with STS so far.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 16 Sep 2003 21:09:44 -0800
Rafiq, How about Boson Practice tests compared to STS ?
has anyone on this list found Boson
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
Rafiq, How about Boson Practice tests compared to STS ?
has anyone on this list found Boson useful ?
Jp.
17-09-2003 13:34:36, Caffrey, Melanie [EMAIL PROTECTED] wrote:
This is most likely the reason Oracle has now made it a requirement. Otherwise, who
would ever take a course?
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
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
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
why is it useful to seperate different i/o pattersn? such as
multi-block reads and single block reads?
Because (assuming adaptive I/O subsystems like EMC's and
such) each gets optimized into different priority scales and
device queues. And of course if they are to the same device, they
Thanks all ,this is a great list!
=== At 2003-06-26, 10:17:00 you wrote: ===
Richard Ji,ÄúºÃ£¡
Hi £¬ how do you know that ISM is used even if multiple shared memory
segment are used in solaris 8?
Matt,
Your SGA can still be larger than 4G even if
With the advent of quantum microbiology and the
like, most informed
people agree that 21st medicine is a science.
However, medicine as
practiced in the 17th century was definitely an
art, not a science. The
argument that tuning is an art--that it is
subjective like a
symphony or like cooking--is
Stephen Evans£¬ÄúºÃ£¡
It seems your words are right, after i balanced my disk io and retest the index
build, wait time during index parallel creation increases.
I will retest my creation next morning.
Thanks.
2003-02-13 06:38:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º
Dennis,
We're going from 2 database servers to 1 for production. Therefore it's already
licensed as needed to be a standby served, saving us the extra dollars.
Dick Goulet
DENNIS WILLIAMS [EMAIL PROTECTED] wrote on 2/11/03 1:54 pm:
Dick
How is the standby database cheaper? I understood from
Whittle Jerome Contr NCI,
1.Temporary tablespace in oracle8i+ does not need coalesce, and Oracle do not
deallocate used sort extents. This is a feature.
2.There is no pctincrease parameter in TEMPORARY tablespace.
SQL /
create temporary tablespace test_tmp tempfile
Thanx Jared. That query waz pretty fast (0.78
secs). Next time i wuld avoid using nested queries
where joins can do the job.
regards
Tc
Wrong conclusion. Jared gave you the best and simplest solution, but Sony implicitly
pointed to your error.
Missing join condition.
Regards,
Stephane
Thanks for your reply.
Now I know whom to contact..for upgrades :)
Cyril
On Thu, 23 Jan 2003 Bowes, Chris wrote :
A valid question. With a pseudo-valid answer, which is: Because
there is no
8i for hp-ux 10.20. We have been asking for upgrades and all for
the last
4+ years and the
Thanks for friends,
I found the reason of my rac down.There is a cron that runs daily to sync the
time with the time server. My sa added it without telling me.
And if i set the time back in one node, the instance on another node went
down, with the same trace information. I
On NTFS there is an allocation unit and the Os gives space in multiple of
allocations units which is 4k or 8k.
So if you use bfile you will waste 3k for each file, increasing your disk
space by 60%.
I am not sure about the size of the allocation unit.
Please verify this with your sysadmin.
oraora oraora,
For blob, it is ok, since it is all in the database, while for bfile,
you actually store them in filesystem, so you have to backup those files indivudually.
Regards
zhu chao
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
===
Thanx Chao.
Still under confusion , whether to store 20,000,000 images of 5k
each either in
-oracle 8.1.6 on win2k ( BLOB or BFILE )
OR
- just on plain linux file system -
OR
- any file server like
In some cases, NOT IN is better than NOT EXISTS. In
other cases, the opposite is true.
Moral: It never pays to discount an option out of hand
- eg, NOT IN often works very very nicely for
uncorrelated subqueries
hth
connor
--- Post, Ethan [EMAIL PROTECTED] wrote: Hold
the press. NOT IN
Dick,
it's a beauty thing...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, November 15, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
Raj,
I needed a 12 pack adter this one, it's from PeopleSlop:
SELECT
Title: RE: RE: RE: CONSISTANT GETS
I've seen worse. My programmers don't know how to use NOT EXISTS even though I've explained it many times. And that's the least of my problems. Look at this mess:
SELECT *
FROM sar.pax_header_suspense_err_temp
WHERE manifest_type
On Fri, Nov 15, 2002 at 05:59:06AM -0800, [EMAIL PROTECTED] wrote:
OH, talk about cruel and unusual punishment!! For the fish that is.
It is interesting that so many people feel this way and yet the topic
is reduced to joking, as if it is not possible (or really desirable) to
replace
.
Jared
Whittle Jerome Contr NCI [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/15/2002 08:21 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: RE: CONSISTANT GETS
I've seen worse. My programmers
Hold the press. NOT IN better than NOT EXISTS? Is this theory or fact? If
so is there any supporting evidence out there? This is the first I have
heard of this.
Thanks!
-Original Message-
Sent: Friday, November 15, 2002 11:35 AM
To: Multiple recipients of list ORACLE-L
Jerry,
I
Hold the press. NOT IN better than NOT EXISTS?
If so is there any supporting evidence out there?
I think you're joking, but if not there's a nice comparison chart of several
tests in Harrison, p. 268.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: RE: CONSISTANT GETS
Hold the press. NOT IN better than NOT EXISTS? Is this theory or fact?
If
so is there any supporting evidence out there? This is the first I have
heard
I was once a consultant on a large Payroll project and ran into a case where
someone had entered a date of death 1 year in advance (something like
8/17/1999 instead of 8/17/1998). I found it in the middle of November.
Because of this, the person was still getting paid. I sent email to payroll,
HR
Title: RE: RE: RE: Double Take and Oracle
Dick,
Thank you, atleast you have given me something to work with. I had already began making plans of approaching management for some serious downtime. I have been holding back as I am awaiting response from Double-Take's Source - Sunbelt Software
Title: RE: RE: RE: Double Take and Oracle
A little clarification
---cut---
The reasons for this are wrapped around Oracle's write as little as needed and
do so as seldomly as possible idea.
---end cut---
is not really true.
When a tablespace is placed into hot backup mode, Oracle
I wanted to take a picture with him.
.. and take him out to lunch to learn from his experience ... ;-)
but it turned out he lasted only for less than a week... ;)
(Some developers he was working with knew a bit more Oracle than him)
- Kirti
-Original Message-
Sent: Friday,
SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be
simpler.
R. Smith
-Original Message-
Sent: Thursday, October 03, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Richard,
Distateful is being nice. Try down right horrifying is a more
appriopriate
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: RE: Backups
SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be
simpler.
R. Smith
-Original Message-
Sent: Thursday, October 03, 2002 3:04 PM
To: Multiple
:RE: RE: RE: Backups
SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be
simpler.
R. Smith
-Original Message-
Sent: Thursday, October 03, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Richard,
Distateful is being nice. Try down right horrifying
/03/2002 02:38 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: RE: Backups
You must be using an old version. Been there done that. Works!
Ron
PS: Also works on NT!
-Original Message
Do you believe them?
Mladen Gogala
Oracle DBA
Phone: (203) 459-6855
Email: [EMAIL PROTECTED]
-Original Message-
From: ltiu [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 6:02 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: Rant
IBM's latest DB2
what about self destruction??
Sunil
-Original Message-
From: ltiu [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 6:02 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: Rant
IBM's latest DB2 claims to do this. Self monitoring, self healing.
ltiu
Sounds like a movie I watched this weekend... Species. It's all science
fiction to me.
-Original Message-
Sent: Monday, July 22, 2002 4:02 PM
To: Multiple recipients of list ORACLE-L
IBM's latest DB2 claims to do this. Self monitoring, self healing.
ltiu
Quoting [EMAIL PROTECTED]:
Yes. I do. Because they're IBM.
Quoting Gogala, Mladen [EMAIL PROTECTED]:
Do you believe them?
Mladen Gogala
Oracle DBA
Phone: (203) 459-6855
Email: [EMAIL PROTECTED]
-Original Message-
From: ltiu [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 6:02 PM
To:
Self-healing... did it have gaping wounds before?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Monday, July 22, 2002 8:02 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: RE: RE: Rant
Yes. I do. Because they're IBM
of list ORACLE-L
Subject: RE: RE: RE: Rant
Yes. I do. Because they're IBM.
Quoting Gogala, Mladen [EMAIL PROTECTED]:
Do you believe them?
Mladen Gogala
Oracle DBA
Phone: (203) 459-6855
Email: [EMAIL PROTECTED]
-Original Message-
From: ltiu [mailto:[EMAIL
oraora oraora£¬
hi, i think use bind variable will give better performance, but it has nothing to
do with the buffer busy wait.Using bind variable will solve the repeated parse and
thus reduce library latch free wait.
And seperate table and index won't help either. There is a
Hi, guys,
We have discussed this topic many times on this list. Actually a good DBA
should design a good backup and restore strategy instead of online or
offline according to business situation.
From my opinion, both online and offline are necessary, for example, I
do monthly offline line cold
Stephane,
pdqout does give me a real good impression, not
only the speed but also the
interface. I can see it uses parallel query.
However, I, as a production
DBA, intend to change the application which come
from a third party as a
package as small as possible. It takes 4hours to
extract data
Ian,
Thanks for the info. Very interesting.
Jim
MacGregor, Ian A. [EMAIL PROTECTED] wrote:
The 0.5 petabyte database at SLAC does not use Oracle; it uses Objectivity.
Objectivity is a small company which makes an OODB. When the project started there
was no way that Oracle could
Robert,
If I understand your requirements correctly,
You have multiple sites separated geographically ( 200
Miles perhaps..?? ) and you are looking for a highly
available , 'Multimaster' kinda environment.
This kind of setup is common in
oh-don't-say-the-name-companies i.e. 'dot bombs' and
1. Is the critical data would be updated in the sites..?
Yes...
2. If yes , are you expecting the other sites to 'see' this update...?
Yes...
3. If one site is down, then are you expecting the other sites to share
the load or you have the closest site in take in all the load...?
Yes
but add
Well,
being in health care industry myself I know too well
what do you mean. Apart from 100s of tousands of $
lost every hour we are down, we have to take some
safety also into account.
As to the question of advanced replication, having
implemented multi-master replication myself I know
what a
Dick - In the Oracle Backup and Recovery Class I took recently, I recall the
instructor saying that restriction had been lifted in Oracle9i. I can't find
my note on this, so don't take it as gospel, but it might be worth looking
into if that would make a difference in the decisions.
Dennis
Log application services can run in foreground or background now, but I
don't think the
database can be open read-only at the same time while doing managed
recovery, even in
9i.
Really, there is no read-only requirement in the architecture I'm looking
at.
RF
Robert G. Freeman - Oracle8i
I agree with this! One of our biggest challenges is trying to stay ahead of
the game! Luckily we don't actually develop any of this software, so the
challenge is not ours to partake in ;P What we do have to try and do is pick
and choose those products that are ahead of the game, and we feel our
Rachel,
SLOUG would definitely pay your travel expenses, and since our meetings run from 1PM
to 5PM, it could really amount to just a day trip for you if you want. You could fly
in that morning, have some lunch, deliver your topic, then take off (unless you wanted
to see the city of St.
I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense.
: )
NAS, is that the same thing as a SAN?
Network - Attached Storage
Storage Area Network
Here we have a couple of SANs, but I think they also fit the description
you gave of an NAS.
Regards,
Patrice Boivin
Systems
details... details... statistics NEVER lie!
-Original Message-
Sent: Wednesday, February 27, 2002 4:37 PM
To: April Wells; Multiple recipients of list ORACLE-L
Any query against an empty table always FLIES!!
Dick Goulet
Reply Separator
Author:
Subject: RE: RE: RE: Manager decrees his data warehouse design.
Hel
I guess the reverse of SAME is EMAS, where Everything Makes Absolute
Sense.
: )
NAS, is that the same thing as a SAN?
Network - Attached Storage
Storage Area Network
Here we have a couple of SANs, but I think
Actually, they're different.
SAN = faster, more $$$ (e.g. EMC)
NAS = slower, less $$$ (e.g. Network Appliance)
-JC
-Original Message-
Sent: Thursday, February 28, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L
Patrice,
They are synonyms for each other as far as I
]
cc:
Subject:RE: RE: RE: Manager decrees his data warehouse design. Hel
I guess the reverse of SAME is EMAS, where Everything Makes Absolute
Sense.
: )
NAS, is that the same thing as a SAN?
Network - Attached Storage
Storage Area Network
Here we have a couple of SANs
What is the avg rate for a NAS? Where is a good place to buy?
-Original Message-
Sent: Thursday, February 28, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
Actually, they're different.
SAN = faster, more $$$ (e.g. EMC)
NAS = slower, less $$$ (e.g. Network Appliance)
-JC
Cyril Thankappan wrote:
U r right ..I still dunno 'much' about perl..
as for dbms_metadata
it is a built in pl/sql package
saying
'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual;
gives the entire ddl creation script.
However, 'interestingly'
1 - 100 of 130 matches
Mail list logo