Re: How Reliable is Explain Plan in 9.2

like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication

RE: How Reliable is Explain Plan in 9.2

and in some cases would actually perform inserts into some other tables, because that's what you *wanted to do* anyways ... right? I want my dBase IV back ... Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network

RE: Fudging outlines

this be done? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message

Re: sql question ???

(*) - 0 1 row selected. -- 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, California-- Mailing list and web hosting services

Re: System tablespace Oracle 9202

to generate scripts for me, SYSTEM was an lmt. -- 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, California-- Mailing list and web hosting services

RE: how to find elapsed time for a query in oracle 8.1.7 Database

are taking long time. Unfortunately I cannot use Oracle trace for it. Regards, Kranti Pushkarna Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary

Re: Query rewrite help needed

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 This email communication is intended as a private communication for the sole use of the primary

RE: Tablespaces - datafiles

management local uniform size 1m / On both 8.1.7.0 and 9.2.0.1 on RH 7.2 I found that the file was immediately created full size. Platform dependencies maybe? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended

Re: db_file_multiblock_read_count + db file scattered read +

read' ela= 2 p1=10 p2=2948 p3=128 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 http://www.fatcity.com San

Fwd: db_file_multiblock_read_count + db file scattered read +

scattered read' ela= 5 p1=10 p2=2820 p3=128 40 WAIT #3: nam='db file scattered read' ela= 2 p1=10 p2=2948 p3=128 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

Re: A SQL Question

). How do I write a SQL script to get following result? Col1 Col2 A B B A C D D C E F F E G H H G Thanks for your help. - Kirti Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended

Re: Corrected SQL Question...

DAL XYZ HOU AUS HOU DAL HOU LIT HOU XYZ LIT DAL C1 C2 --- --- LIT HOU XYZ DAL XYZ HOU Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee

Re: segment from block#

Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained

RE: db file scattered read

over issuing two scattered reads. At 07:44 AM 3/17/2003 -0800, you wrote: How can you tell that DB_FILE_MULTIBLOCK_READ will not span extents? I was unable to confitrm that on Metalink. Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email

Re: Amt of Training to be considered up to date

somewhere on how many weeks of IT training we need per year to stay up-to-date I would appreciate the links. (The ideal would be if Oracle has a policy or statement re. this that is not necessarily dependent on Oracle University marketing) Wolfgang Breitling Centrex Consulting Corporation http

Re: Gather_system_stats

came across Gather_system_stats and was wondering if anyone had used it? Did it improve the executions plan choice at all? Thanks David Hill DBA Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private

Re: lsnrctl -utility, passing password in a command file

are welcome... Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message

Re: Moving an index

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 Centrex Consulting

RE: Reorganizing tables

to promote them to a higher extent size. If so, I export, drop, recreate and import in a new tablespace. I do not use the 'alter table ... move ...' command since it retains the old extent size for the very 1st extent in the new tablespace. Wolfgang Breitling Centrex Consulting Corporation http

Re: A difficult question :)

time:) TIA ... Best Regards Jai -- 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, California-- Mailing list and web hosting services

RE: Reorganizing tables

:[EMAIL PROTECTED][EMAIL PROTECTED] select tablespace_name, initial_extent, next_extent from dba_tables where table_name='TEST'; TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT -- -- --- TAB4M02 131072 4194304 We are on 8.1.7.4 on HP-UX 11.0 Wolfgang

RE: Storage guidelines in 9iR1 ??

. The methodology was as follows, recording the timing at each step 1) Load the file one time into each of the tables 2) note the number of extents 3) perform the selects -- count(*) -- select * from xxx where id = 1; -- a select with a group by. Wolfgang Breitling Centrex Consulting Corporation http

Re: which index ?

if the table is joined with ( driving table ) -ak -- 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, California-- Mailing list and web hosting

Re: index ??

