Re: ORA-01722 invalid number

or expressions. Only numeric fields may be added to or subtracted from dates. Action: Check the character strings in the function or expression. Check that they contain only numbers, a sign, a decimal point, and the character E or e and retry the operation. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

Re: query plan is bad when it is run inside a pl/sql stored

to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET

Re: [Q] create tablespace with different block size error???

, like, for instance, block size. If he rearranges the statement, he'll get the right error. -- Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET

RE: tnsnames.ora not working ?

] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

Re: advice

At 07:59 AM 1/15/2004, you wrote: What else can I suggest to help them collect data that will be informative? My business card ;-) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: Connection Problem

PROTECTED] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

Re: Partitioning question (duplicate?)

to accomplish this without changing the data structures. Daniel Fink -- Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network

RE: Should we stop analyzing?

) to them. At 02:19 PM 1/12/2004, you wrote: P.S. whilst the above is fictitious they do care about %utilisation of bandwidth but not response time from remote sites, God that irritates me. Author: Niall Litchfield INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

Re: Hotsos Symposium Dinner

. Gary (817)424-3443 Office (817)296-8000 Cell Hotsos Symposium 2004 - March 7-10. http://www.hotsos.com/appearances/sym2004.php Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Problem with understanding Optimization methods.

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang

RE: Problem with understanding Optimization methods.

rate and import taxes, it becomes very expensive! But I do have a To Get list that I like to update. regards Denham Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang

RE: Should we stop analyzing?

not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -- Author: Pete Sharman INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: Trigger Question

(or that table for that matter) in either the trigger or any called package or procedure. You'll get a mutating table error. Thanks, N. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Trigger Question

, 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see

Re: table reorganizations

are another person to which can only wholeheartedly recommend Jonathan's book. As for your questions, the answer is 42. On 01/07/2004 02:39:26 PM, Shrake, Jolene wrote: What SQL statement do you use to identify tables that need reorganization? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

RE: table reorganizations

And for us dylsexics it has always been 24 At 01:09 PM 1/7/2004, you wrote: and are you sure it's not 57 now due to inflation? -- Bill Shrek Thater ORACLE DBA Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official

Re: HOTSOS Conference

So YOU beat me to it. I'll be there as well. Registered for Steve's seminar as well. At 03:44 AM 1/6/2004, you wrote: I'll be there. I have the distinction (dubious or otherwise) of being the first to register :) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http

RE: HOTSOS Conference

Do you at least arrive before you leave? At 06:09 AM 1/6/2004, you wrote: I'll be there, trying to set a record for the longest time on a plane by any attendee Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE

Re: Statspack wierd Output

') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

Re: Statspack wierd Output

Alternate solution: Don't run it for an hour. One would expect the accumulated wait times to be smaller then and not leading to the value overflow. At 07:14 AM 1/6/2004, you wrote: Statspack taken from a Production Database for a 1 hour period on Oracle 8.1.7.4 version Wolfgang Breitling Oracle7

Re: Top level heaps/subheaps

Welcome back. I was wondering where you've been the last couple of weeks. At 11:19 AM 1/6/2004, you wrote: As well as Arthur's books and Douglas's books. Some of the Robert's, too. Personally, I'd recommend Stranger In The Strange Land. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

Re: (long) Top level heaps/subheaps

Since we're both going to be in Dallas in March I'll have to have you write my name 1000 times ;-) At 01:04 PM 1/6/2004, you wrote: Yeah I know, did it again. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE

Re: Should we stop analyzing?

of the statistics (even though most don't change at all) and could easily restore the prior state. At 12:09 AM 12/31/2003, you wrote: Wolfgang, First off, sorry for mangling your name in the previous post. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

RE: Should we stop analyzing?

/31/2003, you wrote: Wolfgang, I don't have 9i available at the moment so I can't test this. Just wondering if a 10053 trace shows you if the statistics it is using are gathered from dynamic sampling. Henry -Original Message- Wolfgang Breitling Sent: Tuesday, December 30, 2003 6:24 PM

Re: Should we stop analyzing?

') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

Re: help with estimate row count from asktom

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

RE: Should we stop analyzing?

] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

Re: Should we stop analyzing?

immediately begs the question why do it then ), but ever so often the changed statistics cross a threshold to make a different plan appears to be better. It may be better, or it may turn out to be horrible. My point is: shouldn't that be tested first? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

Re: Should we stop analyzing?

by case and at that time the possibility that newer statistics will change the access plan and improve the performance should be explored. Jared -- Author: Jared Still INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

Re: A performance problem

PROTECTED] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

Re: Who are certified Oracle Masters?

... Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: analyze problems

consultant to implement analyzing Like this. BTW column statistics are there but it makes no difference In plans. I also added optimizer_index_caching=90 and Optimizer_index_cost_adj=40 both also without effect on my testcase Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http

Re: Who are certified Oracle Masters?

of his 10g presentation. At 01:54 PM 12/11/2003, you wrote: I know only of Pete Sharman. Who are other Oracle Certified Masters on this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap, Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande. Am I correct

Re: FW: raw traces - EXEC: c=10,000 e=40

. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network

RE: dbms_stats

are like medicine. In the right (i.e. sparing dose) they are a therapeutic tool. In the wrong, especially too high dose, they become poison. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http

Re: raw traces - EXEC: c=10,000 e=40

] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

RE: Copying stats between/amongst schemas

' to 'DEST_USER' while logged in as ADAWDOA (a DBA account which doesn't own anything ;-)), who owns a statistics table called XFER_STATS. exec dbms_stats.export_schema_stats('SOURCE_USER','XFER_STATS',null, user) exec dbms_stats.import_schema_stats('DEST_USER','XFER_STATS',null,user) Wolfgang Breitling

Re: Help on tkprof output

Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Copying stats between/amongst schemas

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: bad SQL day...help please

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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L

RE: Using miss-spelled hint changes explain plan ...

/*+ diving_site(a) INDEX(C PF_EVENTS_N2) INDEX(G PF_ACCOUNTS_U2) ORDERED */ Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat

RE: Using miss-spelled hint changes explain plan ...

-spelled miss-spelled :-) At 01:05 PM 11/20/2003, you wrote: BINGO !! Thanks Wolfgang if I put the misspelled hint at the end, it is ignored ... all plans look the same then. Another (probably) undocumented feature. Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com

Re: col_usage$ question

Rajendra dot Jamadagni at nospamespn dot com Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City

Re: col_usage$ question

. But it is probably useful for various 10g's advisories, which can make you recommendations based on how the tables (columns) are used. Also, it might help automatic statistics gathering to determine which stats need to be updated or not (this gather stale stuff). Tanel. Wolfgang Breitling Oracle7, 8, 8i

Re: col_usage$ question

imagine that Oracle 10 will use that data to recommend indexes - as Daniel suggested. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL

RE: granting SELECT privilege on SYS.X$ TABLES

to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City

Re: RE: Index behavior

on the index=37930 number of distinct keys=38357 number of leaf blocks=1075 Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City

RE: RE: Index behavior

I don't know. I'm just reporting what I found. It was new to me too. At 09:39 AM 11/6/2003, you wrote: OK, I can follow that, but why the change between ABC% and AB% ? Henry Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see

Re: ** SQL WHERE clause order

evaluated first because it has a program variable :select_sen_emp_chk_first and I want it checked before going to the check dept or salary since that will need a table access. Thank You. Wolfgang Breitling [EMAIL PROTECTED] wrote: Why do you want a certain predicate evaluated first? At 02:34 PM 11/4

Re: ** SQL WHERE clause order

Of course there is. The difference between sets and bags is that sets do not allow duplicates. At 11:29 AM 11/6/2003, you wrote: BAG OK, is there a bag of all bags? On 11/06/2003 01:19:25 PM, Wolfgang Breitling wrote: Then put it in procedural logic instead of into the SQL. SQL is a set

OT - Re: Bitmap join indexes

indexes. :D Pd Mladen Gogala Oracle DBA Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: ** SQL WHERE clause order

You're mistaking bags for windbags. At 01:44 PM 11/6/2003, you wrote: Mladen Gogala scribbled on the wall in glitter crayon: BAG OK, is there a bag of all bags? is that anything like a boss of all bosses?;-) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http

Re: any problem rebuilding indexes used for replication

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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE

Re: Re: explain plan conundrum

needed was histograms, Ill bet. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Re: explain plan conundrum

a different join order on these tables earlier and on 'similiar' joins(ie large number of records and only 4 distinct values on the join column) oracle chooses the proper join 'order' Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see

Re: Index hehavior

where name like 'ABC%'; FULL Table scan 1) select id from table1 where name like 'AB%'; Index scan name is an unique index column Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: Re: explain plan conundrum

to the performance. At 10:04 AM 11/5/2003, you wrote: are histograms only used to determine whether to use an index or join type, not join order? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.co -- Please see the official ORACLE-L FAQ: http

RE: Index behavior

) so he can add anything he desires. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL

Re: Index hehavior

) table and index has been analyzed b4 running the query 1) select id from table1 where name like 'ABC%'; FULL Table scan 1) select id from table1 where name like 'AB%'; Index scan name is an unique index column Any help would be really appreciated. -Sami Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

Re: explain plan conundrum

237 HASH JOIN 1 G 20G 237 INDEX FAST FULL SCANPK1 5 K 11 K3 TABLE ACCESS FULL TABLE2 366 K 4 M 231 Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L

Re: Re: explain plan conundrum

gap fix. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: ** SQL WHERE clause order

/AND clause are looked at. Thanks : SELECT emp_id FROM emp WHERE select_sen_emp_chk_first = 'Y' AND dept = :dept AND salary :min_sal Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: tim= values in Windows 2k / Oracle 9.2.0.4 trace files

2028 $ perl tim.pl 18446744069800 07:05:44.069800 Sunday 02 August 1970 tim.pl is the program shown on p134 of Optimizing Oracle Performance. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http

Re[2]: What happened to Howard Rogers ?

--- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling

Re: What happened to Howard Rogers ?

