Rachel, I love those animations on the last slide!! :0)
g
-Original Message-
Sent: Wednesday, June 27, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L
Joe,
Oops, not that I forgot, I don't think I knew.
okay KEVIN!!! :)
Will send him a new copy to put up
thanks I thought it would be a good way to end it on a smile
From: Guy Hammond [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT: Re: Common Oracle RDBMS Misconceptions
Date: Fri, 29 Jun 2001 08:11:48 -0800
Rachel, I
by: cc:
[EMAIL PROTECTED] Subject: Re: Common
Oracle RDBMS Misconceptions
26-Jun-2001 06:33 PM
Please respond to
ORACLE-L
Sender Info
I want pointers to some more articles like that so that I rid myself of the
disease called 'Common Oracle RDBMS Misconceptions'
enlighten me with clear explanations along with proof
coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L
Hi,
Can't remember who started this thread but the most common misconception I see
is :
NOLOGGING (UNRECOVERABLE) stops redo log generation.
though another favourite of mine is :
The Universal Installer is useful and
You can use the 8i database assistant to reliably create a database.
Hi
Slightly off-topic ... if you're interested in a dictionary of clear
definitions of mystical concepts, may I recommend ...
http://www.sucs.swan.ac.uk/~arthur/jargon/html/entry/tail-recursion.html
There's also a well-written boil-down of the last 50 years of IT development
into one and a half
I still like the Scott Adams variant:
If you have an infinite number of monkeys and an
infinite number of type writers, then you will
eventually get ... a lot of dead monkeys
Tip: You need to feed them
--- Greg Solomon [EMAIL PROTECTED] wrote:
Hi
Slightly off-topic ... if you're
sorry greg
I could make neither head nor tail of the links
coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 28, 2001 8:49 PM
Hi
Slightly off-topic ... if you're interested in a dictionary of
|
|| |
|+---
--|
| |
| To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]|
| cc: (bcc: Mike Hately/ETECH) |
| Subject: Re: Common Oracle RDBMS Misconceptions
Tee hee Mike said spank hooo ho
-Original Message-
Sent: 26 June 2001 14:47
To: Multiple recipients of list ORACLE-L
I've never found hot backups shocking myself. Is it possible that rather
than
visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited
Yes, but look also at bug 1176609.
Dr. Nikolay Kumanov
MIS Manager, Zeitungsgruppe Bulgarien GmbH
47, Tsarigradsko chaussee, Sofia 1504, Bulgaria
phone: +(359-2)4339-643, fax: +(359-2)946-1286
mailto:[EMAIL PROTECTED]
Show me a completely smooth operation and I'll show you someone who's
by: cc:
[EMAIL PROTECTED] Subject: Re: Common
Oracle RDBMS Misconceptions
26-Jun-2001 06:33 PM
Please respond to
ORACLE-L
Sender Info:
No Sender Info
, will see if I can
get
it onto the NYOUG site
From: Post, Ethan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 18:16:04 -0800
Couldn't open it with PPT 97
Title: RE: Common Oracle RDBMS Misconceptions - standby db?
I guess that's the scenario I was thinking of, Stephane. Primary completely hosed and needing modification in one way or the other... and several hours between failover and switching back with the possibility of a few lost
Title: RE: Common Oracle RDBMS Misconceptions - standby db?
Thank you Jeremiah for your explanation. But to clarify, you can't have both databases open at the same time, can you? That's where I hosed stuff up the first time, and I realized why it didn't work immediately after seeing my error
think I knew.
okay KEVIN!!! :)
Will send him a new copy to put up there.
Rachel
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OT: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 20:30:31
tears of happiness
thank you, thank you, thank you...
/tears of happiness
--- Jeremiah Wilton [EMAIL PROTECTED] wrote:
With graceful standby failover (I demo'd it last
year at OOW), you can switch
back and forth, back and forth as many times as you
want without recopying any
database.
cc:
Sent by: Subject: RE: Common Oracle RDBMS
Misconceptions -
root@fatcity.standby db
How about timed_statistics=true is a performance overhead.
Or you still worry about temp segments not being released after a sort.
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS
On Tue, 26 Jun 2001, Stephane Faroult wrote:
But in practice, why would you switch to the standby database, unless
the primary database is crashed or worse?
- Hardware replace/repair
- Move to a larger host
- O/S upgrade
- File layout revision
- Planned/impending infrastructure outage
-
Jeremiah,
You've hit most of mine, but here are a few more:
* It's OK to continue using a db after you've forced
it open.
* To remove a datafile from the db, all you need to
do is offline drop it.
* All there is to switching from RBO to CBO is to
analyse the tables.
* You can apply
and apply the
logs, and put into managed recovery mode.
Mike
From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Common Oracle RDBMS Misconceptions - standby db?
Date: Tue, 26 Jun 2001 11:12:24 -0800
OK. I admit my
Toepke, Kevin M wrote:
Rachel:
The problem seems to be the ftp from work to the OOUG web site (it gets
corrupted in the transfer.) I'll try again later from home.
Kevin
-Original Message-
Sent: Wednesday, June 27, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L
On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
Hi everyone,
I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
I was shocked to read Hot backup mode explained
If this is true then I may be a victim of a disease called
'Common Oracle RDBMS Misconceptions' . Somebody
:
[EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS
Misconceptions
Well i dont know about everyone else, but i knew thats how the hot
backup worked, but then again, i've not attended oracle education
classes either, just some hard core reading and have gotten all of my
backup/recovery concepts from Rama Velpuri's book. An excellent book if
you dont have it.
[EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 04:00:54 -0800
Well i dont know about everyone else, but i knew thats how the hot
backup worked, but then again, i've not attended oracle education
classes either, just some hard core reading and have gotten
Yep, that's the way it works. Whoever started the rumor that the datafiles
were unwriteable hadn't looked into the process deeply enough to understand
it. The Oracle Ed. class that I took for backup and recovery explained the
process exactly as it is, using the checkpoint, redo, and rollbacks
as it
is logging the stuff that needs to be applied when restored (until the
end backup command).
Original Message
On 6/26/01, 11:10:28 AM, Jeremiah Wilton [EMAIL PROTECTED] wrote
regarding RE: Common Oracle RDBMS Misconceptions:
Rollbacks? What's their role in the hot backup mechanism?
--
Jeremiah
Rollbacks? What's their role in the hot backup mechanism?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 26 Jun 2001, Holman, Rodney wrote:
Yep, that's the way it works. Whoever started the rumor that the datafiles
were unwriteable hadn't looked into the process deeply enough
yeah,
that is an awesome write up he did.
"Walking on water and developing software from
a specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 26, 2001 5:06
]To: Multiple recipients
of list ORACLE-L
crimea.ua [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Common
Oracle RDBMS Misconceptions
26
, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Common Oracle RDBMS Misconceptions
I've never found hot backups shocking myself. Is it possible that rather
than
visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited
www.spankeasy.net (I'm not even
Bhahahaah
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 26, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L
I've never found hot backups shocking
or neither of our
papers :)
Rachel
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 09:05:27 -0800
All right folks, I'm collecting misconceptions
Well perhaps you can start writing articles for people.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 26, 2001 8:01 AM
To: Multiple recipients of list
oh yea baby.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Tuesday, June 26, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L
I've never found hot backups shocking myself. Is it possible that rather than
visiting Jeremiah's site
Based on Gaja's book, tune based on waits not based on hit ratios.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Tuesday, June 26, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
All right folks, I'm collecting misconceptions, of
Yea, hit ratios are never important.
Ever.
For anything.
-Original Message-
Sent: Tuesday, June 26, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L
Based on Gaja's book, tune based on waits not based on hit ratios.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
1) If an index exists, it will always be used.
2) It is ALWAYS a database problem.
Terry
Jeremiah Wilton wrote:
All right folks, I'm collecting misconceptions, of the type held by newbies and
oldtimers alike. My OOW proposal this year is for a presentation and paper on a
whole laundry list
I think it's on a site somewhere in Bulgaria.
-Original Message-
Sent: Tuesday, June 26, 2001 2:47 PM
To: Multiple recipients of list ORACLE-L
Rachel,
I am interested in reading your paper - Exploding the Myths. How do I get
access to this paper? Is it available on any website?
Hi Jeremiah,
First, I believe it's a misconception that on a Unix system there can be no
data lost in an Oracle DB from a system crash. This HAS to be a function of
syncer, doesn't it? And, therefore, until syncer decides any buffer
writes actually go to disk, transactions can be toast.
Rachel,
I am interested in reading your paper - Exploding the Myths. How do I get
access to this paper? Is it available on any website?
Thanks
Rao
-Original Message-
Sent: Tuesday, June 26, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
Jeremiah,
Marlene and I did an
Title: RE: Common Oracle RDBMS Misconceptions
I missed the call for presentations for OOW!
Is it too late?
Where do I find it? (looked at ioug.org, didn't see it)
R. Matt Adams - GE Appliances - [EMAIL PROTECTED]
Give me an hour alone in a bank
Pay all my tickets, wipe the slate
, but really
close.
It will be interesting to see if they choose one, both or neither of our
papers :)
Rachel
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue
Title: RE: Common Oracle RDBMS Misconceptions - standby db?
OK. I admit my knowledge on standby is minimal, having only read up on it, fiddled with it and used the idea sparingly for migrations.
However, Jeremiah, I'm very curious. You state that 'Must reinstantiate standby after failover
1) A full table scan is a bad thing
2) the order of things in the FROM/WHERE clause matters (is true in the
RULE-based world)
-Original Message-
Sent: Tuesday, June 26, 2001 2:27 PM
To: Multiple recipients of list ORACLE-L
1) If an index exists, it will always be used.
2) It is ALWAYS
Gaja makes very good points about the importance of hit ratios but I don't
think we should go 180 degrees the other way and abandon them all together.
They certainly tell us something. They just shouldn't necessarily be a
tuning goal. However, most of us are only seeing the hit ratio as of
On Tue, 26 Jun 2001, Jesse, Rich wrote:
First, I believe it's a misconception that on a Unix system there can be no
data lost in an Oracle DB from a system crash. This HAS to be a function of
syncer, doesn't it? And, therefore, until syncer decides any buffer
writes actually go to disk,
Jesse, Rich wrote:
Hi Jeremiah,
First, I believe it's a misconception that on a Unix system there can be no
data lost in an Oracle DB from a system crash. This HAS to be a function of
syncer, doesn't it? And, therefore, until syncer decides any buffer
writes actually go to disk,
. Not quite, but really
close.
It will be interesting to see if they choose one, both or neither of our
papers :)
Rachel
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS
I guess I shudda thrown a smiley in there. yikes...
Anyway, I hope i am not in the minority when i say
that i think hit ratios *are* important, even
in tuning. I just don't think they are the sine
qua non of tuning.
-Original Message-
Sent: Tuesday, June 26, 2001 4:21 PM
To: Multiple
Too late!!
Gaja stole it and wrote a book about it !!
- Kirti
-Original Message-
From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Common Oracle RDBMS Misconceptions
Rachel,
I am
With graceful standby failover (I demo'd it last year at OOW), you can switch
back and forth, back and forth as many times as you want without recopying any
database.
Basically, when you fail over to a standby, you shut down the primary, apply all
the archived redologs to the standby, then copy
But in practice, why would you switch to the standby database, unless
the primary database is crashed or worse? You know how it is in a
production environment, the database crashes. Even if failover is easy,
you always have to instruct users to connect as scott/tiger@backup
instead of
story? (Or advice as to how this can be
done?)
-Original Message-
From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Common Oracle RDBMS Misconceptions
All right folks, I'm collecting misconceptions
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 12:26:20 -0800
Where can I get the exploding the myths paper?
Thanks,
Ken Janusz, CPIM
Jeremiah,
Marlene and I did an exploding the myths paper very
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 12:40:50 -0800
snip
Of course I plan to explain them, but tell me what intrigues you. I'd
-L [EMAIL PROTECTED]
Subject: RE: Common Oracle RDBMS Misconceptions - standby db?
Date: Tue, 26 Jun 2001 15:21:00 -0800
With graceful standby failover (I demo'd it last year at OOW), you can
switch
back and forth, back and forth as many times as you want without recopying
any
database.
Basically
]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions - standby db?
Date: Tue, 26 Jun 2001 16:27:34 -0800
But in practice, why would you switch to the standby database, unless
the primary database is crashed or worse
: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Common Oracle RDBMS Misconceptions
All right folks, I'm collecting misconceptions, of the type
held by newbies and
oldtimers alike. My OOW proposal this year
the paper on their sites. Once I get a copy, it will get posted
to the NYOUG site (www.nyoug.org)
Rachel
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 12:26:20 -0800
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 09:05:27 -0800
All right folks, I'm collecting misconceptions, of the type held by
newbies
and
oldtimers alike. My OOW proposal this year is for a presentation
well it does not exist
will you 'please' be more clear as to what you want to convey
coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 8:16 PM
I've never found hot backups shocking
64 matches
Mail list logo