Re: Oracle version??

2003-02-27 Thread Chip
In the registry My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have

RE: Oracle version??

2003-02-27 Thread Stephane Faroult
List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. What if the only

RE: Oracle version??

2003-02-27 Thread Rajesh Dayal
Hi Chip, I am talking of log directory(N:\Oracle\Inventory\logs and not N:\Oracle\Inventory\components), where every Installer action is logged and not . This doesn't matter whether your Oracle.exe is replaced or not. All of your OUI actions will be logged with all the relevant information

Re: RE: Top 10 DBA Do's and Don'ts anyone

2003-02-27 Thread Jonathan Lewis
A couple of serious Don'ts 1)Don't believe it's true just because it's printed 2)Don't believe it's advanced just because it mentions X$ or underscore parameters. From a recent publication: Paragraph numbers added for reference. quote 1)Cache Buffers Chains: The

Checkpoints

2003-02-27 Thread Zabair Ahmed
The following parameters are set in the init.ora:- NAME VALUE-- ---log_checkpoint_interval 25600log_checkpoint_timeout 0log_checkpoints_to_alert TRUE This means that a checkpoint will happen every 12Mb of redo being filled, os block size is 512. The size of

Upgrade to AIX 5.2

2003-02-27 Thread John Dunn
As AIX 4.3.3 goes out of service this year, we need to upgrade our AIX box to AIX 5.2 We have both Oracle 8.1.7(32 bit) and Oracle 9i Release 2(9.2.0.1.0) (64 bit) installed on that box. Will upgrading to AIX 5.2 cause any problems for Oracle? Any issues etc?? John -- Please see the

RE: Invalid Procedures

2003-02-27 Thread Stephane Faroult
Hello all, We have installed a package in a client's place. Oracle 8.1.7 is the server version. Often it happens that the procedures become invalid. I want to know because of what reason some procedures become invalid. Thanks and Regards, Santosh DDL against the objects the procedures

RE: Upgrade to AIX 5.2