it doesn't use index while if I put and condition it will used ? IS there any way I can change query or index so that it starts using index ( in a better way ) Thanks, -ak SELECT z FROM X WHERE A = :b1 AND B = NVL(:b2,B) AND C= nvl(:b3,C) And D=nvl(:b4,D) Wolfgang

Re: index ??

Title: Re: index ?? Sorry, forgot to ask the first time. What is the selectivity of B? At 12:53 PM 3/31/2003 -0800, you wrote: well , at A is not null and pt present there is only one distinct value in A. ak - Original Message - From: mailto:[EMAIL PROTECTED]Wolfgang Breitling

Re: Oracle urban legends and myths needed

. I'm sure you have lots of them. Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original

Re: Why dbms_output is not working

') 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

RE: Remote DBA

for non-critical purchases (and sometimes none for those either hehe) so I have to go with the free option, and besides, this lets me manage my linux stations from my win2k boxes and vice versa. Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com

RE: Remote DBA

At 05:27 PM 4/3/2003 -0800, you wrote: -Mensaje original- De: Wolfgang Breitling [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 03 de Abril de 2003 19:24 Para: Multiple recipients of list ORACLE-L Asunto: RE: Remote DBA At 02:18 PM 4/3/2003 -0800, you wrote: From: Nelson Flores [EMAIL

Re: oracle job question

a process ? Is this the resson job is not being executed . 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 http

Re: 8i to 9i clone

a 8i database and moved it over to 9i? I want to clone a database that is on 8.1.7 AIX 4.3 32-bit now, move it to a different server that is running 9iRel2 AIX 5 64-bit. Is this possible and has it been done? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see

Re: submitting statspack.snap through dbms_job

://uk.yahoo.com/mail/tagline_plus/?http://uk.promotions.yahoo.com/yplus/btoffer.htmlYahoo! Plus - For a better Internet experience Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication

Re: why ?????????

evaluate to false. This results in a row being read, checking the predicate and rejecting the row. Okay, gurus, please correct me if I am wrong (by the way, I'm being totally serious...) Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email

Re: count(*) vs count(0)

wrote: Having tested both forms... it looks like to be the same... asktom has a detailed thread about this... sorry, because I'm not posting the url link, but in this moment the site is experiencing 'technical difficulties' :-) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

Re: 10053 trace

what platform? 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 http://www.fatcity.com San Diego, California

Re: 10053 trace

-- Wolfgang Breitling [EMAIL PROTECTED] wrote: At 04:15 PM 5/27/2003 -0800, you wrote: hi gurus i am trying to generate 10053 trace in 9i and have met with no success. i used both 'alter session set events' and 'dbms_system.set_ev'. i used the above two to generate 10053 trace for the same

Re: skip scan index

an example where the optimizer would choose a skip scan - and I had tables with just 1 distinct prefix value. My vote goes for your proposed two indices. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ

Re: Hidden Columns

of: DBMS_STATS.GATHER_DATABASE_STATS(method_opt='FOR ALL HIDDEN COLUMNS'); what is a hidden column. I tried gathering stats FOR ALL HIDDEN COLUMNS and it didn't seem to gather any stats for any columns. What is it meant to do? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http

Re: skip scan index

are not classic B*Tree structures as I was lead to believe but are spiked with an unknown liquor. Thanks for helping me clarify this. 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: skip scan index

wrote: On 2003.05.28 23:04 Wolfgang Breitling wrote: I was about to post the results of my test which also did prove you wrong. I ran the test with a 10046 level 8 trace to show the individual index block reads which nicely show why it is called a skip scan, but since you already proved yourself

Re: x$bh.dbablk values (repost)

this is that the blocks other than random_data listed in x$bh are the segment headers. select segment_name, file_id, block_id, blocks, block_id+blocks-1 from dba_extents where owner = 'BCA' and extent_id = 0 order by file_id, block_id; Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

RE: dbms_stats

and partition_name = 'MAY_28_2003'; NUM_ROWS -- 595500 (FACP-LISA) And Jonathan if you happen to read this email, if I am mis-stating what you stated in class please correct me. I am on 8.1.7.4 and that may be the difference. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

RE: skip scan index

Hey, with all that praise being heaped on you for publicizing your wrongness, who would ever want to be right? :-) At 10:51 AM 5/29/2003 -0800, you wrote: Thanks, Pete. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

RE: dbms_stats

can I trust it to get the rest of the statistics correct? Just my two cents. Thanks for your reply. Lisa 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: Tablespace management.

around with DB2. 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 PROTECTED] Fat City

Re: RE: Tablespace management.

? Does it matter? I do keep all my extents uniform. I thought there were issuse with contention on FET$ and UET$ in dictionary managed tablespaces for a transaction database? or am I just wrong? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

RE: RE: Tablespace management.

Defragmenting... paper says it in section 2.1.4. Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see

Re: Gathering statistics on function-based index

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: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Oracle's use of Indexes

what changed. 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: cannot allocate new log

before you open the database. -Scott 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

RE: Oracle's use of Indexes

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, California

Re: dbms_stats via dbms_job - syntax question

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: wait event puzzler

into another query to see which segment it belongs to, it shows me a table, not an index. How can this be? 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: selectivity of predicates with LIKE - diff between 8i and

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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: wait event puzzler

scan. The word 'TYPICALLY' is the key here. Best Regards, K Gopalakrishnan 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: SQL Query Help

). 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 http://www.fatcity.com San Diego, California-- Mailing list

