ering
statistics on the system tablespacE?
>
> From: "Grabowy, Chris" <[EMAIL PROTECTED]>
> Date: 2003/10/07 Tue PM 03:34:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Desupport of RBO
>
> At the recent NYOUG conferen
ll going to be there.
RBO is necessary if you use layered complex views. CBO often times
doesnt hold up. Its a pretty bad design. But some people use it. I see
it mostly with cross-platform apps. They tell you to always use RBO.
if the RBO is totally gone they will need to totally re-architecture
the
003 4:04 PM
To: Multiple recipients of list ORACLE-L
did he mention any benchmarked performance improvements from gathering
statistics on the system tablespacE?
>
> From: "Grabowy, Chris" <[EMAIL PROTECTED]>
> Date: 2003/10/07 Tue PM 03:34:25 EDT
> To: Multiple r
lex views. CBO often times
doesnt hold up. Its a pretty bad design. But some people use it. I see
it mostly with cross-platform apps. They tell you to always use RBO.
if the RBO is totally gone they will need to totally re-architecture
their products. So I dont know if Oracle will do this.
>
> F
Sorry for having made myself misunderstood.
+ 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or
remove it.
A + 0 can do something when :
1) Put after the name of a number column, eg
WHERE SAL + 0 = 2000
2) And if there is an index on this col
Sorry for having made myself misunderstood.
+ 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or
remove it.
A + 0 can do something when :
1) Put after the name of a number column, eg
WHERE SAL + 0 = 2000
2) And if there is an index on this col
le
recipients of list ORACLE-L" <[EMAIL PROTECTED]>Assunto: RE:
Re: Resource for indexData: 15/10/03 05:29Sorry for having made myself misunderstood.+ 0 does, in
your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or
remove it.A + 0 can do something when :1) Put after the
ap" <[EMAIL PROTECTED]>
> Date: 2003/10/21 Tue PM 03:49:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Performance tuning book
>
> Michael, I've responded by preceding your questions with "MM:" and my
> answers with &
t; From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/10/21 Tue PM 03:49:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Performance tuning book
>
> Michael, I've responded by preceding your questions with "MM:&qu
if i want to improve my math skills how much undergraduate math would you recommend?
>
> From: Paul Drake <[EMAIL PROTECTED]>
> Date: 2003/10/23 Thu AM 02:29:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Your new book
>
> R
PROTECTED]>
> Date: 2003/10/23 Thu AM 02:29:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Your new book
>
> Ryan,
>
> I do not recall seeing a single dy/dx or integrand in the text.
> The type of math that he used, I saw in high
; Date: 2003/10/23 Thu AM 09:39:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Your new book
>
>
>
> -Original Message-
> Sent: Wednesday, October 22, 2003 7:15 PM
> To: Multiple recipients of list ORACLE-L
>
>
Title: RE: RE: Your new book
I took a discrete structures for computer science math class as an undergrad. It was great, once I got past the Swedish accent of the instructor and figured out that "contraposite" was the contra opposite.
Yes, a highly recommended class, even if yo
id prefer to handle this in the database.
>
> From: "Gene Sais" <[EMAIL PROTECTED]>
> Date: 2003/10/23 Thu AM 10:29:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: stupid dbms_job question
>
> It's calle
Just a shot in the dark
Have you set initialization parameters in the init file?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 6:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Re: stupid db
what initialization parameters? job_queue_processes is fine.
>
> From: "Gints Plivna" <[EMAIL PROTECTED]>
> Date: 2003/10/23 Thu AM 11:49:32 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: stupid dbms_job question
>
Ryan,
remove the trunc() from sysdate+1/96 trunc is removing your time part. or you
should be using ROUND(SYSDATE+1/96,'MI') instead.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in thi
JOB_QUEUE_INTERVAL I think
But I found that it is obsolete in Release 9.0.1
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 7:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re: stupid dbms_job que
; From: "Gene Sais" <[EMAIL PROTECTED]>
> Date: 2003/10/23 Thu AM 10:29:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: stupid dbms_job question
>
> It's called cron :). Or you could run a shell script that executes the
prefer to handle this in the database.
>
> From: "Gene Sais" <[EMAIL PROTECTED]>
> Date: 2003/10/23 Thu AM 10:29:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: stupid dbms_job question
>
> It's called cron :). O
; To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: stupid dbms_job question
>
> It's called cron :). Or you could run a shell script that executes then
> sleeps for 5 mins.
>
> >>> [EMAIL PROTECTED] 10/23/03 10:09AM >>>
>
it is obsolete in Release 9.0.1
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 7:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re: stupid dbms_job question
>
> what initialization parameters? j
ation (or an aggregation of 800,000 rows), then the
statement "we have done all the necessary tuning on all the SQL queries"
is not yet true.
If your SQL does actually return about 800,000 rows, then it is time to
begin thinking about the mismatch between business processing
requirem
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
t; To: Multiple recipients of list ORACLE-L
> Sent: Thursday, October 10, 2002 7:43 PM
> Subject: Re: sequence numbers
>
>
> CACHE 20 is the default, so if you remove the clause, it will have absolutely
> no impact on performance or anything else...
>
>
in
KEEP buffer pool. He was helping re-write/enhance some MS Access Apps.
Talk about knowing all the right lingo... ;)
- Kirti
-Original Message-
Sent: Friday, October 11, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L
April,
What can I say? Ouch! I feel your pain. I've
dept) also suggested that we make it an IOT using an LMT,
> and since
> the table will never grow over 1GB, asked if there was a way to put
> it in
> KEEP buffer pool. He was helping re-write/enhance some MS Access
> Apps.
>
> Talk about knowing all the right lingo... ;)
&g
sted that we make it an IOT using an LMT,
> and since
> the table will never grow over 1GB, asked if there was a way to put
> it in
> KEEP buffer pool. He was helping re-write/enhance some MS Access
> Apps.
>
> Talk about knowing all the right lingo... ;)
>
> - Kirti
>
Dick - Thanks for posting your results. We have a different ERP (Lawson),
and we have been considering whether Resource Management is worth the
effort. Currently all users access Oracle through a single userid, but there
is an option for each user to have a separate login. The price is that you
the
AIL PROTECTED]>
> Date: 10/10/2002 1:38 PM
>
> I think that you will have an update to the sequence number EVERY time
instead
> of every 20 times. That's mean I/o for every nextval.
>
> Yechiel Adar
> Mehish
> - Original Message -
> From:
gt; the
> > trash.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: "Yechiel Adar" <[EMAIL PROTECTED]>
> > Date: 10/10/2002 1:38 PM
> >
> > I think that you will have an
Thanx Joe.
let me think about it.
Jp.
On Mon, 28 Oct 2002 Joe Testa wrote :
>based on metalink note, first level of support for 9ir1 ends
>6/30/2003.
>
>you decide.
>
>joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: oraora oraora
INET: [EMAIL PROTECTED]
Fat C
t; Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 23 oktober 2002 20:51
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle or mssql
>
> Xenix is history now...SCO itself stopped it sometime in 1990
>
>
>
>
>
>
>
We had to decide the same thing.
As soon as I saw that support is down in 9 months I decided to go with 9.2.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 3:53 AM
> Thanx Joe.
> let me think about it
bericht-
> Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 23 oktober 2002 20:51
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle or mssql
>
> Xenix is history now...SCO itself stopped it sometime in 1990
>
>
>
>
>
woensdag 23 oktober 2002 20:51
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle or mssql
>
> Xenix is history now...SCO itself stopped it sometime in 1990
>
>
>
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORAC
TED]
10/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: RE: oracle or mssql
I would like to point out that what you call "dirty reads" are mostly
the correct reads. Or
speaking of sound more to me
like sloppy programming.
Is that what you're referring to?
Jared
"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL
of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: RE: oracle or mssql
Date: Wed, 30 Oct 2002 10:42:30 -0800
It sounds like he is saying that, once an "insert, update or delete"
statement has been issued (without a following commit), then the records
acted upon are now considered "
s you are speaking of sound more to me
like sloppy programming.
Is that what you're referring to?
Jared
"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <
<[EMAIL PROTECTED]>
>Subject: RE: RE: oracle or mssql
>Date: Wed, 30 Oct 2002 10:42:30 -0800
>
>It sounds like he is saying that, once an "insert, update or delete"
>statement has been issued (without a following commit), then the records
>acted upon are now considered
not acceptable to be wrong with the data 1/1000 of
the time. You commit the transaction and it is done. You roll a transaction
back for a reason.
>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMA
ramming.
Is that what you're referring to?
Jared
"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
nd more to me
like sloppy programming.
Is that what you're referring to?
Jared
"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]
ECTED]>
Sent by: [EMAIL PROTECTED]
10/30/2002 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: RE: oracle or mssql
I would like to point out that what you call "dirty reads" are mo
t you're referring to?
>
> Jared
>
>
>
>
>
>
> "Yechiel Adar" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 10/30/2002 08:54 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]&
> -Original Message-
>
> I just got steamed up because he called it "dirty" reads. To
> my taste they
> are uncommitted changes.
>
Perhaps it would be better to use Oracle's non-judgmental and eminently more
politically correct terminology of "consistent" versus "inconsistent".
--
Pl
licit (select) or explicit ( start
> transaction ).
>
> SQL Server and Sybase do not guarantee this.
>
> The 'dirty' reads you are speaking of sound more to me
> like sloppy programming.
>
> Is that what you're referring to?
>
> Jared
>
>
>
>
>
>
&
ql.
>
> Dick Goulet
>
> Reply Separator
> Author: [EMAIL PROTECTED]
> Date: 10/23/2002 11:48 PM
>
> goodmorning
> everybody who responded to my basic question : thanks
>
> summary
>
> professional : use oracle enter
lol, I'm never one to do that Dick ;)
Although I do have a great tool for your Peoplesoft environment..
;P
-Original Message-
[EMAIL PROTECTED]
Sent: 01 November 2002 14:49
To: Multiple recipients of list ORACLE-L
Subject:Re:RE: Database Monitoring tool
Come on now Mark.
ing you too literally, or something.
> >
> > What are you really saying?
> >
> > Oracle does not allow dirty reads.
> >
> > All queries are consistent to a point in time, the beginning
> > of a transaction, whether implicit (select) or explicit ( start
> > transaction ).
&
Well, once upon a time there was an event called Boston Tea Party
which dealt with too expensive product of low quality delivered by
a monopoly. I wonder whether we can expect Seattle Windows Party?
Would that be too cruel to the fish in Seattle harbor?
> -Original Message-
> From: [EMAIL
-
> From: Gogala, Mladen [mailto:MGogala@;oxhp.com]
> Sent: Thursday, November 14, 2002 3:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: dumping microsoft desktop?
>
>
> Well, once upon a time there was an event called Boston Tea Party
> which dealt w
Title: RE: RE: dumping microsoft desktop?
Mladen,
Actually the Boston Tea Party happened for the opposite reason. The tea on the ships was of LOWER price because it was not taxed. The 'patriots' owned tons of tea stored in warehouses that they could only sell at a profit with hig
that can't be bought out or voted in
(like the anti-trust case).
> -Original Message-
> From: Gogala, Mladen [mailto:MGogala@;oxhp.com]
> Sent: Thursday, November 14, 2002 3:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: dumping microsoft desktop?
find that most employers ask the same easy questions. Particularly developer
questions
>
> 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 i
I find that most employers ask the same easy questions. Particularly developer
> questions
> >
> > From: Kirtikumar Deshpande <[EMAIL PROTECTED]>
> > Date: 2003/10/24 Fri AM 09:49:26 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
&
same easy questions. Particularly
developer questions
>
> 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 pr
PROTECTED]>
> Date: 2003/10/24 Fri AM 11:29:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: dba interview questions
>
> Ryan
>Would that diagram be in "Effective Oracle by Design" by Tom Kyte? Can
> you elaborate?
>
L 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 &q
; 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 would/would
questions? I think its important for DBAs to be good
developers as well. especially if they are part of a development team. I dont think
the skill sets should be seperate. they overlap.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/24 Fri AM 11:3
sk dbas pl/sql questions? I think its important for DBAs
to be good developers as well. especially if they are part of a
development team. I dont think the skill sets should be seperate. they
overlap.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/24 Fri
portant for DBAs to
be good developers as well. especially if they are part of a development
team. I dont think the skill sets should be seperate. they overlap.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/24 Fri AM 11:39:33 EDT
> To: Multiple recipi
Title: RE: Re: dba interview questions
and at least if someone takes the time to read a book and get the whole picture, they have some kind of gumshun.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
> > 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
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
801 - 900 of 63305 matches
Mail list logo