2003-02-27 Thread April Wells
Hey... we are in the same boat... except I have to migrate our Apps to 9.2.0.2 to get us there... From what I UNDERSTAND... (ie... from what I finally drug out of Metalink analyst)... you will probably need to install the 9.2 binaries for 5L (it is the only different set that I have been able to

RE: Upgrade to AIX 5.2

2003-02-27 Thread Jack van Zanen
Hi It's been a while since I talked about this with the Unix guy at my previous assignment, but I think you MUST upgrade to 9i. Jack -Original Message- Sent: donderdag 27 februari 2003 11:45 To: Multiple recipients of list ORACLE-L As AIX 4.3.3 goes out of service this year, we need

Re[2]: DBV

2003-02-27 Thread Breno A. K. Magnago
I ran it. No problem. (Windows 2000 / Oracle 9i) Thanks for all. More information : The problem, four datafile contains corrupt block. (two indexes and two tables). One table I used the package DBMS_REPAIR and made a export, with DIRECT=Y (without it an error happened) and them I imported this

test

2003-02-27 Thread Jos
Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.

test

2003-02-27 Thread Jos
Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.

RE: Invalid Procedures

2003-02-27 Thread McBain, Neil SITI-ITDIEEE
Just been running DBMS_STATS on an 8.1.7 instance HP-UX 11.0 and it did not invalidate packages, however annoyingly adding a partition did. Cheers, Neil. -Original Message- Sent: 27 February 2003 10:45 To: Multiple recipients of list ORACLE-L Hello all, We have installed a

RE: Upgrade to AIX 5.2

2003-02-27 Thread April Wells
Certification matrix says 817 terminal release is certified, as is 9.2 April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Thursday, February 27, 2003 5:34 AM To: Multiple recipients of list

RE: Upgrade to AIX 5.2

2003-02-27 Thread April Wells
Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7 (8i) On IBM AIX -Based Systems Operating System: IBM AIX -Based Systems Version 5.2 (5L) Oracle Server - Enterprise Edition Version 8.1.7

RE: Upgrade to AIX 5.2

2003-02-27 Thread John Dunn
My understanding was that if AIX 5L was run in 64bit mode then Oracle 9i Release 2 was the first release supported, but if not running AIX 5 in 64bit mode then previous version of Oracle would be OK. But maybe I am confused? John -Original Message- Sent: 27 February 2003 11:34 To:

RE: Upgrade to AIX 5.2

2003-02-27 Thread John Dunn
So 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode??? John -Original Message- Sent: 27 February 2003 12:24 To: Multiple recipients of list ORACLE-L Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7 (8i) On IBM AIX -Based Systems

RE: Checkpoints

2003-02-27 Thread Deshpande, Kirti
Zabair, Increasing the l_c_i would help. I see you have l_c_t set to 0, sowhy not set l_c_i to 0 as well? So that the checkpoint will only occur at log switches. - Kirti -Original Message-From: Zabair Ahmed [mailto:[EMAIL PROTECTED]Sent: Thursday, February 27, 2003 3:39

temporary tablespace using tempfile

2003-02-27 Thread Jos
List, Whenwith temporary tablespaceusing tempfile, does Oracle generate redo/undo information for temporary segments? Jos Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.

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

2003-02-27 Thread dist cash
On ORACLE 8i we need setup primary and standby databases same name otherwise will get ORA-1103 error. Does anyone know on ORACLE 9i or 9iR2 this restriction still apply? Thanks. _ Help STOP SPAM with the new MSN 8 and get 2

RE: Invalid Procedures

2003-02-27 Thread Jamadagni, Rajendra
For years, I have been using ... select * from dba_errors / and it tells me what is wrong ... all the time. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have

RE: Oracle and SUN config question...

2003-02-27 Thread Loughmiller, Greg
Title: RE: Oracle and SUN config question... I guess I wasn't very clear in the initial posting. Hangovers can be a dreadful thing.. Let's assume that I have 16 Databases on a SUN enterprise server. The architecture is to install Oracle and it's associated components all in one container.

RE: Dealing with 3rd Party Applications

2003-02-27 Thread Farnsworth, Dave
Jeff, Has this product been reliable for you to use without doing anything funny to the database? Dave -Original Message- Sent: Wednesday, February 26, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Hi, So my boss comes over this morning and tells me that the users are having

Re: Checkpoints

2003-02-27 Thread Tim Gorman
Zabair, You are indeed working from facts, but your conclusion that a checkpoint every minute is "clearly putting considerable load on LGWR" is a deductive leap which is probably unwarranted. I do not have access to an Oracle8 v8.0.6 RDBMS or documentation, but I recall that the

Re: Checkpoints

2003-02-27 Thread Daniel W. Fink
I recall a bug introduced (?) in 8.0.5. If you set log_checkpoints_to_alert, the process consumed a large amount of cpu. I remember changing it to false after our test group found performance problems. How often are you performing log switches during peak usage? Is the CKPT process running?

RE: Checkpoints

2003-02-27 Thread Odland, Brad
Frequent log switches in peak times I think are normal. More data is changing thenyou would expect to see more frequency every minute or so is not really that bad on a busy system...if you see a trend of these becoming more frequent over longer periods of time I would be concerned and

extremely OT, but important -- please read and help

2003-02-27 Thread Rachel Carmichael
I have asked for, and received, Jared's permission to post this. Anyone who feels it is inappropriate and wants to flame me, you are welcome to do so, but please do so privately. Jared does not want this OT post to overwhelm the list and I will not respond to anything sent directly to the list. I

RE: Upgrade to AIX 5.2

2003-02-27 Thread Deshpande, Kirti
It appears that way. We are also pondering on this upgrade as well. But if one takes this route, that is, running 5L in 32-bit mode, one can not install 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX 5L. It is not planned to be available, either. So, we are leaning

Re: DBV

2003-02-27 Thread JApplewhite
Jeremiah, Perhaps the fact that my experience was with Personal Oracle 7.3.2.3 on Win95 explains the hosed database - Win95 not being the best platform, to say the least. I'll definitely try it again - on a test database, of course. BTW, I can't find any way to tell DBV to verify more than one

Re: OCP Hands-On Course Requirement

2003-02-27 Thread KENNETH JANUSZ
Title: OCP Hands-On Course Requirement I would recommend Oracle University. http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?redir_type=3p_org_id=lang=source_call=global Ken Janusz, CPIM - Original Message - From: Wiegand, Kurt To: Multiple

OCP Hands-On Course Requirement

2003-02-27 Thread Wiegand, Kurt
Title: OCP Hands-On Course Requirement Can anyone direct me towards an Oracle Authorized Education Center or Partner in the Washington D.C. area? I'm planning on getting certified but only see Oracle University offering 9-5 Monday-Friday courses. Thanks. Kurt

RE: Upgrade to AIX 5.2

2003-02-27 Thread April Wells
It looks like that is what it is saying... I am planning on upgrade to 9.2.0.2 ASAP. April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple

RE: corrupted block

2003-02-27 Thread Stephen Lee
-Original Message- Of course, we took the EXACT SAME BACKUP, restored it to another filesystem and have NO corruption in the database. But it can't possibly be hardware problems. It's just Oracle playing games with my mind. -- Sunspots. --

Re: Oracle version??

2003-02-27 Thread Chip
My inventory logs (19 files, 16.6 MB) do have a verbose record of OUI actions. Note: all the installation logs can be deleted to clean up space. Also, the inventory logs only record OUI actions. The Oracle 8.1.7.4.6 patch installation does not use OUI (the DBA manually copies many files into

Number of joins in the query

2003-02-27 Thread Krishnaswamy, Ranganath
Dear List, I have a basic doubt about the number of joins I should have. Say, I have three tables by name station, station_restriction and stn_rstcn_to_frm with the following structure: StationStation_restriction stn_rstcn_to_frm --

RE: Oracle Performance Tuning Exam

2003-02-27 Thread Paula_Stankus
Title: RE: Oracle Performance Tuning Exam I am going to the IOUG - do you recommend any seminars or presentations on performance that will be presented there? Thanks, Paula -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 26, 2003

PGA question

2003-02-27 Thread Koivu, Lisa
Title: PGA question Hi everyone, I'm looking through the documentation regarding the PGA. It doesn't say specifically how the following parms affect the size of the PGA, just that it does: OPEN_LINKS DB_FILES LOG_FILES - Obsolete w/8i On Metalink they just say this is proprietary. I'm

RE: Upgrade to AIX 5.2

2003-02-27 Thread John Dunn
I thought that you had to have Oracle 9 release 2 if running AIX 5 in 64bit mode, not the other way around. We have a customer who is intending to run Oracle 9i Release 2 on AIX 5 running in 32bit kernel mode. Can anyone say for definate whether this will work or not? John -Original

RE: Oracle Performance Tuning Exam

2003-02-27 Thread Paula_Stankus
Title: RE: Oracle Performance Tuning Exam BTW, That is why I didn't spend more than a few hours preparing for that exam. I already sensed that it would be a waste of time in the long-run. -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

testing..

2003-02-27 Thread Mohoni, Uma

RE: DBMS_STATS

2003-02-27 Thread Terrian, Tom (Contractor) (DAASC)
Thanks to Tim Johnston and Jonathan Lewis. They were exactly right! Tom -Original Message- Sent: Tuesday, February 25, 2003 7:49 PM To: Multiple recipients of list ORACLE-L To expand on this, the action level is controlled by the granularity parameter... Granularity of

RE: corrupted block

2003-02-27 Thread Spears, Brian
Rachel, Were you running the validate command on your backups? It would be interesting to see if that wasn't cutting the mustard either. Brian Spears -Original Message- Sent: Wednesday, February 26, 2003 9:59 PM To: Multiple recipients of list ORACLE-L I wish it was

Re: Checkpoints

2003-02-27 Thread Zabair Ahmed
Hi Daniel Log switches are happening every 20-25mins during peak times and yes the ckpt process is started automatically. ZabairWith Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs

RE: DBV

2003-02-27 Thread Grant Allen
Jeremiah, [snip] BTW, I can't find any way to tell DBV to verify more than one datafile at a time. Is there? Doesn't look like it. I tried dbv blocksize=8192 file=system01.dbf,tools01.dbf dbv blocksize=8192 file*.dbf dbv blocksize=8192

RE: Oracle and SUN config question...

2003-02-27 Thread Stephen Lee
As far as I know, the oratab is only used by the startup and shutdown scripts (and any homebrew scripts you might write). If you wanted different oratabs in different locations, then you won't be able to have a single oracle startup / shutdown script in init.d. I think you need to edit one for

RE: Dealing with 3rd Party Applications

2003-02-27 Thread david davis
Dennis, The lowest common denomintor is a good description. I have seen in the third party apps they don't use/require (or necessarily test) their application with items that would be found in the Oracle Enterprise version and unlikely with the extras such as partitioning. The documentation

Re: DBV

2003-02-27 Thread Jeremiah Wilton
In Unix, maybe something like this? for X in *.dbf do dbv file=$X done Add logfiles, paths, etc. as you wish. I suppose something similar must be possible in batch scripting for windows. Then again maybe not! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 27 Feb 2003,

Re: DBMS_STATS

2003-02-27 Thread Jeff Landers
Terrian, Tom (Contractor) (DAASC) wrote: I have never had good luck with DBMS_STATS. It seems that the old analyze runs much faster.Runs in 45 seconds:analyze table log_trans partition (log_trans_20030104) estimate statistics sample 5 percent;Takes over 2 hours:execute

RE: corrupted block

2003-02-27 Thread Rachel Carmichael
it's not a hardware problem. the fact that the filesystem failed at 6AM this morning is merely a collective hallucination yes, it went down hard. My database was not on it, I had insisted they move all the files. They didn't move the Oracle binaries though (there is no hardware problem) so we are

Re: Number of joins in the query

2003-02-27 Thread Daniel W. Fink
The minimum number of equi-joins (a = a) is the number of tables - 1. For 3 tables, a minimum of 2 join conditions are needed. Additional joins are needed for composite values (relationship defined by multiple columns) or theta joins (where the join is on a range of values). Krishnaswamy,

RE: Oracle Performance Tuning Exam

2003-02-27 Thread Rachel Carmichael
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

RE: newbie dba question

2003-02-27 Thread DENNIS WILLIAMS
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: Dealing with 3rd Party Applications

2003-02-27 Thread Jesse, Rich
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

Re: temporary tablespace using tempfile

2003-02-27 Thread Connor McDonald
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 information

Re: ODBC and password expire messages

2003-02-27 Thread Jay
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: Number of joins in the query

2003-02-27 Thread Robson, Peter
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: Number of joins in the query

2003-02-27 Thread DENNIS WILLIAMS
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-

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

2003-02-27 Thread VIVEK_SHARMA
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

RE: IOUG setting up

2003-02-27 Thread Paula_Stankus
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: Dealing with 3rd Party Applications

2003-02-27 Thread Harrington, Eric
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

RE: Re: Number of joins in the query

2003-02-27 Thread Stephane Faroult
SARCASM 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 /SARCASM - --- Original Message

Deleting rows (ORA-01403)

2003-02-27 Thread Craig Healey
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

RE: corrupted block

2003-02-27 Thread Thomas Day
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

RE: Number of joins in the query

2003-02-27 Thread DENNIS WILLIAMS
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

RE: Number of joins in the query

2003-02-27 Thread Saira Somani
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: newbie dba question

2003-02-27 Thread david davis
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: corrupted block

2003-02-27 Thread Rachel Carmichael
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 validate

RE: Dealing with 3rd Party Applications

2003-02-27 Thread DENNIS WILLIAMS
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 to

RE: Number of joins in the query

2003-02-27 Thread Sunil_Nookala
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

RE: IOUG setting up

2003-02-27 Thread Stephen Andert
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

RE: Oracle Performance Tuning Exam

2003-02-27 Thread Paula_Stankus
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:

RE: newbie dba question

2003-02-27 Thread Alex Dashko
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 normalnomal.But what steps in identifying the slowdowns in performace should be taken

Re:RE: Dealing with 3rd Party Applications

2003-02-27 Thread dgoulet
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

RE: Deleting rows (ORA-01403)

2003-02-27 Thread Gogala, Mladen
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 Slayer is

Purely for your amusement

2003-02-27 Thread Barbara Baker
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

RE: IOUG setting up

2003-02-27 Thread Paula_Stankus
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 would

RE: corrupted block

2003-02-27 Thread MacGregor, Ian A.
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

RE: corrupted block

2003-02-27 Thread Rachel Carmichael
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 on the

RE: Purely for your amusement

2003-02-27 Thread Mercadante, Thomas F
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: Purely for your amusement

2003-02-27 Thread Scott Behrens
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)-- snipped

MS SQL hasn't given up!

2003-02-27 Thread DENNIS WILLIAMS
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.

RE: Perl Modules

2003-02-27 Thread Jared . Still
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

RE: Upgrade to AIX 5.2

2003-02-27 Thread Tracy Rahmlow
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

RE: RE: Dealing with 3rd Party Applications

2003-02-27 Thread DENNIS WILLIAMS
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: IOUG setting up

2003-02-27 Thread Gene Sais
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-mail

RE: MS SQL hasn't given up!

2003-02-27 Thread Jamadagni, Rajendra
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,

RE: Purely for your amusement

2003-02-27 Thread Boivin, Patrice J
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

shared tnsnames.ora

2003-02-27 Thread Fedock, John (KAM.RHQ)
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 a

Re: MS SQL hasn't given up!

2003-02-27 Thread Lyndon Tiu
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 years

Re: Upgrade to AIX 5.2

2003-02-27 Thread Ruth Gramolini
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: Upgrade

Re: shared tnsnames.ora

2003-02-27 Thread Ron Thomas
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

2003-02-27 Thread Deshpande, Kirti
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: MS SQL hasn't given up!

2003-02-27 Thread Paula_Stankus
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: Purely for your amusement

2003-02-27 Thread Boivin, Patrice J
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

RE: MS SQL hasn't given up!

2003-02-27 Thread Paula_Stankus
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

RE: Purely for your amusement

2003-02-27 Thread Nick Wagner
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: shared tnsnames.ora

2003-02-27 Thread John Kanagaraj
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

RE: shared tnsnames.ora

2003-02-27 Thread Stephen Lee
-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 way

RE: IOUG setting up

2003-02-27 Thread Stephen Andert
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

RE: Oracle Performance Tuning Exam

2003-02-27 Thread Nguyen, David M
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:

  1   2   >