There are laws that are in effect without you having to sign papers. I'm no lawyer and I do understand that just because it appears on some website a statement isn't necessarily true ( we all should be very well aware of that with all the advice about hit ratios and extent fragmentation on

Re: What happened to Howard Rogers ?

this time, I get to write my own material, and when I'm not training, I can stay at home and do real research. I was never sacked by Oracle. Regards HJR Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ

Re: dba interview questions

candidate, the one with the most expensive suit, groundless self-confidence and least amount of knowledge or management capabilities. Racial, gender and religious prejudices are usually a plus. Mladen Gogala Oracle DBA Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http

RE: Cache a table

and someone will correct me. But I doubt I will use the CACHE option anytime soon. Tom Mercadante Oracle Certified Professional Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

RE: CBO with Foreign Key

be using NDV(a,b) not NDV(a)*NDV(b). Hope this is clearer. Again, I'll try to post some actual data as soon as I can. Henry -Original Message- Wolfgang Breitling Sent: Thursday, October 16, 2003 10:04 PM To: Multiple recipients of list ORACLE-L That's the problem with answering without

Re: CBO with Foreign Key

Independence Assumption Fallacy (or I guess maybe the Predicate Independence Assumption) discussed by Wolfgang Breitling in Fallacies of the Cost Based Optimizer. If I am joining a parent and child table (parent PK [a,b]), Oracle assumes a resulting cardinality of : rows(parent)*rows(child)/{max(NDV

Re: CBO with Foreign Key

the CBO (8.1.7) to recognize parent/child relationships? This seems to be an extreme example of the Join Independence Assumption Fallacy (or I guess maybe the Predicate Independence Assumption) discussed by Wolfgang Breitling in Fallacies of the Cost Based Optimizer. If I am joining a parent and child

Re: bitmap conversion on a index that is not bitmapped ???

-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7

Re: CBO Puzzles

the HELP command for other information (like subscribing). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: DB Parameters

oracle 9.2.0.1.0 production . Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: how to keep statistics up to date for CBO

this e-mail message from your computer, Thank you. **5 Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http

RE: how to keep statistics up to date for CBO

! -Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: how to keep statistics up to date for CBO One reason to collect index stats separately would

Re: EXP-00091: Exporting questionable statistics.

this error. Any ideas? -- Thanks, Jake Johnson [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City

Re: How to copy recursive files in Windows? like unix cp -r

want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling

Re: alter session

of 'ListGuru') 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). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com

Cary's Book - new topic

can not until the last pieces are complete. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services

RE: Cary's Book - new topic

but incomplete and the user has to ask 10 questions to get at the one real answer he's after then what good is a fast response time? -Original Message- Sent: Tuesday, October 07, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

RE: Cary's Book - new topic

A totally different point: How come I see your response before I see my own post? At 12:39 PM 10/7/2003, you wrote: Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: RE: Cary's Book - new topic

: The application. Make it fast. Me: Define fast. Customer: As fast as possible. Do it now. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET

Re[2]: Cary's Book - new topic

I W see my own post? Sounds like you can see into the future. Would you mind reading the Wall Street journal and reporting back to us? -rje Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http

RE: Cary's Book - new topic

Actually, something must be wrong with my feed. There are several gaps in the messages judging from the quoted original, which I never saw, in a response. At 03:24 PM 10/7/2003, you wrote: I'm using Method R to post. On Tue, 2003-10-07 at 15:04, Wolfgang Breitling wrote: A totally different

RE: how to send mail from windows command prompt?

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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official

RE: Table not reusing deleted space

, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling

Re: Seems odd to me....(bug?)

PROTECTED] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

Re: Huge optimization costs with 9.2

hours. Of course, I re-analyzed all tables and indexes. The explain plan changed from hash join to nested-loop. All the parameters are same. So I have to put optimized_feature_enable=8.1.7 to make run normal as usual. I hate to disable the new feature, but no choose. Wolfgang Breitling Oracle7, 8

Re: STAT from trace

of the recursive queries. Everything else was identical. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services

RE: STAT from trace

. What's up? Henry Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: locally managed autoallocate (was: Separate Indexes and

). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services

Re: TEMP Tablespace problem

not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED

Re: locally managed autoallocate (was: Separate Indexes and

for autoallocated extents and you thus get 1 extent of the next tier size: 1M Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services

Re: TEMP Tablespace problem

users to temp_new, then offline the old temp tablespace, drop the old temp tablespace, and finally remove the old temp datafiles from OS. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http

Re: locally managed autoallocate (was: Separate Indexes and

, in the place SCSI controllers go when they burn out. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

Re: Multiple block sizes

the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ

Re: Multiple block sizes

experimenting with block sizes like that. I assume index organized tables would be the best solution if you got huge amount of tiny lookup tables, but yeah, in packaged app you can't just start changing physical structure... Tanel. Wolfgang Breitling Centrex Consulting Corporation http

Re: how to generate unique file names on Windows.

message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). Wolfgang Breitling Oracle7, 8, 8i

RE: Hiding passwords

) and retrieve the password across the network, encrypted of course. This works on windows as well, though you're there restricted to doing this strictly from within the Perl script. Jared Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see

  1   2   3   >