RE: Number of joins in the query

Since the primary key/foregin key can be composite, there can be more than n-1 join conditions, but there will be only n-1 joins. e.g. A's primary key is col1 and col2 referred by B's col1 and col2 in this case you will only have 1 join, between A and B, but 2 join conditions A.col1 = B.col1 an

RE: Purely for your amusement

Title: RE: Purely for your amusement More wonderful is that the users are complaining about poor performance and not of wrong data it is returning.   Are the users comfortable with catesian products returned to them with meaningless data?   Regards Naveen -Original Message-From: J

Re: system/internal tables for query tree

In ver 9 you could look at v$sql_plan. It is not available before that, but you could look at the defn for v$sql_plan and see if the relevant x$ tables are in any way available in the later versions of 8.1 hth connor --- Chuan Zhang <[EMAIL PROTECTED]> wrote: > > DBAs, > >Does anyone by a

Re: Oracle Performance Tuning Exam

Depends on the path chosen to Oracle 9i DBA OCP: 1A) Pass the 5 Oracle 8i OCP DBA exams, then pass the Oracle 9i DBA OCP upgrade exam (total of 6 exams, but still does not need an Oracle Univeristy course) Note: if Oracle retires the Oracle8i DBA exams like the Oracle 8 DBA exams, they would be

Re: Fwd: RE: newbie dba question - another try

Thanks Darell! Your advice as well as from others is greatly appreciated.  Darrell Landrum <[EMAIL PROTECTED]> wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be

system/internal tables for query tree

DBAs, Does anyone by all means know the system/internal tables which store the information about query tree? "Query tree" is an internal representation of an SQL statement where the single parts built in(Join, projection..) are stored separately. Many thanks in advance. Chuan -- Please s

Re: [Q] does ORACLE 9i primary and stansby DB need same name???

dist cash, The same restriction still exists for 9iR2, for regular Standby Databases (a.k.a DataGuard). However, in Oracle 9iR2, you could set up Logical Standby database, which can be in a separate name. But then again, logical standby is not really along the same lines the regular standby (in 8i

Re: Fwd: RE: newbie dba question - another try

Thanks Darell! Your advice as well as from others is greatly appreciated.    Darrell Landrum <[EMAIL PROTECTED]> wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be ru

Re: Partitioning

Title: RE: Partitioning It's true for 9.2, too. It doesn't make sense to have different storage parameters for hash partitions. - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 26, 2003 6:39 PM Subject:

Fwd: RE: newbie dba question - another try

Reply to ///Thanks very much to everyne! I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performac

Re: MetaLink on the blink

I'm getting in just fine ! Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 11:04 AM > It appears that MetaLink has just taken a dive. > > A

Re: MetaLink on the blink

It seems to be working fine Jared. give a try again. Jp. 2003/02/28 9:04:07, [EMAIL PROTECTED] wrote: >It appears that MetaLink has just taken a dive. > >Anyone else notice, or is it just me? > >Maybe I'll try another site. > >Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.n

[no subject]

set oracle-l nomail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

Re: PGA question

Presumably they affect some of the required memory structures - shouldn't be too hard to work out I would have thought. Just measure the pga usage via sesstat and play with the parameters to see the impact hth connor --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: ---

RE: MetaLink on the blink

Title: RE: MetaLink on the blink Jared, Must be just you. ;-)  I just got on it at 7:20 PM Central time and did a search. REALLY fast for once. Maybe they did an upgrade or just that the majority of users have gone home. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROT

Fwd: RE: newbie dba question - another try

   Note: forwarded message attached.Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more--- Begin Message --- Thanks very much to everyne! I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be runni

Re: table name = schema name issue?

I have not killed my self testing everything I can think of, but all the testing I have done to this point does not seem to hurt having a table name same as schema owner. From: Webber Valerie H <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL

RE: MS SQL hasn't given up!

As long as I'm not replaced by an open source (cheap) DBA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 925-7187 [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Thurs

RE: MetaLink on the blink

working for me! -Original Message- Sent: Thursday, February 27, 2003 7:04 PM To: Multiple recipients of list ORACLE-L It appears that MetaLink has just taken a dive. Anyone else notice, or is it just me? Maybe I'll try another site. Jared -- Please see the official ORACLE-L FAQ: htt

