Re: Re: [Q] wait time /lob def

2004-01-30 Thread ryan.gaffuri
i apologize if someone posted this answer(i missed it if you did), but why do cached lobs require writes on the control file? and jonathan said that isnt 'necessarily' bad. is that because there isnt alot of I/O? so caching lobs are primarily useful for read only or read 'mostly' LOBs?

Re: Re: [Q] wait time /lob def

2004-01-30 Thread Tanel Poder
Hi! i apologize if someone posted this answer(i missed it if you did), but why do cached lobs require writes on the control file? NOCACHE NOLOGGING LOBs require writes to controlfile, because last nologging operation to a datafile has to be reflected somewhere, for being able to determine which

Re: Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread ryan.gaffuri
I know when oracle uses a fast full scan. Its the full scan that does 1 I/O at a time. I rarely see oracle using it and when it does, it generally means my table(s) aren't properly analyzed. From: David Hau [EMAIL PROTECTED] Date: 2004/01/26 Mon PM 10:34:25 EST To: Multiple recipients of

Re: Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread ryan.gaffuri
btw, in many cases range scan is faster than a fast full scan. Range scan recursively hits the nodes that are needed and skips the ones that are not. So it reads less blocks. So if you are looking for a 'range' or a specific value, range scan beats fast full scan most of the time. Less

Re: Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread ryan.gaffuri
i found numerous cases(I dont have them in front of me) when fast full scan incurred far more logical I/Os than an index range scan. I found this particularly for oltp type get 10 records transactions. However, I forced an index_ffs once and it increased my logical I/Os by 30% but decreased my

