> > From: Kirtikumar Deshpande <[EMAIL PROTECTED]>
> > Date: 2003/10/24 Fri AM 09:49:26 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: dba interview questions
> >
> > The problem with such lists is that the
e <[EMAIL PROTECTED]>
> > > Date: 2003/10/24 Fri AM 09:49:26 EDT
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > Subject: Re: dba interview questions
> > >
> > > The problem with such lists is that the prospects also have
PROTECTED]>
> Date: 2003/10/24 Fri AM 11:39:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: dba interview questions
>
> We prefer to ask their experiences and then throw a curve ball and ask
them to defend it. Small issues like "Why w
y bad books and then dont read the stuff on OTN.
oracle has very good docs. I do have a beef over lack of syntax examples...
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/24 Fri AM 11:39:33 EDT
> To: Multiple recipients of list ORACLE-L <[
ns are better. Have a development
> DB set up with things for the applicant to do.
>
> I find that most employers ask the same easy
> questions. Particularly developer questions
> >
> > From: Kirtikumar Deshpande
> <[EMAIL PROTECTED]>
> > Date: 2003/10/24 Fri
lt;[EMAIL PROTECTED]>
> Date: 2003/10/28 Tue PM 01:29:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: wither Designer documentation?
>
>
> I have had the same problem. I have contacted Oracle for a "user guide" with
> no resp
ts of list ORACLE-L
does the data dictionary still use rule by support? any idea why toad would
bother slipping it in?
>
> From: "John Shaw" <[EMAIL PROTECTED]>
> Date: 2003/10/28 Tue PM 02:59:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
&g
>>>
does the data dictionary still use rule by support? any idea why toad would
bother slipping it in? > > From: "John Shaw"
<[EMAIL PROTECTED]>> Date: 2003/10/28 Tue PM 02:59:25
EST> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>> Subj
does the data dictionary still use rule by support? any idea why toad would bother
slipping it in?
>
> From: "John Shaw" <[EMAIL PROTECTED]>
> Date: 2003/10/28 Tue PM 02:59:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject:
:29:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: wither Designer documentation?
>
>
> I have had the same problem. I have contacted Oracle for a "user guide"
with
> no response as of yet. I am literally printing off the
this one. atleast they can write one and sell
> the damn thing...
> >
> > From: "Tracy Rahmlow" <[EMAIL PROTECTED]>
> > Date: 2003/10/28 Tue PM 01:29:25 EST
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: wither Design
use rule by support? any idea why toad
would
> bother slipping it in?
> >
> > From: "John Shaw" <[EMAIL PROTECTED]>
> > Date: 2003/10/28 Tue PM 02:59:25 EST
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: ora-600
If there're already hints like ordered and use_nl that tell Oracle how to join,
lack of statistics is less of a problem. In fact, you may need to use those two
hints in some queries against data dictionary even in pre-9i Oracle.
Yong Huang
--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
>
> Jus
Depending on the query, in dba_extents example there are hints only in one
part of multi-part union all SQL, but nevertheless, good point :)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 29, 2003 1:04 AM
> If there'r
I have seen something of the kind done at one of my large customers (600+ databases,
Oracle + Sybase), where I have had more than a hand into the Oracle part (the
inventory is stored in *blush* Sybase) and I am working on something similar with a
colleague elsewhere, where there are _only_ 80 da
Title: RE: Re[2]: performance questions
Mark,
I do not think this thread is OT ... this is till very much on topic. I have been gaining so many views on SLA ... I love this topic.
Raj
Rajendra dot Jamadagni at
r to maintain the SLA then re-negotiation is required.
This is probably harder than it sounds. How does the
service-provider prove that the client has done something
that makes it impossible for the service-provider to
maintain the SLA?
Best regards,
Jonathan Gennick --- Brighten the corn
Hi,
I am sorry if I sounded discouraging.
That wasnt the idea.
anyway if the idea or point was missed
I guess it is not anyway worth labouring on it :)
Best Regards
Cyril
On Wed, 28 May 2003 Joan Hsieh wrote :
>Cyril,
>
>we need some encouragements on those who has the experiences and
>al
a $3m / month performance bonus).
A simple example of re-negotiation is a batch system (system A) dependent
on data from another system (system B). If the SLA says "system A will be
available by 7:00am each day" and system B starts delivering the data at
2:00am instead of midnight, then syst
what did oracle use before the RBO?
>
> From: Mogens Nørgaard <[EMAIL PROTECTED]>
> Date: 2003/06/11 Wed AM 12:39:20 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Rule Based Optimizer
>
> Yep. Here's the official
Perhaps MBO (Mood Based Optimizer)!
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, June 11, 2003 7:39
AM
Subject: Re: Re: Rule Based
Optimizer
what did oracle use before the RBO? > > From:
, 2003 7:39 AM
what did oracle use before the RBO?
>
> From: Mogens Nørgaard < [EMAIL PROTECTED]>
> Date: 2003/06/11 Wed AM 12:39:20 EDT
> To: Multiple recipients of list ORACLE-L < [EMAIL PROTECTED]>
> Subject: Re: Rule Based Optimizer
>
> Yep. Here's the
;Mercadante, Thomas F" <[EMAIL PROTECTED]>
> Date: 2003/06/11 Wed PM 01:25:07 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Rule Based Optimizer
>
> well beat me with a stick and call me black and blue.
>
> of *course* I
06/11 Wed PM 01:25:07 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Rule Based Optimizer
>
> well beat me with a stick and call me black and blue.
>
> of *course* I meant RBO!
>
> Tom Mercadante
> Oracle Certified Professional
>
ens Nørgaard < [EMAIL PROTECTED]>
> Date: 2003/06/11 Wed AM 12:39:20 EDT
> To: Multiple recipients of list ORACLE-L < [EMAIL PROTECTED]>
> Subject: Re: Rule Based Optimizer
>
> Yep. Here's the official statement from Oracle about RBO in 10i:
>
> "The RBO is Or
work necessary'.
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: 11 June 2003 19:10
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: Rule Based Optimizer
>
>
> did oracle
that if I craete a another table that just has
the rows I need, I can often significantly improve performance.
>
> From: "Niall Litchfield" <[EMAIL PROTECTED]>
> Date: 2003/06/12 Thu PM 01:15:08 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>
There's a good document about this two interesting parameters:
http://www.evdbt.com/SearchIntelligenceCBO.doc
and also see "asktom"
http://asktom.oracle.com/pls/ask/f?p=4950:8:308736813964790489::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6601251003901,
=== At 2003-06-16, 04:37:00 you wrote
Tue PM 04:20:10 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 8i OCP Question
>
> Jay,
>
> the answer is B is the funny word there really is "supports".
>
> C is the the predecessor to Rman - and it only works in Oracle
hat I thought might work is that in OEM backup manager only
full backups are allowed on NoArchivelog db's at least that is my
understanding.
From: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: RE: 8i OCP
what will be the name of your book? when will it be out? you have an extract of what
it will cover yet?
>
> From: "Arup Nanda" <[EMAIL PROTECTED]>
> Date: 2003/06/19 Thu PM 03:31:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subj
http://www.dba-oracle.com/bp/bp_titles.htm
Look about in the middle of the page.
> -Original Message-
> what will be the name of your book? when will it be out? you
> have an extract of what it will cover yet?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
sday, June 19, 2003 3:59
PM
Subject: Re: Re: Passwords and
authentication
what will be the name of your book? when will it be out? you
have an extract of what it will cover yet? > > From: "Arup
Nanda" <[EMAIL PROTECTED]>> Date:
2003/06/19 Thu PM 03:31:43 E
"HIPAA Auditing for Oracle Database Security" Nice.
Well, Arup, Get to publishing!
;-)
--Scott
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/19/03 3:19 PM
http://www.dba-oracle.com/bp/bp_titles.htm
Look about in the middle of the page.
> -Original Message
Thanks, Scott.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 6:04 PM
> "HIPAA Auditing for Oracle Database Security" Nice.
>
> Well, Arup, Get to publishing!
>
> ;-)
>
> --Scott
>
>
> -Original Message-
>
ja" <[EMAIL PROTECTED]>
> Date: 2003/06/24 Tue PM 12:25:02 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OR Vs UNION
>
> IMHO ...
>
> Cannot be.. the Access Path Taken is Different.. "OR" is Transfered to
> Inlist It
06/25 Wed PM 02:59:58 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 9i OCP Details
>
> Hi!
>
> If you're getting this OCP to look more appealing to employers, I'd go with
> 8i first, then upgrade to 9i.
> On resume it
;
> Date: 2003/06/25 Wed PM 02:59:58 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 9i OCP Details
>
> Hi!
>
> If you're getting this OCP to look more appealing to employers, I'd go
with
> 8i first, then upgrade to 9i.
ot; <[EMAIL PROTECTED]>
> > Date: 2003/06/25 Wed PM 02:59:58 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: 9i OCP Details
> >
> > Hi!
> >
> > If you're getting this OCP to look more appealing to em
> > then pass an all day comprehensive hands on test right?
> >
> > what do they have you do for that test? i heard there are different
OCMs?
> btw, how much does it all cost?
> > >
> > > From: "Tanel Poder" <[EMAIL PROTECTED]>
> > > D
If you are on windoze this might be of great help. I use it to decipher a lot
of such acronyms :-)
http://www.gurunet.com/
Naveen
> -Original Message-
> From: Ryan [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 8:35 AM
> To: Multiple recipients of list ORACLE-L
&
esday, June 25, 2003 10:57 PM
> >
> >
> > > to get OCM you need to
> > >
> > > take 2 advanced classes
> > > then pass an all day comprehensive hands on test right?
> > >
> > > what do they have you do for that test? i heard there
ate: 2003/06/26 Thu AM 05:49:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 9i OCP Details
>
> > If you want real advanced courses go with [...] what Jonathan Lewis
> > or guys at his level provide.
>
> I have to agree on this.
Title: RE: Re: 9i OCP Details
It's well worth the begging. I went in April and it was a GREAT class. I suggest you do what you can to get there.
-Scott
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 26, 2003 7:15 AM
To: Mul
p before he makes up his mind.
>
> From: "Gudmundur Bjarni Josepsson" <[EMAIL PROTECTED]>
> Date: 2003/06/26 Thu AM 05:49:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 9i OCP Details
>
> > If you want real adva
g' get my boss to
send
me. slow economy. people dont want to spend money on training. :(
hope it doesnt fill up before he makes up his mind.
>
> From: "Gudmundur Bjarni Josepsson" <[EMAIL PROTECTED]>
> Date: 2003/06/26 Thu AM 05:49:43 EDT
> To: Multiple recipien
what office is that internals class taught out of? does anyone else teach it? how many
days is it?
>
> From: "Gogala, Mladen" <[EMAIL PROTECTED]>
> Date: 2003/06/26 Thu AM 11:35:34 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sub
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 9iAS admin certification
>
>
> it is only an associate, though...
> the description of what to study looks like it is EXTREMELY broad
>
> April Wells
> Oracle DBA/Oracle Apps DBA
> Corporate Systems
> Amarillo Tex
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 9iAS admin certification
>
>
> it is only an associate, though...
> the description of what to study looks like it is EXTREMELY broad
>
> April Wells
> Oracle DBA/Oracle Apps DBA
> Co
Title: RE: RE: 9iAS admin certification
From what I have been able to determine... you pretty much have to read everything and hope you remember something for the test.
There is "supposed" to be a book out by WROX publishing... It is 'supposed' to be out in May acco
thanx a lot for your info' Regis.
(B
(Bi need to calculate the exact time taken for IMP.
(Bthe source and target char. set is JA16SJIS,whereas i have UTF8 on test Database.
(B
(BSo thought of changing it to JA16SJIS.
(B
(Bokif there is no other option ...let me re-create the DB
cc:
Subject: Re[2]: Happy Holidays!!
12/20/2002 12:31
of list ORACLE-L
> Subject: Re[2]: Happy Holidays!!
>
>
> Some people have all the luck!! Enjoy
>
> Dick Goulet
>
> Reply Separator
> Author: "Thomas Day" <[EMAIL PROTECTED]>
> Date: 12/20/2002
27;) 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: Centralized StatsPack Repository
Steve,
I am leaning more towards Oracle Str
>- Original Message -
>From: "Sinardy Xing" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Sun, 05 Jan 2003 20:28:36
>
>Ha ha ha... but what is Chanukah?
>
Jewish Diwali :-)
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-
Is it good to use this (_full_table_scan=FALSE)?
If there are less than (say about 1 lakh records), a full scan of
table is better. How efficient is the usage of the above by
setting it to false.
Rgds,
Satya
On Tue, 07 Jan 2003 Koivu, Lisa wrote :
>_full_table_scan=FALSE
>
>-Original Messag
I think you are new to the list.
All '_' parameters given as a solution without a warning that their use can
be dangerous, are meant as fun and nothing else.
Regards
Naveen
-Original Message-
Sent: Wednesday, January 08, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
Is it good
Tim Gorman,
hi, in oracle 9i there is waits=y to print the wait time in the
tkprofed file, but in 7-8i, tkprof does not support this option.
Is there any script that can generate the wait time from the 10046 trace file?
Thanks.
Regards
zhu chao
msn:[EMAIL PROTE
> -Original Message-
> From: Robert Eskridge [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 20, 2003 6:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: Americas Cup
>
>
> Mladen, have you ever seen video of what a Coast Guard .50cal can do
Three options:
* use the "Hotsos Profiler" trace analysis tool from
http://www.hotsos.com
* use the "itrprof" trace analysis tool from
http://www.ubtools.com
* copy a TKPROF executable from an Oracle9i release
and run (through SQL*Net!) against your earlier databas
Message-
> From: Robert Eskridge [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 20, 2003 6:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: Americas Cup
>
>
> Mladen, have you ever seen video of what a Coast Guard .50cal can do
> to a fishing boa
: Monday, January 20, 2003 6:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: Americas Cup
>
>
> Mladen, have you ever seen video of what a Coast Guard .50cal can do
> to a fishing boat? I don't know what armament Ellison's interceptor
> c
Title: RE: Re[2]: Americas Cup
Hi Team
My 2 cents worth. As a Kiwi I can tell you that there is a high level of public interest in the America's cup here in New Zealand. It is after all a major sporting event. However to many people, sail boat racing is as interesting as watching
Ahem
OT list, please?
Jared
DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/21/2003 12:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Re[2]: Americ
>Pomin,
>
>Pls check this tablespace whether it's already
>exist in your database.
>Try this script (connect as sys):
>
>SQL > select * from dba_tablespaces where
>tablespace_name = 'TSelCZ_Data';
Would be better in UPPERCASE. Besides, this is far from being enough. When you drop a
tablespace, t
in 9i, you can remove the datafiles as well by using the clause "and
datafiles" on the drop tablespace command.
Saves having to remember to go back and clean up after yourself.
Without that clause, the drop tablespace command works as it did in 8i
Rachel
--- Stephane Faroult <[EMAIL PROTECTED]>
Thank you very much Dennis and Dick for your info.
wow!! These days I am learning lot. Thanks for my friend Ravi Kiran
who suggested me to join this group..
-Original Message-
Sent: Friday, January 24, 2003 10:35 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Allow me to add
lt;[EMAIL PROTECTED]>
Subject: Re[2]: Peoplesoft & Oracle
Date: Wed, 29 Jan 2003 09:44:23 -0500
David & Lisa,
1st point is that were still on PeopleTools 7.53 so this may be
somewhat
dated. Anyway, go to Peopletools, utilities, use Peopletools options.
Uncheck
the "Grant Ac
think CAREFULLY about this as it invalidates your recovery procedures.
Nologging means there is nothing in the redo logs to be applied. and
your backup is invalid.
Other than that, I suggest you do some research in the Oracle docs. A
VERY brief check (search on nologging) brought me this informati
Breno,
100mb of redo in 20 minutes is not all that high. I have seen far
worse (as I am sure most on the list have as well). Why do you perceive this
as a problem? Are you seeing poor performance or waits?
Is the generation of redo (and archived logs) causing the system to
halt due
You're correct in saying that your undo blocks are protected by your redo
files.
What type of operation are you performing on your table? I ask because only
a small subset of commands support the NOLOGGING feature; the remainder will
generate redo as usual.
If you're not using a syntax that supp
gt;
Sent by: [EMAIL PROTECTED]
01/29/2003 09:09 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re[2]: undo tablespace
Mike,
I asked it because I have a problem.
Any insert data
I agree in principal with Dan's thesis, but I'll add something.
Don't do things that generate unnecessary undo and redo, either.
One common example is SQL that updates a column to a value that it
already contains. For example, we see things like setting a flag='y'
without checking that the flag d
-L <[EMAIL PROTECTED]>
Subject: RE: Re[2]: undo
tablespace
Sent by:
Breno,
There is your problem. Don't try to solve it by trying to eliminate
undo. I have run into that situation several times. The key is to set up the
database management processes to handle the situation.
Things to think about:
1) Increase the size of the device where archive_dum
Title: RE: Re[4]: undo tablespace
I think it might be a typo, or I've not had enuf coffee yet today, but the nologging on b.table2 wouldn't impact the redo logging; nologging on a.table1 would, tho...
> -Original Message-
> From: Breno A. K. Magnago [mailto:[EMAIL PRO
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: ** other oracle forums
>
> The newsgroups comp.databases.oracle.XXX, where XXX is server, misc, tools or
> marketplace. DBA issues are mostly discussed at ...server. If you don't have
> direct access to Usenet, go to groups.google
RHAS Developer Edition, £40 a pop for download. Best money I've spent this
year.
Mike Hately
-Original Message-
Sent: 04 November 2003 15:45
To: Multiple recipients of list ORACLE-L
Tuesday, November 4, 2003, 10:14:25 AM, you wrote:
JT> What I dont like about Suse is no ISOs unless you'
bad decision.
how do i analyze why it made a bad join order decision? hints like this are a stop gap
fix.
>
> From: Yong Huang <[EMAIL PROTECTED]>
> Date: 2003/11/04 Tue PM 02:09:30 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: exp
Could you please post the entire sql and plan and statistics of the tables
and indexes so that we can comment on it rather than letting us guess on
selective bits of the entire problem.
At 01:29 PM 11/4/2003, you wrote:
everything is analyzed. For all indexes, for all indexed columns.
I used an
t; To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: explain plan conundrum
>
> Hi, Ryan,
>
> Where's the 20 billion rows? There's 1 G rows and 20 G bytes.
>
> What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES f
optimizer made a bad decision.
>
> how do i analyze why it made a bad join order decision? hints like this
are
> a stop gap fix.
> >
> > From: Yong Huang <[EMAIL PROTECTED]>
> > Date: 2003/11/04 Tue PM 02:09:30 EST
> > To: Multiple recipients of list ORACLE-
other table and that filters out enough
> rows that that join should go first. The optimizer made a bad decision.
>
> how do i analyze why it made a bad join order decision? hints like this
are
> a stop gap fix.
> >
> > From: Yong Huang <[EMAIL PROTECTED]>
> > Date: 2
However, since it is a join predicate, the histogram data can not be used.
The CBO uses the density values of the join column(s) to derive the join
selectivity. The density value of a column changes (from 1/num_distinct)
when you collect a histogram. If you create a frequency histogram (aka
val
and only 4 distinct values on the join column) oracle
chooses the proper join 'order'
>
> From: Wolfgang Breitling <[EMAIL PROTECTED]>
> Date: 2003/11/05 Wed AM 11:49:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Re: exp
are histograms only used to determine whether to use an index or join type, not join
order?
>
> From: Wolfgang Breitling <[EMAIL PROTECTED]>
> Date: 2003/11/05 Wed AM 11:49:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re:
cant you use rownum with a 'merge'?
>
> From: "Khedr, Waleed" <[EMAIL PROTECTED]>
> Date: 2003/11/05 Wed AM 11:34:33 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: External Tables question
>
> What
> Date: 2003/11/05 Wed AM 11:49:26 EST
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: Re: explain plan conundrum
> >
> > However, since it is a join predicate, the histogram data can not be used.
> > The CBO uses the d
The join order of an access plan - in the absence of any leading or ordered
hints - is determined strictly like everything else by the CBO: the join
order with the lowest estimated cost wins. And the selectivity and
cardinality estimates play a big role in determining the cardinality and
thus c
Histograms are only used to refine the selectivity of a predicate. This in
turn determines the cardinality estimate and various costs such as index
access cost and then of course join costs (NL, sort-merge, and hash) and
join cardinality. This ultimately will drive the decision whether a
partic
t; Date: 2003/11/05 Wed AM 11:34:33 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: External Tables question
>
> What about rownum?
>
> Waleed
>
> -Original Message-
> Sent: Wednesday, November 05, 2003 11:25 AM
>
Jose Luis,
What you say refers to the physical standby database (which works well), not to the
logical standby database (which on the paper looks great, allows you to open the
database, create additional tablespaces, create additional indexes on replicated
objects etc) but which in practice s
Stephane,
What sort of problems can one expect from logical standby?
I'm toying with the idea of using it as a replication database -- no
additional schema objects will be created, but users will have read-only
access to it. It's one of the options I'm looking at.
Seems to me like there was a th
Hi all,
As Stephane told, logical standby (LSB) has a lot of tiny little
exceptions and special issues to cope with. I've done one implementation
in production until now (did appr. 20 Physical Standby sites as well).
But, even that site uses 2 LSB's as reporting systems, and has a PSB for
the HA
there was a thread -- Paul Baumgartel started it looking for
information on logical standby.
IIRC, he found that there were a few "gotchas" -- check the fatcity
archives.
I do know that since it's based on Logminer technology, it has the same
limitations that Logminer does
--- Walt Weaver <[EMA
Walt,
I'll step in here--my experiment with Logical Standby convinced me that
it is not ready for prime time.
1. Major bugs caused apply process to crash repeatedly.
2. Difficulty filtering out DDL from apply stream.
3. Horrendous performance of apply process--frequently the elapsed
time to ap
Walt, drop me your email-address, and I send you the handouts of a
special I presented about DG for Oracle University in
Stockholm.
I'm going out now for a few hours (it's 19.30 over here), but I'll
respond later this evening.
regards, Carel-Jan
At 09:19 12-11-03 -0800, you wrote:
Stephane,
What
:59Para: Multiple recipients of list ORACLE-LAsunto:
RE: Re: Logical StandBy questionWalt, drop me your
email-address, and I send you the handouts of a special I presented about DG
for Oracle University in Stockholm.I'm going out now for a few hours
(it's 19.30 over here)
oles, 12 de noviembre de 2003 19:59
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Re: Logical StandBy question
Walt, drop me your email-address, and I send you the handouts of a
special I presented about DG for Oracle University in
Stockholm.
I'm going out now for a few hours (it
]Sent: Thursday, November
13, 2003 3:34 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Re: Logical StandBy
question
I am
just planning a LOGICAL data guard installation in an important
client.
They
need it for reporting and backup (primary is 24x7x365 and we have hot
801 - 900 of 63825 matches
Mail list logo