Re: sequential waits -- how to proceed

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 -- Please

Re: sequential waits -- how to proceed

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 http://www.fatcity.com San Diego, California-- Mailing list

RE: Multiple addreses in tns

of Oracle not going to the next address ?? locdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = invalid)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = valid)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = locdb) ) ) Wolfgang Breitling

Re: OEM Repository Problem

this problem. Do I have to reinstall the Oracle Software again. 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 http

Re: imp table data, but not PK indexes?

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 Centrex Consulting Corporation

Re: logon trigger to start tracing

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 http://www.fatcity.com San Diego, California

Re: Index Usage ?!

light on this Tanel. Regards, Jp. Content-Disposition: attachment; filename==?iso-2022-jp?Q?memb=5Fora=5F2400.trc?= Content-Type: application/octet-stream Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L

RE: Timestamps in trace files (and other trace file oddities)

scattered read reads 18 blocks starting at 6041. Why does the next scattered read start at block# 6042? Any ideas? 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: Timestamps in trace files (and other trace file oddities)

') 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: Timestamps in trace files (and other trace file oddities)

to see what blocks from the other tables are in memory next time I run this. Aside from this indirect approach, any other suggestions on confirming your plausible hypothesis? Is there a way to breakdown the workload of individual cpu's? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

Re: Timestamps in trace files (and other trace file oddities)

with LIOs or PIOs. Dan 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 http://www.fatcity.com San Diego

RE: Timestamps in trace files (and other trace file oddities)

it is only granted to root). Thanks for the offer to look at the 10053. Now that I've finally gotten the chance to work on some of the fun stuff, I'd like to give it a whirl myself. Is the offer still open if I run into trouble :) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

Re: Inlist Iterator and NULLs

to a single (non-joined) statement, it computes the cost and plan like I would expect. It is when we add in other tables and a join condition that it 'loses' its mind. Thoughts? Need More Detail? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

Re: optimizer parameters in Oracle 9.2

discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please

RE: rebuild index -initial extent - magic??!!

if there is data in the index? - how it could possibly deallocate space if you wish to have a smaller extent size. It was very quick. Did I really end up with new extents for XSC_UK each 128K Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com

Re: Inlist Iterator and NULLs *SOLVED*

. The lesson learned here is to not to focus on a 'problem' until you fully understand the whole situation. Daniel 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: HELP! Index Debate!

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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: 9i then 8i Installs