RE: Purely for your amusement

The numbers look normal based on three Cartesian joins. Multiply the card for those Cartesians and you will get big numbers. Is the sql missing the join predicates(I'm tired to look further)? Regards, Waleed -Original Message- Sent: Thursday, February 27, 2003 1:24 PM To: Multiple

MetaLink on the blink

It appears that MetaLink has just taken a dive. Anyone else notice, or is it just me? Maybe I'll try another site. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com Sa

RE: Purely for your amusement

Title: RE: Purely for your amusement Heh. 6 tables, 2 where statements, one of which is an outer. Gotta love it. I'm thinking of building a tool that intercepts dumb SQL and emails back a raspberry. Whaddya think, is there a market for such a utility? > -Original Message- > From: B

Re: Purely for your amusement

Hmm. Joining 6 tables, but only 3 appear in the where clause. Small wonder if it runs a long time. Jared Barbara Baker <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/27/2003 02:51 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE

RE: Ora 29540 error

We were finally able to get this redone. Thank you so much for your help. Randy R. Pace Development Team Leader Accela, Inc. 9662 South 700 East Sandy UT, 84070 Tel: 801 495 9300 Fax: 801 495 9301 www.accela.com -Original Message- Sent: Wednesday, Decembe

RE: Purely for your amusement

Barbara, This might be an obvious comment, but isn't the where clause missing a few join conditions? eg - these 3 tables don't seem to get mentioned: ADMARC.CNR CNR, ADMARC.WOEMANIFEST_VIEW WOEMANIFEST_VIEW, ADMARC.WO_CHARG_VIEW WO_CHARG_VIEW Regards, Bruce Reardon -Original Message- Sen

Re: DBV

One of the issues with dbv is that is assumes that you use a 2k block size. In addition, you will want to ignore files for temporary tablespaces. I use the following code to create a shell script to run the dbverify commands. Incorporate this code into a wrapper script and run it periodically.

Re: Purely for your amusement

I found it in our "offending sql statements" report we get from the database each morning. Went looking when someone complained about poor performance. (Ya, do you THINK) Probably not Discoverer. I think it was either Access or Crystal. (When I found it, it had double quotes around everyth

RE: shared tnsnames.ora

With Oracle, you MUST run OID for LDAP. There is no other supported LDAP, and since OID doesn't generate v3-compatible LDIFs, the Oracle schemas in OID are not easily ported to a non-supported LDAP (like SunOne). Oracle says "Sure! We support any v3-compliant LDAP!" Not really. They support a

RE: shared tnsnames.ora

Regarding distributing the tnsnames - you could use a very simple Windows batch file to do that (eg have PC names in 1 text file) and use FOR /F to process it. This works best if tnsnames lives in the same place on each client. Or create an env variable / registry key on each client to point to

Re: Purely for your amusement

That is truly awesome Barbara, I don't envy you. ;) But, it is incomplete without the offending SQL. Jared Barbara Baker <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/27/2003 10:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]

Re: temporary tablespace using tempfile

Connor, Thanks for your reply. Where can I find these information about what temporary segment will generate redo/undo? Jos  Connor McDonald <[EMAIL PROTECTED]> wrote: "depends" but tpically, a lot less.Exceptions are easy to find - eg, you need undo for aglobal temp table because you are allowed

RE: shared tnsnames.ora

The problem is if that shared tnsnames.ora then becomes a massive single point of failure. If for some reason someone messes up this file or it becomes unavailable. All your users would be left out of the databases. I REALLY think Oracle Names is the way to go. (I have used it in 1000+ user envir

RE: Purely for your amusement

RF, This looks like a good one for your list: "11. Developers of SQL should consider using a WHERE clause." Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -Original Message-

Re: Purely for your amusement

This wouldn't happen to be Discoverer would it?>>> [EMAIL PROTECTED] 02/27/03 03:24PM >>>Barbara,Don't worry about the explain plan...  What's the BHR looking like?I guess in all seriousness this query is most likely missing some joinsgiven the CARD result and the CARTESIAN's in the plan.  H

RE: shared tnsnames.ora

If you are not going to use Onames, another consideration is to create an DNS alias for your db server host and use the alias in the tnsnames file for host value.  It makes it easy to the move database to another server and make 1 change to DNS.   On the listener side, I always use localhost

Re:MS SQL hasn't given up!

I don't believe MS will ever give up. Isn't that part of American Capitalism? Your competitor does you one better on some test, therefore you've got to better them. Give Oracle a couple of weeks and we'll here that one too. But seriously, how many of us really care about the TP-C benchm

RE: shared tnsnames.ora

John - Here is a white paper on Oracle's site. I keep seeing where Oracle is encouraging people to switch to LDAP and that Names will eventually go away, and that has discouraged me from going the Names route. Maybe that will never occur and 10 years from now Names will be going strong. Of course,

RE: shared tnsnames.ora

John In the past the answer was to set up Oracle Names. I think Oracle said they will be phasing that out in favor of LDAP systems. I believe if you are starting today the best idea would be to consider Oracle Internet Directory, or more generically an LDAP system of some type. Dennis Willi

Re: Oracle Performance Tuning Exam

If you are taking the 9i certification, there are only 4 exams that you have to take. Unfortunately, unless you took at least one exam last year and got "grand-fathered", you will have to enroll at Oracle U. for one of the four courses covering the certification exams. -- Alan Davey [EMAIL P

Re: Purely for your amusement

Barbara, Don't worry about the explain plan... What's the BHR looking like? I guess in all seriousness this query is most likely missing some joins given the CARD result and the CARTESIAN's in the plan. Have fun. Oh, and is the CNR table analyzed? Regards, Mark.

RE: Purely for your amusement

Let me guess: this is a 64-bit implementation of Oracle on HP? There are apparently lots of Endian bugs in how the Oracle kernel emits statistics on this platform. It's common, for example, for 10046 trace files to contain row counts in the millions of trillions (or something like that). It's not *

RE: shared tnsnames.ora

Easy to maintain?? The "maintenance" of an alias is to DELETE it, then add it again. Oracle officially does not support maintenance of alias information in ONames. This really bites, especially when your network domain changes. The solution is to modify the repository directly. If you're u

RE: shared tnsnames.ora

Below is the end of my own tnsnames.ora located on my PC. There is a common network tnsnames.ora on a network share located on my 'R' drive. The network version has all the permanent databases defined in it. I can add any temporary or new test servers to my copy of tnsnames.ora and still get to

RE: Purely for your amusement

Title: RE: Purely for your amusement Barbara, I just gotta know: How long does it take to run? Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From:   Barbara Baker [SMTP:[EMAIL PROTECTED] And you thought your job w

table name = schema name issue?

Title: table name = schema name issue? Are there any known issues to having a table name the same as its schema name? Such as EMPLOYEE table in the EMPLOYEE schema. Someone told me there was an issue when Oracle tried to resolve EMPLOYEE.EMPLOYEE in the code. Thanks in advance. Val Valerie

RE: MS SQL hasn't given up!

Title: RE: MS SQL hasn't given up! He's got a good point,  performance at that point doesn't matter if your system must be rebooted weekly, and crashes every couple of days.     The tests should be run 24x7 for 350 days... to get a real idea on what kind of reliability and performance you

Re: Purely for your amusement

Have you tried including a WHERE clause ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd

RE: MS SQL hasn't given up!

Title: RE: MS SQL hasn't given up! I would be curious to know what changes they made to the OS, what services they decided not to run.   Did they follow their own security guidelines before running the tests?   Pat. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PRO

RE: MS SQL hasn't given up!

Title: RE: MS SQL hasn't given up! Paula,   I like the 100% tired part.   Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

RE: Oracle Performance Tuning Exam

Title: RE: Oracle Performance Tuning Exam There are totally five exams we have to pass to get certified, I'd like to know which exam should I take first and what next in order?    Thanks, David   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thur

RE: IOUG setting up

Paula, If your local Oracle User Group isn't giving enough attention to Oracle, then what are they giving attention to? Is it more developer or applications focused? Or so much of a vendor controlled group that they don't do much besides advertise for the vendors products? Here in AZ, we apprec

RE: shared tnsnames.ora

-Original Message- > I am looking for info on how you support a large > number of PCs (200+) and keep each ones tnsnames.ora > file in sync. --- One way is to use Oracle names servers. For some reason, I have never liked this. No particular reason. Another w

RE: shared tnsnames.ora

John, Your answer is. Oracle Name Server. There were some details on the list a few weeks back. ML has a number of notes. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this

RE: Purely for your amusement

Title: RE: Purely for your amusement Misery loves company.  Thank you!  By the way...  how long does this take to finish?  -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 27, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Subject

RE: MS SQL hasn't given up!

Title: RE: MS SQL hasn't given up! I agree - the biggest advantage Oracle has to MS SQL Server is Unix stability to Windows stability.  -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, February 27, 2003 2:44 PMTo: Multiple recipients of lis

RE: Purely for your amusement

Disable all triggers, primary keys and foreign keys... they are obviously causing all your problems. Consider purchasing the same hardware as the one used for the MS SQL Server benchmark. (not) Regards, Pat. -Original Message- Sent: Thursday, February 27, 2003 2:53 PM To: Multiple recipi

RE: MS SQL hasn't given up!

Title: RE: MS SQL hasn't given up! I think it is foolish to ignore MS SQL at this point.  I think that knowing MS SQL only benefits me as a Oracle DBA in the long-run.  It helps to understand the core concepts of managing RDBMS.  I don't think I could know both in the same amount of detail and

RE: Upgrade to AIX 5.2

Tracy, We are still debating this issue with our preferred App Vendor... Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue. Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, as *none* of the new features of 9i would be used

Re: shared tnsnames.ora

Use Oracle Names. Easy to setup/maintain. never touch a client config again. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

Re: Upgrade to AIX 5.2

I am testiing 9iR2 on aix 5.2 now.  We will be going to 64bit when we upgrade all databases.  It seems fine to me. Ruth - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Thursday, February 27, 2003 8:29 AM Subject: RE: Upgrad

Re: MS SQL hasn't given up!

If you know MS. You should know they will never give up. They will conquer the Universe one day. Resistance is futile. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > For your amusement, MS thinks they can "now" equal Oracle in > performance > (wasn't that what they claimed 3 year

shared tnsnames.ora

I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync.  It seems that most people do not touch them.  Some try to modify them and when new databases are created, the tnsnames.ora files must be changes as well.  It seems to be that

RE: Purely for your amusement

I have a hard time believing these figures... unbelievable! Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes

RE: MS SQL hasn't given up!

Title: RE: MS SQL hasn't given up! Select * from dual / always gives good performance ... Okay ... MS got good numbers, so assume that system was so tweaked that no other program else might be running on it for all we know. Launch a local IE and see the TPC-C go down ... (I know, sometime

RE: IOUG setting up

Paula - Not sure what part of Florida you are from, but here is the link for South Florida's OUG http://www.sfoug.org/SFOUG.jsp Gene>>> [EMAIL PROTECTED] 02/27/03 01:11PM >>>Paula, I just did a search at ioug.org and it looks like there are 5 OracleUser Groups in FL. (Guessing based on your e

RE: RE: Dealing with 3rd Party Applications

Dick You make some excellent points. I had a vendor recently that supplied scripts to import everything under SYS. In that case I spent some time loading their schema into a test database then exporting it again so I could import it harmlessly into a non-SYS schema on production. I think it

RE: Upgrade to AIX 5.2

John/Kirti, We are in the same boat with you. However, we were looking to first upgrade to AIX 5L first and leave our existing 8.1.7 32-bit databases (booting the server in 32 bit mode). In a subsequent phase we would upgrade 8.1.7 32-bit to 9.2 64-bit. The downside to this is that it will affe

RE: Perl Modules

Platform? Perl version? You may want to consider joinging the DBI Users list. It can be found at lists.perl.org Jared sstefick <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/26/2003 09:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PR

MS SQL hasn't given up!

For your amusement, MS thinks they can "now" equal Oracle in performance (wasn't that what they claimed 3 years ago?). Anyway, I tend to think of these benchmarks like the NASCAR winners. Yeah I'm going to go by a Chrysler because it won the NASCAR championship. http://www.entmag.com/news/article

Re: Purely for your amusement

Thanks!   I especially liked:   TABLE...FULL OF 'WOE'   That seems to be how the day is going for several of us.  Scott >>> [EMAIL PROTECTED] 2/27/03 1:23:55 PM >>>And you thought your job was bad . . .(Yes, this IS a production job)--

RE: Purely for your amusement

Barbara, I noticed that there was on INDEX being used in the plan. Please modify the code. Use of indexes are not permitted unless explicit permission has been given. thank you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 27, 2003 1:24

RE: corrupted block

I rounded... it was actually something like 6:04AM :) --- Thomas Day <[EMAIL PROTECTED]> wrote: > > 6 AM --- A new shift comes on. Or is that when the janitor shows up > and > needs a place to plug in his vacuum cleaner? > > I am always suspicious of hardware/system failures that fall right o

RE: corrupted block

Ome of our sys admins once assigned two file systems to the same area of disk which as you might expect caused a multitude of problems. I don't believe the I/O system complained at all when one file system would overwrite blocks written by another. Ian MacGregor Stanford Linear Accelerator C

RE: IOUG setting up

Title: RE: IOUG setting up Cute. "What I needed to forget about tuning once I got my Cert".  I already contacted the one in town, thanks.  I just don't think they give enough attention to Oracle and get the good speakers in - perhaps I can help with that.  What about the following: "Why

Purely for your amusement

And you thought your job was bad . . . (Yes, this IS a production job) -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6238983833668070 Card=81143391896031200 10 MERGE JOIN (Cost=6238983833668070 Card=

RE: Deleting rows (ORA-01403)

Is there a pre-delete trigger on the table? > -Original Message- > From: Craig Healey [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 27, 2003 12:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Deleting rows (ORA-01403) > > > It's getting late, and Buffy the Vampire Slay

Re:RE: Dealing with 3rd Party Applications

Dennis, My heartburn with third party vendors is not that they don't have good Oracle people on their helpdesk, but rather that they don't have good Oracle people period. One of our third party vendors, forever to remain nameless(so I stay out of trouble), has an Oracle DBA who just happen to

RE: newbie dba question

Thanks very much to everyne! I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be tak

RE: Oracle Performance Tuning Exam

Title: RE: Oracle Performance Tuning Exam Okay, We can plan our time so that one person goes to one and the other to the other - taping or taking copius notes and getting extra handouts then share.  -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thurs

RE: IOUG setting up

Paula, I just did a search at ioug.org and it looks like there are 5 Oracle User Groups in FL. (Guessing based on your e-mail address :) It would be much easier to get involved with one of those that starting a new one that would be competing for members and vendor support. Take a look at ioug.

RE: Number of joins in the query

If you are joining 'n' number of tables, you should have a minimum of 'n-1' joining conditions, otherwise it might result in cartesian product. Sunil Nookala Dell Corp. -Original Message- Sent: Thursday, February 27, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Two! PK on s

RE: Dealing with 3rd Party Applications

David ROLMAO !! I like your statement "the clients loved that". Would that be humor?? Rich - I repeat my statement: "suck all you can out of the vendor documents", and make that your starting point. Each vendor has their own approach to Oracle. Some are good, some are frankly bad. But you need

RE: corrupted block

Brian, I can ask. When I try to do something Oracle on the production boxes I get my hand slapped and am told "we pay the hosting company to do that". When I ask, I sometimes get the info I need. Rachel --- "Spears, Brian" <[EMAIL PROTECTED]> wrote: > Rachel, > > Were you running the validat

Re: newbie dba question

Alex In my experience, when I have inherited systems worrying about "tuning" was the least of my concerns. I could think of other things to look into first (no particular order): - Backup/Recovery procedures - like do backups happen, archivelog mode on (you would be surprised) - Database Event

RE: Number of joins in the query

A joins B joins C Is the same as A joins C So I would think 2 joins is all you need - 3 would give you an unnecessary loop...but I could be wrong. -Original Message- Krishnaswamy, Ranganath Sent: February 27, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Dear List, I

RE: Number of joins in the query

Ranganath On looking closer at your model, it appears you may have duplicated keys. That may be the source of your confusion. Your model may not be properly normalized. What is the relationship between the three tables? It appears that Station is the parent of the two other tables, but its key i

RE: corrupted block

6 AM --- A new shift comes on. Or is that when the janitor shows up and needs a place to plug in his vacuum cleaner? I am always suspicious of hardware/system failures that fall right on the hour. I once had an Oracle database on an AIX system. Every morning, when I came in, it was just start

Deleting rows (ORA-01403)

It's getting late, and Buffy the Vampire Slayer is on TV tonight, so I want to go home...sorry, I'm digressing... I try to delete a row, in TOAD, or in SQL*Plus, and I get an ORA-01403: ORA-01403 no data found Cause: In a host language program, all records have been fetched. The return code from t

RE: Re: Number of joins in the query

And if you fail to follow Dan's advice, and that one of the tables in the FROM clause is just used to link two other tables or perform an existence test (not to return data in the select list), just do like everybody else : add DISTINCT >- --- Original Message --- - >From:

RE: Dealing with 3rd Party Applications

Jeff, > The performance they are complaining about is when they log into the application it takes about a minute for their initial screen (which includes a list of values) to appear. I'll assume you have reproduced this time delay on more than one machine. If this is so (and that you want to cont

RE: IOUG setting up

Title: RE: IOUG setting up Guys, I wish to setup an IOUG group in my city.  I wish to do this so I can bring in some of the more relevant training available for Oracle DBA's in this area - Mogens, Cary, Robert, etc.  Any advice on the best way to do this from folks who have - quickest way to

RE: OEM - Automation of Start of Collection for Performance Reports

How can Start of Collection of ALL (Multiple) Performance Reports be automated in OEM 9.2 , before a Transactions' Run ? There Exist about 100 such Performance Reports in OEM . Manually starting Collection of these individually in OEM takes too much effort & collection has to be started much be

RE: Number of joins in the query

Ranganath Not a problem. The algorithm is N-1. If you have N tables, you need N-1 joins. If you have 2 tables, you only need a single join to connect them. 3 tables, 2 joins, and so forth. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mai

RE: Number of joins in the query

Two! PK on stn_rstcn_to_frm? T'would be clearer if you presented your problem as tables a, b, c, rather than getting us to struggle through all these stns... peter -Original Message- [mailto:[EMAIL PROTECTED] Sent: 27 February 2003 14:59 To: Multiple recipients of list ORACLE-L Dear

Re: ODBC and password expire messages

If you are using VB (VBA/VB.Net or enve C#) using oo4o (Oracle Objects For OLE).  This will five you more funcationalty and an increase in speed. - Original Message - From: Chip To: Multiple recipients of list ORACLE-L Sent: Thursday, February 27, 2003 2:09 AM

Re: temporary tablespace using tempfile

"depends" but tpically, a lot less. Exceptions are easy to find - eg, you need undo for a global temp table because you are allowed to 'rollback' etc hth connor --- Jos <[EMAIL PROTECTED]> wrote: > > List, > > When with temporary tablespace using tempfile, does > Oracle generate redo/undo inf

RE: Dealing with 3rd Party Applications

Thanks Tim. I think I will always consider my tuning skills basic until I can at least get to the point that when someone mentions a buzzword (waits,ratios,tkprof,latches,fetches,etc.) I will be able to recall to memory a unhazy idea of the concept they are referring to instead of rummaging throug

RE: Dealing with 3rd Party Applications

IME, I've found that the reason they say not to use features like that is because they don't know them and are therefore not able to support them. One of our 3PV's applications that used Oracle had many features of Oracle performance (and recovery!!!) disabled because it was the least common denom

RE: newbie dba question

Alex I would recommend you install Oracle's STATSPACK, if you haven't already. If you haven't, consider buying Don Burleson's book "Oracle9i High-Performance Tuning with STATSPACK". You can run some STATSPACK snapshots while the system is normal and see what the performance is like. Ask people

RE: Oracle Performance Tuning Exam

Anything by Cary Millsap, Tim Gorman, Jonathan Lewis, Anjo Kolk there are others but I plan on being at any session I can that the above give... which should be interesting as they have Anjo and Jonathan presenting in the same time slot. Hm, where are the Raelians when I need them? --- [EMAIL

  1   2   >