Re: Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread ryan.gaffuri
my question pertains to regular 'index full scans' NOT index fast full scans. any ideas? I rarely ever find this to be an optimal index access method for anything. From: Tanel Poder [EMAIL PROTECTED] Date: 2004/01/27 Tue AM 11:19:27 EST To: Multiple recipients of list ORACLE-L [EMAIL

Re: Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread Tanel Poder
Yes, and my reply was about regular index full scans, according to your question. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 6:59 PM my question pertains to regular 'index full scans' NOT index fast full

Re: Re: When does Oracle use 'Index Fast Scan'

2004-01-27 Thread ryan.gaffuri
ive found that index_ffs typically incur higher logical I/Os that index range scans. so its not just access speeds. From: David Hau [EMAIL PROTECTED] Date: 2004/01/27 Tue AM 11:54:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: When does Oracle use 'Index

Re: RE: pga_aggregate_target and a memory leak

2004-01-24 Thread Ryan
where did you hear that oracle 10g was written almost entirely outside the US? what critical problems have you had with 9i? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 10:19 PM On 01/23/2004 07:54:25 PM, Arnold, Sandra

Re: RE: pga_aggregate_target and a memory leak

2004-01-24 Thread Mladen Gogala
Personal communication. On 01/24/2004 06:44:24 AM, Ryan wrote: where did you hear that oracle 10g was written almost entirely outside the US? what critical problems have you had with 9i? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday,

RE: Re: pga_aggregate_target and a memory leak

2004-01-23 Thread Jeroen van Sluisdam
this also. I will email him To ask for details. Anybody else experience with this or this patch? Regards, Jeroen -Oorspronkelijk bericht- Van: Arnold, Sandra [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 23 januari 2004 3:19 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Re

Re: RE: pga_aggregate_target and a memory leak

2004-01-23 Thread ryan.gaffuri
i heard tom kyte speak in december. He said first quarter 2004 for solaris. most people seem to still be on 8i. We have both 8i and 9i instance here. It will probably be a year before many employers are using it anywy. From: Grabowy, Chris [EMAIL PROTECTED] Date: 2004/01/23 Fri PM 03:24:45

RE: RE: pga_aggregate_target and a memory leak

2004-01-23 Thread Arnold, Sandra
We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra -Original Message- Sent: Friday, January 23, 2004 5:39 PM To:

Re: RE: pga_aggregate_target and a memory leak

2004-01-23 Thread Mladen Gogala
On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote: We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra That would be a very

Re: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Ryan
Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you certain its PAT causing it? Maybe they didnt fix all the memory leaks with the PGA in general? has anyone

Re: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Kirtikumar Deshpande
Paul, Most of my work is on HP-UX and AIX. I have yet to see any ORA-600 and memory leaks related to P_A_T. All databases that I work with are on 9.2.0.4, except just one running on 9.2.0.3. No memory leak there either. - Kirti --- Paul Drake [EMAIL PROTECTED] wrote: --- Kirtikumar

Re: RE: Healty ratio of index segment size vs table segment size?

2004-01-22 Thread ryan.gaffuri
comments in line... I may need correction from some of you on this. -Original Message- Sent: Wednesday, January 21, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper

RE: RE: Has anyone done any scalability work on dbms_lock?

2004-01-22 Thread Goulet, Dick
Well, I don't know about anyone else, but I make use of it to synchronize data upload programs for our testers. Can't have two instances of the upload program processing the same tester, they'd duplicate data. Anyhow, we normally run 4 instances of this program the dbms_lock package works

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Arnold, Sandra
I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which is pointing to some memory problems. It is occurring during the CTX_DOC.FILTER process. We are running this process from a custom PL/SQL package that is being initiated from an Oracle Job. However, we

Re: RE: How to get unique value using AWK?[CLOSED]

2004-01-22 Thread jaysingh1
Thanks Kirti and everyone who responded. This forum is really great. - Original Message - Date: Thursday, January 22, 2004 12:14 pm Why not process the trace file with 9i tkprof? It will nicely summarize the wait times for those events. After seeing those unique wait events, your

Re: RE: Has anyone done any scalability work on dbms_lock?

2004-01-22 Thread Jonathan Lewis
I came across a very nice example a while ago where there were 4 concurrent sessions feeding data into a holding table, and one session consuming from the table. The rules said that the consumer could not run while the producers were loading the table, but multiple producers were allowed to run.

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread DENNIS WILLIAMS
Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To: Multiple recipients of list ORACLE-L I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which is

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Arnold, Sandra
Yes. On Solaris 5.8. -Original Message- Sent: Thursday, January 22, 2004 3:10 PM To: Multiple recipients of list ORACLE-L Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To:

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Jeroen van Sluisdam
- Van: Ryan [mailto:[EMAIL PROTECTED] Verzonden: donderdag 22 januari 2004 11:05 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: Re: pga_aggregate_target and a memory leak Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list

RE: Re: pga_aggregate_target and a memory leak

2004-01-22 Thread Arnold, Sandra
2004 11:05 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: Re: pga_aggregate_target and a memory leak Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you

Re: Re: Has anyone done any scalability work on dbms_lock?

2004-01-21 Thread ryan.gaffuri
nuno-- what level are you trying to scale it to? how long will you hold the locks? I used it last year because only one process could run at a time. seemed to have similiar over head to 'select for update'. If you look at the PL/SQL Packages book by Fuerstein et al(not a real popular book, but

RE: Re[2]: Oracle vs Mysql

2004-01-21 Thread Igor Neyman
I was using Lattice-C on x286. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carel-Jan Engel Sent: Tuesday, January 20, 2004 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2

RE: Re[2]: Oracle vs Mysql

2004-01-21 Thread Goulet, Dick
yup Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Carel-Jan Engel [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004 5:29 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Re[2]: Oracle vs MysqlAt 03:29 PM 1/20/2004, you wrote

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread ryan.gaffuri
kirti-- would you recommend avoiding pga_aggregate_target for now? From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... -

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
I think it depends on your applications. In DSS type environments we are still stuggling to figure out if P_A_T is helping or not. Initial tests are not in P_A_T's favor. But in another Application, that is 80% OLTP, P_A_T was the only choice to avoid swapping. This 9.2.0.3 database had the

Re: RE: Has anyone done any scalability work on dbms_lock?

2004-01-21 Thread Nuno Pinto do Souto
Hmm, that's actually a very good idea. It might actually do the job here. Thanks. Nuno Souto [EMAIL PROTECTED] Jamadagni, Rajendra [EMAIL PROTECTED] wrote: if it is single instance you could also use global application contexts ... (alas they don't work in RAC across node) ... -- Please

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Paul Drake
--- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: I think it depends on your applications. In DSS type environments we are still stuggling to figure out if P_A_T is helping or not. Initial tests are not in P_A_T's favor. But in another Application, that is 80% OLTP, P_A_T was the only

Re: Re: pga_aggregate_target -- actual values from my database

2004-01-21 Thread Hemant K Chitale
We have a new reporting instance [Solaris 8, 8GB RAM, 4 CPUs, 9.2.0.4] where initially SGA_MAX_SIZE was 2GB, DB_CACHE_SIZE was 32MB, SHARED_POOL_SIZE was 200MB and PGA_AGGREGATE_TARGET was 100MB. There are approx 10 to 15 active users at any time. Without really having any baseline we've gone

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time.

Re: Re: OS authentication; remote login; domain qualification

2004-01-20 Thread bhabani s pradhan
I added the parameter to registry OSAUTH_PREFIX_DOMAIN=true but it didn't help. Any other place where i can see..? Thanks and Regards B S Pradhan --- On Mon, 19 Jan 2004 Jared Still wrote : You must set OSAUTH_PREFIX_DOMAIN=true in the registry to use externally identified domain

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Nuno Souto
- Original Message - Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle Beat ya: Oracle Add-In for Lotus 123. Using Ora*Net (Async), V4.1.4. 1987. And demoed to the press that same year. g,dr

Re: Re: Oracle vs Mysql

2004-01-20 Thread ryan.gaffuri
if Oracle is offshoring its develeoping of its database, everyone else will also... so much for job security. anyone I heard postgre sql has multi-versioning? Is it implemented like Oracle? So UDB is the new DB2? Oracle claims that DB2 is not one database but a different database for

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mercadante, Thomas F
Ahhh. Sql*Calc, Sql*Graph, Sqr EasySqr. Those were the good old days. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 8:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: On

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Jesse, Rich
Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite COBOL, and could effortlessly have them do DB work. I also didn't have to hunt thru all the source for a single SQL statement since they were in

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread KENNETH JANUSZ
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:39 AM Careful Mladen, your revealing your

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mercadante, Thomas F
The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Jesse, Rich
I've got my GX21-9129-9 right here in front of me. It should be in a museum... I'll take Obscure Geek References for $800, Alex. Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message-

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
I do indeed. Rumor was that rpt/rpf was written by Larry himself. On 01/20/2004 09:39:34 AM, Goulet, Dick wrote: Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday,

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 01/20/2004 08:04:33 AM, Thater, William wrote: Mladen Gogala scribbled on the wall in glitter crayon: oh damn, have we been at this too long?;-) Yes, we probably have. I must say that the spirit of Oracle Corp. has changed significantly since the days of Geoff Squire, Chris Ellis, Richard

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Probably because they were dropping RPT RPF SQR smells a lot like it, YUCK! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go

RE: Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Stephane Faroult
[snip] 120 col. punch cards? You had a high-density model. Mine only had 80 cols, of which 72 were usable for my goto-happy Fortran statements. SF No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 01/20/2004 10:09:34 AM, KENNETH JANUSZ wrote: Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM I've never done anything with System/3. My first IBM was 3084 with MVS and IMS, running on 8M RAM. After an upgrade, it was a

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Orr, Steve
RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
YES! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:10 AM To: Multiple recipients of list ORACLE-L Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM

Re: Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread KENNETH JANUSZ
The old IBM System3 machines used 120 col. punch cards. And initially they had no HD's. Everything was done with cards and a reader/sorter. To compile a program you took the code you wrote, punched it into cards and then put it behind a stack of cards that was the compiler. The machine read

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread eric king
What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:49 PM To: Multiple

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Orr, Steve
Yupp. RPF=report formatter or some such. -Original Message- eric king Sent: Tuesday, January 20, 2004 1:19 PM To: Multiple recipients of list ORACLE-L What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Eric, They were the precusors to Oracle reports. RPT was the report extraction tool, and RPF was the report formatter. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 3:19 PM To: Multiple recipients of list ORACLE-L

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Bellow, Bambi
But, unless you have old diskettes... you'll never see them. They died with the demise of v5. -Original Message- Sent: Tuesday, January 20, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Yupp. RPF=report formatter or some such. -Original Message- eric king Sent:

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 01/20/2004 03:29:33 PM, Goulet, Dick wrote: Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Dick, when you are talking about big

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread mkline1
I know I used to set up RPT and do all sorts of complex updating things. At the State and with things coming from mainframes, the data organization seemed to lend itself well to RPT. Since the organization was like of loops within loops, I could take the high order update and then loop through

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Tanel Poder
Dick, when you are talking about big mouth from Finland, you probably don't refer to Pamela Anderson, also from Finland? The other person from Finland, whom I will not mention except by the first name (Linus) should be given credit for a wonderful OS that is successfully breaking the MS

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
If Mr Torvalds needs a security blanket, I'd be happy to send him several. Yes he crafted a wonderful OS I sincerely hope he knocks Billy Gates down to size. Seems to be doing one heck of a job at it, even with SCO on MicroSlop's side. MS Anderson appears headed for the twilight, thank GOD.

RE: Re: Oracle vs Mysql

2004-01-20 Thread Grant Allen
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 20 January 2004 23:59 To: Multiple recipients of list ORACLE-L Subject: Re: Re: Oracle vs Mysql if Oracle is offshoring its develeoping of its database, everyone

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Carel-Jan Engel
At 03:29 PM 1/20/2004, you wrote: I do indeed. Rumor was that rpt/rpf was written by Larry himself. Now I understand! I once applied for a job at Oracle, and got asked: What do you think about RPT/RPF. My answer: Probably som hobby-project of one or another developer, which, after demonstration

Re: Re: OS authentication; remote login; domain qualification

2004-01-19 Thread bhabani s pradhan
Hi Thanks for the info. Let me try this. Regards, B S Pradhan --- On Mon, 19 Jan 2004 Jared Still wrote : You must set OSAUTH_PREFIX_DOMAIN=true in the registry to use externally identified domain accounts. I can't recall if the default value is true or false, but try setting it

Re: RE: Oracle vs Mysql

2004-01-19 Thread Nuno Pinto do Souto
DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free Bzzzt. Oracle won because it

RE: Re: Who is Melanie Craft?

2004-01-15 Thread Stephane Faroult
I have just done an Amazon search, I guess that Melanie Craft's book 'A Hard-Hearted Man (Intimate Moments, No 870)' will bring some terrific change to my usual reading list. Although one of her other masterpieces, 'Trust Me' looks terribly reminiscent of the Oracle doc, doesn't it. SF (almost

RE: Re: A STRANGE QUERY

2004-01-13 Thread Odland, Brad
At first stab...I would guess that there is something foobarred with the primary key index. I would rebuild the primary key and try again. Brad O. -Original Message- Sent: Monday, January 12, 2004 4:45 PM To: Multiple recipients of list ORACLE-L It is not an expensive query.It

RE: re BCV / SnapShot / SnapClone and the ALTER SYSTEM

2004-01-12 Thread John Kanagaraj
not reflect those of my employer or customers ** -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Saturday, January 10, 2004 6:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM Yes, I hadn't read

Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM

2004-01-12 Thread Mladen Gogala
in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Saturday, January 10, 2004 6:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: re BCV / SnapShot / SnapClone

RE: re BCV / SnapShot / SnapClone and the ALTER SYSTEM

2004-01-12 Thread John Kanagaraj
of list ORACLE-L Subject: Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM John, I know that fro RMAN tablespaces need not be in hot backup mode. The trick with susspend is quick dirty way of achieving the same effect as with the cold backup, without bringing the database down. No RMAN involved

Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM

2004-01-10 Thread Hemant K Chitale
Yes, I hadn't read the line so the tablespaces had to be put into backup mode or (8i and after) the database had to be suspended you _do_ have an OR between the backup mode and the database .. suspended. We hadn't heard of anyone using the SUSPEND and didn't want to take the chance of a database

Re: Re: Index usage

2004-01-09 Thread bhabani s pradhan
sorry, the second query uses equality operator.. WHERE UPPER(col1) = 'xyz'; index hint is not helping. regards, B S Pradhan -- On Thu, 08 Jan 2004 zions swordfish wrote : hi, pradhan, I don't see any kind of differences with your two queries, but I suggest you to use

Re: Re: table reorganizations

2004-01-09 Thread Tanel Poder
Another way would be to do exchange partition between a single- or multipartition partitioned table and a regular table. Easier than dbms_redefinition and less locking issues than with manual lock swap. Tanel. --- Saatja: Rachel Carmichael [EMAIL PROTECTED] Kuupäev: 09.01.2004 16:14:33 ---

RE: Re[2]: Books on rac

2004-01-09 Thread April Wells
Title: RE: Re[2]: Books on rac Hi Jonathan Don asked me if I would be interested in writing the Programmers Interview book... the Apps book was just done, so I took him up on the offer. I am writing for CRC... in fact I have one in process now for them. April -Original Message

Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM SUSPEND --

2004-01-09 Thread Mladen Gogala
I should have expressed myself more clearly. Suspend is not necessary, it's only fast. Basically, with suspend, you don't put tablespaces into backup mode. You suspend, resync, split and start aonther instance as if it crashed. As no I/O is going to disk, datafiles aren't fuzzy, so no recovery

RE: Re[2]: another OCP question -- help me guys

2004-01-08 Thread Jamadagni, Rajendra
-Original Message- [irrelevant stuff deleted] P.S. I can work powerpoint too. Close your Powerpoint.exe and S L O W L Y back away from the keyboard and nobody gets hurt ... Raj Rajendra dot Jamadagni at

Re: Re[1]: OCP question from Boson practice tests

2004-01-08 Thread Richard Foote
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 08, 2004 1:59 AM My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge

Re: Re[1]: OCP question from Boson practice tests

2004-01-08 Thread Richard Foote
Hi Prem Comments in line. Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? Although there are certainly some dodgy questions and correspondingly suz answers, I think you'll find the majority of the OCP exam will have

Re: Re: Difference on ArchiveLog (I'm rewriting the question)

2004-01-08 Thread Vélez
Hello everybody thank for your answers, the size I'm talking about is summing up real sizes of archivelogs files, and I had each configuration of redo logs for one week, and the first one was for many months. Therewas not any change on database objects and the database is small, thesumming up

RE: Re[1]: OCP question from Boson practice tests

2004-01-08 Thread Thater, William
Richard Foote scribbled on the wall in glitter crayon: So in short Cary, you have a fair to average chance of passing the exams :) that's Ok for Cary, what about us mere mortals?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song

Re: Re: Difference on ArchiveLog (I'm rewriting the question)

2004-01-08 Thread Tanel Poder
: Mauricio Vélez To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 4:04 PM Subject: Re: Re: Difference on ArchiveLog (I'm rewriting the question) Hello everybody thank for your answers, the size I'm talking about is summing up real sizes of archivelogs

Re: Re: Difference on ArchiveLog (I'm rewriting the question)

2004-01-08 Thread Tim Gorman
Mauricio, Variances of 1G of redo generation (i.e. 4G one day, 2G another day, 3G another day) are not indicative of anything unusual. I've seen systems that generate 4T of redo one day, 6T of redo another day, and then only 0.5T of redo the following day. All without changing the size of the

RE: Re: Problem with understanding Optimization methods.

2004-01-07 Thread Stephane Faroult
To what Mladen said about the optimizer_blah parameters, there is another thing which can be added. Most third-party software is over-indexed (as you have noticed) because they optimistically want to cover *all* possible cases and quite often a column which is highly discreminant at one site

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
I didn't mean to scold... you post way more information than I usually do! And I answer whilst eating breakfast at times too :) Richard *is* right, the problem is, the sql statement is misformed but the answer key says it will work. Which is yet another reason I dislike the OCP exams. ---

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan
A small but growing number of employers want certification. Considering the job market, I recommend anyone who is not at Rachel's, etc.. level to get certified as both a developer and a DBA. I'm doing Java also, just to have it. The java test is a total joke. You only need to get 52% right and its

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Stefick Ronald S Contr ESC/HRIDA
Title: RE: Re[2]: another OCP question -- help me guys Uh No one can be at Rachel's level. She's the DBA Goddess -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 8:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
Michael Abbey once said (I'm paraphrasing here) the resume and OCP get you in the door. It's your experience that gets you the job and keeps you there We've had numerous discussions on this list about interview questions. I've been on interviews where I spent an entire day (9-4) and talked to 11

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William
Rachel Carmichael scribbled on the wall in glitter crayon: Oh yeah -- how does having a college degree in art history make a person a better DBA? how does my degree, which is in computer science but which is 28 years old, have anything to do with current programming and database work? it

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan
degrees and ocps often do alot more than get you past the HR department. most jobs these days are short term temp jobs. temp companies offer you salary based mainly on your resume. most technical interviews are a joke. I can make more money if I double my experience level and have a computer

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Mladen Gogala
On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote: Oh yeah -- how does having a college degree in art history make a person a better DBA? how does my degree, which is in computer science but which is 28 years old, have anything to do with current programming and database work? Believe it

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Cary Millsap
My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
I do understand, and that's why I said that I tried to bring people in first, before HR (as you know) --- Thater, William [EMAIL PROTECTED] wrote: Rachel Carmichael scribbled on the wall in glitter crayon: Oh yeah -- how does having a college degree in art history make a person a better

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William
Rachel Carmichael scribbled on the wall in glitter crayon: I do understand, and that's why I said that I tried to bring people in first, before HR (as you know) yup, but most places don't have a Goddess on staff.;-) and i'm seeing the requirement for OCP being listed in consulting postings

Re: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Ryan
for performance tuning exam you have to know some garbage. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:59 AM My question, Richard, is can a person pass the exam just by studying what is correct? Or is it

Re: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Mladen Gogala
Misconceptions, superstitions and myths are always useful to know and believe in. They make people better socialized and the risk of being burnt at stake as a heretic(metaphorically, of course) is much lower. On 01/07/2004 10:59:26 AM, Cary Millsap wrote: Or is it necessary to work harder to

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Rachel Carmichael
From past history: I passed the 8 and 8i exams without having done any work in either version, nor did I study for them. I used Jonathan's method of using later questions to infer the answer to earlier ones, in part. Marlene Theriault, an excellent DBA, took several tries to pass because she knew

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
Now I understand their use, I shall immediately go out and hire an art history major as the deparmental sacrifical lamb (and dartboard while we are at it) I'm still a hands-on DBA, although I have some paperwork responsibilities as well. Not management, other than my own work :) Rachel ---

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Carel-Jan Engel
Wasn't it you, Cary, who got tought by his parents that every question has two answers: The right one and the one the teacher wants to hear? And you had to learn them both? That's merely what OCP is about, I think. Get a certificate to get hired, and get the proper knowledge to remain hired

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Loughmiller, Greg
Title: RE: Re[2]: another OCP question -- help me guys brutal, absolutely brutal... Rachel, can ya out-source your sacrificial lamb for our use as well:-) -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 11:54 AM To: Multiple

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Goulet, Dick
Rachel, A few years ago I was offered a job by a defense contractor in the area who was looking for a DBA, but more importantly a DBA with a still active clearance. Well all was well in 90% of that company, except HR. Simple answer, no degree no job. I don't have the degree so they

  1   2   3   4   5   6   7   8   9   10   >