a test box yet and was wondering if it is possible and if so if there are any pitfalls I should watchout for, other then the standard Windows stuff Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http

RE: Multiple Datafiles and performance?

? For future apps I am pushing for optimal recommendations that go for more raid 1 sets or raid 10 over the Raid 5. This should allow for more flexibility for spreading out the i/o. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see

Re: Multiple Datafiles and performance?

, IIRC. The biggest number of files I've had in a production database is about 1150, 960MB each. On WindowsNT4... =8´o 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: possible Bug in Oracle 9.2.0.2

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 http://www.fatcity.com San Diego

RE: Can't insert into partition

as it is executed in the PLSQL procedure, i.e. is the procedure using literals such as 2004 in the predicates for sourcefiscalyear, or is it really using a bindvariable? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L

RE: Can't insert into partition

of list ORACLE-L Is the sql you posted the exact sql as it is executed in the PLSQL procedure, i.e. is the procedure using literals such as 2004 in the predicates for sourcefiscalyear, or is it really using a bindvariable? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation

RE: Can't insert into partition

, but CBO was making a good decision anyway for awhile, then for some reason didn't make a good decision anymore. 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: Record breaking query

(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.comhttp://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http

Re: HELP! Index Debate!

index branch block traversing mechanism can't be used starting with omitted or non-equal predicate and starting from them leaf block linked list is read up to a value is found which doesn't match the last equality predicate? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com

Re: quick suggestions for tuning ?

how many of the LIOs end up as PIOs - the infamous buffer hit ratio. The only way to reduce the # of LIOs is through SQL tuning. any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation

RE: Record breaking query

') 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

RE: Can't insert into partition

). 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: OCP Architecture question

. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value? 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: NEXT_EXTENT and PCT_INCREASE

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 Network

Re: Listener problem on one client computer

pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. 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: latch free wait event

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: [EMAIL PROTECTED] Fat City Network

Re: How to get the source code of the trigger without using

') 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: How to get the source code of the trigger without using

Why is it far fetched and unnatural ? In my view that is the only way to be sure to get the correct source. At 08:09 AM 9/5/2003 -0800, you wrote: Well, the idea of extracting it from user_triggers or dba_triggers is a little far fetched and unnatural, but should work. Wolfgang Breitling Oracle7

RE: 10g

the server or the disk box to get the genie ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

Re: overloading and = comparisons in SQL

: NO. ) 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: overloading and = comparisons in SQL

- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM 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: Weird behavior with VARCHAR fields (was: ORA-01403 error,

I do not understand why it returns a row in SQLPlus and it does not in a stored procedure... The problem is now fixed, but I'd like to know the reason it won't work leaving it as it was. It also fails if I put a string instead of a variable in the stored procedure. Wolfgang Breitling Oracle7, 8

Re: how can I see which database I am logged into without

Email me or post here thanks Gene 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: index suppression and processing

of indexes when doing an implicit conversion? Can we force index use with this statement: delete /*+ INDEX(tablename indexname [indexname]) */ from table_messages. This is the first time we have seen this problem with this table. thanks, David Ehresmann Wolfgang Breitling Oracle7, 8, 8i, 9i OCP

Re: Difference in Performance in two schemas in the same BD

TABLE ACCESS (BY INDEX ROWID) OF 'TCON_DESTRAN' 395942 INDEX (UNIQUE SCAN) OF 'CP01CON_DST' (UNIQUE) TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 Wolfgang Breitling Centrex Consulting Corporation http

RE: Difference in Performance in two schemas in the same BD

90 optimizer_index_cost_adj integer 30 Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 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

RE: how can I see which database I am logged into without

, Mike (LogicaCMG) [EMAIL PROTECTED] sent: Hi, this statement returns the GLOBAL_NAME value rather than the database name. Admittedly the 2 should usually be the same but often (following a database clone for instance) it is not correctly set. Regards, Mike Hately Wolfgang Breitling Oracle7, 8

  1   2   3   >